Skip to content

Implementing a SQL Data Warehouse

Here you have the best Microsoft 70-767 practice exam questions

  • Preview the first 5 of 142 questions for free
  • These questions were last updated on June 1, 2026
  • This site is not affiliated with or endorsed by Microsoft.
Question 1 of 142

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Microsoft Azure SQL Data Warehouse instance that must be available six months a day for reporting.

You need to pause the compute resources when the instance is not being used.

Solution: You use SQL Server Configuration Manager.

Does the solution meet the goal?

Answer

Suggested Answer

The suggested answer is B.

To manage compute resources for an Azure SQL Data Warehouse, such as pausing them when not in use, you need to use specific management tools provided by Azure, such as the Azure portal, PowerShell, or REST APIs. SQL Server Configuration Manager is not an appropriate tool for this task as it is designed for managing SQL Server services and network configuration on Windows, not for managing Azure SQL Data Warehouse instances. Therefore, the solution of using SQL Server Configuration Manager does not meet the goal.

Question 2 of 142

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Microsoft Azure SQL Data Warehouse instance that must be available six months a day for reporting.You need to pause the compute resources when the instance is not being used.Solution: You use the Azure portal.Does the solution meet the goal?

Answer

Suggested Answer

The suggested answer is A.

To pause a SQL Data Warehouse database, use any of these individual methods.

Pause compute with Azure portal -

Pause compute with PowerShell -

Pause compute with REST APIs -
Note: To pause a database:
1. Open the Azure portal and open your database. Notice that the Status is Online.
Exam 70-767: Question 2 - Image 1

2. To suspend compute and memory resources, click Pause, and then a confirmation message appears. Click yes to confirm or no to cancel.
References:
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-manage-compute-overview https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-manage-compute-portal#pause-compute-bk A
Question 3 of 142

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Microsoft Azure SQL Data Warehouse instance that must be available six months a day for reporting.

You need to pause the compute resources when the instance is not being used.

Solution: You use SQL Server Management Studio (SSMS).

Does the solution meet the goal?

Answer

Suggested Answer

The suggested answer is B.

To pause a SQL Data Warehouse database, use any of these individual methods.

Pause compute with Azure portal -

Pause compute with PowerShell -

Pause compute with REST APIs -
References:
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-manage-compute-overview
Question 4 of 142

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a data warehouse that stores information about products, sales, and orders for a manufacturing company. The instance contains a database that has two tables named SalesOrderHeader and SalesOrderDetail. SalesOrderHeader has 500,000 rows and SalesOrderDetail has 3,000,000 rows.

Users report performance degradation when they run the following stored procedure:

Exam 70-767: Question 4 - Image 1

You need to optimize performance.

Solution: You run the following Transact-SQL statement:

Exam 70-767: Question 4 - Image 2

Does the solution meet the goal?

Answer

Suggested Answer

The suggested answer is B.

Creating statistics with a sample size of 100 rows from a table containing 500,000 rows is inadequate for the query optimizer to generate an effective execution plan. The sample size is too small to accurately represent the data distribution within the table. For better performance, a larger sample size or full statistics should be created, or other optimizations such as indexing might be necessary to improve the query performance.

Question 5 of 142

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a data warehouse that stores information about products, sales, and orders for a manufacturing company. The instance contains a database that has two tables named SalesOrderHeader and SalesOrderDetail. SalesOrderHeader has 500,000 rows and SalesOrderDetail has 3,000,000 rows.

Users report performance degradation when they run the following stored procedure:

Exam 70-767: Question 5 - Image 1

You need to optimize performance.

Solution: You run the following Transact-SQL statement:

Exam 70-767: Question 5 - Image 2

Does the solution meet the goal?

Answer

Suggested Answer

The suggested answer is B.

The proposed solution of creating statistics with a sample size of 0 percent will not optimize performance. When 0 percent is specified, the statistics object is created but does not contain any actual statistics data, which would not help in optimizing the query performance. Proper statistics are needed to help the query optimizer make informed decisions. Therefore, this solution does not meet the goal of optimizing performance.

137 more questions await

Unlock the full Microsoft 70-767 question bank

5 of 142 completed4%

Choose your plan

One-time payment · No subscription · No hidden fees

Standard

Quick preparation

$25

30 days access

30 day access to all questions
Instant free updates
Highest passing rate in industry
Printable PDF download
No money-back guarantee
Best Value

Premium

Guaranteed success

$60$35

90 days access

PDF

Printable PDF download

New

Save every question as a PDF for offline study or printing.

90 day access to all questions
Instant free updates
Highest passing rate in industry
Pass guaranteed or money back

100% Money-Back Guarantee

Don't pass? Full refund.

4.9/5

Based on 5,948+ reviews

Trusted by thousands of professionals

Join certified professionals who passed their exams with Examice

Examice helped me pass my AWS certification on the first try! The questions were incredibly similar to the real exam. Comments helped me understand answers I was struggling with.
S
Sarah C.
Cloud Engineer
Great results in a short prep time. Passed on my first attempt.
D
David K.
Network Engineer
I needed to pass an exam for work, and this website delivered. The quality for the price is outstanding, and the support is really good. I passed without issues.
M
Michael R.
Security Analyst
Skeptical at first, but impressed. Every question included clear, detailed explanations.
L
Lisa M.
Solutions Architect
The guarantee gave me confidence to invest in the premium package. Turns out I didn't need it. Passed comfortably. The explanations for each answer were incredibly detailed and helped me grasp security concepts that I'd been struggling with for months.
R
Robert H.
Cybersecurity Consultant
Used Examice for my PMP certification. The questions were well structured and covered all exam domains thoroughly.
J
James T.
IT Manager
After failing my first attempt with other study materials, I switched to Examice and passed confidently on my second attempt.
A
Anna W.
Data Engineer
The premium package was worth it. 90 days of access gave me the flexibility to study when it worked for me, without feeling rushed.
E
Emily J.
DevOps Engineer
Straightforward questions that matched the real exam perfectly. Studied for two weeks and passed with a great score.
K
Karen P.
Systems Administrator

Frequently Asked Questions

Everything you need to know. Contact us for more.

Our Microsoft 70-767 questions are based on real exam experiences and are continuously updated to match the current exam format. Most candidates who study with us report passing on their first attempt, based on a self reported post exam survey.

With our Premium package, you get a 100% money-back guarantee. If you don't pass your exam after studying with our materials, simply contact us with your exam results and we'll refund your purchase. Terms and conditions apply, read our full refund policy to learn more.

Our question bank is updated regularly based on feedback from recent exam takers. We typically review and update our content every week with reports about new questions or changes to the exam format.

Yes. When your access is close to expiring, you can renew it for another 30 days directly from the exam page. If you need more time while you are still preparing, reach out and we will help.

This is a one-time payment with no recurring charges. Once you purchase, you get full access to all exam questions for the duration of your package (30 days for Standard, 90 days for Premium). No hidden fees or automatic renewals.

Pass on your first try

All 142questions · Detailed explanations · Printable PDF · 90 days access

Money-back guaranteeSecure checkout
$35

one-time payment