Practice Exams:

View All

Microsoft Fabric Analytics Engineer DP-600 Query And Analyze Data With Visual SQL KQL And DAX Practice Test

Skill 2.3 – 60 original questions

This Microsoft DP-600 practice test focuses on query and analyze data with visual sql kql and dax through original scenario-based questions aligned to the active DP-600 skills measured as of July 21, 2026. Use the complete ExamSnap DP-600 collection for broader practice across Microsoft Fabric analytics lifecycle, data preparation, querying, and semantic modeling. For broader exam preparation, review the Microsoft DP-600 Exam Dumps page.

Instructions: Select the best answer for each question. Review the explanation after answering; each option includes a reason it is or is not the strongest choice for the scenario.

Question 1

The next sprint for Proseware’s marketing semantic model includes a task to let a business analyst select columns, add filters, and create grouped summaries without writing SQL. The acceptance criteria add that the team wants the smallest administrative blast radius. Which Fabric or Power BI action is appropriate? Existing users should keep their current access.

Use the Visual Query Editor to build the query graphically
Filter or remediate rows with missing mandatory keys before loading the curated layer
Create a OneLake shortcut to the existing data
Configure the appropriate gateway and connection credentials
Use Real-Time hub to browse and connect to real-time data sources

Correct answer: A

Why: The Visual Query Editor provides a graphical experience for selecting, filtering, joining, and aggregating supported data. This directly matches the stated requirement.

Option review:

A: The Visual Query Editor provides a graphical experience for selecting, filtering, joining, and aggregating supported data. This directly matches the stated requirement.

B: Mandatory-key quality rules should be enforced before downstream joins and aggregations depend on those records. This can be valid for ‘Identify and resolve duplicate data, missing data, or null values’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

C: A shortcut provides logical access to supported external or OneLake data without copying the underlying files. This can be valid for ‘Ingest or access data as needed’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

D: An on-premises gateway provides the network bridge while the connection stores the credentials and source details. This can be valid for ‘Create a data connection’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

E: Real-Time hub is the Fabric experience for discovering, connecting to, and managing real-time event streams and sources. This can be valid for ‘Discover data by using OneLake catalog and Real-Time hub’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

Learning point: Use the Visual Query Editor to build the query graphically

Question 2

Blue Yonder Airlines is troubleshooting a design decision in the supply-chain lakehouse. The desired end state is to prototype a warehouse query through drag-and-drop operations before inspecting the generated query; the team wants to keep governance centralized. Which change should the operations data team make? Existing users should keep their current access.

Denormalize selected attributes into the analytical table
Append or union the row sets instead of joining them
Build it in the Visual Query Editor
Apply an explicit predicate that excludes the test rows
Create a fact table at a defined grain with separate dimension tables

Correct answer: C

Why: The visual editor is intended for graphical query construction while still supporting common relational operations. This directly matches the stated requirement.

Option review:

A: Denormalization trades additional storage and duplication for simpler reads and fewer joins in analytical workloads. This can be valid for ‘Denormalize data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

B: Union or append combines rows from compatible schemas, whereas a join combines columns based on matching keys. This can be valid for ‘Merge or join data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

C: The visual editor is intended for graphical query construction while still supporting common relational operations. This directly matches the stated requirement.

D: A deterministic filter predicate is the direct way to prevent unwanted rows from reaching downstream analysis. This can be valid for ‘Filter data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

E: A star schema places measurable events in a fact table and descriptive context in dimensions, simplifying analytics and improving model usability. This can be valid for ‘Implement a star schema for a lakehouse or warehouse’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

Learning point: Build it in the Visual Query Editor

Question 3

For the IoT telemetry solution, Fabrikam has documented a business requirement to let a business analyst select columns, add filters, and create grouped summaries without writing SQL. The data governance group must meet it in a way where the approach should remain understandable to future maintainers. What is the best choice? No unrelated workspace or model permissions should be changed.

Create a fact table at a defined grain with separate dimension tables
Use KQL operators such as where, summarize, and bin against the KQL database
Use the Visual Query Editor to build the query graphically
Denormalize selected attributes into the analytical table
Create a SQL view

Correct answer: C

Why: The Visual Query Editor provides a graphical experience for selecting, filtering, joining, and aggregating supported data. This directly matches the stated requirement.

Option review:

A: A star schema places measurable events in a fact table and descriptive context in dimensions, simplifying analytics and improving model usability. This can be valid for ‘Implement a star schema for a lakehouse or warehouse’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

B: KQL is optimized for filtering and aggregating log, telemetry, and time-series data in Eventhouse. This can be valid for ‘Select, filter, and aggregate data by using KQL’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

C: The Visual Query Editor provides a graphical experience for selecting, filtering, joining, and aggregating supported data. This directly matches the stated requirement.

D: Denormalization trades additional storage and duplication for simpler reads and fewer joins in analytical workloads. This can be valid for ‘Denormalize data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

E: A view encapsulates a reusable query and presents it as a virtual table. This can be valid for ‘Create views, functions, and stored procedures’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

Learning point: Use the Visual Query Editor to build the query graphically

Question 4

A governance review of Litware’s finance reporting platform asks for evidence that the solution can prototype a warehouse query through drag-and-drop operations before inspecting the generated query. Because the implementation should reduce operational overhead, which action should be approved? No unrelated workspace or model permissions should be changed.

Enable the supported OneLake availability or integration for the Eventhouse data
Append or union the row sets instead of joining them
Build it in the Visual Query Editor
Model the warehouse with conformed dimensions around fact tables
Write the required SQL query against the endpoint

Correct answer: C

Why: The visual editor is intended for graphical query construction while still supporting common relational operations. This directly matches the stated requirement.

Option review:

A: OneLake integration makes supported Eventhouse data discoverable and accessible through OneLake for cross-engine use. This can be valid for ‘Implement OneLake integration for Eventhouse and semantic models’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

C: The visual editor is intended for graphical query construction while still supporting common relational operations. This directly matches the stated requirement.

D: Conformed dimensions and explicit fact grain are core star-schema practices for reliable analytical joins. This can be valid for ‘Implement a star schema for a lakehouse or warehouse’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

E: The SQL analytics endpoint supports relational querying with T-SQL for selection, filtering, joins, and aggregation. This can be valid for ‘Select, filter, and aggregate data by using SQL’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

Learning point: Build it in the Visual Query Editor

Question 5

Before expanding the retail performance dashboard, the finance analytics squad at Woodgrove Bank must let a business analyst select columns, add filters, and create grouped summaries without writing SQL. The rollout plan says that the solution must remain maintainable as usage grows. Which option most directly addresses the requirement? The team will validate the change first in a nonproduction environment.

Enable the supported OneLake availability or integration for the Eventhouse data
Use the Visual Query Editor to build the query graphically
Create a SQL view
Add a calculated or derived column in the transformation layer
Handle nulls explicitly with a null-replacement rule such as COALESCE

Correct answer: B

Why: The Visual Query Editor provides a graphical experience for selecting, filtering, joining, and aggregating supported data. This directly matches the stated requirement.

Option review:

B: The Visual Query Editor provides a graphical experience for selecting, filtering, joining, and aggregating supported data. This directly matches the stated requirement.

C: A view encapsulates a reusable query and presents it as a virtual table. This can be valid for ‘Create views, functions, and stored procedures’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

D: A derived column enriches the dataset with business logic while preserving the source fields. This can be valid for ‘Enrich data by adding new columns or tables’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

E: Explicit null handling avoids treating missing values as valid zeroes unless the business rule specifically requires that replacement. This can be valid for ‘Identify and resolve duplicate data, missing data, or null values’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

Learning point: Use the Visual Query Editor to build the query graphically

Question 6

Coho Winery is redesigning its marketing semantic model. The analytics engineering team must prototype a warehouse query through drag-and-drop operations before inspecting the generated query. In addition, the team wants the smallest administrative blast radius. Which action is the best fit? The team will validate the change first in a nonproduction environment.

Use an Eventhouse with a KQL database
Use a Fabric lakehouse
Use Direct Lake against the OneLake-backed data
Model the warehouse with conformed dimensions around fact tables
Build it in the Visual Query Editor

Correct answer: E

Why: The visual editor is intended for graphical query construction while still supporting common relational operations. This directly matches the stated requirement.

Option review:

A: Eventhouse and KQL databases are optimized for high-volume real-time, log, and time-series analytics. This can be valid for ‘Choose between different data stores’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

B: A lakehouse combines OneLake Delta storage with Spark-oriented engineering and a SQL analytics endpoint. This can be valid for ‘Choose between different data stores’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

C: Direct Lake lets semantic models query OneLake Delta data with in-memory analytical performance without a traditional import copy. This can be valid for ‘Implement OneLake integration for Eventhouse and semantic models’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

E: The visual editor is intended for graphical query construction while still supporting common relational operations. This directly matches the stated requirement.

Learning point: Build it in the Visual Query Editor

Question 7

During a design review for Adventure Works’s supply-chain lakehouse, one requirement is non-negotiable: let a business analyst select columns, add filters, and create grouped summaries without writing SQL. Because the team wants to keep governance centralized, what should the operations data team implement? The solution must work with the current Fabric architecture rather than a parallel custom platform.

Use the Visual Query Editor to build the query graphically
Denormalize selected attributes into the analytical table
Create the additional dimension or lookup table during transformation
Apply an explicit predicate that excludes the test rows
Use an Eventhouse with a KQL database

Correct answer: A

Why: The Visual Query Editor provides a graphical experience for selecting, filtering, joining, and aggregating supported data. This directly matches the stated requirement.

Option review:

A: The Visual Query Editor provides a graphical experience for selecting, filtering, joining, and aggregating supported data. This directly matches the stated requirement.

B: Denormalization trades additional storage and duplication for simpler reads and fewer joins in analytical workloads. This can be valid for ‘Denormalize data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

C: Adding a curated table can enrich the model with reusable business context for downstream joins and analysis. This can be valid for ‘Enrich data by adding new columns or tables’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

E: Eventhouse and KQL databases are optimized for high-volume real-time, log, and time-series analytics. This can be valid for ‘Choose between different data stores’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

Learning point: Use the Visual Query Editor to build the query graphically

Question 8

The data governance group at Tailspin Toys is preparing the next release of its IoT telemetry solution. They need to prototype a warehouse query through drag-and-drop operations before inspecting the generated query; the approach should remain understandable to future maintainers. Which choice most directly satisfies the requirement? The solution must work with the current Fabric architecture rather than a parallel custom platform.

Filter or remediate rows with missing mandatory keys before loading the curated layer
Build it in the Visual Query Editor
Configure the appropriate gateway and connection credentials
Use a Fabric warehouse
Handle nulls explicitly with a null-replacement rule such as COALESCE

Correct answer: B

Why: The visual editor is intended for graphical query construction while still supporting common relational operations. This directly matches the stated requirement.

Option review:

A: Mandatory-key quality rules should be enforced before downstream joins and aggregations depend on those records. This can be valid for ‘Identify and resolve duplicate data, missing data, or null values’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

B: The visual editor is intended for graphical query construction while still supporting common relational operations. This directly matches the stated requirement.

C: An on-premises gateway provides the network bridge while the connection stores the credentials and source details. This can be valid for ‘Create a data connection’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

D: A warehouse is optimized for structured relational analytics and T-SQL based development in Fabric. This can be valid for ‘Choose between different data stores’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

Learning point: Build it in the Visual Query Editor

Question 9

A production readiness review at Fourth Coffee found a gap in the finance reporting platform. The remediation must let a business analyst select columns, add filters, and create grouped summaries without writing SQL, and the implementation should reduce operational overhead. What is the most appropriate action? The design decision will be reviewed by both data engineering and BI owners.

Apply an explicit predicate that excludes the test rows
Filter or remediate rows with missing mandatory keys before loading the curated layer
Use KQL project and where operators
Use the Visual Query Editor to build the query graphically
Use Direct Lake against the OneLake-backed data

Correct answer: D

Why: The Visual Query Editor provides a graphical experience for selecting, filtering, joining, and aggregating supported data. This directly matches the stated requirement.

Option review:

A: A deterministic filter predicate is the direct way to prevent unwanted rows from reaching downstream analysis. This can be valid for ‘Filter data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

C: KQL provides concise operators for selecting columns and filtering event data. This can be valid for ‘Select, filter, and aggregate data by using KQL’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

D: The Visual Query Editor provides a graphical experience for selecting, filtering, joining, and aggregating supported data. This directly matches the stated requirement.

E: Direct Lake lets semantic models query OneLake Delta data with in-memory analytical performance without a traditional import copy. This can be valid for ‘Implement OneLake integration for Eventhouse and semantic models’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

Learning point: Use the Visual Query Editor to build the query graphically

Question 10

For a new phase of the retail performance dashboard, Wide World Importers asks the finance analytics squad to prototype a warehouse query through drag-and-drop operations before inspecting the generated query. The architecture decision record also states that the solution must remain maintainable as usage grows. Which approach should be selected? The design decision will be reviewed by both data engineering and BI owners.

Add a calculated or derived column in the transformation layer
Use a left outer join from customers to orders
Build it in the Visual Query Editor
Create a stored procedure
Create a SQL function

Correct answer: C

Why: The visual editor is intended for graphical query construction while still supporting common relational operations. This directly matches the stated requirement.

Option review:

A: A derived column enriches the dataset with business logic while preserving the source fields. This can be valid for ‘Enrich data by adding new columns or tables’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

B: A left outer join retains all rows from the left input and adds matching rows from the right input when available. This can be valid for ‘Merge or join data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

C: The visual editor is intended for graphical query construction while still supporting common relational operations. This directly matches the stated requirement.

D: A stored procedure packages procedural multi-statement T-SQL operations for repeatable execution. This can be valid for ‘Create views, functions, and stored procedures’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

E: A function is appropriate for reusable parameterized logic that returns a value or table expression. This can be valid for ‘Create views, functions, and stored procedures’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

Learning point: Build it in the Visual Query Editor

Question 11

Northwind Traders is standardizing how the marketing semantic model is managed. The immediate goal is to let a business analyst select columns, add filters, and create grouped summaries without writing SQL. Given that the team wants the smallest administrative blast radius, which option should the analytics engineering team choose? Existing users should keep their current access.

Flatten the required lookup attributes into the reporting structure
Use the OneLake catalog to discover and evaluate available data products
Use an Eventhouse with a KQL database
Use the Visual Query Editor to build the query graphically
Apply the row filter as early as practical in the query or transformation

Correct answer: D

Why: The Visual Query Editor provides a graphical experience for selecting, filtering, joining, and aggregating supported data. This directly matches the stated requirement.

Option review:

A: Flattening commonly consumed attributes can make read-oriented analytics simpler when update anomalies are controlled upstream. This can be valid for ‘Denormalize data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

B: The OneLake catalog is designed to discover governed Fabric data items across the organization. This can be valid for ‘Discover data by using OneLake catalog and Real-Time hub’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

C: Eventhouse and KQL databases are optimized for high-volume real-time, log, and time-series analytics. This can be valid for ‘Choose between different data stores’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

D: The Visual Query Editor provides a graphical experience for selecting, filtering, joining, and aggregating supported data. This directly matches the stated requirement.

E: Early filtering reduces the volume of data moved and processed while preserving only the rows required by the workload. This can be valid for ‘Filter data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

Learning point: Use the Visual Query Editor to build the query graphically

Question 12

An internal audit of Trey Research’s supply-chain lakehouse identifies this requirement: prototype a warehouse query through drag-and-drop operations before inspecting the generated query. The operations data team also notes that the team wants to keep governance centralized. What should they do? Existing users should keep their current access.

Use T-SQL with SELECT, JOIN, WHERE, GROUP BY, and aggregate functions as required
Create the additional dimension or lookup table during transformation
Build it in the Visual Query Editor
Use the OneLake catalog to discover and evaluate available data products
Create a OneLake shortcut to the existing data

Correct answer: C

Why: The visual editor is intended for graphical query construction while still supporting common relational operations. This directly matches the stated requirement.

Option review:

A: SQL is the native relational query language for warehouse and SQL analytics endpoint workloads. This can be valid for ‘Select, filter, and aggregate data by using SQL’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

B: Adding a curated table can enrich the model with reusable business context for downstream joins and analysis. This can be valid for ‘Enrich data by adding new columns or tables’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

C: The visual editor is intended for graphical query construction while still supporting common relational operations. This directly matches the stated requirement.

D: The OneLake catalog is designed to discover governed Fabric data items across the organization. This can be valid for ‘Discover data by using OneLake catalog and Real-Time hub’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

E: A shortcut provides logical access to supported external or OneLake data without copying the underlying files. This can be valid for ‘Ingest or access data as needed’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

Learning point: Build it in the Visual Query Editor

Question 13

The IoT telemetry solution at Alpine Ski House is moving from proof of concept to production. Before rollout, the data governance group must let a business analyst select columns, add filters, and create grouped summaries without writing SQL, while ensuring that the approach should remain understandable to future maintainers. Which action best meets both needs? No unrelated workspace or model permissions should be changed.

Identify the duplicate keys and deduplicate according to the authoritative business rule
Use the Visual Query Editor to build the query graphically
Flatten the required lookup attributes into the reporting structure
Use KQL project and where operators
Write the required SQL query against the endpoint

Correct answer: B

Why: The Visual Query Editor provides a graphical experience for selecting, filtering, joining, and aggregating supported data. This directly matches the stated requirement.

Option review:

A: Deduplication must preserve the correct authoritative row while eliminating records that would inflate analytical results. This can be valid for ‘Identify and resolve duplicate data, missing data, or null values’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

B: The Visual Query Editor provides a graphical experience for selecting, filtering, joining, and aggregating supported data. This directly matches the stated requirement.

C: Flattening commonly consumed attributes can make read-oriented analytics simpler when update anomalies are controlled upstream. This can be valid for ‘Denormalize data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

D: KQL provides concise operators for selecting columns and filtering event data. This can be valid for ‘Select, filter, and aggregate data by using KQL’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

Learning point: Use the Visual Query Editor to build the query graphically

Question 14

Contoso has a change request for the finance reporting platform: prototype a warehouse query through drag-and-drop operations before inspecting the generated query. The enterprise reporting group wants a solution where the implementation should reduce operational overhead. Which implementation is most suitable? No unrelated workspace or model permissions should be changed.

Use a Power BI semantic model
Build it in the Visual Query Editor
Create a SQL view
Convert the column to an appropriate date or datetime data type
Use Dataflow Gen2 for the ingestion and transformation flow

Correct answer: B

Why: The visual editor is intended for graphical query construction while still supporting common relational operations. This directly matches the stated requirement.

Option review:

A: A semantic model is the analytical serving layer for governed relationships, measures, and report consumption. This can be valid for ‘Choose between different data stores’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

B: The visual editor is intended for graphical query construction while still supporting common relational operations. This directly matches the stated requirement.

D: Using the correct native type enables valid date comparisons, filtering, and time intelligence. This can be valid for ‘Convert column data types’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

E: Dataflow Gen2 provides a Power Query based low-code ingestion and transformation experience. This can be valid for ‘Ingest or access data as needed’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

Learning point: Build it in the Visual Query Editor

Question 15

A solution architect reviewing Wingtip Toys’s retail performance dashboard asks the finance analytics squad to let a business analyst select columns, add filters, and create grouped summaries without writing SQL. Since the solution must remain maintainable as usage grows, which recommendation is strongest? The team will validate the change first in a nonproduction environment.

Use T-SQL with SELECT, JOIN, WHERE, GROUP BY, and aggregate functions as required
Use the Visual Query Editor to build the query graphically
Use the OneLake catalog to discover and evaluate available data products
Use a Fabric data pipeline Copy activity
Cast the column to the appropriate numeric type before aggregation

Correct answer: B

Why: The Visual Query Editor provides a graphical experience for selecting, filtering, joining, and aggregating supported data. This directly matches the stated requirement.

Option review:

B: The Visual Query Editor provides a graphical experience for selecting, filtering, joining, and aggregating supported data. This directly matches the stated requirement.

C: The OneLake catalog is designed to discover governed Fabric data items across the organization. This can be valid for ‘Discover data by using OneLake catalog and Real-Time hub’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

D: Copy activity is suited to orchestrated bulk data movement into Fabric with scheduling and monitoring. This can be valid for ‘Ingest or access data as needed’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

E: Numeric calculations require a compatible numeric type and should avoid relying on implicit conversion. This can be valid for ‘Convert column data types’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using the Visual query editor’.

Learning point: Use the Visual Query Editor to build the query graphically

Question 16

The next sprint for Proseware’s customer 360 model includes a task to return revenue by product category from a warehouse using relational syntax. The acceptance criteria add that the team wants the smallest administrative blast radius. Which Fabric or Power BI action is appropriate? Existing users should keep their current access.

Append or union the row sets instead of joining them
Use T-SQL with SELECT, JOIN, WHERE, GROUP BY, and aggregate functions as required
Build it in the Visual Query Editor
Create the additional dimension or lookup table during transformation
Flatten the required lookup attributes into the reporting structure

Correct answer: B

Why: SQL is the native relational query language for warehouse and SQL analytics endpoint workloads. This directly matches the stated requirement.

Option review:

A: Union or append combines rows from compatible schemas, whereas a join combines columns based on matching keys. This can be valid for ‘Merge or join data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

B: SQL is the native relational query language for warehouse and SQL analytics endpoint workloads. This directly matches the stated requirement.

C: The visual editor is intended for graphical query construction while still supporting common relational operations. This can be valid for ‘Select, filter, and aggregate data by using the Visual query editor’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

D: Adding a curated table can enrich the model with reusable business context for downstream joins and analysis. This can be valid for ‘Enrich data by adding new columns or tables’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

E: Flattening commonly consumed attributes can make read-oriented analytics simpler when update anomalies are controlled upstream. This can be valid for ‘Denormalize data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

Learning point: Use T-SQL with SELECT, JOIN, WHERE, GROUP BY, and aggregate functions as required

Question 17

Blue Yonder Airlines is troubleshooting a design decision in the sales analytics solution. The desired end state is to filter and summarize rows exposed through a SQL analytics endpoint; the team wants to keep governance centralized. Which change should the BI platform team make? Existing users should keep their current access.

Use a DAX query with functions such as SUMMARIZECOLUMNS and CALCULATE as appropriate
Use Dataflow Gen2 for the ingestion and transformation flow
Create and manage a shared Fabric connection for the data source
Write the required SQL query against the endpoint
Enable the supported OneLake availability or integration for the Eventhouse data

Correct answer: D

Why: The SQL analytics endpoint supports relational querying with T-SQL for selection, filtering, joins, and aggregation. This directly matches the stated requirement.

Option review:

A: DAX queries and functions operate on semantic-model metadata, relationships, and filter context. This can be valid for ‘Select, filter, and aggregate data by using DAX’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

B: Dataflow Gen2 provides a Power Query based low-code ingestion and transformation experience. This can be valid for ‘Ingest or access data as needed’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

C: Fabric connections centralize connection details and credentials so supported items can reuse governed access. This can be valid for ‘Create a data connection’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

D: The SQL analytics endpoint supports relational querying with T-SQL for selection, filtering, joins, and aggregation. This directly matches the stated requirement.

E: OneLake integration makes supported Eventhouse data discoverable and accessible through OneLake for cross-engine use. This can be valid for ‘Implement OneLake integration for Eventhouse and semantic models’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

Learning point: Write the required SQL query against the endpoint

Question 18

For the risk analytics environment, Fabrikam has documented a business requirement to return revenue by product category from a warehouse using relational syntax. The security analytics team must meet it in a way where the approach should remain understandable to future maintainers. What is the best choice? No unrelated workspace or model permissions should be changed.

Apply the row filter as early as practical in the query or transformation
Enable the supported OneLake availability or integration for the Eventhouse data
Use T-SQL with SELECT, JOIN, WHERE, GROUP BY, and aggregate functions as required
Handle nulls explicitly with a null-replacement rule such as COALESCE
Append or union the row sets instead of joining them

Correct answer: C

Why: SQL is the native relational query language for warehouse and SQL analytics endpoint workloads. This directly matches the stated requirement.

Option review:

A: Early filtering reduces the volume of data moved and processed while preserving only the rows required by the workload. This can be valid for ‘Filter data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

B: OneLake integration makes supported Eventhouse data discoverable and accessible through OneLake for cross-engine use. This can be valid for ‘Implement OneLake integration for Eventhouse and semantic models’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

C: SQL is the native relational query language for warehouse and SQL analytics endpoint workloads. This directly matches the stated requirement.

D: Explicit null handling avoids treating missing values as valid zeroes unless the business rule specifically requires that replacement. This can be valid for ‘Identify and resolve duplicate data, missing data, or null values’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

E: Union or append combines rows from compatible schemas, whereas a join combines columns based on matching keys. This can be valid for ‘Merge or join data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

Learning point: Use T-SQL with SELECT, JOIN, WHERE, GROUP BY, and aggregate functions as required

Question 19

A governance review of Litware’s service-operations warehouse asks for evidence that the solution can filter and summarize rows exposed through a SQL analytics endpoint. Because the implementation should reduce operational overhead, which action should be approved? No unrelated workspace or model permissions should be changed.

Precompute the required daily aggregate table or result
Write the required SQL query against the endpoint
Use the OneLake catalog to discover and evaluate available data products
Use Real-Time hub to browse and connect to real-time data sources
Use Dataflow Gen2 for the ingestion and transformation flow

Correct answer: B

Why: The SQL analytics endpoint supports relational querying with T-SQL for selection, filtering, joins, and aggregation. This directly matches the stated requirement.

Option review:

A: Pre-aggregation can reduce repeated scanning of detail rows when consumers consistently query a higher-level grain. This can be valid for ‘Aggregate data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

B: The SQL analytics endpoint supports relational querying with T-SQL for selection, filtering, joins, and aggregation. This directly matches the stated requirement.

D: Real-Time hub is the Fabric experience for discovering, connecting to, and managing real-time event streams and sources. This can be valid for ‘Discover data by using OneLake catalog and Real-Time hub’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

Learning point: Write the required SQL query against the endpoint

Question 20

Before expanding the executive reporting workspace, the customer insights team at Woodgrove Bank must return revenue by product category from a warehouse using relational syntax. The rollout plan says that the solution must remain maintainable as usage grows. Which option most directly addresses the requirement? The team will validate the change first in a nonproduction environment.

Handle nulls explicitly with a null-replacement rule such as COALESCE
Use T-SQL with SELECT, JOIN, WHERE, GROUP BY, and aggregate functions as required
Create a stored procedure
Create a OneLake shortcut to the existing data
Create a DAX measure using the required aggregation and filter context logic

Correct answer: B

Why: SQL is the native relational query language for warehouse and SQL analytics endpoint workloads. This directly matches the stated requirement.

Option review:

A: Explicit null handling avoids treating missing values as valid zeroes unless the business rule specifically requires that replacement. This can be valid for ‘Identify and resolve duplicate data, missing data, or null values’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

B: SQL is the native relational query language for warehouse and SQL analytics endpoint workloads. This directly matches the stated requirement.

C: A stored procedure packages procedural multi-statement T-SQL operations for repeatable execution. This can be valid for ‘Create views, functions, and stored procedures’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

D: A shortcut provides logical access to supported external or OneLake data without copying the underlying files. This can be valid for ‘Ingest or access data as needed’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

E: DAX measures evaluate in semantic-model filter context and are the native way to define reusable analytical calculations. This can be valid for ‘Select, filter, and aggregate data by using DAX’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

Learning point: Use T-SQL with SELECT, JOIN, WHERE, GROUP BY, and aggregate functions as required

Question 21

Coho Winery is redesigning its customer 360 model. The retail insights team must filter and summarize rows exposed through a SQL analytics endpoint. In addition, the team wants the smallest administrative blast radius. Which action is the best fit? The team will validate the change first in a nonproduction environment.

Apply an explicit predicate that excludes the test rows
Group the data by month and region and calculate the required summary measures
Write the required SQL query against the endpoint
Create a OneLake shortcut to the existing data
Identify the duplicate keys and deduplicate according to the authoritative business rule

Correct answer: C

Why: The SQL analytics endpoint supports relational querying with T-SQL for selection, filtering, joins, and aggregation. This directly matches the stated requirement.

Option review:

B: Aggregation changes detailed rows into grouped summaries at the required analytical grain. This can be valid for ‘Aggregate data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

C: The SQL analytics endpoint supports relational querying with T-SQL for selection, filtering, joins, and aggregation. This directly matches the stated requirement.

E: Deduplication must preserve the correct authoritative row while eliminating records that would inflate analytical results. This can be valid for ‘Identify and resolve duplicate data, missing data, or null values’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

Learning point: Write the required SQL query against the endpoint

Question 22

During a design review for Adventure Works’s sales analytics solution, one requirement is non-negotiable: return revenue by product category from a warehouse using relational syntax. Because the team wants to keep governance centralized, what should the BI platform team implement? The solution must work with the current Fabric architecture rather than a parallel custom platform.

Create a DAX measure using the required aggregation and filter context logic
Configure the appropriate gateway and connection credentials
Use T-SQL with SELECT, JOIN, WHERE, GROUP BY, and aggregate functions as required
Create a fact table at a defined grain with separate dimension tables
Add a calculated or derived column in the transformation layer

Correct answer: C

Why: SQL is the native relational query language for warehouse and SQL analytics endpoint workloads. This directly matches the stated requirement.

Option review:

A: DAX measures evaluate in semantic-model filter context and are the native way to define reusable analytical calculations. This can be valid for ‘Select, filter, and aggregate data by using DAX’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

B: An on-premises gateway provides the network bridge while the connection stores the credentials and source details. This can be valid for ‘Create a data connection’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

C: SQL is the native relational query language for warehouse and SQL analytics endpoint workloads. This directly matches the stated requirement.

D: A star schema places measurable events in a fact table and descriptive context in dimensions, simplifying analytics and improving model usability. This can be valid for ‘Implement a star schema for a lakehouse or warehouse’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

E: A derived column enriches the dataset with business logic while preserving the source fields. This can be valid for ‘Enrich data by adding new columns or tables’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

Learning point: Use T-SQL with SELECT, JOIN, WHERE, GROUP BY, and aggregate functions as required

Question 23

The security analytics team at Tailspin Toys is preparing the next release of its risk analytics environment. They need to filter and summarize rows exposed through a SQL analytics endpoint; the approach should remain understandable to future maintainers. Which choice most directly satisfies the requirement? The solution must work with the current Fabric architecture rather than a parallel custom platform.

Use an inner join on the matching business or surrogate key
Flatten the required lookup attributes into the reporting structure
Use a DAX query with functions such as SUMMARIZECOLUMNS and CALCULATE as appropriate
Create and manage a shared Fabric connection for the data source
Write the required SQL query against the endpoint

Correct answer: E

Why: The SQL analytics endpoint supports relational querying with T-SQL for selection, filtering, joins, and aggregation. This directly matches the stated requirement.

Option review:

A: An inner join returns only rows with matching keys on both sides. This can be valid for ‘Merge or join data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

B: Flattening commonly consumed attributes can make read-oriented analytics simpler when update anomalies are controlled upstream. This can be valid for ‘Denormalize data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

C: DAX queries and functions operate on semantic-model metadata, relationships, and filter context. This can be valid for ‘Select, filter, and aggregate data by using DAX’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

D: Fabric connections centralize connection details and credentials so supported items can reuse governed access. This can be valid for ‘Create a data connection’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

E: The SQL analytics endpoint supports relational querying with T-SQL for selection, filtering, joins, and aggregation. This directly matches the stated requirement.

Learning point: Write the required SQL query against the endpoint

Question 24

A production readiness review at Fourth Coffee found a gap in the service-operations warehouse. The remediation must return revenue by product category from a warehouse using relational syntax, and the implementation should reduce operational overhead. What is the most appropriate action? The design decision will be reviewed by both data engineering and BI owners.

Use an inner join on the matching business or surrogate key
Denormalize selected attributes into the analytical table
Precompute the required daily aggregate table or result
Create the additional dimension or lookup table during transformation
Use T-SQL with SELECT, JOIN, WHERE, GROUP BY, and aggregate functions as required

Correct answer: E

Why: SQL is the native relational query language for warehouse and SQL analytics endpoint workloads. This directly matches the stated requirement.

Option review:

C: Pre-aggregation can reduce repeated scanning of detail rows when consumers consistently query a higher-level grain. This can be valid for ‘Aggregate data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

E: SQL is the native relational query language for warehouse and SQL analytics endpoint workloads. This directly matches the stated requirement.

Learning point: Use T-SQL with SELECT, JOIN, WHERE, GROUP BY, and aggregate functions as required

Question 25

For a new phase of the executive reporting workspace, Wide World Importers asks the customer insights team to filter and summarize rows exposed through a SQL analytics endpoint. The architecture decision record also states that the solution must remain maintainable as usage grows. Which approach should be selected? The design decision will be reviewed by both data engineering and BI owners.

Denormalize selected attributes into the analytical table
Apply the row filter as early as practical in the query or transformation
Use the OneLake catalog to discover and evaluate available data products
Create a DAX measure using the required aggregation and filter context logic
Write the required SQL query against the endpoint

Correct answer: E

Why: The SQL analytics endpoint supports relational querying with T-SQL for selection, filtering, joins, and aggregation. This directly matches the stated requirement.

Option review:

B: Early filtering reduces the volume of data moved and processed while preserving only the rows required by the workload. This can be valid for ‘Filter data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

D: DAX measures evaluate in semantic-model filter context and are the native way to define reusable analytical calculations. This can be valid for ‘Select, filter, and aggregate data by using DAX’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

E: The SQL analytics endpoint supports relational querying with T-SQL for selection, filtering, joins, and aggregation. This directly matches the stated requirement.

Learning point: Write the required SQL query against the endpoint

Question 26

Northwind Traders is standardizing how the customer 360 model is managed. The immediate goal is to return revenue by product category from a warehouse using relational syntax. Given that the team wants the smallest administrative blast radius, which option should the retail insights team choose? Existing users should keep their current access.

Cast the column to the appropriate numeric type before aggregation
Create a SQL view
Use Real-Time hub to browse and connect to real-time data sources
Use T-SQL with SELECT, JOIN, WHERE, GROUP BY, and aggregate functions as required
Use Direct Lake against the OneLake-backed data

Correct answer: D

Why: SQL is the native relational query language for warehouse and SQL analytics endpoint workloads. This directly matches the stated requirement.

Option review:

A: Numeric calculations require a compatible numeric type and should avoid relying on implicit conversion. This can be valid for ‘Convert column data types’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

B: A view encapsulates a reusable query and presents it as a virtual table. This can be valid for ‘Create views, functions, and stored procedures’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

C: Real-Time hub is the Fabric experience for discovering, connecting to, and managing real-time event streams and sources. This can be valid for ‘Discover data by using OneLake catalog and Real-Time hub’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

D: SQL is the native relational query language for warehouse and SQL analytics endpoint workloads. This directly matches the stated requirement.

Learning point: Use T-SQL with SELECT, JOIN, WHERE, GROUP BY, and aggregate functions as required

Question 27

An internal audit of Trey Research’s sales analytics solution identifies this requirement: filter and summarize rows exposed through a SQL analytics endpoint. The BI platform team also notes that the team wants to keep governance centralized. What should they do? Existing users should keep their current access.

Create a OneLake shortcut to the existing data
Write the required SQL query against the endpoint
Group the data by month and region and calculate the required summary measures
Use Dataflow Gen2 for the ingestion and transformation flow
Use the OneLake catalog to discover and evaluate available data products

Correct answer: B

Why: The SQL analytics endpoint supports relational querying with T-SQL for selection, filtering, joins, and aggregation. This directly matches the stated requirement.

Option review:

A: A shortcut provides logical access to supported external or OneLake data without copying the underlying files. This can be valid for ‘Ingest or access data as needed’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

B: The SQL analytics endpoint supports relational querying with T-SQL for selection, filtering, joins, and aggregation. This directly matches the stated requirement.

C: Aggregation changes detailed rows into grouped summaries at the required analytical grain. This can be valid for ‘Aggregate data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

D: Dataflow Gen2 provides a Power Query based low-code ingestion and transformation experience. This can be valid for ‘Ingest or access data as needed’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

E: The OneLake catalog is designed to discover governed Fabric data items across the organization. This can be valid for ‘Discover data by using OneLake catalog and Real-Time hub’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

Learning point: Write the required SQL query against the endpoint

Question 28

The risk analytics environment at Alpine Ski House is moving from proof of concept to production. Before rollout, the security analytics team must return revenue by product category from a warehouse using relational syntax, while ensuring that the approach should remain understandable to future maintainers. Which action best meets both needs? No unrelated workspace or model permissions should be changed.

Use T-SQL with SELECT, JOIN, WHERE, GROUP BY, and aggregate functions as required
Use the Visual Query Editor to build the query graphically
Use Dataflow Gen2 for the ingestion and transformation flow
Precompute the required daily aggregate table or result
Convert the column to an appropriate date or datetime data type

Correct answer: A

Why: SQL is the native relational query language for warehouse and SQL analytics endpoint workloads. This directly matches the stated requirement.

Option review:

A: SQL is the native relational query language for warehouse and SQL analytics endpoint workloads. This directly matches the stated requirement.

B: The Visual Query Editor provides a graphical experience for selecting, filtering, joining, and aggregating supported data. This can be valid for ‘Select, filter, and aggregate data by using the Visual query editor’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

C: Dataflow Gen2 provides a Power Query based low-code ingestion and transformation experience. This can be valid for ‘Ingest or access data as needed’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

D: Pre-aggregation can reduce repeated scanning of detail rows when consumers consistently query a higher-level grain. This can be valid for ‘Aggregate data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

E: Using the correct native type enables valid date comparisons, filtering, and time intelligence. This can be valid for ‘Convert column data types’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

Learning point: Use T-SQL with SELECT, JOIN, WHERE, GROUP BY, and aggregate functions as required

Question 29

Contoso has a change request for the service-operations warehouse: filter and summarize rows exposed through a SQL analytics endpoint. The Fabric center of excellence wants a solution where the implementation should reduce operational overhead. Which implementation is most suitable? No unrelated workspace or model permissions should be changed.

Write the required SQL query against the endpoint
Add a calculated or derived column in the transformation layer
Use KQL operators such as where, summarize, and bin against the KQL database
Apply the row filter as early as practical in the query or transformation
Append or union the row sets instead of joining them

Correct answer: A

Why: The SQL analytics endpoint supports relational querying with T-SQL for selection, filtering, joins, and aggregation. This directly matches the stated requirement.

Option review:

A: The SQL analytics endpoint supports relational querying with T-SQL for selection, filtering, joins, and aggregation. This directly matches the stated requirement.

B: A derived column enriches the dataset with business logic while preserving the source fields. This can be valid for ‘Enrich data by adding new columns or tables’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

C: KQL is optimized for filtering and aggregating log, telemetry, and time-series data in Eventhouse. This can be valid for ‘Select, filter, and aggregate data by using KQL’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

D: Early filtering reduces the volume of data moved and processed while preserving only the rows required by the workload. This can be valid for ‘Filter data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

Learning point: Write the required SQL query against the endpoint

Question 30

A solution architect reviewing Wingtip Toys’s executive reporting workspace asks the customer insights team to return revenue by product category from a warehouse using relational syntax. Since the solution must remain maintainable as usage grows, which recommendation is strongest? The team will validate the change first in a nonproduction environment.

Use KQL operators such as where, summarize, and bin against the KQL database
Use a left outer join from customers to orders
Use T-SQL with SELECT, JOIN, WHERE, GROUP BY, and aggregate functions as required
Append or union the row sets instead of joining them
Build it in the Visual Query Editor

Correct answer: C

Why: SQL is the native relational query language for warehouse and SQL analytics endpoint workloads. This directly matches the stated requirement.

Option review:

A: KQL is optimized for filtering and aggregating log, telemetry, and time-series data in Eventhouse. This can be valid for ‘Select, filter, and aggregate data by using KQL’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

C: SQL is the native relational query language for warehouse and SQL analytics endpoint workloads. This directly matches the stated requirement.

D: Union or append combines rows from compatible schemas, whereas a join combines columns based on matching keys. This can be valid for ‘Merge or join data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

E: The visual editor is intended for graphical query construction while still supporting common relational operations. This can be valid for ‘Select, filter, and aggregate data by using the Visual query editor’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using SQL’.

Learning point: Use T-SQL with SELECT, JOIN, WHERE, GROUP BY, and aggregate functions as required

Question 31

The next sprint for Proseware’s marketing semantic model includes a task to summarize event counts by device over five-minute intervals in an Eventhouse. The acceptance criteria add that the team wants the smallest administrative blast radius. Which Fabric or Power BI action is appropriate? Existing users should keep their current access.

Denormalize selected attributes into the analytical table
Use a DAX query with functions such as SUMMARIZECOLUMNS and CALCULATE as appropriate
Apply the row filter as early as practical in the query or transformation
Apply an explicit predicate that excludes the test rows
Use KQL operators such as where, summarize, and bin against the KQL database

Correct answer: E

Why: KQL is optimized for filtering and aggregating log, telemetry, and time-series data in Eventhouse. This directly matches the stated requirement.

Option review:

B: DAX queries and functions operate on semantic-model metadata, relationships, and filter context. This can be valid for ‘Select, filter, and aggregate data by using DAX’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using KQL’.

C: Early filtering reduces the volume of data moved and processed while preserving only the rows required by the workload. This can be valid for ‘Filter data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using KQL’.

E: KQL is optimized for filtering and aggregating log, telemetry, and time-series data in Eventhouse. This directly matches the stated requirement.

Learning point: Use KQL operators such as where, summarize, and bin against the KQL database

Question 32

Blue Yonder Airlines is troubleshooting a design decision in the supply-chain lakehouse. The desired end state is to project selected telemetry fields and filter recent events in a KQL database; the team wants to keep governance centralized. Which change should the operations data team make? Existing users should keep their current access.

Use KQL project and where operators
Use a DAX query with functions such as SUMMARIZECOLUMNS and CALCULATE as appropriate
Use T-SQL with SELECT, JOIN, WHERE, GROUP BY, and aggregate functions as required
Use the OneLake catalog to discover and evaluate available data products
Model the warehouse with conformed dimensions around fact tables

Correct answer: A

Why: KQL provides concise operators for selecting columns and filtering event data. This directly matches the stated requirement.

Option review:

A: KQL provides concise operators for selecting columns and filtering event data. This directly matches the stated requirement.

C: SQL is the native relational query language for warehouse and SQL analytics endpoint workloads. This can be valid for ‘Select, filter, and aggregate data by using SQL’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using KQL’.

E: Conformed dimensions and explicit fact grain are core star-schema practices for reliable analytical joins. This can be valid for ‘Implement a star schema for a lakehouse or warehouse’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using KQL’.

Learning point: Use KQL project and where operators

Question 33

For the IoT telemetry solution, Fabrikam has documented a business requirement to summarize event counts by device over five-minute intervals in an Eventhouse. The data governance group must meet it in a way where the approach should remain understandable to future maintainers. What is the best choice? No unrelated workspace or model permissions should be changed.

Use KQL operators such as where, summarize, and bin against the KQL database
Create and manage a shared Fabric connection for the data source
Use Direct Lake against the OneLake-backed data
Create a OneLake shortcut to the existing data
Flatten the required lookup attributes into the reporting structure

Correct answer: A

Why: KQL is optimized for filtering and aggregating log, telemetry, and time-series data in Eventhouse. This directly matches the stated requirement.

Option review:

A: KQL is optimized for filtering and aggregating log, telemetry, and time-series data in Eventhouse. This directly matches the stated requirement.

B: Fabric connections centralize connection details and credentials so supported items can reuse governed access. This can be valid for ‘Create a data connection’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using KQL’.

Learning point: Use KQL operators such as where, summarize, and bin against the KQL database

Question 34

A governance review of Litware’s finance reporting platform asks for evidence that the solution can project selected telemetry fields and filter recent events in a KQL database. Because the implementation should reduce operational overhead, which action should be approved? No unrelated workspace or model permissions should be changed.

Append or union the row sets instead of joining them
Enable the supported OneLake availability or integration for the Eventhouse data
Create a stored procedure
Use KQL project and where operators
Create a OneLake shortcut to the existing data

Correct answer: D

Why: KQL provides concise operators for selecting columns and filtering event data. This directly matches the stated requirement.

Option review:

D: KQL provides concise operators for selecting columns and filtering event data. This directly matches the stated requirement.

Learning point: Use KQL project and where operators

Question 35

Before expanding the retail performance dashboard, the finance analytics squad at Woodgrove Bank must summarize event counts by device over five-minute intervals in an Eventhouse. The rollout plan says that the solution must remain maintainable as usage grows. Which option most directly addresses the requirement? The team will validate the change first in a nonproduction environment.

Create a stored procedure
Use Real-Time hub to browse and connect to real-time data sources
Use KQL operators such as where, summarize, and bin against the KQL database
Build it in the Visual Query Editor
Use a Fabric data pipeline Copy activity

Correct answer: C

Why: KQL is optimized for filtering and aggregating log, telemetry, and time-series data in Eventhouse. This directly matches the stated requirement.

Option review:

A: A stored procedure packages procedural multi-statement T-SQL operations for repeatable execution. This can be valid for ‘Create views, functions, and stored procedures’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using KQL’.

B: Real-Time hub is the Fabric experience for discovering, connecting to, and managing real-time event streams and sources. This can be valid for ‘Discover data by using OneLake catalog and Real-Time hub’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using KQL’.

C: KQL is optimized for filtering and aggregating log, telemetry, and time-series data in Eventhouse. This directly matches the stated requirement.

D: The visual editor is intended for graphical query construction while still supporting common relational operations. This can be valid for ‘Select, filter, and aggregate data by using the Visual query editor’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using KQL’.

E: Copy activity is suited to orchestrated bulk data movement into Fabric with scheduling and monitoring. This can be valid for ‘Ingest or access data as needed’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using KQL’.

Learning point: Use KQL operators such as where, summarize, and bin against the KQL database

Question 36

Coho Winery is redesigning its marketing semantic model. The analytics engineering team must project selected telemetry fields and filter recent events in a KQL database. In addition, the team wants the smallest administrative blast radius. Which action is the best fit? The team will validate the change first in a nonproduction environment.

Create a fact table at a defined grain with separate dimension tables
Use a left outer join from customers to orders
Use KQL project and where operators
Use a Fabric lakehouse
Apply the row filter as early as practical in the query or transformation

Correct answer: C

Why: KQL provides concise operators for selecting columns and filtering event data. This directly matches the stated requirement.

Option review:

C: KQL provides concise operators for selecting columns and filtering event data. This directly matches the stated requirement.

D: A lakehouse combines OneLake Delta storage with Spark-oriented engineering and a SQL analytics endpoint. This can be valid for ‘Choose between different data stores’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using KQL’.

Learning point: Use KQL project and where operators

Question 37

During a design review for Adventure Works’s supply-chain lakehouse, one requirement is non-negotiable: summarize event counts by device over five-minute intervals in an Eventhouse. Because the team wants to keep governance centralized, what should the operations data team implement? The solution must work with the current Fabric architecture rather than a parallel custom platform.

Use KQL operators such as where, summarize, and bin against the KQL database
Enable the supported OneLake availability or integration for the Eventhouse data
Use an Eventhouse with a KQL database
Create a OneLake shortcut to the existing data
Use the OneLake catalog to discover and evaluate available data products

Correct answer: A

Why: KQL is optimized for filtering and aggregating log, telemetry, and time-series data in Eventhouse. This directly matches the stated requirement.

Option review:

A: KQL is optimized for filtering and aggregating log, telemetry, and time-series data in Eventhouse. This directly matches the stated requirement.

Learning point: Use KQL operators such as where, summarize, and bin against the KQL database

Question 38

The data governance group at Tailspin Toys is preparing the next release of its IoT telemetry solution. They need to project selected telemetry fields and filter recent events in a KQL database; the approach should remain understandable to future maintainers. Which choice most directly satisfies the requirement? The solution must work with the current Fabric architecture rather than a parallel custom platform.

Filter or remediate rows with missing mandatory keys before loading the curated layer
Model the warehouse with conformed dimensions around fact tables
Create a stored procedure
Use KQL project and where operators
Denormalize selected attributes into the analytical table

Correct answer: D

Why: KQL provides concise operators for selecting columns and filtering event data. This directly matches the stated requirement.

Option review:

B: Conformed dimensions and explicit fact grain are core star-schema practices for reliable analytical joins. This can be valid for ‘Implement a star schema for a lakehouse or warehouse’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using KQL’.

D: KQL provides concise operators for selecting columns and filtering event data. This directly matches the stated requirement.

E: Denormalization trades additional storage and duplication for simpler reads and fewer joins in analytical workloads. This can be valid for ‘Denormalize data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using KQL’.

Learning point: Use KQL project and where operators

Question 39

A production readiness review at Fourth Coffee found a gap in the finance reporting platform. The remediation must summarize event counts by device over five-minute intervals in an Eventhouse, and the implementation should reduce operational overhead. What is the most appropriate action? The design decision will be reviewed by both data engineering and BI owners.

Use Direct Lake against the OneLake-backed data
Use the Visual Query Editor to build the query graphically
Use an Eventhouse with a KQL database
Use KQL operators such as where, summarize, and bin against the KQL database
Use the OneLake catalog to discover and evaluate available data products

Correct answer: D

Why: KQL is optimized for filtering and aggregating log, telemetry, and time-series data in Eventhouse. This directly matches the stated requirement.

Option review:

A: Direct Lake lets semantic models query OneLake Delta data with in-memory analytical performance without a traditional import copy. This can be valid for ‘Implement OneLake integration for Eventhouse and semantic models’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using KQL’.

D: KQL is optimized for filtering and aggregating log, telemetry, and time-series data in Eventhouse. This directly matches the stated requirement.

Learning point: Use KQL operators such as where, summarize, and bin against the KQL database

Question 40

For a new phase of the retail performance dashboard, Wide World Importers asks the finance analytics squad to project selected telemetry fields and filter recent events in a KQL database. The architecture decision record also states that the solution must remain maintainable as usage grows. Which approach should be selected? The design decision will be reviewed by both data engineering and BI owners.

Use KQL project and where operators
Use an inner join on the matching business or surrogate key
Handle nulls explicitly with a null-replacement rule such as COALESCE
Create and manage a shared Fabric connection for the data source
Create the additional dimension or lookup table during transformation

Correct answer: A

Why: KQL provides concise operators for selecting columns and filtering event data. This directly matches the stated requirement.

Option review:

A: KQL provides concise operators for selecting columns and filtering event data. This directly matches the stated requirement.

B: An inner join returns only rows with matching keys on both sides. This can be valid for ‘Merge or join data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using KQL’.

C: Explicit null handling avoids treating missing values as valid zeroes unless the business rule specifically requires that replacement. This can be valid for ‘Identify and resolve duplicate data, missing data, or null values’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using KQL’.

E: Adding a curated table can enrich the model with reusable business context for downstream joins and analysis. This can be valid for ‘Enrich data by adding new columns or tables’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using KQL’.

Learning point: Use KQL project and where operators

Question 41

Northwind Traders is standardizing how the marketing semantic model is managed. The immediate goal is to summarize event counts by device over five-minute intervals in an Eventhouse. Given that the team wants the smallest administrative blast radius, which option should the analytics engineering team choose? Existing users should keep their current access.

Enable the supported OneLake availability or integration for the Eventhouse data
Apply an explicit predicate that excludes the test rows
Identify the duplicate keys and deduplicate according to the authoritative business rule
Flatten the required lookup attributes into the reporting structure
Use KQL operators such as where, summarize, and bin against the KQL database

Correct answer: E

Why: KQL is optimized for filtering and aggregating log, telemetry, and time-series data in Eventhouse. This directly matches the stated requirement.

Option review:

B: A deterministic filter predicate is the direct way to prevent unwanted rows from reaching downstream analysis. This can be valid for ‘Filter data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using KQL’.

C: Deduplication must preserve the correct authoritative row while eliminating records that would inflate analytical results. This can be valid for ‘Identify and resolve duplicate data, missing data, or null values’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using KQL’.

D: Flattening commonly consumed attributes can make read-oriented analytics simpler when update anomalies are controlled upstream. This can be valid for ‘Denormalize data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using KQL’.

E: KQL is optimized for filtering and aggregating log, telemetry, and time-series data in Eventhouse. This directly matches the stated requirement.

Learning point: Use KQL operators such as where, summarize, and bin against the KQL database

Question 42

An internal audit of Trey Research’s supply-chain lakehouse identifies this requirement: project selected telemetry fields and filter recent events in a KQL database. The operations data team also notes that the team wants to keep governance centralized. What should they do? Existing users should keep their current access.

Precompute the required daily aggregate table or result
Use KQL project and where operators
Apply an explicit predicate that excludes the test rows
Use a left outer join from customers to orders
Create a SQL view

Correct answer: B

Why: KQL provides concise operators for selecting columns and filtering event data. This directly matches the stated requirement.

Option review:

B: KQL provides concise operators for selecting columns and filtering event data. This directly matches the stated requirement.

C: A deterministic filter predicate is the direct way to prevent unwanted rows from reaching downstream analysis. This can be valid for ‘Filter data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using KQL’.

D: A left outer join retains all rows from the left input and adds matching rows from the right input when available. This can be valid for ‘Merge or join data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using KQL’.

Learning point: Use KQL project and where operators

Question 43

The IoT telemetry solution at Alpine Ski House is moving from proof of concept to production. Before rollout, the data governance group must summarize event counts by device over five-minute intervals in an Eventhouse, while ensuring that the approach should remain understandable to future maintainers. Which action best meets both needs? No unrelated workspace or model permissions should be changed.

Precompute the required daily aggregate table or result
Cast the column to the appropriate numeric type before aggregation
Use KQL operators such as where, summarize, and bin against the KQL database
Handle nulls explicitly with a null-replacement rule such as COALESCE
Create a SQL function

Correct answer: C

Why: KQL is optimized for filtering and aggregating log, telemetry, and time-series data in Eventhouse. This directly matches the stated requirement.

Option review:

B: Numeric calculations require a compatible numeric type and should avoid relying on implicit conversion. This can be valid for ‘Convert column data types’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using KQL’.

C: KQL is optimized for filtering and aggregating log, telemetry, and time-series data in Eventhouse. This directly matches the stated requirement.

Learning point: Use KQL operators such as where, summarize, and bin against the KQL database

Question 44

Contoso has a change request for the finance reporting platform: project selected telemetry fields and filter recent events in a KQL database. The enterprise reporting group wants a solution where the implementation should reduce operational overhead. Which implementation is most suitable? No unrelated workspace or model permissions should be changed.

Use KQL project and where operators
Create a DAX measure using the required aggregation and filter context logic
Build it in the Visual Query Editor
Apply the row filter as early as practical in the query or transformation
Write the required SQL query against the endpoint

Correct answer: A

Why: KQL provides concise operators for selecting columns and filtering event data. This directly matches the stated requirement.

Option review:

A: KQL provides concise operators for selecting columns and filtering event data. This directly matches the stated requirement.

B: DAX measures evaluate in semantic-model filter context and are the native way to define reusable analytical calculations. This can be valid for ‘Select, filter, and aggregate data by using DAX’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using KQL’.

Learning point: Use KQL project and where operators

Question 45

A solution architect reviewing Wingtip Toys’s retail performance dashboard asks the finance analytics squad to summarize event counts by device over five-minute intervals in an Eventhouse. Since the solution must remain maintainable as usage grows, which recommendation is strongest? The team will validate the change first in a nonproduction environment.

Use KQL operators such as where, summarize, and bin against the KQL database
Apply an explicit predicate that excludes the test rows
Use a Fabric data pipeline Copy activity
Apply the row filter as early as practical in the query or transformation
Flatten the required lookup attributes into the reporting structure

Correct answer: A

Why: KQL is optimized for filtering and aggregating log, telemetry, and time-series data in Eventhouse. This directly matches the stated requirement.

Option review:

A: KQL is optimized for filtering and aggregating log, telemetry, and time-series data in Eventhouse. This directly matches the stated requirement.

C: Copy activity is suited to orchestrated bulk data movement into Fabric with scheduling and monitoring. This can be valid for ‘Ingest or access data as needed’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using KQL’.

Learning point: Use KQL operators such as where, summarize, and bin against the KQL database

Question 46

The next sprint for Proseware’s customer 360 model includes a task to calculate a context-aware business measure over a semantic model. The acceptance criteria add that the team wants the smallest administrative blast radius. Which Fabric or Power BI action is appropriate? Existing users should keep their current access.

Add a calculated or derived column in the transformation layer
Create a SQL view
Use a left outer join from customers to orders
Create a DAX measure using the required aggregation and filter context logic
Use KQL project and where operators

Correct answer: D

Why: DAX measures evaluate in semantic-model filter context and are the native way to define reusable analytical calculations. This directly matches the stated requirement.

Option review:

C: A left outer join retains all rows from the left input and adds matching rows from the right input when available. This can be valid for ‘Merge or join data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using DAX’.

D: DAX measures evaluate in semantic-model filter context and are the native way to define reusable analytical calculations. This directly matches the stated requirement.

E: KQL provides concise operators for selecting columns and filtering event data. This can be valid for ‘Select, filter, and aggregate data by using KQL’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using DAX’.

Learning point: Create a DAX measure using the required aggregation and filter context logic

Question 47

Blue Yonder Airlines is troubleshooting a design decision in the sales analytics solution. The desired end state is to return a summarized table from a semantic model while applying model-aware filters; the team wants to keep governance centralized. Which change should the BI platform team make? Existing users should keep their current access.

Use KQL project and where operators
Convert the column to an appropriate date or datetime data type
Use a DAX query with functions such as SUMMARIZECOLUMNS and CALCULATE as appropriate
Identify the duplicate keys and deduplicate according to the authoritative business rule
Use Dataflow Gen2 for the ingestion and transformation flow

Correct answer: C

Why: DAX queries and functions operate on semantic-model metadata, relationships, and filter context. This directly matches the stated requirement.

Option review:

A: KQL provides concise operators for selecting columns and filtering event data. This can be valid for ‘Select, filter, and aggregate data by using KQL’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using DAX’.

B: Using the correct native type enables valid date comparisons, filtering, and time intelligence. This can be valid for ‘Convert column data types’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using DAX’.

C: DAX queries and functions operate on semantic-model metadata, relationships, and filter context. This directly matches the stated requirement.

D: Deduplication must preserve the correct authoritative row while eliminating records that would inflate analytical results. This can be valid for ‘Identify and resolve duplicate data, missing data, or null values’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using DAX’.

Learning point: Use a DAX query with functions such as SUMMARIZECOLUMNS and CALCULATE as appropriate

Question 48

For the risk analytics environment, Fabrikam has documented a business requirement to calculate a context-aware business measure over a semantic model. The security analytics team must meet it in a way where the approach should remain understandable to future maintainers. What is the best choice? No unrelated workspace or model permissions should be changed.

Convert the column to an appropriate date or datetime data type
Use a Fabric data pipeline Copy activity
Use the Visual Query Editor to build the query graphically
Build it in the Visual Query Editor
Create a DAX measure using the required aggregation and filter context logic

Correct answer: E

Why: DAX measures evaluate in semantic-model filter context and are the native way to define reusable analytical calculations. This directly matches the stated requirement.

Option review:

A: Using the correct native type enables valid date comparisons, filtering, and time intelligence. This can be valid for ‘Convert column data types’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using DAX’.

B: Copy activity is suited to orchestrated bulk data movement into Fabric with scheduling and monitoring. This can be valid for ‘Ingest or access data as needed’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using DAX’.

C: The Visual Query Editor provides a graphical experience for selecting, filtering, joining, and aggregating supported data. This can be valid for ‘Select, filter, and aggregate data by using the Visual query editor’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using DAX’.

E: DAX measures evaluate in semantic-model filter context and are the native way to define reusable analytical calculations. This directly matches the stated requirement.

Learning point: Create a DAX measure using the required aggregation and filter context logic

Question 49

A governance review of Litware’s service-operations warehouse asks for evidence that the solution can return a summarized table from a semantic model while applying model-aware filters. Because the implementation should reduce operational overhead, which action should be approved? No unrelated workspace or model permissions should be changed.

Cast the column to the appropriate numeric type before aggregation
Use a DAX query with functions such as SUMMARIZECOLUMNS and CALCULATE as appropriate
Create the additional dimension or lookup table during transformation
Model the warehouse with conformed dimensions around fact tables
Group the data by month and region and calculate the required summary measures

Correct answer: B

Why: DAX queries and functions operate on semantic-model metadata, relationships, and filter context. This directly matches the stated requirement.

Option review:

B: DAX queries and functions operate on semantic-model metadata, relationships, and filter context. This directly matches the stated requirement.

E: Aggregation changes detailed rows into grouped summaries at the required analytical grain. This can be valid for ‘Aggregate data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using DAX’.

Learning point: Use a DAX query with functions such as SUMMARIZECOLUMNS and CALCULATE as appropriate

Question 50

Before expanding the executive reporting workspace, the customer insights team at Woodgrove Bank must calculate a context-aware business measure over a semantic model. The rollout plan says that the solution must remain maintainable as usage grows. Which option most directly addresses the requirement? The team will validate the change first in a nonproduction environment.

Model the warehouse with conformed dimensions around fact tables
Use KQL project and where operators
Cast the column to the appropriate numeric type before aggregation
Use the Visual Query Editor to build the query graphically
Create a DAX measure using the required aggregation and filter context logic

Correct answer: E

Why: DAX measures evaluate in semantic-model filter context and are the native way to define reusable analytical calculations. This directly matches the stated requirement.

Option review:

A: Conformed dimensions and explicit fact grain are core star-schema practices for reliable analytical joins. This can be valid for ‘Implement a star schema for a lakehouse or warehouse’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using DAX’.

B: KQL provides concise operators for selecting columns and filtering event data. This can be valid for ‘Select, filter, and aggregate data by using KQL’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using DAX’.

C: Numeric calculations require a compatible numeric type and should avoid relying on implicit conversion. This can be valid for ‘Convert column data types’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using DAX’.

D: The Visual Query Editor provides a graphical experience for selecting, filtering, joining, and aggregating supported data. This can be valid for ‘Select, filter, and aggregate data by using the Visual query editor’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using DAX’.

E: DAX measures evaluate in semantic-model filter context and are the native way to define reusable analytical calculations. This directly matches the stated requirement.

Learning point: Create a DAX measure using the required aggregation and filter context logic

Question 51

Coho Winery is redesigning its customer 360 model. The retail insights team must return a summarized table from a semantic model while applying model-aware filters. In addition, the team wants the smallest administrative blast radius. Which action is the best fit? The team will validate the change first in a nonproduction environment.

Use a DAX query with functions such as SUMMARIZECOLUMNS and CALCULATE as appropriate
Write the required SQL query against the endpoint
Use Direct Lake against the OneLake-backed data
Apply an explicit predicate that excludes the test rows
Identify the duplicate keys and deduplicate according to the authoritative business rule

Correct answer: A

Why: DAX queries and functions operate on semantic-model metadata, relationships, and filter context. This directly matches the stated requirement.

Option review:

A: DAX queries and functions operate on semantic-model metadata, relationships, and filter context. This directly matches the stated requirement.

B: The SQL analytics endpoint supports relational querying with T-SQL for selection, filtering, joins, and aggregation. This can be valid for ‘Select, filter, and aggregate data by using SQL’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using DAX’.

Learning point: Use a DAX query with functions such as SUMMARIZECOLUMNS and CALCULATE as appropriate

Question 52

During a design review for Adventure Works’s sales analytics solution, one requirement is non-negotiable: calculate a context-aware business measure over a semantic model. Because the team wants to keep governance centralized, what should the BI platform team implement? The solution must work with the current Fabric architecture rather than a parallel custom platform.

Create a SQL view
Use Real-Time hub to browse and connect to real-time data sources
Handle nulls explicitly with a null-replacement rule such as COALESCE
Build it in the Visual Query Editor
Create a DAX measure using the required aggregation and filter context logic

Correct answer: E

Why: DAX measures evaluate in semantic-model filter context and are the native way to define reusable analytical calculations. This directly matches the stated requirement.

Option review:

A: A view encapsulates a reusable query and presents it as a virtual table. This can be valid for ‘Create views, functions, and stored procedures’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using DAX’.

E: DAX measures evaluate in semantic-model filter context and are the native way to define reusable analytical calculations. This directly matches the stated requirement.

Learning point: Create a DAX measure using the required aggregation and filter context logic

Question 53

The security analytics team at Tailspin Toys is preparing the next release of its risk analytics environment. They need to return a summarized table from a semantic model while applying model-aware filters; the approach should remain understandable to future maintainers. Which choice most directly satisfies the requirement? The solution must work with the current Fabric architecture rather than a parallel custom platform.

Apply the row filter as early as practical in the query or transformation
Use a DAX query with functions such as SUMMARIZECOLUMNS and CALCULATE as appropriate
Create a fact table at a defined grain with separate dimension tables
Model the warehouse with conformed dimensions around fact tables
Use KQL project and where operators

Correct answer: B

Why: DAX queries and functions operate on semantic-model metadata, relationships, and filter context. This directly matches the stated requirement.

Option review:

B: DAX queries and functions operate on semantic-model metadata, relationships, and filter context. This directly matches the stated requirement.

C: A star schema places measurable events in a fact table and descriptive context in dimensions, simplifying analytics and improving model usability. This can be valid for ‘Implement a star schema for a lakehouse or warehouse’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using DAX’.

Learning point: Use a DAX query with functions such as SUMMARIZECOLUMNS and CALCULATE as appropriate

Question 54

A production readiness review at Fourth Coffee found a gap in the service-operations warehouse. The remediation must calculate a context-aware business measure over a semantic model, and the implementation should reduce operational overhead. What is the most appropriate action? The design decision will be reviewed by both data engineering and BI owners.

Precompute the required daily aggregate table or result
Create a fact table at a defined grain with separate dimension tables
Create and manage a shared Fabric connection for the data source
Create a stored procedure
Create a DAX measure using the required aggregation and filter context logic

Correct answer: E

Why: DAX measures evaluate in semantic-model filter context and are the native way to define reusable analytical calculations. This directly matches the stated requirement.

Option review:

B: A star schema places measurable events in a fact table and descriptive context in dimensions, simplifying analytics and improving model usability. This can be valid for ‘Implement a star schema for a lakehouse or warehouse’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using DAX’.

E: DAX measures evaluate in semantic-model filter context and are the native way to define reusable analytical calculations. This directly matches the stated requirement.

Learning point: Create a DAX measure using the required aggregation and filter context logic

Question 55

For a new phase of the executive reporting workspace, Wide World Importers asks the customer insights team to return a summarized table from a semantic model while applying model-aware filters. The architecture decision record also states that the solution must remain maintainable as usage grows. Which approach should be selected? The design decision will be reviewed by both data engineering and BI owners.

Use a Fabric lakehouse
Use Real-Time hub to browse and connect to real-time data sources
Create a OneLake shortcut to the existing data
Append or union the row sets instead of joining them
Use a DAX query with functions such as SUMMARIZECOLUMNS and CALCULATE as appropriate

Correct answer: E

Why: DAX queries and functions operate on semantic-model metadata, relationships, and filter context. This directly matches the stated requirement.

Option review:

A: A lakehouse combines OneLake Delta storage with Spark-oriented engineering and a SQL analytics endpoint. This can be valid for ‘Choose between different data stores’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using DAX’.

E: DAX queries and functions operate on semantic-model metadata, relationships, and filter context. This directly matches the stated requirement.

Learning point: Use a DAX query with functions such as SUMMARIZECOLUMNS and CALCULATE as appropriate

Question 56

Northwind Traders is standardizing how the customer 360 model is managed. The immediate goal is to calculate a context-aware business measure over a semantic model. Given that the team wants the smallest administrative blast radius, which option should the retail insights team choose? Existing users should keep their current access.

Apply an explicit predicate that excludes the test rows
Apply the row filter as early as practical in the query or transformation
Create a DAX measure using the required aggregation and filter context logic
Filter or remediate rows with missing mandatory keys before loading the curated layer
Use a Power BI semantic model

Correct answer: C

Why: DAX measures evaluate in semantic-model filter context and are the native way to define reusable analytical calculations. This directly matches the stated requirement.

Option review:

C: DAX measures evaluate in semantic-model filter context and are the native way to define reusable analytical calculations. This directly matches the stated requirement.

D: Mandatory-key quality rules should be enforced before downstream joins and aggregations depend on those records. This can be valid for ‘Identify and resolve duplicate data, missing data, or null values’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using DAX’.

E: A semantic model is the analytical serving layer for governed relationships, measures, and report consumption. This can be valid for ‘Choose between different data stores’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using DAX’.

Learning point: Create a DAX measure using the required aggregation and filter context logic

Question 57

An internal audit of Trey Research’s sales analytics solution identifies this requirement: return a summarized table from a semantic model while applying model-aware filters. The BI platform team also notes that the team wants to keep governance centralized. What should they do? Existing users should keep their current access.

Use a DAX query with functions such as SUMMARIZECOLUMNS and CALCULATE as appropriate
Use KQL project and where operators
Use a left outer join from customers to orders
Enable the supported OneLake availability or integration for the Eventhouse data
Create the additional dimension or lookup table during transformation

Correct answer: A

Why: DAX queries and functions operate on semantic-model metadata, relationships, and filter context. This directly matches the stated requirement.

Option review:

A: DAX queries and functions operate on semantic-model metadata, relationships, and filter context. This directly matches the stated requirement.

D: OneLake integration makes supported Eventhouse data discoverable and accessible through OneLake for cross-engine use. This can be valid for ‘Implement OneLake integration for Eventhouse and semantic models’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using DAX’.

Learning point: Use a DAX query with functions such as SUMMARIZECOLUMNS and CALCULATE as appropriate

Question 58

The risk analytics environment at Alpine Ski House is moving from proof of concept to production. Before rollout, the security analytics team must calculate a context-aware business measure over a semantic model, while ensuring that the approach should remain understandable to future maintainers. Which action best meets both needs? No unrelated workspace or model permissions should be changed.

Create a stored procedure
Create a DAX measure using the required aggregation and filter context logic
Group the data by month and region and calculate the required summary measures
Use a Fabric warehouse
Build it in the Visual Query Editor

Correct answer: B

Why: DAX measures evaluate in semantic-model filter context and are the native way to define reusable analytical calculations. This directly matches the stated requirement.

Option review:

B: DAX measures evaluate in semantic-model filter context and are the native way to define reusable analytical calculations. This directly matches the stated requirement.

Learning point: Create a DAX measure using the required aggregation and filter context logic

Question 59

Contoso has a change request for the service-operations warehouse: return a summarized table from a semantic model while applying model-aware filters. The Fabric center of excellence wants a solution where the implementation should reduce operational overhead. Which implementation is most suitable? No unrelated workspace or model permissions should be changed.

Handle nulls explicitly with a null-replacement rule such as COALESCE
Use a Fabric lakehouse
Create a SQL function
Group the data by month and region and calculate the required summary measures
Use a DAX query with functions such as SUMMARIZECOLUMNS and CALCULATE as appropriate

Correct answer: E

Why: DAX queries and functions operate on semantic-model metadata, relationships, and filter context. This directly matches the stated requirement.

Option review:

C: A function is appropriate for reusable parameterized logic that returns a value or table expression. This can be valid for ‘Create views, functions, and stored procedures’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using DAX’.

D: Aggregation changes detailed rows into grouped summaries at the required analytical grain. This can be valid for ‘Aggregate data’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using DAX’.

E: DAX queries and functions operate on semantic-model metadata, relationships, and filter context. This directly matches the stated requirement.

Learning point: Use a DAX query with functions such as SUMMARIZECOLUMNS and CALCULATE as appropriate

Question 60

A solution architect reviewing Wingtip Toys’s executive reporting workspace asks the customer insights team to calculate a context-aware business measure over a semantic model. Since the solution must remain maintainable as usage grows, which recommendation is strongest? The team will validate the change first in a nonproduction environment.

Apply the row filter as early as practical in the query or transformation
Create the additional dimension or lookup table during transformation
Create a fact table at a defined grain with separate dimension tables
Create a DAX measure using the required aggregation and filter context logic
Configure the appropriate gateway and connection credentials

Correct answer: D

Why: DAX measures evaluate in semantic-model filter context and are the native way to define reusable analytical calculations. This directly matches the stated requirement.

Option review:

D: DAX measures evaluate in semantic-model filter context and are the native way to define reusable analytical calculations. This directly matches the stated requirement.

E: An on-premises gateway provides the network bridge while the connection stores the credentials and source details. This can be valid for ‘Create a data connection’, but it does not directly satisfy the scenario requirement being tested under ‘Select, filter, and aggregate data by using DAX’.

Learning point: Create a DAX measure using the required aggregation and filter context logic

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25

Question 26

Question 27

Question 28

Question 29

Question 30

Question 31

Question 32

Question 33

Question 34

Question 35

Question 36

Question 37

Question 38

Question 39

Question 40

Question 41

Question 42

Question 43

Question 44

Question 45

Question 46

Question 47

Question 48

Question 49

Question 50

Question 51

Question 52

Question 53

Question 54

Question 55

Question 56

Question 57

Question 58

Question 59

Question 60

Related posts: