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?

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

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You are the database administrator for a company that hosts Microsoft SQL Server. You manage both on-premises and Microsoft Azure SQL Database environments.
One instance hosts a user database named HRDB. The database contains sensitive human resources data.
You need to grant an auditor permission to view the SQL Server audit logs while following the principle of least privilege.
Which permission should you grant?

• A. View Server State
• B. View Definition
• C. DDLAdmin
• D. sysadmin
• E. dbo
• F. View Database State
• G. dbcreator
• H. db_datawriter

You administer a Microsoft SQL Server 2016 server.
The MSSQLSERVER service uses a domain account named CONTOSO\SQLService.
You plan to configure Instant File Initialization.
You need to ensure that Data File Autogrow operations use Instant File Initialization.
What should you do? Choose all that apply.

• A. Add the CONTOSO\SQLService account to the Server Operators fixed server role.
• B. Enable snapshot isolation.
• C. Restart the SQL Server Service.
• D. Add the CONTOSO\SQLService account to the Perform Volume Maintenance Tasks local security policy.
• E. Disable snapshot isolation.
• F. Restart the SQL Server Agent Service.

You are the database administrator of a Microsoft SQL Server instance. Developers are writing stored procedures to send emails using sp_send_dbmail. Database Mail is enabled.
You need to configure each account's profile security and meet the following requirements:
* Account SMTP1_Account must only be usable by logins that have been given explicit permissions to use the SMTP1_profile.
* Account SMTP2_Account must only be usable by logins who are a member of the
[DatabaseMailUserRole] role in msdb.
In the table below. identify the profile type that must be used for each account.
NOTE: Make only one selection in each column.

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You are the database administrator for a company that hosts Microsoft SQL Server. You manage both on-premises and Microsoft Azure SQL Database environments. A service account has the required permissions to backup all databases.
You have a user database named HRDB that contains sensitive human resources data. The HRDB backup files must be encrypted.
You need to grant the service account that backs up the HRDB database the permission necessary to access the encryption key. Your solution must use the principle of least privilege.
Which permission should you grant?

• A. View Definition
• B. DDLAdmin
• C. sysadmin
• D. View ServerState
• E. dbo
• F. View Database State
• G. dbcreator
• H. db_datawriter