ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam
Go to Exam

Exam DP-300 topic 6 question 17 discussion

Actual exam question from Microsoft's DP-300
Question #: 17
Topic #: 6
[All DP-300 Questions]

HOTSPOT -
You plan to migrate on-premises Microsoft SQL Server databases to Azure.
You need to identify which deployment and resiliency options meet the following requirements:
✑ Support user-initiated backups.
✑ Support multiple automatically replicated instances across Azure regions.
✑ Minimize administrative effort to implement and maintain business continuity.
What should you identify? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Azure SQL Managed Instance
Managed Instance will support native BACKUP like SQL Server.

COPY_ONLY Backup -
Once you create a credential, you can backup any database using standard BACKUP T-SQL command:

BACKUP DATABASE tpcc2501 -
TO URL = 'https://myacc.blob.core.windows.net/testcontainer/tpcc2501.bak'

WITH COPY_ONLY -
The only mandatory property is COPY_ONLY. Azure SQL Managed Instance owns the backup chain. This means that you cannot perform database backup that breaks the backup chain. Azure SQL Managed Instance allows you to perform only COPY_ONLY backups.

Box 2: Auto-failover group -
For geographic failover of instances of SQL Managed Instance, use Auto-failover groups.
The auto-failover groups feature allows you to manage the replication and failover of some or all databases on a logical server to another region.
Incorrect:
Not Active geo-replication: Active geo-replication is not supported by Azure SQL Managed Instance.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/automated-backups-overview https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-sql-db
by eric0718 at May 1, 2022, 11:05 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
boopytoob
6 months, 3 weeks ago
Azure SQL Managed Instance & Auto-failover group 1. Azure SQL Database single database does not support user-initiated backups: - https://learn.microsoft.com/en-us/azure/azure-sql/database/features-comparison?view=azuresql Therefore, the answer must be Azure SQL Managed Instance or SQL Server on Azure Virtual Machines. 2. Active geo-replication is only supported by Azure SQL Database - https://learn.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview?view=azuresql Therefore, the answer must be either Auto-failover group or Zone-redundant deployment. 3. Zone-redundant deployment does not work across multiple Azure Regions - https://learn.microsoft.com/en-us/azure/storage/common/storage-redundancy Therefore, the answer must be Auto-failover group. 4. Auto-failover group is only supported by Azure SQL Managed Instance - https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/auto-failover-group-sql-mi?view=azuresql&tabs=azure-powershell Therefore, the answer must be Azure SQL Managed Instance & Auto-failover group.
upvoted 4 times
voodoo_sh
2 months, 2 weeks ago
you are wrong in my opinion. I think it is: Azure SQL Database and Geo-replication. Because Azure SQL Database supports user-initiated backups. It can be done not through T-SQL, but through Azure portal via Export database (save it as .bacpac to storage account). Geo-replication is the only option that can allow multiple replicas (four) across Azure regions, and Azure SQL DB is the only option that supports it.
upvoted 1 times
...
...
bsk1983
7 months, 4 weeks ago
user initiated backups are possible in SQL managed instance and Active-Geo replication is NOT supported by SQL managed instance so, answer is correct 1) SQL managed instance 2) Auto failover groups
upvoted 1 times
...
vcloudpmp
9 months, 2 weeks ago
User-initiated backups -- Managed Instance. https://github.com/MicrosoftDocs/sql-docs/blob/live/azure-sql/managed-instance/doc-changes-updates-release-notes-whats-new-archive.md Multiple replicas - https://learn.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-sql-db?view=azuresql&tabs=azure-powershell Auto-failover groups support geo-replication of all databases in the group to only one secondary logical server in a different region. If you need to create multiple Azure SQL Database geo-secondary replicas (in the same or different regions) for the same primary replica, use active geo-replication.
upvoted 1 times
...
TheDataGuy
1 year, 3 months ago
Support multiple automatically replicated instances across Azure regions. This cannot be done using Failover. We can have multiple replicas using Geo-Replication. And since we need initiated user backup we need VMs since MI does not support Geo-Replication.
upvoted 1 times
Fer079
1 year, 3 months ago
Active geo-replication applies to Azure SQL Database only, so if you select this option then you cannot use SQL DB in VMs
upvoted 1 times
testdumps2017
8 months, 2 weeks ago
https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/business-continuity-high-availability-disaster-recover-hadr-overview?view=azuresql-mi&preserve-view=true. "Fail over to a geo-replicated secondary instance" - so it can. it is, in fact, part of the Mission Critical tier.
upvoted 1 times
...
...
...
Itsalwaymethecap
1 year, 9 months ago
The answers are: Azure SQL Managed Instance Auto-failover group The requirement is to have user initiated backup hence managed instance supports it. Since its managed instanced, Geo-replication is not supported hence auto-failover groups
upvoted 4 times
...
txustopo
1 year, 10 months ago
The correct Answers is "Azure SQL Databases" and "Geo-replication". "Minimize administrative effort to implement and maintain business continuity." is not in Virtual Machine and the question does not especify that type of Fail Over you want, but especify multiple replications.
upvoted 3 times
...
jackdong
1 year, 10 months ago
I would go Azure SQL Managed Instance" and "Auto-failover group". "Active geo-replication" is applied for Azure SQL Database.
upvoted 4 times
JayBee65
1 year, 9 months ago
The question asks for multiple replicated instances. In active geo-replication is on Database level and can have up to 4 secondaries. The Failover Groups are on server level and can only have one copy in a different region. - so this answer is not correct. https://docs.microsoft.com/en-us/answers/questions/37772/failover-groups-or-geo-replication.html
upvoted 2 times
jackdong
1 year, 8 months ago
Geo-replication is supported by Azure sql database only, which doesn't support user-initiated backups.
upvoted 1 times
...
...
...
JVDA_
1 year, 11 months ago
"Active geo-replication is not supported by Azure SQL Managed Instance but Auto Failover groups is supported." https://docs.microsoft.com/en-us/answers/questions/37772/failover-groups-or-geo-replication.html
upvoted 3 times
...
eric0718
1 year, 11 months ago
Answer is correct.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago