Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
A company has a Microsoft SQL Server environment in Microsoft Azure. The databases are stored directly in Azure blob storage. The company uses a complex backup process.
You need to simplify the backup process. Future restores should not require differential or multiple incremental logs to perform a restore.
You need to design a backup solution for the SQL Server instances.
Which option should you use?
A . backup compression
B . backup encryption
C . file snapshot backup
D . mirrored backup media sets
E . SQL Server backup to URL
F . SQL Server Managed Backup to Azure
G . tail-log backup
H . back up and truncate the transaction log
Answer: C
Explanation:
SQL Server File-snapshot backup uses Azure snapshots to provide nearly instantaneous backups and quicker restores for database files stored using the Azure Blob storage service. This capability enables you to simplify your backup and restore policies.
References: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/file-
snapshot-backups-for-database-files-in-azure?view=sql-server-2017
Leave a Reply