Microsoft MCP 070-765

Not sure a study set is what you need? Download the free 070-765 demo from Getcertkey and review a sample of the Microsoft Provisioning SQL Databases practice questions before you spend anything — the 2026 edition is ready to try today.

Microsoft 070-765 Exam Overview:

Certification Vendor:	Microsoft
Exam Name:	Provisioning SQL Databases
Exam Number:	70-765
Related Certifications:	MCSA: SQL 2016 Database Administration 70-764 Administering a SQL Database Infrastructure
Exam Duration:	120 minutes
Exam Format:	Multiple Response, Multiple Choice
Exam Price:	$165 USD (approx.)
Available Languages:	English
Certificate Validity Period:	Certification recognized under MCSA until retirement of the certification track
Passing Score:	700 (on a scale of 1000)
Real Exam Qty:	40-60
Sample Questions:
Exam Way:	Delivered through Pearson VUE testing centers and online proctored options
Pre Condition:	Recommended: experience with SQL Server administration, cloud service models, and Azure SQL Database/VM deployments
Official Syllabus URL:	https://learn.microsoft.com/en-us/certifications/exams/70-765

Microsoft 070-765 Exam Syllabus Topics:

Common Questions About the Microsoft 070-765 Exam

What is the Microsoft Provisioning SQL Databases exam all about?

The 070-765 exam is the official Microsoft exam behind the MCP certification, validating the skills measured by the Microsoft Provisioning SQL Databases credential. It sits at the Associate / Professional (MCSA SQL 2016 Database Administration) level of the Microsoft certification program. It also connects to 70-764 Administering a SQL Database Infrastructure, MCSA: SQL 2016 Database Administration, so the knowledge you build here carries over to those tracks as well.

How many questions are on the 070-765 exam, and how much time do I get?

The 070-765 exam contains 40-60 questions to be completed within 120 minutes. Before exam day, divide the available time by the question count to work out a comfortable per-question pace, and mark any item that eats into it so you can return later instead of getting stuck. Timed sessions in the Getcertkey test engines make that pacing automatic — run at least two full-length mock exams under the clock so time pressure never becomes the reason you drop points.

What score do I need to pass the 070-765 exam, and what does it cost?

The passing score for the 070-765 exam is 700 (on a scale of 1000), and the official registration fee is $165 USD (approx.). Retakes are not discounted — every new attempt means paying the full fee again — so it pays to measure yourself before you book. Work through the 268 practice questions on Getcertkey, sit a timed practice test, and schedule your exam only when your scores are consistently comfortable. That simple habit is the cheapest exam strategy there is.

Are there any prerequisites for the 070-765 exam?

Recommended: experience with SQL Server administration, cloud service models, and Azure SQL Database/VM deployments Requirements can change when Microsoft revises its certification program, so confirm the current eligibility rules on the official exam page before you register.

Can I try the 070-765 practice questions before I buy?

Yes. Getcertkey provides a free 070-765 PDF demo so you can review the question style and answer quality before purchasing. Every purchase also includes 365 days of free updates — if Microsoft revises the exam during that period, the updated material reaches you at no cost. Once the free-update year ends, you can extend your update service at a 50% discount.

What if I fail the 070-765 exam, and how is my order delivered?

Every Microsoft Provisioning SQL Databases purchase on Getcertkey is covered by a 100% money-back guarantee with clear conditions: if you take the corresponding exam within 60 days of your purchase and do not pass, you can claim a full refund by submitting a scanned copy of your exam enrollment slip and your official score report as a PDF within two days of the exam date; claims are processed within seven days of submission. The guarantee does not apply to exams taken within three days of purchase, to material that was downloaded but never used in an exam attempt, or to free products and expired orders, and the candidate name must match the payer name. If you would rather not take a refund, you can instead exchange your purchase for two free exam preparation products of equal value and keep the update service on your original product.

Delivery is instant: your download is sent to your email within one minute of payment, with no limit on how many computers you may install the material on. If nothing arrives within two hours, check your spam folder and contact customer service for help.

What topics are covered in the 070-765 exam?

The Microsoft Provisioning SQL Databases exam blueprint is organized into 3 domains. The first three are:

• Manage Databases and Instances
• Implement SQL in Azure
• Deploy and Migrate Applications / Manage Storage

For the complete domain-by-domain breakdown, scroll up to the full exam topics outline above and use it to plan how you distribute your study time.

Microsoft Provisioning SQL Databases Sample Questions:

Question #1

You administer all the deployments of Microsoft SQL Server 2014 in your company. You have two servers in the same data center that hosts your production database.
You need to ensure that the database remains available if a catastrophic server failure or a disk failure occurs.
You also need to maintain transactional consistency of the data across both servers.
You need to achieve these goals without manual intervention.
Which configuration should you use?

A. Two servers configured on the same subnetSQL Server Availability Group configured in Synchronous-Commit Availability Mode
B. Two servers configured in the same data centerA primary server configured to perform log-shipping every 10 minutes A backup server configured as a warm standby
C. Two servers configured in different data centersSQL Server Availability Group configured in Synchronous-Commit Availability Mode One server configured as an Active Secondary
D. Two servers configured in different data centersSQL Server Availability Group configured in Asynchronous-Commit Availability Mode
E. Two servers configured in a Windows Failover Cluster in the same data center SQL Server configured as a clustered instance
F. Two servers configured in the same data centerSQL Server Availability Group configured in Asynchronous-Commit Availability Mode One server configured as an Active Secondary
G. SQL Server that includes an application database configured to perform transactional replication
H. SQL Server that includes an application database configured to perform snapshot replication

Question #2

You administer a Microsoft SQL Server 2014 database instance. You create a new user named UserA.
You need to ensure that UserA is able to create SQL Server Agent jobs and execute SQL Server agent jobs owned by UserA To which role should you add UserA?

A. SQLAgentUserRole
B. ServerGroupAdministratorGroup
C. Securityadmin
D. DatabaseMailUserRole

Question #3

You have Microsoft SQL Server on a Microsoft Azure Virtual machine that has a 4-TB database.
You plan to configure daily backups for the database. A single full backup will be approximately 1.5 TB of compressed data.
You need to ensure that the last backups are retained.
Where should you store the daily backups?

A. Local storage
B. Block blob storage.
C. Page blob storage
D. Virtual disks

Question #4

You have a Microsoft SQL server that manages all of your databases.
You must create a database named Marketing Data. The database will initially consume 400 megabytes (MB) of storage and will grow by one percent per year.
The database file must be stored on the Marketing share of the Lon-SVR1 server. The file must not automatically increase in size. Log files must be stored on the L drive of the SQL Server machine in a folder named Logs.
You need to create the MarketingData database.
How should you complete the Transact-SQL statement? To answer, select the appropriate Transact-SQL segments in the answer area.
NOTE: Each correct selection is worth one point.

Question #5

You plan to create an AlwaysOn availability group that will have two replicas in Microsoft Azure and two onpremises replicas.
You need to ensure that a replica in Azure is always available.
Which cmdlet should you run before you deploy the virtual machines?

A. New-AzureRmSqlServerCommunicationLink
B. New-AzureRmSqlServer
C. New-AzureRmAvailabilitySet
D. New-AzureRmSqlElasticPool
E. New-AzureRmLoadBalancer
F. New-AzureRmVM
G. New-AzureRmSqlDatabaseSecondary
H. New-AzureRmSqlDatabaseCopy

Solutions: