// implementing a sql data warehouse
IMPLEMENTING-A-SQL-DATA-WAREHOUSE
Prepare for the Microsoft SQL Data Warehouse exam with domain-aligned practice and real-world scenarios for data engineers.
49
questions
40
in exam
120m
duration
at a glance
What you get
PDF US$10.00Sub US$10/mopass 700
Free practice questions are available without payment; anyone can start practicing at no cost.
access options
PDF bank or platform subscription?
Two separate purchases: a one-time PDF for 70-767, or a monthly subscription for online practice and simulators across the platform. A subscription does not include the PDF download.
option / 01 · pdf file
Full question bank PDF
US$10.00· one-time
- Full question bank as a print-ready PDF
- Lifetime access to this exam only
- Domain-tagged questions with explanations
- Separate from online practice — buy once
option / 02 · subscription
All exams · practice & simulator
US$10.00· per month
- Practice & exam simulator on every bank
- All current and future exams included
- Personal analytics and retention tools
- Cancel anytime — no per-exam upsells
sample · 1 of 49Shuffle
See what's in the bank.
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have a database named DB1 that has change data capture enabled.
A Microsoft SQL Server Integration Services (SSIS) job runs once weekly. The job loads changes from DB1 to a data warehouse by querying the change data capture tables.
Users report that an application that uses DB1 is suddenly unresponsive.
You discover that the Integration Services job causes severe blocking issues in the application.
You need to ensure that the users can run the application as quickly as possible.
Your SQL Server login is a member of only the ssis_admin database role.
Which stored procedure should you execute?
You have a database named DB1 that has change data capture enabled.
A Microsoft SQL Server Integration Services (SSIS) job runs once weekly. The job loads changes from DB1 to a data warehouse by querying the change data capture tables.
Users report that an application that uses DB1 is suddenly unresponsive.
You discover that the Integration Services job causes severe blocking issues in the application.
You need to ensure that the users can run the application as quickly as possible.
Your SQL Server login is a member of only the ssis_admin database role.
Which stored procedure should you execute?
A
catalog.deploy_project
0%
B
catalog.restore_project
0%
C
catalog.stop_operation
0%
D
sys.sp_cdc_add_job
0%
04 · coverage
Exam domains
Designing and Implementing Data Storage Solutions25%
1 q
Data Processing20%
0 q
Data Integration25%
4 q
Data Security and Compliance30%
0 q
Uncategorized90%
44 q
community questionsview all →
Questions from the community
Top-voted approved contributions for this exam, reviewed before landing in the bank.
// top community questionsview all →
0.0 · 0 reviews
What candidates say
no reviews yet
related
You may also like
More exams based on your interests.
49 questions
PDF US$10.00 one-time·Sub US$10/mo
updated 7h ago·devco · cert
premiummicrosoft● updated 7h ago
Implementing a SQL Data Warehouse
Prepare for the Microsoft SQL Data Warehouse exam with domain-aligned practice and real-world scenarios for data engineers.
// OFFICIAL EXAM LOGISTICS
source · microsoft
// PASSING SCORE
750 / 1000· scaled
minimum to pass
75%of scale
// QUESTIONS
40official
// DURATION
120min
// EXAM FEE
165usd
// ITEM TYPES
multiple choice
multiple response
case study
// questions
81in bank
// pass rate
92%self-reported
// last update
7h agoago
// add cadence · 12w
// downloadable pdf bank
Get the whole bank as a PDF
Every question tagged by domain, with a detailed explanation. Preview the first pages free — buy once for lifetime access to the full PDF.
81 questions
// what's inside
- 81 exam-style questions with verified answers
- Every question tagged by domain (4 domains covered)
- A detailed explanation / rationale for every question
// sample · 1 of 49
See what's in the bank.
#023b5e2f-e3fc-44ed-a4bf-c9f46dcecb3fD1 · Hybridhard
↑ +47· 5 comments· seen 1,284×
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have a database named DB1 that has change data capture enabled.
A Microsoft SQL Server Integration Services (SSIS) job runs once weekly. The job loads changes from DB1 to a data warehouse by querying the change data capture tables.
Users report that an application that uses DB1 is suddenly unresponsive.
You discover that the Integration Services job causes severe blocking issues in the application.
You need to ensure that the users can run the application as quickly as possible.
Your SQL Server login is a member of only the ssis_admin database role.
Which stored procedure should you execute?
You have a database named DB1 that has change data capture enabled.
A Microsoft SQL Server Integration Services (SSIS) job runs once weekly. The job loads changes from DB1 to a data warehouse by querying the change data capture tables.
Users report that an application that uses DB1 is suddenly unresponsive.
You discover that the Integration Services job causes severe blocking issues in the application.
You need to ensure that the users can run the application as quickly as possible.
Your SQL Server login is a member of only the ssis_admin database role.
Which stored procedure should you execute?
A
catalog.deploy_project
0%B
catalog.restore_project
0%C
catalog.stop_operation
0%D
sys.sp_cdc_add_job
0%E
sys.sp_cdc_change_job
0%F
sys.sp_cdc_disable_db
0%G
sys.sp_cdc_enable_db
0%H
sys.sp_cdc_stop_job
0%Community converges on E. Official key confirms.
0 votes · last validated recently
// explanation
BFD with a 300 ms interval × multiplier 3 = 900 ms detection, well under one second. Combined with a redundant Direct Connect at a different DX location, BGP withdrawal handles the cutover cleanly. Tightening BGP timers alone causes flap during normal jitter; switching VIF types is not a failover mechanism.
contributed by
N1
@netdiver· revised by @cloud_chris// coverage · 5 domains
What this bank tests.
D125%
Designing and Implementing Data Storage Solutions1 q
D220%
Data Processing0 q
D325%
Data Integration4 q
D430%
Data Security and Compliance0 q
—90%
Uncategorized44 q
// composition
By format & difficulty.
// by format
98%
single · 48multi · 1
// by difficulty
medium
5· 100%
// contributors · 0 engineers
Built by people who took the exam.
Every question is contributed by someone who recently sat 70-767, then reviewed by an SME before landing in the bank. These are the most prolific contributors.
No contributors for this exam yet. Be the first to contribute a question.
// community questions
Questions from the community
Top-voted approved contributions for this exam, reviewed before landing in the bank.
// top community questionsview all →
// compare
One bank, or the whole platform?
this bank
$10.00· one-time
platform · subscribed
$10.00· per month
This bank
All other banks · 23+ exams
Lifetime access
All future updates included
Personal analytics + retention
Cancel anytime
—
// 0 reviews
0.0/ 5
5
0
4
0
3
0
2
0
1
0
No reviews yet. Be the first to share your experience with this question bank.
// faq
Things buyers ask before they buy.
Q.
Can I practice for free?
Free practice questions are available without payment; anyone can start practicing at no cost.
Q.
What do subscribers get?
Subscribers unlock the full practice question bank for each certification exam.
Q.
How much can I see without a subscription?
Approximately 1/2 of the question bank is accessible without a subscription.
Q.
What is the passing score?
The official passing mark for this exam is 700.
Q.
How long is the certification valid?
The certification is valid for 2 years. Renew by passing the current exam version or earning 30 continuing education credits within two years.
Q.
What experience is recommended?
2+ years designing data warehouse solutions using SQL Server, Azure Data Factory, and Azure Synapse Analytics. Familiarity with ETL processes and cloud data platforms.
// related
You may also like
Discover more exams based on your interests.
// ready when you are
49 questions. 92% pass rate. $10.00 once.
Lifetime access · all updates included · 30-day refund