Provisioning SQL Databases — Question 28

You have an on-premises Microsoft SQL server that has a database named DB1. DB1 contains several tables that are stretched to Microsoft Azure.
From SQL Server Management Studio (SSMS), a junior database administrator accidentally deletes several rows from the Azure SQL database and breaks the connection to Azure.
You need to resume Stretch Database operations.
Which two stored procedures should you use? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

Answer options

• A. sys.sp_rda_reconcile_batch
• B. sys.sp_rda_reconcile_indexes
• C. sys.sp_rda_reauthorize_db
• D. sys.sp_rda_reconcile_columns
• E. sys.sp_rda_set_rpo_duration

Correct answer: C, D

Explanation

The correct answers are C and D. sys.sp_rda_reauthorize_db is used to re-establish the authorization to the Azure database, while sys.sp_rda_reconcile_columns helps to sync the schema changes that occurred due to the deletion. The other options do not directly address the need to restore the connection and reconcile the database structure.