Summer Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Microsoft Certified: Azure Database Administrator Associate DP-300 Exam Questions and Answers PDF

Page: 7 / 13
Total 311 questions

Administering Microsoft Azure SQL Solutions Questions and Answers

Question 25

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 SQL database named Sales.

You need to implement disaster recovery for Sales to meet the following requirements:

  • During normal operations, provide at least two readable copies of Sales.
  • Ensure that Sales remains available if a datacenter fails.

Solution: You deploy an Azure SQL database that uses the General Purpose service tier and geo-replication.

Does this meet the goal?

Options:

A.

Yes

B.

No

Question 26

You have an Azure Data Factory pipeline that is triggered hourly.

The pipeline has had 100% success for the past seven days.

The pipeline execution fails, and two retries that occur 15 minutes apart also fail. The third failure returns the following error.

What is a possible cause of the error?

Options:

A.

From 06:00 to 07:00 on January 10, 2021, there was no data in wwi/BIKES/CARBON.

B.

The parameter used to generate year=2021/month=01/day=10/hour=06 was incorrect.

C.

From 06:00 to 07:00 on January 10, 2021, the file format of data in wwi/BIKES/CARBON was incorrect.

D.

The pipeline was triggered too early.

Question 27

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.

Options:

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.

Question 28

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

You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1 and a virtual network named VNET1. SQLMI1 resides on VNET1. The on-premises network connects to VNET1 by using an ExpressRoute connection.

You plan to migrate DB1 to SQLMI1 by using Azure Database Migration Service.

You need to configure VNET1 to support the migration.

What should you do?

Options:

A.

Configure service endpoints.

B.

Configure virtual network peering.

C.

Deploy an Azure firewall.

D.

Configure network security groups (NSGs).

Page: 7 / 13
Total 311 questions