exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 4 question 51 discussion

Actual exam question from Microsoft's AZ-305
Question #: 51
Topic #: 4
[All AZ-305 Questions]

HOTSPOT -
You plan to migrate on-premises Microsoft SQL Server databases to Azure.
You need to recommend a deployment and resiliency solution that meets the following requirements:
✑ Supports user-initiated backups
✑ Supports multiple automatically replicated instances across Azure regions
✑ Minimizes administrative effort to implement and maintain business continuity
What should you recommend? 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: an Azure SQL database -
Incorrect answers:
User imitated backups are not supported by Azure SQL Managed instance.

Box 2: Active geo-replication -
Active geo-replication required to multiple automatically replicated instances across Azure regions.
You can manage Azure SQL Database security for geo-restore. SQL database cannot be used for geo-restore.
Incorrect:
Not SQL Server: Active geo-replication requires Azure SQL database.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview

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
Balaji_c_s
Highly Voted 2 years, 2 months ago
Managed Instance + Auto Failover Group
upvoted 94 times
Student2023
1 year, 5 months ago
This is correct
upvoted 3 times
...
...
kay000001
Highly Voted 2 years, 2 months ago
Azure SQL Managed instances & Auto Failover Group - supports User Initiated Backups and minimizes administrative effort for business continuity. https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview?view=azuresql - Auto failover groups https://docs.microsoft.com/en-us/azure/architecture/framework/services/data/azure-sql-managed-instance/reliability
upvoted 26 times
heero
2 years, 2 months ago
but Active geo-replication is not supported by Azure SQL Managed Instance.
upvoted 1 times
GarryK
2 years, 2 months ago
It said Auto Failover groups not active geo replication
upvoted 4 times
...
...
...
SeMo0o0o0o
Most Recent 3 weeks, 1 day ago
WRONG 1. Azure SQL Managed Instance 2. Auto-failover group
upvoted 1 times
...
UWSFish
4 months, 2 weeks ago
Really think it is MI. Microsoft's user initiated backup is a workaround and does not work in all Azure SQL scenarios...https://learn.microsoft.com/en-us/answers/questions/1367837/how-to-initiate-an-on-demand-backup-of-an-azure-ms
upvoted 1 times
...
23169fd
5 months, 2 weeks ago
Deployment solution: Azure SQL Managed Instance Resiliency solution: Auto-failover group
upvoted 1 times
...
Lazylinux
7 months, 2 weeks ago
Based on the below info i would choose MI and Failover-Group Active Geo-Replication: *Configuration: Active Geo-Replication is set up per database and supports manual failover. It allows you to create readable secondary databases in a different Azure region. *Use Case: It’s designed as a business continuity solution, providing a way to maintain a copy of your primary database for disaster recovery purposes. *Number of Secondaries: You can have up to four secondaries for a single primary database. *Applicability: Active Geo-Replication is specific to Azure SQL Database. *Failover: Manual failover is initiated by the user.
upvoted 2 times
Lazylinux
7 months, 2 weeks ago
Finish off => Failover Groups: *Configuration: Failover Groups operate at the server level and 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. *Use Case: It’s suitable for scenarios where you want to manage multiple databases together, ensuring coordinated failover. *Number of Copies: Failover Groups can only have one copy in a different region. *Applicability: Failover Groups are applicable to both Azure SQL Database and Azure SQL DB managed instance. *Failover: Failover is automated and managed by the system. Backups: Even though MI is copy-only backup it is suffice for this task, More info here https://learn.microsoft.com/en-us/azure/azure-sql/database/features-comparison?view=azuresql https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/failover-group-sql-mi?view=azuresql
upvoted 1 times
...
...
Cg007
8 months ago
If priority is minimal administrative effort and the ability to automate replication across regions with built-in failover, then Azure SQL Database single database with auto-failover group is the way to go.
upvoted 1 times
...
varinder82
8 months, 3 weeks ago
Final Answer: - Azure SQL Database with Single SQL Database - Active geo replication
upvoted 3 times
...
ayadmawla
11 months, 1 week ago
My answer is Single SQL Database Active geo MI neither supports manual backup nor multi region
upvoted 2 times
...
BShelat
12 months ago
SQL Managed instance supports "copy-only" backups if initiated by users in other words it is not really a backup then. Hence SQL Managed instance is ruled out. Azure SQL DB single DB supports multiple replicas across multiple regions. Hence given answers are correct.
upvoted 1 times
...
bechidu
1 year, 1 month ago
I think it should be Azure SQL managed instance and Auto failover group. Since user initiated backups are supported only in SQL managed instances... https://learn.microsoft.com/en-us/azure/azure-sql/database/features-comparison?view=azuresql
upvoted 3 times
...
Balamani1
1 year, 2 months ago
Managed Instance + Auto Failover Group refer the link below https://www.examtopics.com/discussions/microsoft/view/75025-exam-dp-300-topic-6-question-17-discussion/
upvoted 3 times
...
jojorabbit2021
1 year, 3 months ago
keyword is "Supports multiple automatically replicated instances" also supports user initiated backups, the only option would be managed instance. Second answer is auto-failover as managed instances don't support active geo replication.
upvoted 3 times
...
Sheedy9022
1 year, 5 months ago
I guess the key here is "support multiple".... given answer is correct
upvoted 1 times
...
NotMeAnyWay
1 year, 5 months ago
Deployment Solution: c. Azure SQL Database Single Database Azure SQL Database Single Database supports user-initiated backups and minimizes administrative effort as it is a fully managed platform as a service (PaaS) database engine. Resiliency Solution: b. Active Geo-Replication Active Geo-Replication supports multiple automatically replicated instances across Azure regions and provides a business continuity solution with minimal administrative effort. It allows for up to four readable secondary databases in the same or different data center locations (regions).
upvoted 7 times
mtc9
9 months, 1 week ago
Data center is a zone, not region
upvoted 1 times
...
...
Tr619899
1 year, 5 months ago
The recommended deployment solution is Azure SQL Managed Instance and the recommended resiliency solution is Auto-failover groups. This combination supports user-initiated backups, multiple automatically replicated instances across Azure regions, and minimizes administrative effort to implement and maintain business continuity.
upvoted 1 times
...
techrat
1 year, 7 months ago
Passed the exam with 979 today, this question was on the exam. I answered Managed Instance and Auto Failover Group
upvoted 18 times
aksuxin
1 year, 5 months ago
passing with 979 seems so suspicious and unnecessary. Microsoft may eventually kill this site. Don't be selfish.
upvoted 4 times
...
LavaPup
1 year, 2 months ago
Thanks @techrat! Just ignore @aksuxin, what a waste comment!
upvoted 3 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
Loading ...