Integrate SQL Solutions with Azure Services DP-800 Practice Questions (Page 5)

Questions 21–25

1. 21application · medium

   A company uses Data API Builder to expose a SQL Server database to a React web app. The database has a table named Orders with a column named CustomerId. The web app needs to query orders by CustomerId and include the related customer name from a Customers table. The developer wants to minimize the number of REST calls from the client. What should the developer configure in the Data API Builder configuration file?

   • ADefine a REST endpoint for Orders with a filter on CustomerId and enable data caching with a short cache duration.
   • BDefine a GraphQL endpoint for Orders with a filter on CustomerId and configure a relationship to Customers so the client can query nested customer data.
   • CDefine a REST endpoint for Orders with a filter on CustomerId and enable GraphQL relationships to Customers.
   • DDefine a REST endpoint for Orders with a filter on CustomerId and configure the entity to expose a foreign key relationship to Customers.
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   How do you expose a stored procedure as a custom action in Data API Builder?

   • AAdd the stored procedure to the 'tables' list.
   • BCreate a view that calls the stored procedure.
   • CDefine it in the 'actions' section of the entity configuration.
   • DSet the entity type to 'stored-procedure'.
   Reveal Solution Discussion Select an answer first
4. 23foundation · easy

   Which Data API Builder entity configuration setting enables clients to filter query results by fields that are not part of the primary key?

   • Afiltering.enabled
   • Bsorting.enabled
   • Cpagination.enabled
   • Dcaching.enabled
   Reveal Solution Discussion Select an answer first
5. 24foundation · easy

   You are setting up Data API Builder for a SQL database. Which file is the primary configuration file that defines the runtime settings, authentication, and entity mappings?

   • Adatabase.json
   • Bappsettings.json
   • Cdab-config.json
   • Dconfig.yaml
   Reveal Solution Discussion Select an answer first
6. 25expert · hard

   A company uses Data API Builder to expose a SQL database to a public web app. The web app has high read traffic but low write traffic. The database is a single Azure SQL Database. The team wants to reduce the load on the database and improve response times. What should they configure in Data API Builder?

   • AEnable GraphQL on the read entities to allow the client to request only needed fields.
   • BEnable data caching on the read entities with a cache duration of 60 seconds.
   • CEnable pagination on the read entities to limit the number of rows returned.
   • DEnable searching on the read entities to allow client-side filtering.
   Reveal Solution Discussion Select an answer first