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
C.
Premium P30 disk storage
D.
Standard locally redundant disk storage
E.
Standard geo-redundant disk storage
F.
Standard zone redundant blob storage
G.
Standard locally redundant blob storage
H.
Standard geo-redundant blob storage
Explanation:
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.https://msdn.microsoft.com/en-us/library/dn435916.aspx
https://azure.microsoft.com/en-us/pricing/details/storage/blobs/