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

Questions 6–10

1. 6application · medium

   A developer is using Data API Builder to expose a SQL database to a web application. The database has a table named Products with a column named CategoryId. The web app needs to display products by category, and the developer wants to allow the client to filter products by category using a REST endpoint. What should the developer configure in the Data API Builder configuration file?

   • ACreate a separate view for each category and expose each as an entity.
   • BEnable the 'filter' property on the Products entity to allow filtering by CategoryId.
   • CEnable REST on the Products entity and rely on the client to use the $filter query parameter with CategoryId.
   • DEnable the 'search' property on the Products entity to allow searching by category.
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A developer is using Data API Builder to expose a SQL database to a React application. The database has a table named Employees and a table named Departments. The application needs to query employees and include the department name in the same response. The developer wants to use GraphQL. What should they configure?

   • ADefine both tables as entities and set up a relationship from Employees to Departments.
   • BDefine a stored procedure that returns the joined data and expose it via GraphQL.
   • CEnable REST on both entities and use a client-side join.
   • DDefine a view that joins Employees and Departments and expose it as an entity.
   Reveal Solution Discussion Select an answer first
4. 8expert · hard

   A company is deploying Data API Builder to Azure App Service. They have a custom domain name and want to use HTTPS. They also want to restrict access to the API to only authenticated users. What should they do?

   • AConfigure the custom domain in Data API Builder's configuration file and use a self-signed certificate.
   • BUse Azure API Management to handle custom domain and TLS, and rely on API Management's subscription keys.
   • CConfigure a custom domain and TLS/SSL binding in App Service, and set the 'authentication' property in Data API Builder to 'Azure AD'.
   • DUse Azure Front Door to handle custom domain and TLS, and set 'authentication' to 'anonymous'.
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A developer is deploying Data API Builder to an Azure Container Instance to expose a SQL database. The container needs to be accessible from a specific virtual network only. The developer has a configuration file that defines REST endpoints. What should the developer do to ensure the container is only reachable from the virtual network?

   • ASet the 'host' mode in the configuration file to 'production' and deploy the container with a public IP address.
   • BSet the 'authentication' property in the configuration file to 'Azure AD' and disable anonymous access.
   • CUse Azure API Management in front of the container and configure an IP restriction policy.
   • DDeploy the container to the virtual network and configure a network security group to allow traffic only from the virtual network's address space.
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A healthcare organization uses Data API Builder to expose a SQL database containing patient records. They have a stored procedure that returns a list of patients for a given doctor. The team wants to expose this stored procedure via REST so that the doctor's ID is passed as a query parameter. What is the correct way to configure this in Data API Builder?

   • AUse the 'rest' property to set the endpoint to the stored procedure name and enable 'pagination'.
   • BCreate a view that calls the stored procedure and expose the view as an entity.
   • CExpose the underlying table and use a GraphQL filter to simulate the stored procedure logic.
   • DAdd an entity for the stored procedure and set 'source' to the procedure name, then define the parameter in the 'parameters' section.
   Reveal Solution Discussion Select an answer first