Administering Relational Databases on Microsoft Azure (DP-300) Test 2
© examsiri.com
Question : 39 of 40
Marks:
+1,
-0
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 rows in Table1 that have
changed.
You need to ensure that webapp1 can identity the changes to Table'. 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.
Select and Place:
Actions
1. From webapp1, connect to SQLDb1, obtain the initial dataset, and run the CHANGeTABLE() function.
2. Connect to SQLDb1 and run the following Transact-SQL statement.
ALTER DATABASE SQLDB1 SET CMANGE_TRACKING - ON
3. From webapp1, connect to SQLDb1, obtain the initial dataset, and run the CHANGE_TRACKINOSCURRENT_VERSION() function.
4. Connect to SQLDb1 and run the following Transact-SQL statement.
EXEC sys.sp_cdc_enable_table
5. Connect to SQLDb1 and run the following Transact-SQL statement.
EXEC sys.sp_cdc_enable_db
6. Connect to SQLDb1 and run the following Transact-SQL statement.
ALTER TABLE dbo.Table1 ENABLE CHANGE_TRACKING
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 rows in Table1 that have
changed.
You need to ensure that webapp1 can identity the changes to Table'. 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.
Select and Place:
Actions
1. From webapp1, connect to SQLDb1, obtain the initial dataset, and run the CHANGeTABLE() function.
2. Connect to SQLDb1 and run the following Transact-SQL statement.
ALTER DATABASE SQLDB1 SET CMANGE_TRACKING - ON
3. From webapp1, connect to SQLDb1, obtain the initial dataset, and run the CHANGE_TRACKINOSCURRENT_VERSION() function.
4. Connect to SQLDb1 and run the following Transact-SQL statement.
EXEC sys.sp_cdc_enable_table
5. Connect to SQLDb1 and run the following Transact-SQL statement.
EXEC sys.sp_cdc_enable_db
6. Connect to SQLDb1 and run the following Transact-SQL statement.
ALTER TABLE dbo.Table1 ENABLE CHANGE_TRACKING
Go to Question: