70-765 Sample Questions & Answers
Free Provisioning SQL Databases practice questions with worked answers and explanations. See how the ExamJungle simulator prepares you — then jump into the full test.
Launch the full 70-765 simulator →Showing 3 of 7 free samples.
- Question 1
After recently deploying a number of GS-series virtual machines (VMs) in Microsoft Azure, you are preparing to deploy Microsoft SQL Server.
You are required to deploy a 40 MB database. You want to make sure that you make use of a storage option that guarantees 100 IOPS, but keeps expenses to a minimum.Solution: You configure the use of Premium P4 disk storage.
Has the requirement been satisfied?
Show answer & explanation
Correct answer: A
Explanation:
P4 and P6 disk sizes are as yet only supported for Managed Disks.
References: docs.microsoft.com/en-us/azure/storage/storage-premium-storage#premium-storage-supported-vms">https://docs.microsoft.com/en-us/azure/storage/storage-premium-storage#premium-sto - Question 2
A Microsoft Azure virtual machine (VM) hosts a 2 TB database. The Backup to URL method is employed for Microsoft SQL Server backups. You have been tasked with provisioning the storage account for these backups. You are informed that expenses should be as little as possible. You want to employ a storage option that meets these requirements.
Solution: You configure the use of standard zone redundant blob storage.
Has the requirement been satisfied?
Show answer & explanation
Correct answer: B
Explanation:
Zonel^dundant blob storage would be expensive as it stores three copies of data across multiple datacenters within or across regions.
References: azure.microsoft.com/en-us/pricing/details/storage/blobs/">https://azure.microsoft.com/en-us/pricing/details/storage/blobs/ - Question 3
You are developing a database application using Microsoft SQL Server 2012. You want to create an object that receives an input variable, produces a table of values, and cannot be referenced in a view.
Solution: You make use of a stored procedure.
Has the requirement been satisfied?
Show answer & explanation
Correct answer: B
Explanation:
Stored procedures accept input parameters and return multiple values in the form of output parameters to the calling program. They cannot be used in views.
References: docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/stored-procedures-database-engine">https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/store
Ready for the real thing?
The full 70-765 simulator has every exam-style question, timed mode, and instant scoring.