New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Microsoft Certified: Azure Database Administrator Associate DP-300 Passing Score

Page: 3 / 13
Total 341 questions

Administering Relational Databases on Microsoft Azure Questions and Answers

Question 9

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

Question 10

You need to recommend a solution to ensure that the performance of DB3 is optimized after the migration to Azure SQL Database. The solution must meet availability requirements.

What should you include in the recommendation?

Options:

A.

Resource Governor

B.

a custom resource pool

C.

vertical scaling

D.

horizontal scaling

Question 11

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.

Options:

Question 12

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?

Options:

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.

Page: 3 / 13
Total 341 questions