Winter Sale 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ex2p65

Exact2Pass Menu

Administering Relational Databases on Microsoft Azure

Last Update 7 hours ago Total Questions : 366

The Administering Relational Databases on Microsoft Azure content is now fully updated, with all current exam questions added 7 hours ago. Deciding to include DP-300 practice exam questions in your study plan goes far beyond basic test preparation.

You'll find that our DP-300 exam questions frequently feature detailed scenarios and practical problem-solving exercises that directly mirror industry challenges. Engaging with these DP-300 sample sets allows you to effectively manage your time and pace yourself, giving you the ability to finish any Administering Relational Databases on Microsoft Azure practice test comfortably within the allotted time.

Question # 4

You plan to deploy Instance1 by using the following script.

You need to specify the licenseType and storagenedundancy parameters. The deployment must meet the availability requirements and the business requirements for DB1 and DB2.

To what should you set each parameter? To answer, select the appropriate options in the answer area.

Question # 5

You need to recommend a solution that will enable remote developers to access DB1 and DB2. The solution must support the planned changes and meet the secunty requirements.

What should you include in the recommendation?

A.

a public endpoint via a database-level firewall rule

B.

a private endpoint

C.

a public endpoint via a server-level firewall rule

D.

a Point-to-Site (P2S) VPN

Question # 6

You need to recommend which configuration to perform twice to enable access to the primary and secondary replicas of DB3. The solution must meet the availability requirements.

What should you recommend?

A.

Configure virtual network service endpoints.

B.

Enable database firewall rules.

C.

Create database-scoped credentials.

D.

Configure connection strings that reference the read-write listener.

Question # 7

You need to recommend a service tier and a method to offload analytical workloads for the databases migrated from SVR1. The solution must meet the availability and business requirements.

What should you recommend? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Question # 8

Which counter should you monitor for real-time processing to meet the technical requirements?

A.

SU% Utilization

B.

CPU% utilization

C.

Concurrent users

D.

Data Conversion Errors

Question # 9

You need to recommend a process to automate the management of DB3. The solution must meet the management requirements. What should be the first step of the process?

A.

Configure Microsoft Entra authentication for the logical server that hosts DB3.

B.

Create a database that has database-scoped credentials.

C.

Configure a private endpoint for connectivity to DB3.

D.

Create data base-scoped credentials in DB3.

Question # 10

You need to implement a solution to notify the administrators. The solution must meet the monitoring requirements.

What should you do?

A.

Create an Azure Monitor alert rule that has a static threshold and assign the alert rule to an action group.

B.

Add a diagnostic setting that logs QueryStoreRuntimeStatistics and streams to an Azure event hub.

C.

Add a diagnostic setting that logs Timeouts and streams to an Azure event hub.

D.

Create an Azure Monitor alert rule that has a dynamic threshold and assign the alert rule to an action group.

Go to page: