nerdexam
Microsoft

70-473 · Question #5

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…

The correct answer is A. Run the BACKUP DATABASE statement and use the TO DISK clause. C. Run the BACKUP DATABASE statement and use the TO URL clause. https://msdn.microsoft.com/en-us/library/dn435916.aspx

Implement business continuity

Question

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.

Options

  • ARun the BACKUP DATABASE statement and use the TO DISK clause.
  • BRun the CREATE DATABASE statement and use the AS COPY OF clause.
  • CRun the BACKUP DATABASE statement and use the TO URL clause.
  • DRun the BACKUP DATABASE statement and use the MIRROR clause.

How the community answered

(17 responses)
  • A
    82% (14)
  • B
    12% (2)
  • D
    6% (1)

Explanation

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

Topics

#SQL Server backup#AlwaysOn Availability Groups#Azure Blob storage#BACKUP DATABASE

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-473 Practice