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 is deploying a Microsoft SQL Server environment in Microsoft Azure.
Backups need to be performed and managed automatically.
You need to configure the SQL Server backup.
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: F
Explanation:
SQL Server Managed Backup to Microsoft Azure manages and automates SQL Server backups to Microsoft Azure Blob storage. You can choose to allow SQL Server to determine the backup schedule based on the transaction workload of your database. Or you can use advanced options to define a schedule.
References: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server
managed-backup-to-microsoft-azure
Leave a Reply