Home » Microsoft » 70-765 » Where should you store the daily backups?
You have Microsoft SQL Server on a Microsoft Azure Virtual machine that has a 4-TB database.
You plan to configure daily backups for the database. A single full backup will be approximately 1.5 TB of compressed data.
You need to ensure that the last backups are retained.
Where should you store the daily backups?
A. Local storage
B. Page blob storage
C. Virtual disks
D. Block blob storage.
Correct Answer: D
Explanation/Reference:
Explanation:
When backing up to Microsoft Azure blob storage, SQL Server 2016 supports backing up to multiple blobs to enable backing up large databases, up to a maximum of 12.8 TB. This is done through Block Blobs.
Incorrect Answers:
A: Local storage is not guaranteed to be retained.
Reference: https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-backup-recovery