SIMULATION
You need to configure your user account as the Azure AD admin for the server named sql12345678.
To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.

You have an Azure subscription that contains the resources shown in the following table.

You need to configure a connection between VM1 and MI1. The solution must meet the following requirements:
- The connection must be encrypted.
- Network latency must be minimized.
What should you implement?

Hotspot Question
You have an Azure SQL database named DB1. The automatic tuning options for DB1 are configured as shown in the following exhibit.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Hotspot Question
You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Machines named SQLVM1 and a user named User1. SQLVM1 hosts a database named DB1.
You need to ensure that User1 can perform the following tasks on DB1:
- Create jobs.
- View all jobs.
- Modify, delete, and disable the jobs the user created.
The solution must use the principle of least privilege.
Which built-in database role should you assign to User1, and where is the role defined? To answer, select the appropriate options in the answer area.

You have an Azure SQL database named DB1.
You need to encrypt DB1. The solution must meet the following requirements:
- Encrypt data in motion.
- Support comparison operators.
- Provide randomized encryption.
What should you include in the solution?