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 ensure 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 DATABASE statement and use the AS COPY OF clause.
C.
Run the BACKUP DATABASE statement anduse 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
Should be A & C
1
0
+1
0
0
Why dont consider answers A. and B.
answer A. allow you to meet the requisite “…ensure that the backups are stored on-premises”
answer B. allows to “…Backups will run on a secondary replica.”
0
1
B is “CREATE DATABASE” not “BACKUP DATABASE”, and what about “and in Microsoft Azure Blob storage.” part?
0
0