Home » Microsoft » 70-765 » Which storage option should you use?
Note: This question-is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question-in the series. Each question-is independent of the other questions in this series.
Information and details provided in a question-apply only to that question.
You have a virtual machine (VM) in Microsoft Azure, which has a 2 terabyte (TB) database. Microsoft SQL Server backups are performed by using Backup to URL.
You need to provision the storage account for the backups while minimizing costs.
Which storage option should you use?
A. Premium P10 disk storage B. Premium P20 disk storage
B. Premium P30 disk storage
C. Standard locally redundant disk storage
D. Standard geo-redundant disk storage
E. Standard zone redundant blob storage
F. Standard locally redundant blob storage
G. Standard geo-redundant blob storage
Correct Answer: G
Explanation/Reference:
A URL specifies a Uniform Resource Identifier (URI) to a unique backup file. The URL is used to provide the location and name of the SQL Server backup file. The URL must point to an actual blob, not just a container. If the blob does not exist, it is created. If an existing blob is specified, BACKUP fails, unless the “WITH FORMAT” option is specified to overwrite the existing backup file in the blob.
LOCALLY REDUNDANT STORAGE (LRS) makes multiple synchronous copies of your data within a single datacenter.
Incorrect Answers:
F: Zone redundant blob storage would be me more expensive as it stores three copies of data across multiple datacenters within or across regions.
References: https://msdn.microsoft.com/en-us/library/dn435916.aspx https://azure.microsoft.com/en-us/pricing/details/storage/blobs/
it’s F
F?