Pre-Winter Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmasmnth

You have an Azure SQL database named AdventureWorksDB that contains a table named dbo.

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 processes 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.

SetSql 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

Microsoft DP-800 Summary

  • Vendor: Microsoft
  • Product: DP-800
  • Update on: Sep 15, 2026
  • Questions: 87
Price: $52.5  $149.99
Buy Now DP-800 PDF + Testing Engine Pack

Payments We Accept

Your purchase with ExamsVCE is safe and fast. Your products will be available for immediate download after your payment has been received.
The ExamsVCE website is protected by 256-bit SSL from McAfee, the leader in online security.

examsvce payment method