Home / Microsoft / DP-300

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

Question list

List of questions

Question 291

(0)

HOTSPOT You have an instance of SQL Server on Azure Virtual Machines named VM1. You need to use an Azure Automation runbook to initiate a SQL Server database backup on VM1. How should you complet

Question 292

(0)

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

Question 293

(0)

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 soluti

Question 294

(0)

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

Question 295

(0)

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 Tran

Question 296

(0)

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?

Question 297

(0)

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 nee

Question 298

(0)

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 th

Question 299

(0)

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. W

Question 300

(0)

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 opera

Related questions

Task 5 You need to configure a disaster recovery solution for db1. When a failover occurs, the connection strings to the database must remain the same. The secondary server must be in the West US 3 Azure region.

Task 10 You need to protect all the databases on sql37006S95 from SQL injection attacks.

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.

You have an Azure SQL Database managed instance named SQLMI1. A Microsoft SQL Server Agent job runs on SQLMI1. You need to ensure that an automatic email notification is sent once the job completes. What should you include in the solution?

HOTSPOT You have an Azure SQL database named DB1 that contains two tables named Table1 and Table2. Both tables contain a column named a Column1. Column1 is used for joins by an application named App1. You need to protect the contents of Column1 at rest, in transit, and in use. How should you protect the contents of Column1? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

DRAG DROP You have an Azure SQL database that contains a table named Employees. Employees contains a column named Salary. You need to encrypt the Salary column. The solution must prevent database administrators from reading the data in the Salary column and must provide the most secure encryption. Which three 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 have SQL Server on Azure virtual machines in an availability group. You have a database named DB1 that is NOT in the availability group. You create a full database backup of DB1. You need to add DB1 to the availability group. Which restore option should you use on the secondary replica?

You have a database on a SQL Server on Azure Virtual Machines instance. The current state of Query Store for the database is shown in the following exhibit.

HOTSPOT You have an Azure SQL database that contains a table named Customer. Customer has the columns shown in the following table. You plan to implement a dynamic data mask for the Customer_Phone column. The mask must meet the following requirements: ▪ The first six numerals of each customer’s phone number must be masked. ▪ The first six numerals of each customer’s phone number must be masked. ▪ The last four digits of each customer’s phone number must be visible. Hyphens must be preserved and displayed. How should you configure the dynamic data mask? To answer, select the appropriate options in the answer area.

Task 4 You need to enable change data capture (CDC) for db1.

Question 291

HOTSPOT

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

You need to use an Azure Automation runbook to initiate a SQL Server database backup on VM1.

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

NOTE: Each correct selection is worth one point.

Show Answer Comment (0)

Question 292

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.

Show Answer Comment (0)

Question 293

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?

Create a proximity group and an availability set. Deploy each virtual machine to the availability set Add both virtual machines to the proximity group.

Create two proximity groups and a single availability set. Deploy both virtual machines to the availability set. Add one virtual machine to each proximity group.

Create two proximity groups and two availability sets. Deploy each virtual machine to a unique availability set. Add one virtual machine to each proximity group.

Create a proximity group and two availability sets. Deploy each virtual machine to a unique availability set. Add both virtual machines to the proximity group.

Show Answer Comment (0)

Question 294

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?

ROW_ MODE_MEMORY GRANT_FEEDBACK

BATCH MODE_MEMORY GRAIJT_FEEDBACK

BATCH_MODE_ADAPTIVE_TOIMS

BATC H_MODE_ON_ROWSTOR E

Show Answer Comment (0)

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.

Show Answer Comment (0)

Question 296

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?

H-series

G -series

M-series

E-series

Show Answer Comment (0)

Question 297

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?

Log Analytics

Azure SQL Analytics

Query Performance Insight

SQL Insights

Show Answer Comment (0)

Question 298

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?

Modify the Set Session Event Filters settings.

Add a target.

Add an action.

Modify the Specify Session Data Storage settings.

Show Answer Comment (0)

Question 299

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.

General Purpose Standard

Business Critical Premium

Business Critical Memory Optimized Premium

General Purpose Premium

Business Critical Standard

Show Answer Comment (0)