Pre-Summer Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70track

Free Microsoft DP-300 Practice Exam with Questions & Answers | Set: 5

Questions 41

You need to identify the event_flle target for monitonng DB3 after the migration to Azure SQL Database. The solution must meet the management requirements,

What should you use as the event_file target?

Options:
A.

an Azure SQL database

B.

an Azure Blob Storage container

C.

a SQL Server filegroup

D.

an Azure Files share

Microsoft DP-300 Premium Access
Questions 42

You need to recommend a backup solution to restore DB3. The solution must meet the availability requirements. Which type of backup should you use?

Options:
A.

transaction log

B.

point-in-time restore (PITR)

C.

differential

D.

long-term retention (LTR)

Questions 43

You need to recommend which service and target endpoint to use when migrating the databases from SVR1 to Instance1. The solution must meet the availability requirements.

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

NOTE Each correct selection is worth one point.

DP-300 Question 43

Options:
Questions 44

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.

DP-300 Question 44

Options:
Questions 45

What should you implement to meet the disaster recovery requirements for the PaaS solution?

Options:
A.

Availability Zones

B.

failover groups

C.

Always On availability groups

D.

geo-replication

Questions 46

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

Options:
A.

Business Critical 4-vCore

B.

Hyperscale

C.

General Purpose v-vCore

D.

Serverless

Questions 47

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

What should you do?

Options:
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 dia gnostic 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.

Questions 48

Which audit log destination should you use to meet the monitoring requirements?

Options:
A.

Azure Storage

B.

Azure Event Hubs

C.

Azure Log Analytics

Questions 49

You are evaluating the business goals.

Which feature should you use to provide customers with the required level of access based on their service agreement?

Options:
A.

dynamic data masking

B.

Conditional Access in Azure

C.

service principals

D.

row-level security (RLS)

Questions 50

You need to implement the monitoring of SalesSQLDb1. The solution must meet the technical requir ements.

How should you collect and stream metrics? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

DP-300 Question 50

Options:
Exam Code: DP-300
Certification Provider: Microsoft
Exam Name: Administering Relational Databases on Microsoft Azure
Last Update: May 22, 2026
Questions: 388

Microsoft Related Exams

PL-500 - Microsoft Power Automate RPA Developer
MO-101 - Microsoft Word Expert (Word and Word 2019)
MB-240 - Microsoft Dynamics 365 for Field Service
MD-102 - Endpoint Administrator
PL-600 - Microsoft Power Platform Solution Architect
MO-300 - Microsoft PowerPoint (PowerPoint and PowerPoint 2019)
MB-335 - Microsoft Dynamics 365 Supply Chain Management Functional Consultant Expert
MB-230 - Microsoft Dynamics 365 for Customer Service
AZ-800 - Administering Windows Server Hybrid Core Infrastructure
MO-200 - Microsoft Excel (Excel and Excel 2019)
MB-820 - Microsoft Dynamics 365 Business Central Developer
AI-102 - Designing and Implementing a Microsoft Azure AI Solution
SC-300 - Microsoft Identity and Access Administrator
MS-102 - Microsoft 365 Administrator Exam
SC-100 - Microsoft Cybersecurity Architect
Microsoft Free Access
Get Microsoft Full Access

Microsoft Free Exams
Microsoft Free Exams
Prepare effectively for Microsoft certification exams with free study resources and practice tests from Examstrack.