Changed DP-300 Exam Questions

Administering Relational Databases on Microsoft Azure Questions and Answers

Question 13

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:

transaction log

point-in-time restore (PITR)

differential

long-term retention (LTR)

Question 14

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 15

You have a SQL Server on Azure Virtual Machines instance that hosts a database named Db1.

You need to configure the autogrow and autoshrink settings for DB1.

Which statements should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Question 16

You have an Azure Databricks workspace named workspace1 in the Standard pricing tier. Workspace1

contains an all-purpose cluster named cluster1.

You need to reduce the time it takes for cluster1 to start and scale up. The solution must minimize costs.

What should you do first?

Options:

Upgrade workspace1 to the Premium pricing tier.

Configure a global init script for workspace1.

Create a pool in workspace1.

Create a cluster policy in workspace1.

Spring Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Administering Relational Databases on Microsoft Azure Questions and Answers

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

CompTIA

Fortinet

Microsoft

Salesforce