Administering a SQL Database Infrastructure — Question 84

You plan to migrate the db to azure.
You verify that all objects are valid for azure sql database. You need to ensure that users and logins are migrated to azure.
What should you do?

Answer options

• A. Use the Copy Database wizard
• B. Use the Database Transfer wizard
• C. Use the SQL Management Studio to deploy the db to azure
• D. Back up the databasae from the local server and restore it to azure

Correct answer: C, D

Explanation

Option C is correct because SQL Management Studio allows for the deployment of databases to Azure while ensuring user and login information is included. Option D is also valid as backing up and restoring a database can transfer the entire database, but it may not maintain logins without additional steps. Options A and B do not specifically cater to migrating user and login information to Azure.