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

Page 11 of 76
PDF with 352 Questions

You have an Azure SQL database named SQL1.

You need to implement a disaster recovery solution for SQL1. The solution must minimize the following:

•The recovery point objective (RPO)
•The recovery time objective (RTO)
•Administrative effort

What should you include in the solution?

  1. Azure Site Recovery
  2. active geo-replication
  3. availability groups
  4. auto-failover groups

Answer(s): D



You need to recommend a disaster recovery solution for an on-premises Microsoft SQL Server database. The solution must meet the following requirements:

•Support real-time data replication to a different geographic region.
•Use Azure as a disaster recovery target.
•Minimize costs and administrative effort.

What should you include in the recommendation?

  1. database mirroring on an instance of SQL Server on Azure Virtual Machines
  2. availability groups for SQL Server on Azure Virtual Machines
  3. an Azure SQL Managed Instance link
  4. transactional replication to an Azure SQL Managed Instance

Answer(s): D



You have an Azure subscription.

You need to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability group. The solution must meet the following requirements:

•Minimize how long it takes to fail over.
•Maintain existing connections to the primary replica during a failover.

What should you do?

  1. Connect each virtual machine to a different subnet on a virtual network. Deploy a basic Azure load balancer.
  2. Connect each virtual machine to a different subnet on a single virtual network.
  3. Connect each virtual machine to a single subnet on a single virtual network.
  4. Connect each virtual machine to a single subnet on a virtual network. Deploy a standard Azure load balancer.

Answer(s): C



You have an Azure SQL database.

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

•Minimizes how long it takes to recover the database if a datacenter fails
•Minimizes administrative effort

What should you include in the solution?

  1. Azure Site Recovery
  2. active geo-replication
  3. auto-failover groups
  4. Azure Backup

Answer(s): C



Page 11 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