DP-800: Developing AI-Enabled Database Solutions

By Microsoft · Question Mode

QuestionQ80

VerifiedDesign and develop database solutions

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

Your company plans to develop an Azure Functions app that runs whenever rows in dbo.ToDo change. The app will process INSERT, UPDATE, and DELETE events by using the Azure SQL trigger binding.

You need to configure ToDo to support the planned app.

What should you do?

Explanation

The Azure SQL trigger binding uses SQL change tracking to monitor a table and invoke a function for inserted, updated, and deleted rows. Its required setup enables change tracking on both the database that contains the monitored table and on that table itself.

Learn more

Community Discussion

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