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

Questions 26–30

1. 26expert · hard

   A company is deploying Data API Builder to Azure App Service for a production workload. The configuration file is stored in a Git repository. The team wants to automate deployment and ensure that the configuration file is validated before deployment. They also want to monitor the health of the API. What should they do?

   • AUse Azure CLI to deploy the container and then use Log Analytics to query the config file.
   • BManually upload the config file to the App Service and use Azure Monitor for containers.
   • CUse Azure DevOps pipeline to build the container, run 'dab validate' on the config file, and deploy to App Service. Enable Application Insights for the App Service.
   • DUse GitHub Actions to deploy the container directly without validation, and rely on App Service built-in logging.
   Reveal Solution Discussion Select an answer first
2. 27application · medium

   A logistics company has a SQL database that tracks shipment statuses. They want to trigger an Azure Function whenever a shipment status changes from 'In Transit' to 'Delivered'. The database has Change Tracking enabled. What is the most efficient way to implement this?

   • APoll the database every minute from a timer-triggered Azure Function to check for status changes.
   • BUse the Azure Function SQL trigger binding with Change Tracking enabled on the Shipments table.
   • CUse Change Data Capture (CDC) and configure a Stream Analytics job to send changes to the Azure Function.
   • DCreate a stored procedure that sends a notification via Azure Service Bus when the status changes, and have the Azure Function listen to the queue.
   Reveal Solution Discussion Select an answer first
4. 28application · medium

   A company is using Data API Builder to expose a SQL database. They have a table named Employees with a column named Salary that should not be exposed to external clients. The team wants to hide this column while still allowing access to other columns. What is the best approach?

   • ASet the 'rest' property to 'disabled' for the Employees table and create a new entity for the other columns.
   • BCreate a view that excludes the Salary column and expose the view as an entity in Data API Builder.
   • CUse the 'exclude' property in the entity configuration to hide the Salary column.
   • DModify the database to remove the Salary column from the Employees table.
   Reveal Solution Discussion Select an answer first
5. 29foundation · easy

   Which database object can be exposed as a read-only entity in Data API Builder without requiring a primary key?

   • AStored procedure
   • BTable
   • CIndex
   • DView
   Reveal Solution Discussion Select an answer first
6. 30foundation · easy

   What is the purpose of the 'dab deploy' command in Data API Builder?

   • ATo create a new database schema.
   • BTo start a local development server.
   • CTo publish the configuration to a hosting environment.
   • DTo generate client SDKs.
   Reveal Solution Discussion Select an answer first