You administer a Microsoft SQL Server 2016 database instance.

You create a new user named UserA. You need to ensure that UserA is able to create SQL Server Agent jobs and to execute SQL

Server Agent jobs.

To which role should you add UserA?

A. Securityadmin

B. RSExecRole

C. SQLAgentUserRole

D. DatabaseMailUserRole

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?

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.