CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-300

Free DP-300 Exam Braindumps (page: 3)

Page 2 of 76
PDF with 360 Questions

DRAG DROP (Drag and Drop is not supported)
You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 is 30 TB and has a 1-GB daily rate of change.

You back up the database by using a Microsoft SQL Server Agent job that runs Transact-SQL commands. You perform a weekly full backup on Sunday, daily differential backups at 01:00, and transaction log backups every five minutes.

The database fails on Wednesday at 10:00.

Which three backups should you restore in sequence? To answer, move the appropriate backups from the list of backups to the answer area and arrange them in the correct order.
Select and Place:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



You are building a database backup solution for a SQL Server database hosted on an Azure virtual machine.

In the event of an Azure regional outage, you need to be able to restore the database backups. The solution must minimize costs.
Which type of storage accounts should you use for the backups?

  1. locally-redundant storage (LRS)
  2. read-access geo-redundant storage (RA-GRS)
  3. zone-redundant storage (ZRS)
  4. geo-redundant storage

Answer(s): B

Explanation:

Geo-redundant storage (with GRS or GZRS) replicates your data to another physical location in the secondary region to protect against regional outages. However, that data is available to be read only if the customer or Microsoft initiates a failover from the primary to secondary region. When you enable read access to the secondary region, your data is available to be read if the primary region becomes unavailable. For read access to the secondary region, enable read-access geo-redundant storage (RA-GRS) or read-access geo-zone- redundant storage (RA-GZRS).

Incorrect Answers:
A: Locally redundant storage (LRS) copies your data synchronously three times within a single physical location in the primary region. LRS is the least expensive replication option, but is not recommended for applications requiring high availability.

C: Zone-redundant storage (ZRS) copies your data synchronously across three Azure availability zones in the primary region.

D: Geo-redundant storage (with GRS or GZRS) replicates your data to another physical location in the secondary region to protect against regional outages. However, that data is available to be read only if the customer or Microsoft initiates a failover from the primary to secondary region.


Reference:

https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy



You have SQL Server on Azure virtual machines in an availability group. You have a database named DB1 that is NOT in the availability group. You create a full database backup of DB1.
You need to add DB1 to the availability group.

Which restore option should you use on the secondary replica?

  1. Restore with Recovery
  2. Restore with Norecovery
  3. Restore with Standby

Answer(s): B

Explanation:

Prepare a secondary database for an Always On availability group requires two steps:
1. Restore a recent database backup of the primary database and subsequent log backups onto each server instance that hosts the secondary replica, using RESTORE WITH NORECOVERY
2. Join the restored database to the availability group.


Reference:

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/manually-prepare-a-secondary-database-for-an-availability-group-sql-server



You are planning disaster recovery for the failover group of an Azure SQL Database managed instance.

Your company’s SLA requires that the database in the failover group become available as quickly as possible if a major outage occurs.

You set the Read/Write failover policy to Automatic.

What are two results of the configuration? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

  1. In the event of a datacenter or Azure regional outage, the databases will fail over automatically.
  2. In the event of an outage, the databases in the primary instance will fail over immediately.
  3. In the event of an outage, you can selectively fail over individual databases.
  4. In the event of an outage, you can set a different grace period to fail over each database.
  5. In the event of an outage, the minimum delay for the databases to fail over in the primary instance will be one hour.

Answer(s): A,E

Explanation:

A: Auto-failover groups allow you to manage replication and failover of a group of databases on a server or all databases in a managed instance to another region.

E: Because verification of the scale of the outage and how quickly it can be mitigated involves human actions by the operations team, the grace period cannot be set below one hour. This limitation applies to all databases in the failover group regardless of their data synchronization state.

Incorrect Answers:
C: individual SQL Managed Instance databases cannot be added to or removed from a failover group.


Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview






Post your Comments and Discuss Microsoft DP-300 exam with other Community members:

DP-300 Discussions & Posts