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: 12)

Page 12 of 76
PDF with 352 Questions

You have an Azure SQL database named DB1.

You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails. The solution must minimize costs.

Which deployment option and pricing tier should you configure?

  1. Azure SQL Database managed instance General Purpose
  2. Azure SQL Database Hyperscale
  3. Azure SQL Database Premium
  4. Azure SQL Database managed instance Business Critical

Answer(s): C



You are modifying an existing disaster recovery solution for an Azure SQL managed instance that contains a failover group named FG1.

You need to ensure the maximum in-transit time for FG1 when an automatic failover oсcurs.

What should you configure?

  1. an availability group
  2. a secondary managed instance
  3. a failover policy
  4. a grace period

Answer(s): D



You have an Azure subscription that contains three instances of SQL Server on Azure Virtual Machines.

You plan to implement a disaster recovery solution.

You need to be able to perform disaster recovery drills regularly. The solution must meet the following requirements:

•Minimize administrative effort for the recovery drills.
•Isolate the recovery environment from the production environment

What should you use?

  1. native Microsoft SQL Server backup
  2. Azure Site Recovery
  3. Recovery Services vaults
  4. Azure Backup

Answer(s): B



You have an instance of SQL Server on Azure Virtual Machines named VM1.

You need to implement a disaster recovery solution that meets the following requirements:

•Returns the solution to an operational state within 15 minutes of a failure
•Can perform disaster recovery testing in an isolated environment
•Minimizes administrative effort

What should you include in the solution?

  1. active geo-replication
  2. auto-failover groups
  3. Azure Site Recovery
  4. a failover cluster instance (FCI)

Answer(s): C



Page 12 of 76



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

laks commented on December 26, 2024
so far seems good
UNITED STATES
upvote

Jack commented on October 24, 2024
Muito bom as perguntas
Anonymous
upvote

TheUser commented on October 23, 2024
So far seems good
Anonymous
upvote

anonymus commented on October 23, 2024
master database differential backup is not supported in sql server
EUROPEAN UNION
upvote

Ntombi commented on October 17, 2024
i find the questions helpful for my exam preparation
Anonymous
upvote

Ntombi commented on October 17, 2024
The questions help me to see if I understood what I have learned
Anonymous
upvote

ntombi commented on October 17, 2024
writing exam at the end of the month
Anonymous
upvote

Raby commented on August 13, 2024
Wonderful work guys. The PDF version helped me pass. Thank you
EUROPEAN UNION
upvote