Objective 2.1
DP-700Design and implement loading patterns
Objective 2.1 sits in Ingest and transform data, which carries 33% of the DP-700 Fabric Data Engineer exam. The questions below are original, written from the official objective title above, and each explanation cites the Microsoft Azure page it rests on.
Objective title verbatim from the official objectives. Microsoft Azure exam page ↗
A worked example
Shown solved, with the whole explanation open: this is what every question here carries.
A team stores modeled dimensional data for BI reporting and needs full multi-table ACID transactions in T-SQL. Which item fits?
Correct.
Concept
Lakehouse and warehouse share a SQL engine but differ on transactions and tooling; multi-table ACID T-SQL work belongs to the warehouse.
Why C
The warehouse is T-SQL developed with full multi-table ACID transaction support.
Source
Microsoft Learn, What Is Fabric Data Warehouse?, checked August 2026Fabric Data Warehouse is primarily developed with T-SQL, and shares a large surface area based on the SQL Database Engine, with full multi-table ACID transaction support, materialized views, functions, and stored procedures.
Now you: objective 2.1 questions
No account needed. The explanation opens when you answer.
Sample question 1 of 3
With the SQL analytics endpoint, T-SQL commands can do what?
Sample question 2 of 3
A warehouse needs data from a mirrored database and another warehouse in one T-SQL query. Which capability enables this?
Sample question 3 of 3
Which store is the ideal fit for star or snowflake schemas and governed semantic models for BI?
That’s 3 of the full DP-700 Fabric Data Engineer bank.
Keep going free: 10 questions per certification in bank practice, with no account.
Continue practisingRead the sources
These are the official pages the questions above cite. Reading them is studying the objective from the primary source, which is what the explanations point you toward anyway.