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

You have an Azure SQL database named SOL1.

You need to implement a disaster recovery solution for SQL1. The solution must minimize the following:

* The recovery point objective JRPO)

* The recovery time objective (RTO)

* Administrative effort

What should you include in the solution?

DRAG DROP

You have an Azure key vault named Vault1 and a SQL Server on Azure Virtual Machines instance named SQL1 SQL 1 hosts a database named DB1.

You need to configure Transparent Data Encryption (TDE) on D61 to use a key in Vault1

Which four actions should you perform in sequence' To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

You Save an Azure SCX database named DB1.

You need to query the fragmentation information of data and indexes for the tables in D61.

Which command should you run?

You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1.

You have an Azure subscription that contains an Azure SQL database named SQLDB1.

You need to replicate DB1 to SQlDC1.

Which type of replication should you use?

HOTSPOT

You have an Azure subscription.

You need to deploy a logical SQL server by using an Azure Resource Manager (ARM) template. The solution must ensure that the server will allow inbound connectivity from any Azure resource.

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

NOTE: Each correct selection is worth one point.

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

You plan louse SQLDB11 as an elastic job database to run jobs on SQlDb11 andSOtDB22. What is the minimum number of database scoped credentials required tor the elastic jobs?

You have an Azure subscription.

You need to deploy an Instance of SQL Server on Azure Virtual Machines. The solution must meet the following 'requirements:

* Custom performance configuration. such as lCPS. capacity, and throughout, must be supported.

* Costs must be minimized

Which type of disk should you include in the solution?

You have an Azure subscription.

You create a logical SQL server that hosts four databases Each database will be used by a separate customer.

You need to ensure that each customer can access only its own database. The solution must minimize administrative effort

Which two actions should you perform? Each correct answer presents part of the solution

NOTE: Each correct selection is worth one point.

Task 1

In an Azure SQL database named db1, you need to enable page compression on the PK_SalesOrderHeader_SalesOrderlD clustered index of the SalesLT.SalesOrderHeader table.