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?
Suggested Answer:E🗳️
To set up the database as a subscriber we need to configure database replication. You can use SQL Server Management Studio to configure replication. Use the latest versions of SQL Server Management Studio in order to be able to use all the features of Azure SQL Database. Reference: https://www.sqlshack.com/sql-server-database-migration-to-azure-sql-database-using-sql-server-transactional-replication/
The answer E is correct. It's not asking how to migrate but what tool to use for setting up a transactional replication. "Replication can be configured by using SQL Server Management Studio". https://docs.microsoft.com/en-us/azure/azure-sql/database/replication-to-sql-database
This is the correct answer as it needs configuration on the SSMS side to perform the replication
Reference: https://www.sqlshack.com/sql-server-database-migration-to-azure-sql-database-using-sql-server-transactional-replication/
D. SQL Server Agent for SQL Server 2017 or later
Explanation:
SQL Server Agent: SQL Server Agent is a component of SQL Server that enables the scheduling and automation of administrative tasks, including replication. You can use SQL Server Agent to set up and manage replication subscriptions.
Azure SQL Database supports various types of replication, such as transactional replication or snapshot replication, depending on your synchronization requirements. SQL Server Agent is commonly used for managing replication in SQL Server environments.
The given answer "E: SQL Server Management Studio 17.9.1 or later" is correct based on the remarks from: https://docs.microsoft.com/en-us/azure/azure-sql/database/replication-to-sql-database.
1. Replication can be configured by using SQL Server Management Studio or by executing Transact-SQL statements on the publisher. You cannot configure replication by using the Azure portal.
2. Replication can only use SQL Server authentication logins to connect to Azure SQL Database.
I believe the answer should be B (SQL Data sync tool)
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-data-sql-server-sql-database
SQL Server Data Tools (SSDT) allows Visual Studio to create a SQL Server database project. It is nothing to do with migration/replication. It's a development tool.
upvoted 3 times
...
...
This section is not available anymore. Please use the main Exam Page.DP-201 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
extraego
Highly Voted 4 years, 9 months agocadio30
3 years, 11 months agoAhmedReda
Highly Voted 4 years, 10 months agoMLCL
4 years, 10 months agodakku987
Most Recent 1 year, 4 months agosyu31svc
4 years, 5 months agoIkrom
4 years, 8 months agopravinDataSpecialist
4 years, 11 months agoAbhitm
4 years, 11 months agodrdean
4 years, 11 months agoextraego
4 years, 9 months ago