70-473 · Question #23
You are planning the consolidation of the databases from Host1. You need to identify which methods to use to back up the data after the consolidation completes. What are two possible methods that achi
The correct answer is A. BACKUP TO URL C. a maintenance plan. After consolidating databases, two effective methods for backing up the data are using BACKUP TO URL for cloud storage or implementing a scheduled maintenance plan.
Question
Options
- ABACKUP TO URL
- BAlwaysOn failover clustering
- Ca maintenance plan
- DAlwaysOn Availability Groups
How the community answered
(35 responses)- A91% (32)
- B3% (1)
- D6% (2)
Why each option
After consolidating databases, two effective methods for backing up the data are using BACKUP TO URL for cloud storage or implementing a scheduled maintenance plan.
BACKUP TO URL is a SQL Server feature that enables direct backup of databases to Azure Blob Storage, providing a scalable, off-site, and durable storage solution for consolidated database backups.
AlwaysOn Failover Cluster Instances (FCI) provide high availability at the instance level by clustering SQL Server instances, but they do not perform backups; they ensure continuous service availability.
A SQL Server maintenance plan can be configured to automate various administrative tasks, including database backups (full, differential, transaction log), allowing for scheduled and consistent backup operations for the consolidated data.
AlwaysOn Availability Groups offer high availability and disaster recovery through database replication, but they are not a backup mechanism; they provide data redundancy rather than point-in-time restorable copies.
Concept tested: SQL Server backup methods
Source: https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/backup-to-url-for-sql-server
Topics
Community Discussion
No community discussion yet for this question.