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

Questions 1–5

1. 1expert · hard

   A company uses Azure SQL Database for a multi-tenant application. They need to stream changes from a table to different Azure Functions based on the tenant ID. The table has a TenantId column. The company wants to minimize latency and avoid polling. What should they use?

   • AUse Change Tracking and a polling Azure Function that runs every minute.
   • BEnable CDC on the table and use a single Azure Function with a SQL trigger binding, then route events to tenant-specific functions.
   • CCreate a database trigger that calls an Azure Function via HTTP for each change.
   • DUse Azure Logic Apps with a SQL connector that polls for changes.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   In a Data API Builder configuration, which entity property controls the maximum number of records returned per page for a REST endpoint?

   • Apagination.max-page-size
   • Bfilter.allow
   • Csearch.enabled
   • Dcache.max-age
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A company is deploying Data API Builder to Azure App Service. They have a configuration file that works locally. The team wants to ensure the deployment is reproducible and that configuration changes are tracked. What is the recommended approach for deploying Data API Builder?

   • AManually upload the configuration file to the App Service via the Azure portal each time a change is made.
   • BStore the configuration file in Azure Blob Storage and mount it to the App Service at runtime.
   • CCommit the configuration file to a Git repository and use Azure DevOps or GitHub Actions to deploy it to App Service.
   • DUse Azure CLI to run 'az webapp config set' with the configuration file contents.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which Azure Monitor component is specifically designed to monitor the performance and usage of a live web application?

   • AAzure Monitor metrics
   • BApplication Insights
   • CAzure Advisor
   • DLog Analytics
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A company is deploying Data API Builder to expose a SQL database to external partners. The partners will use REST endpoints. The company wants to restrict access to specific IP addresses. What should they configure?

   • AUse Azure API Management in front of Data API Builder and configure an IP restriction policy.
   • BSet the 'authentication' property in the Data API Builder configuration to 'Azure AD' and require tokens.
   • CConfigure the hosting environment (e.g., App Service or Container Instances) to restrict inbound IP addresses.
   • DSet the 'host' mode to 'production' and enable 'cors' with allowed origins.
   Reveal Solution Discussion Select an answer first