Microsoft DP-300 Practice Test - Questions Answers, Page 30

HOTSPOT

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.

NOTE: Each correct selection is worth one point.

You plan to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability group.

You need to recommend a deployment solution that meets the following requirements:

* Provides a Service Level Agreement (SLA) of at least 99.95%

* Replicates databases in the same group synchronously

* Minimizes the latency of database writes

What should you recommend?

You have an Azure subscription that contains an Azure SQL database. The database contains a table named tablet.

You execute the following Transact-SQL statements.

You need to reduce the time it takes to perform analytic queries on the database.

Which configuration should you enable?

HOTSPOT

You have an Azure subscription.

You need to deploy a logical SQL server by using PowerShell. The solution must ensure that the logical SQL server can create Azure AD users and provide Transparent Data Encryption (TDE} with a customer-managed key.

How should you complete the command? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have an Azure subscription.

You plan to deploy an instance of SQL Sevier on Azure Virtual Machines that supports Write Accelerator.

Which virtual machine series should you use?

You have an Azure subscription that contains the following resources:

* 10 Azure SQL databases

* Five Azure SQL managed instances

* Five instances of SQL Server on Azure Virtual Machines

You need to implement a centralized monitoring solution for all the Azure SQL resources. The solution must minimize administrative effort. What should you include in the solution?

You have an instance of SQL Server on Azure Virtual Machines named SQL1.

SQL1 contains an Extended Events session named session! that captures Microsoft SQL Server events.

You need to correlate the session events with events captured by Event Tracing for Windows (ETW).

What should you do for session1?

You have an on-premises datacenter that contains a 14-TB Microsoft SQL Server database.

You plan to create an Azure SQL managed instance and migrate the on-premises database to the new instance.

Which three service tiers support the SQL managed instance? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

You have an instance of SQL Server on Azure Virtual Machines named VM1.

You need to implement a disaster recovery solution that meets the following requirements:

* Returns the solution to an operational state within 15 minutes of a failure

* Can perform disaster recovery testing in an isolated environment

* Minimizes administrative effort

What should you include in the solution?