DP-300 Practice Test 4 — 10 Questions

Question 1

You are reviewing an Azure SQL Database automated backup retention policy. The exhibit shows the current configuration. You need to ensure that the database can be restored to a point in time within the last 7 days at a granularity of 1 minute. Which of the following is a limitation of the current configuration?

Accepted Answer

The backup interval of 12 hours does not allow 1-minute granularity for point-in-time restore.. The current configuration uses a backup interval of 12 hours, which means automated backups are taken only every 12 hours. Point-in-time restore (PITR) in Azure SQL Database relies on full, differential, and transaction log backups to allow restoration to any second within the retention period. With a 12-hour backup interval, transaction log backups are not frequent enough to achieve 1-minute granularity; the minimum granularity is limited by the frequency of log backups, which defaults to every 5-10 minutes but can be configured. A 12-hour interval indicates that log backups are not being taken frequently enough, thus preventing 1-minute restore granularity.

Answer

The retention period is too short to support point-in-time restore.

Answer

The policy must specify a minimum retention of 30 days for point-in-time restore.

Answer

Geo-redundant backup must be disabled for point-in-time restore to work.

Question 2

A company is deploying Azure SQL Managed Instance and needs to ensure that the failover group provides automatic failover with zero data loss during a regional outage. The secondary region is 500 miles away. Which data replication mode should be configured?

Accepted Answer

Synchronous replication. Azure SQL Managed Instance failover groups require synchronous replication to guarantee zero data loss during automatic failover. Synchronous replication ensures that transactions are committed on both the primary and secondary replicas before acknowledging the commit, so no data is lost even if the primary region fails. This mode is mandatory for failover groups with the 'automatic failover' and 'zero data loss' requirements, despite the 500-mile distance which introduces latency.

Answer

Geo-replication

Answer

Snapshot replication

Answer

Asynchronous replication

Question 3

Match each Azure SQL Database service tier to its description.

Question 4

Match each Azure SQL Database backup type to its description.

Question 5

Match each Azure SQL Database migration tool to its description.

Question 6

Match each Azure SQL Database security feature to its purpose.

Question 7

Match each Azure SQL Database high availability feature to its description.

Question 8

Match each Azure SQL Database performance tuning feature to its description.

Question 9

Match each Azure SQL Database command to its function.

Question 10

Match each Azure SQL Database error code to its meaning.

DP-300 Practice Test 4 — 10 Questions

Exhibit

DP-300 Practice Test 4 — 10 Questions

Exhibit