Exam DP-300 topic 2 question 26 discussion

Actual exam question from Microsoft's DP-300

Question #: 26
Topic #: 2

DRAG DROP
-

You have an Azure subscription that contains an Azure SQL database named SQLDb1. SQLDb1 contains a table named Table1.

You plan to deploy an Azure web app named webapp1 that will export the rows in Table1 that have changed.

You need to ensure that webapp1 can identify the changes to Table1. The solution must meet the following requirements:

• Minimize compute times.
• Minimize storage.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Show Suggested Answer

Suggested Answer:

by KIET2131 at March 7, 2023, 9:09 a.m.

Comments

Submit Cancel

Pranava_GCP

Highly Voted 2 years, 1 month ago

The answer is correct. To track changes, change tracking must first be enabled for the database and then enabled for the tables that you want to track within that database. 1) ALTER DATABASE Sandbox1 SET CHANGE_TRACKING = ON 2) ALTER TABLE Persons ENABLE CHANGE_TRACKING 3) run the CHANGETABLE() function

upvoted 7 times

...

sgoncharuk

Most Recent 1 year, 5 months ago

3) change_tracking_current_version()

upvoted 4 times

2f5c7cd

7 months, 2 weeks ago

agree. "Obtain initial data Before an application can obtain changes for the first time, the application must send a query to obtain the initial data and the synchronization version. The application must obtain the appropriate data directly from the table, and then use CHANGE_TRACKING_CURRENT_VERSION() to obtain the initial version. This version will be passed to CHANGETABLE(CHANGES ...) the first time that changes are obtained." https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/work-with-change-tracking-sql-server?view=sql-server-ver16#see-also

upvoted 1 times

...

uvj

1 year, 11 months ago

https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/about-change-tracking-sql-server?view=sql-server-ver16 To track changes, change tracking must first be enabled for the database and then enabled for the tables that you want to track within that database. The table definition does not have to be changed in any way, and no triggers are created.

upvoted 1 times

...

KIET2131

2 years, 3 months ago

is it correct?

upvoted 1 times

JG1984

2 years, 1 month ago

Change Tracking should be enabled on the table first and then on the database and finally run the change tracking function

upvoted 1 times

Pranava_GCP

2 years, 1 month ago

did a small lab, got error msg when enabling Change_Tracking on table before enabling on database level. ====Change tracking must be enabled on database 'Sandbox1' before it can be enabled on table 'Persons'.====

upvoted 7 times

...