Booking the 070-765 exam means paying the registration fee all over again if the first attempt goes wrong. That is why so many candidates rehearse with the Microsoft Provisioning SQL Databases questions from ExamCost before they ever schedule a seat.
Microsoft 070-765 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Provisioning SQL Databases |
| Exam Number: | 70-765 |
| Exam Duration: | 120 minutes |
| Passing Score: | 700 (on a scale of 1000) |
| Related Certifications: | 70-764 Administering a SQL Database Infrastructure MCSA: SQL 2016 Database Administration |
| Exam Format: | Multiple Response, Multiple Choice |
| Real Exam Qty: | 40-60 |
| Certificate Validity Period: | Certification recognized under MCSA until retirement of the certification track |
| Available Languages: | English |
| Exam Price: | $165 USD (approx.) |
| 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:
| Section | Objectives |
|---|---|
| Topic 1: Manage Databases and Instances | - Configure SQL Server performance settings - Configure secure access to Azure SQL Databases - Manage SQL Server instances |
| Topic 2: Deploy and Migrate Applications / Manage Storage | - Manage SQL Storage and perform database maintenance - Deploy applications to Azure SQL Database or SQL Server on Azure VM - Migrate on-premises SQL Server databases to Azure |
| Topic 3: Implement SQL in Azure | - Deploy SQL Server databases to Azure VMs - Deploy Microsoft Azure SQL Database - Plan SQL Server installation - Deploy SQL Server instances |
Your Microsoft Provisioning SQL Databases Questions, Answered
Registering for the 070-765 exam costs $165 USD (approx.) at the official rate, and you need 700 (on a scale of 1000) to pass. Bear in mind that an unsuccessful attempt is not discounted the second time around — a retake is charged at the full fee again. That is why experienced candidates test themselves with the 268 practice questions from ExamCost until their results are consistently strong before spending money on the real thing.
Yes, and we encourage it. A free PDF demo of the 070-765 questions is available so you can evaluate the quality and layout before buying. After purchase, your material stays current with 365 days of free updates — and if that period ever expires, you can extend the update service at a 50% discount through your member zone.
You will face 40-60 questions within a time allowance of 120 minutes. Raw numbers aside, the real skill is pacing: candidates who run out of time usually spent too long on early questions. Our advice is to set a mental per-question budget, skip and revisit anything that stalls you, and complete at least two full timed runs in the ExamCost test engine before the real appointment so the clock never rattles you.
Both situations are covered. Take the corresponding 070-765 exam within 60 days of purchase without passing, and you may claim a full refund under our 100% Money Back Guarantee: submit a scanned exam enrollment slip plus the official Score Report PDF within 2 days of your exam date, and we finish processing within 7 days. The conditions are strict — an exam taken within 3 days of purchase does not qualify, the candidate's name must match the payer's, and free materials or expired orders are excluded. Would you rather keep studying? Swap the order for two other exam products of equal value free of charge while keeping updates on your original purchase. As for delivery, it is immediate: files unlock for download the moment payment clears, a copy reaches your mailbox within a minute, and there is no cap on how many computers you install it on — if 2 hours pass with nothing received, contact our support team.
Passing the 070-765 exam earns you the MCP certification, a Associate / Professional (MCSA SQL 2016 Database Administration)-level credential. It is the vendor's official proof that your skills meet the standard employers look for, and it regularly appears as a requirement in job postings. The certification also relates to 70-764 Administering a SQL Database Infrastructure, MCSA: SQL 2016 Database Administration, so it can anchor a broader certification plan rather than stand alone.
Recommended: experience with SQL Server administration, cloud service models, and Azure SQL Database/VM deployments Because vendors revise their eligibility rules from time to time, treat this as a starting point and verify the latest requirements on the official exam page — see the official 070-765 exam outline before you commit to a test date.
The vendor organizes the Microsoft Provisioning SQL Databases blueprint into 3 domains, led by Deploy and Migrate Applications / Manage Storage, Implement SQL in Azure, Manage Databases and Instances. Every domain contains further subtopics, and the weighting tells you where your study hours pay off most — the full outline above has the complete picture, so review it before building your study plan.
Microsoft Provisioning SQL Databases Sample Questions:
You have an on-premises Microsoft SQL server named server and a Microsoft Azure SQL Database server named server2. Server1 has a database named obi . server2 has several databases.
You need to configure db1 to store infrequently accessed data on server2.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of anions to the answer area and arrange them in the correct order.
Correct Answer:
Explanation:
References:
https://docs.microsoft.com/en-us/sql/sql-server/stretch-database/enable-stretch-database-for-a-database?view=sql-server-ver15
You use Microsoft SQL Server 2014 to develop a database application. You need to create an object that meets the following requirements:
Which object should you use?
- A. Scalar-valued function
- B. Inline function
- C. User-defined data type
- D. Stored procedure
Correct Answer: D 🗳️
Explanation: Only visible for ExamCost members. You can sign-up / login (it's free).
You use Resource Manager to deploy a new Microsoft SQL Server instance in a Microsoft Azure virtual machine (VM) that uses Premium storage. The combined initial size of the SQL Server user database files is expected to be over 200 gigabytes (GB). You must maximize performance for the database files and the log file.
You add the following additional drive volumes to the VM:
You have the following requirements:
Maximize performance of the SQL Server instance.
Use Premium storage when possible.
You need to deploy the SQL instance.
In the table below, identify the drive where you must store each SQL Server file type.
NOTE: Make only one selection in each column. Each correct selection is worth one point.
Correct Answer:
Explanation:
Enable read caching on the disk(s) hosting the data files and TempDB.
Do not enable caching on disk(s) hosting the log file. Host caching is not used for log files.
Incorrect Answers:
C, D: Avoid using operating system or temporary disks for database storage or logging.
References:
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-performance
You have a Microsoft SQL Server that has a database named DB1. DB1 has a data files on drive E and transaction logs on drive L.
Drive L fails and is replaced.
You need to recover DB1. The solution must minimize data loss.
Which three statements should you execute in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.
Correct Answer:
1 - ALTER DATABASE db1 SET SINGEL_USER WITH ROLL-BACK IMMEDIATE
2 - DBCC CHECKED('DB1' REPAIR_REBUILD)
3 - ALTER DATABASE DB1 SET ONLINE, MULTI_USER
Explanation:
ALTER DATABASE '<your_database>' SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO DBCC CHECKDB ('<your_database>', REPAIR_REBUILD) GO ALTER DATABASE '<your_database>' SET MULTI_USER GO
You administer a Microsoft SQL Server 2014 database.
You configure Transparent Data Encryption (TDE) on the Orders database by using the following statements:
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'MyPassword1!'
CREATE CERTIFICATE TDE_Certificate WITH SUBJECT = 'TDE Certificate';
BACKUP CERTIFICATE TDE_Certificate TO FILE = ''d:\TDE_Certificate.cer'
WITH PRIVATE KEY (FILE = 'D:\TDE_Certificate.key',
ENCRYPTION BY PASSWORD = 'MyPassword1!');
CREATE DATABASE ENCRYPTION KEY
WITH ALGORITHM = AES_256
ENCRYPTION BY SERVER CERTIFICATE TDE_Certificate;
ALTER DATABASE Orders SET ENCRYPTION ON;
You attempt to restore the Orders database and the restore fails. You copy the encryption file to the original location.
A hardware failure occurs and so a new server must be installed and configured.
After installing SQL Server to the new server, you restore the Orders database and copy the encryption files to their original location. However, you are unable to access the database.
You need to be able to restore the database.
Which Transact-SQL statement should you use before attempting the restore?
- A. ALTER DATABASE Master SET ENCRYPTION OFF;
- B. CREATE CERTIFICATE TDE_Certificate FROM FILE = 'd:\TDE_Certificate.cer';
- C. CREATE CERTIFICATE TDE_Certificate FROM FILE = 'd:\TDE_Certificate.cer'WITH PRIVATE KEY (FILE = 'D:\TDE_Certificate.key',DECRYPTION BY PASSWORD = 'MyPassword1!');
- D. CREATE CERTIFICATE TDE_Certificate WITH SUBJECT = 'TDE Certificate'; USE Orders;CREATE DATABASE ENCRYPTION KEYWITH ALGORITHM = AES_256ENCRYPTION BY SERVER CERTIFICATE TDE_Certificate;
Correct Answer: C 🗳️
Explanation: Only visible for ExamCost members. You can sign-up / login (it's free).
Viewing page 1 out of 54 pages.
Viewing questions 1-5 out of 268 questions.
