Question
You have an Azure SQL database named AdventureWorksDB that contains a table named dbo.Employee.
You have a C# Azure Functions app that uses an HTTP-triggered function with an Azure SQL input binding to query dbo.Employee.
You are adding a second function that will react to row changes in dbo.Employee and write structured logs.
You need to configure AdventureWorksDB and the app to meet the following requirements:
- Changes to dbo.Employee must trigger the new function within five seconds.
- Each invocation must process no more than 100 changes.
Which two database configurations should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Create an AFTER trigger on dbo.Employee for Data Manipulation Language (DML).
- B. Set Sql_Trigger_MaxBatchSize to 100.
- C. Enable change tracking on the dbo.Employee table. Correct
- D. Enable change tracking at the database level. Correct
- E. Set Sql_Trigger_PollingIntervalMs to 5000.
- F. Enable change data capture (CDC) for dbo.Employee table changes.
Explanation
The Azure SQL trigger for Functions relies on SQL change tracking, which must be enabled first on the database and then on the monitored table. Those are the two database configurations. Sql_Trigger_MaxBatchSize and Sql_Trigger_PollingIntervalMs are function app settings rather than database settings, and their defaults of 100 changes and 1000 ms already meet the requirements. The binding does not use a DML AFTER trigger or change data capture.
