nerdexam
Microsoft

70-459 · Question #88

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.)

The correct answer is C. Create a share on your Windows Azure site by using your Windows Azure storage account D. Schedulea full backup by using the command BACKUP DATABASE ProdDB TO URL. 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…

Design and implement database solutions for cloud

Question

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.)

Options

  • ACreate a credential called MyCredential on SQL Server by using a Windows domain account
  • BSchedule a full backup by using the command BACKUP DATABASE ProdDB TO DISK...
  • CCreate a share on your Windows Azure site by using your Windows Azure storage account
  • DSchedulea full backup by using the command BACKUP DATABASE ProdDB TO URL ...
  • ECreate a share on the hot standby site and grant permission to the SQL Server service login.
  • FCreate a credential called MyCredential on SQL Server, using MyStorageAccount for the
  • GSchedule a full backup by using the command BACKUP DATABASE ProdDB TO SHARE ...

How the community answered

(34 responses)
  • A
    6% (2)
  • C
    82% (28)
  • E
    9% (3)
  • G
    3% (1)

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 You can use this feature to manually backup or configureyour own backup strategylike you would for a local storage or other off-site options. This feature is also referred to as SQL Server Backup to URL. SQL Server Managed Backup toWindows Azure

Topics

#Azure backup#BACKUP TO URL#cloud storage#backup strategy

Community Discussion

No community discussion yet for this question.

Full 70-459 Practice