Download Microsoft.70-765.Test4Prep.2018-11-16.106q.tqb
| Vendor: | Microsoft |
| Exam Code: | 70-765 |
| Exam Name: | Provisioning SQL Databases |
| Date: | Nov 16, 2018 |
| File Size: | 2 MB |
Demo Questions
Question 1
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?
- Premium P10 disk storage
- Premium P20 disk storage
- Premium P30 disk storage
- Standard locally redundant disk storage
- Standard geo-redundant disk storage
- Standard zone redundant blob storage
- Standard locally redundant blob storage
- Standard geo-redundant blob storage
Correct answer: G
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.References:https://msdn.microsoft.com/en-us/library/dn435916.aspxhttps://azure.microsoft.com/en-us/pricing/details/storage/blobs/ 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/
Question 2
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 deployed a GS-series virtual machine (VM) in Microsoft Azure. You plan to deploy Microsoft SQL Server.
You need to deploy a 30 megabyte (MB) database that requires 100 IOPS to be guaranteed while minimizing costs.
Which storage option should you use?
- Premium P10 disk storage
- Premium P20 disk storage
- Premium P30 disk storage
- Standard locally redundant disk storage
- Standard geo-redundant disk storage
- Standard zone redundant blob storage
- Standard locally redundant blob storage
- Standard geo-redundant blob storage
Correct answer: A
Explanation:
Premium Storage Disks Limits When you provision a disk against a Premium Storage account, how much input/output operations per second (IOPS) and throughput (bandwidth) it can get depends on the size of the disk. Currently, there are three types of Premium Storage disks: P10, P20, and P30. Each one has specific limits for IOPS and throughput as specified in the following table: References: https://docs.microsoft.com/en-us/azure/storage/storage-premium-storage Premium Storage Disks Limits
When you provision a disk against a Premium Storage account, how much input/output operations per second (IOPS) and throughput (bandwidth) it can get depends on the size of the disk. Currently, there are three types of Premium Storage disks: P10, P20, and P30. Each one has specific limits for IOPS and throughput as specified in the following table:
References: https://docs.microsoft.com/en-us/azure/storage/storage-premium-storage
Question 3
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 deployed several GS-series virtual machines (VMs) in Microsoft Azure. You plan to deploy Microsoft SQL Server in a development environment.
You need to provide storage to the environment that minimizes costs.
Which storage option should you use?
- Premium P10 disk storage
- Premium P20 disk storage
- Premium P30 disk storage
- Standard locally redundant disk storage
- Standard geo-redundant disk storage
- Standard zone redundant blob storage
- Standard locally redundant blob storage
- Standard geo-redundant blob storage
Correct answer: D
