QuestionQ39

VerifiedSecure, optimize, and deploy database solutions

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

You have a C# Azure Functions app that uses an HTTP-triggered function and an Azure SQL input binding to query dbo.Employee.

You are adding a second function that responds to row changes in dbo.Employee and writes structured logs.

You need to configure AdventureWorksDB and the app to meet these requirements:

  • Changes to dbo.Employee must invoke the new function within five seconds.
  • Each invocation must handle 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.

Choose two
Explanation

The Azure SQL trigger binding uses SQL change tracking to detect row inserts, updates, and deletes. Change tracking must be enabled both for the database and for the specific monitored table. The trigger’s default maximum batch size is 100 changes and its default polling interval is 1,000 milliseconds, satisfying the stated limits without requiring a database configuration change. Azure SQL trigger for Functions

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!