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

Questions 11–15

1. 11application · medium

   A company uses Azure SQL Database for an e-commerce application. They need to stream changes from the Orders table to an Azure Event Hub for real-time analytics. The database has change data capture (CDC) enabled. What should they use to stream the changes?

   • AChange Tracking with a custom application that queries the change table.
   • BAzure Data Factory with a copy activity that runs every minute.
   • CAzure Logic Apps with a SQL connector that polls the table for changes.
   • DAzure Functions with a SQL trigger binding that reads CDC changes and sends them to Event Hub.
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   Which Azure service provides a built-in trigger for Azure Functions that responds to changes in a SQL database?

   • ABlob trigger binding
   • BTimer trigger binding
   • CSQL trigger binding
   • DHTTP trigger binding
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   Which Azure Monitor feature is used to collect and analyze logs from multiple Azure resources in a centralized workspace?

   • ALog Analytics workspace
   • BApplication Insights
   • CAzure Monitor alerts
   • DAzure Service Health
   Reveal Solution Discussion Select an answer first
5. 14application · medium

   A team is deploying Data API Builder to Azure App Service using a Docker container. The configuration file is stored in the repository. The team wants to ensure that the configuration file is not exposed to the public. What should they do?

   • AMount the configuration file as a volume from Azure Files and set the container to read-only.
   • BUse Azure Key Vault to store the configuration file and reference it from the container.
   • CStore the configuration file in the container image and set environment variables for connection strings.
   • DSet the 'host' mode to 'production' and ensure the configuration file is placed outside the web root.
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   A company exposes a Customers table via Data API Builder. They want to allow clients to search for customers by name using a REST endpoint. The search should support partial matches (e.g., 'Joh' matches 'John'). What configuration is required?

   • ASet the 'rest' property to 'enabled' and rely on the default query parameters.
   • BCreate a view that uses LIKE '%search%' and expose the view as an entity.
   • CEnable the 'search' property on the Customers entity and set the searchable fields to include 'FirstName' and 'LastName'.
   • DEnable the 'filter' property and instruct clients to use the '$filter' query parameter with 'contains' operator.
   Reveal Solution Discussion Select an answer first