DP-600 · Question #205
DP-600 Question #205: Real Exam Question with Answer & Explanation
The correct answer is C: The session context is not maintained for the independent execution of queries. In Microsoft Fabric's SQL Query Editor, when you execute multiple independent query batches, the session context - including temporary tables, session-scoped variables, and other transient state - is NOT maintained between those independent executions. Each independent batch is t
Question
In the SQL Query Editor within Fabric, what happens to the session context when you run multiple independent query batches?
Options
- AThe session context is maintained across all batches
- BThe session context is maintained only if the batches are executed sequentially
- CThe session context is not maintained for the independent execution of queries
- DThe session context is only maintained for Transaction Control Language (TCL) statements
Explanation
In Microsoft Fabric's SQL Query Editor, when you execute multiple independent query batches, the session context - including temporary tables, session-scoped variables, and other transient state - is NOT maintained between those independent executions. Each independent batch is treated as its own isolated execution context. This differs from running multiple statements within a single batch (e.g., separated by semicolons in a single run), where context can persist. Developers should be aware of this behavior to avoid relying on session state across independent query executions, as doing so will produce errors or unexpected results.
Topics
Community Discussion
No community discussion yet for this question.