Designing an Azure Data Solution (legacy) — Question 12

You plan to migrate data to Azure SQL Database.
The database must remain synchronized with updates to Microsoft Azure and SQL Server.
You need to set up the database as a subscriber.
What should you recommend?

Answer options

• A. Azure Data Factory
• B. SQL Server Data Tools
• C. Data Migration Assistant
• D. SQL Server Agent for SQL Server 2017 or later
• E. SQL Server Management Studio 17.9.1 or later

Correct answer: E

Explanation

The correct answer, E, SQL Server Management Studio 17.9.1 or later, provides the necessary tools to manage and configure subscriptions for database synchronization. The other options, while useful for data management and migration, do not specifically facilitate the setup of a database as a subscriber for synchronization purposes.