Sign in

Free 70-765 sample questions

Real questions from the Provisioning SQL Databases practice bank, with the correct answer and an explanation for each one. No junk, no filler.

Try them in the simulator Same questions, with study, timed and flashcard modes.

Showing 3 of 7 free sample questions.

Question 1Choose one

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?

Question 2Choose one

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?

Question 3Choose one

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?

4 more free samples are waiting

Create a free account to unlock the whole 70-765 sample bank, or get full access to all 48 practice questions in the simulator.

Create account