Microsoft Exam DP-300 Topic 8 Question 50 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 50
Topic #: 8

You have a new Azure subscription.

You create an Azure SQL Database instance named DB1 on an Azure SQL Database server named Server1.

You need to ensure that users can connect to DB1 in the event of an Azure regional outage. In the event of an outage, applications that connect to DB1 must be able to connect without having to update the connection strings.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

AFrom the properties of DB1. configure geo-replication.

BFrom the properties of Server1 add a failover group.

CCreate a new Azure SQL Database server named Server2.

DFrom the properties of Server1 configure retention for DB1

ECreate a new Azure SQL Database instance named DB2.

Show Suggested Answer

Suggested Answer: B, C

https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview?tabs=azure-powershell#best-practices-for-sql-database

https://docs.microsoft.com/en-us/azure/azure-sql/database/failover-group-add-single-database-tutorial?tabs=azure-portal

by Noah at May 07, 2022, 09:17 PM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!