You have an

on-premises Microsoft SQL Server 2014 database in an AlwaysOn availability group.

You are planning a backup solution for the database. Backups will run on a secondary replica.

You need to create a backup procedure for the database. The solution must ensu

re that the backups are stored on-premises and in Microsoft Azure Blob storage.

Which two actions should you perform? Each correct answer presents part of the solution.

A. Run the BACKUP DATABASE statement and use the TO DISK clause.

B. Run the CREATE DA

TABASE statement and use the AS COPY OF clause.

C. Run the BACKUP DATABASE statement and use the TO URL clause.

D. Run the BACKUP DATABASE statement and use the MIRROR clause.

Explanation:

https://msdn.microsoft.com/en-us/library/dn435916.aspx