DP-300 Online Practice Questions and Answers

HOTSPOT

You have an Azure SQL Database managed instance named sqldbmi1 that contains a database name Sales.

You need to initiate a backup of Sales.

How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

HOTSPOT

You have two Azure virtual machines named VM1 and VM2 that run Windows Server 2019. VM1 and VM2 each host a default Microsoft SQL Server 2019 instance. VM1 contains a database named DB1 that is backed up to a file named D:

\DB1.bak.

You plan to deploy an Always On availability group that will have the following configurations:

1.

VM1 will host the primary replica of DB1.

2.

VM2 will host a secondary replica of DB1.

You need to prepare the secondary database on VM2 for the availability group.

How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.

Hot Area:

HOTSPOT

You have a SQL Server on Azure Virtual Machines instance named VM1 that hosts a database named DB1. You run the following query.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Hot Area:

DRAG DROP

You have a database named db1.

The log for db1 contains the following entry.

You need to ensure That db1 can process transactions.

Select and Place:

HOTSPOT

You are evaluating the role assignments.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Hot Area:

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while

others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have an Azure Data Lake Storage account that contains a staging zone.

You need to design a daily process to ingest incremental data from the staging zone, transform the data by executing an R script, and then insert the transformed data into a data warehouse in Azure Synapse Analytics.

Solution: You use an Azure Data Factory schedule trigger to execute a pipeline that executes mapping data flow, and then inserts the data into the data warehouse.

Does this meet the goal?

A. Yes

B. No

You have an Azure SQL managed instance named SQL1 and two Azure web apps named App1 and App2.

You need to limit the number of IOPs that App2 queries generate on SQL1.

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

NOTE: Each correct selection is worth one point.

A. Enable query optimizer fixes.

B. Enable Resource Governor.

C. Enable parameter sniffing.

D. Create a workload group.

E. Configure In-memory OLTP.

F. Run the Database Engine Tuning Advisor.

G. Reduce the Max Degree of Parallelism value.

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

You need to monitor SQL1 and query the metrics by using Kusto query language. The solution must minimize administrative effort.

Where should you store the metrics?

A. a Log Analytics workspace

B. Azure Event Hubs

C. Azure SQL Database

D. an Azure Blob storage container

You manage 100 Azure SQL managed instances located across 10 Azure regions.

You need to receive voice message notifications when a maintenance event affects any of the 10 regions.

The solution must minimize administrative effort.

What should you do?

A. From the Azure portal, create a service health alert.

B. From the Azure portal, create an Azure Advisor operational excellence alert.

C. From Microsoft SQL Server Management Studio (SSMS), configure a SQL Server agent job.

D. From the Azure portal, configure an activity log alert.

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

You need to implement SQL insights for db1.

Which two resources should you create first? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A. a storage account

B. a virtual machine

C. an Azure logic app

D. an Azure function

E. a Log Analytics workspace

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.

A. Deny public access.

B. Create a private endpoint.

C. Create a database-level firewall rule.

D. Create a network security group (NSG).

E. Create a server-level firewall rule.

You deploy an instance of SQL Server on Azure Virtual Machines: named SQL1 that hosts multiple databases.

You configure the full recovery model for all the databases.

You perform a full backup of the master database on SQL1.

You need to a perform an additional backup of the master database on SQL1. The solution must minimize how long it takes to perform the backup.

Which type of backup should you perform?

A. log

B. full

C. differential

D. tail-log

You plan to deploy an Azure SQL managed instance.

You need to restore database backups across regions.

Which type of storage account should you use?

A. locally-redundant storage (LRS)

B. zone-redundant storage (ZRS)

C. geo-zone-redundant storage (GZRS)

D. geo-redundant storage (GRS)

Based on the PaaS prototype, which Azure SQL Database compute tier should you use?

A. Business Critical 4-vCore

B. Hyperscale

C. General Purpose v-vCore

D. Serverless

You need to provide an implementation plan to configure data retention for ResearchDB1. The solution must meet the security and compliance requirements.

What should you include in the plan?

A. Configure the Deleted databases settings for ResearchSrv01.

B. Deploy and configure an Azure Backup server.

C. Configure the Advanced Data Security settings for ResearchDB1.

D. Configure the Manage Backups settings for ResearchSrv01.