Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

Microsoft DP-300 - Administering Relational Databases on Microsoft Azure

Microsoft DP-300 Premium Access     Download Demo    
Page: 1 / 6
Total 341 questions

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

A.

Azure Storage

B.

Azure Event Hubs

C.

Azure Log Analytics

What should you use to migrate the PostgreSQL database?

A.

Azure Data Box

B.

AzCopy

C.

Azure Database Migration Service

D.

Azure Site Recovery

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

A.

Availability Zones

B.

failover groups

C.

Always On availability groups

D.

geo-replication

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.

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.

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 identify the event_file 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?

A.

an Azure SQL database

B.

an Azure Blob Storage container

C.

a SQL Server filegroup

D.

an Azure Files share

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

A.

transaction log

B.

point-in-time restore (PITR)

C.

differential

D.

long-term retention (LTR)

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.

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?

A.

an Azure SQL database

B.

an Azure Blob Storage container

C.

a SQL Server filegroup

D.

an Azure Files share