Note: This question is part of a serie

s 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 o

nly to that question.

A company has a Microsoft SQL Server environment in Microsoft Azure. The databases are stored directly in Azure blob storage.

You need to ensure that you can restore a database to a specific point in time between backups while mini

mizing the number of Azure storage containers required.

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

SQL Server Managed Backup to Microsoft Azure supports point in time restore for the retention time period specified.

References:

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-managed-backup-to-microsoft-azure?view=sql-server-2017