Exam4Training

Which two actions should you perform?

You need to implement a backup strategy to support the requirements.

Which two actions should you perform? Each correct answer presents part of the solution. Choose two.
A . Create a credential called MyCredential on SQL Server by using a Windows domain account and password.
B . Schedule a full backup by using the command BACKUP DATABASE ProdDB TO DIS
C . ..
D . Create a share on your Windows Azure site by using your Windows Azure storage account information, and grant permission to the SQL Server service login.
E . Schedule a full backup by using the command BACKUP DATABASE ProdDB TO UR
F . .. WTTH CREDENTIAL=N’MyCredential’
G . Create a share on the hot standby site and grant permission to the SQL Server service login.
H . Create a credential called MyCredential on SQL Server, using MyStorageAccount for the storage account name and StorageAccountKey for the access key.
. Schedule a full backup by using the command BACKUP DATABASE ProdDB TO SHAR
. .. WITH CREDENTIAL=N’ MyCredential’

Answer: CD

Explanation:

* Scenario: The current nightly backups have been failing due to insufficient space on the available drives and manual drive cleanup often needing to happen to get past the errors. Additional space will not be made available for backups on the HQ or satellite servers.

* Need to store files in the cloud.

* Manage your backups to Windows Azure: Using the same methods used to backup to DISK and TAPE, you can now back up to Windows Azure storage by Specifying URL as the backup destination. You can use this feature to manually backup or configure your own backup strategy like you would for a local storage or other off-site options. This feature is also referred to as SQL Server Backup to URL.

Exit mobile version