Microsoft
70-465 · Question #144
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. Schedule a 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…
Submitted by ravi_2018· Mar 5, 2026Design and implement database solutions for SQL Server
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
- DSchedule a 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
(46 responses)- A2% (1)
- B2% (1)
- C72% (33)
- E9% (4)
- G15% (7)
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 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. SQL Server Managed Backup to Windows Azure
Topics
#Azure storage backup#SQL Server backup#BACKUP TO URL#credentials
Community Discussion
No community discussion yet for this question.