Administering a SQL Database Infrastructure — Question 251

You administer a Microsoft SQL Server 2016 database instance.
You plan to migrate the database to Windows Azure SQL Database.
You verify that all objects contained in the database are compatible with Windows Azure SQL Database.
You need to ensure that database users and required server logins are migrated to Windows Azure SQL Database.
What should you do?

Answer options

• A. Use the Copy Database wizard.
• B. Back up the database from the local server and restore it to Windows Azure SQL Database.
• C. Use the Database Transfer wizard.
• D. Use SQL Server Management Studio to deploy the database to Windows Azure SQL Database.

Correct answer: D

Explanation

The correct answer is D because SQL Server Management Studio provides tools specifically designed to facilitate the deployment of databases to Windows Azure SQL Database, including the migration of users and logins. Options A and C do not support migrating users and logins directly, while option B is not suitable as backups cannot be restored directly to Azure SQL Database.