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

Administering Relational Databases on Microsoft Azure Questions and Answers

Question 9

You need to recommend a solution to meet the security requirements and the business requirements for DB3. What should you recommend as the first step of the solution?

Options:

Run the sys.5p_cdc_en«ble_db stored procedure.

Run the alter table statement and specify the enable chahgc_tracking clause.

Run the alter database statement and specify the set cmange_trackinc> - on clause.

Run the sp_addarticle stored procedure.

Question 10

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

Options:

SU% Utilization

CPU% utilization

Concurrent users

Data Conversion Errors

Question 11

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:

Resource Governor

a custom resource pool

vertical scaling

horizontal scaling

Question 12

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.

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

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

Administering Relational Databases on Microsoft Azure Questions and Answers

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer: