Exam DP-800 Topic 2 Question 61 Discussion

Actual exam question for Microsoft's DP-800 exam
Question #: 61
Topic #: 2

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. D. Enable change tracking at the database level. E. Set Sql_Trigger_PollingIntervalMs to 5000. F. Enable change data capture (CDC) for dbo.Employee table changes.

Suggested Answer: C,D Vote an answer

To use an Azure SQL trigger in an Azure Functions app, you must perform the following two database configurations:
Enable change tracking on the database: You must turn on change tracking at the database level to allow the system to monitor for row-level modifications.
Enable change tracking on the table: You must specifically enable change tracking for the table that the second function is monitoring.
These configurations are mandatory for the Azure SQL trigger to detect inserts, updates, and deletes.
Incorrect:
Configuring Timing and Batching
While the database setup enables the tracking mechanism, the specific performance requirements (triggering within five seconds and processing no more than 100 changes) are managed through application settings in the Azure Function app, rather than database-side configurations:
Sql_Trigger_MaxBatchSize: Set this to 100 to ensure each invocation processes no more than
100 changes.
Sql_Trigger_PollingIntervalMs: Set this to 5000 (5,000 milliseconds) or less to ensure changes are detected and triggered within five seconds.
Reference:
https://learn.microsoft.com/en-us/azure/azure-functions/functions-bindings-azure-sql-trigger

by Doris at Oct 15, 2026, 06:14 PM

Limited Time Offer

15%

Off

Get Premium DP-800 Questions as Interactive Self Test Engine or PDF

Comments

Here are all the actual test exam dumps for IT exams. Most people prepare for the actual exams with our test dumps to pass their exams. So it's critical to choose and actual test pdf to succeed.

RECENT DISCUSSIONS

Useful Links

Contact Us

Our Working Time: ( GMT 0:00-15:00 )
From Monday to Saturday

Support: Contact now

If you have any question please leave me your email address, we will reply and send email to you in 12 hours.

Disclaimer:
Actual4test doesn't offer Real SANS and GIAC Exam Questions.
Oracle and Java are registered trademarks of Oracle and/or its affiliates
Actual4test material do not contain actual actual Oracle Exam Questions or material.
Actual4test doesn't offer Real Microsoft Exam Questions.
Microsoft®, Azure®, Windows®, Windows Vista®, and the Windows logo are registered trademarks of Microsoft Corporation
Actual4test Materials do not contain actual questions and answers from Cisco's Certification Exams. The brand Cisco is a registered trademark of CISCO, Inc
CFA Institute does not endorse, promote or warrant the accuracy or quality of these questions. CFA® and Chartered Financial Analyst® are registered trademarks owned by CFA Institute.
Actual4test does not offer exam dumps or questions from actual exams. We offer learning material and practice tests created by subject matter experts to assist and help learners prepare for those exams. All certification brands used on the website are owned by the respective brand owners. Actual4test does not own or claim any ownership on any of the brands.