View Full Microsoft DP-600 Exam Dumps and Practice Test Dumps.

 

Question 281

Which DAX function can return a value from a related table when a valid many-to-one relationship exists between the current table and the related table?

1. FILTER
2. RELATED
3. SUMX
4. VALUES

Correct Answer: 2

Explanation

RELATED retrieves a value from a related table when a valid relationship exists and the current row context can navigate to the related table. It is commonly used in calculated columns when descriptive information needs to be brought from a dimension table into another table. FILTER creates a filtered table, SUMX performs row-by-row aggregation, and VALUES returns distinct values. Therefore, RELATED is the appropriate DAX function when a calculation needs to retrieve a corresponding value from a related table.

Question 282

Which Fabric component provides a SQL-based endpoint for querying tables stored in a lakehouse?

1. SQL analytics endpoint
2. Eventstream
3. Dataflow Gen2
4. OneLake catalog

Correct Answer: 1

Explanation

A lakehouse provides a SQL analytics endpoint that allows users to query the structured tables in the lakehouse using SQL. This gives SQL-oriented users a familiar interface for analytical queries without requiring the lakehouse itself to be converted into a traditional warehouse. Eventstream is designed for real-time event processing, Dataflow Gen2 handles data transformation, and OneLake catalog supports data discovery. Therefore, the SQL analytics endpoint is the appropriate component when SQL querying of lakehouse tables is required.

Question 283

Which DAX function can modify the filter context in which an expression is evaluated?

1. CALCULATE
2. DISTINCT
3. CONCATENATEX
4. MINX

Correct Answer: 1

Explanation

CALCULATE evaluates an expression after modifying its filter context. It is one of the most important DAX functions for creating analytical measures because filters can be added, removed, or modified as part of the calculation. For example, a measure can use CALCULATE to evaluate sales for a specific product category or ignore a particular filter. DISTINCT returns unique values, CONCATENATEX combines text values, and MINX performs an iterator-based minimum calculation. Therefore, CALCULATE is the appropriate function for changing filter context during evaluation.

Question 284

Which Power Query feature is most appropriate for creating a reusable data-preparation process that can be applied to multiple entities within a Fabric dataflow?

1. Custom function
2. Bookmark
3. Measure
4. Calculation group

Correct Answer: 1

Explanation

A Power Query custom function allows transformation logic to be defined once and reused with different inputs. This is particularly useful when several entities have similar structures and require the same cleansing or transformation steps. The function can accept parameters and return a transformed table, reducing duplicated query logic and making maintenance easier. Bookmarks control report states, measures contain DAX calculations, and calculation groups organize reusable semantic calculations. Therefore, a custom function is the appropriate Power Query feature for reusable data-preparation logic.

Question 285

Which semantic-model relationship type is commonly used between a dimension table containing unique keys and a fact table containing repeated foreign keys?

1. Many-to-many
2. One-to-one
3. One-to-many
4. Many-to-one only from the fact perspective

Correct Answer: 3

Explanation

A one-to-many relationship is the standard relationship between a dimension table and a fact table in a star schema. The dimension contains one unique row for each key, while the fact table can contain many rows referencing the same key. For example, one customer can have many sales transactions. This relationship supports predictable filtering from the dimension toward the fact table. Many-to-many relationships are used for more complex scenarios, while one-to-one is appropriate only when both sides contain unique keys. Therefore, one-to-many is the standard choice.

Question 286

Which DAX function can return a table containing all rows from a specified table while removing filters from that table?

1. ALL
2. IF
3. RELATED
4. DIVIDE

Correct Answer: 1

Explanation

ALL returns all values or rows from a specified table or column while removing filters affecting that table or column. It is often used in calculations where a denominator must represent the overall population rather than the current filtered subset. For example, a percentage-of-total calculation can use ALL to obtain an unfiltered total. IF handles conditional logic, RELATED retrieves related values, and DIVIDE performs arithmetic division. Therefore, ALL is the appropriate function when a table expression should ignore filters applied to the specified table.

Question 287

Which Fabric experience is specifically designed for querying and analyzing event data using Kusto Query Language?

1. Warehouse
2. Eventhouse
3. Lakehouse
4. Dataflow Gen2

Correct Answer: 2

Explanation

Eventhouse is a Fabric experience designed for real-time and event-based analytical workloads and uses Kusto Query Language for querying event data. It is well suited to telemetry, logs, application events, and other high-volume time-oriented datasets. A Warehouse provides SQL-based relational analytics, a Lakehouse combines data-lake storage with analytical capabilities, and Dataflow Gen2 focuses on data transformation. Therefore, Eventhouse is the appropriate Fabric experience when event data needs to be queried and analyzed using KQL.

Question 288

Which DAX function can return a table containing rows from a source table after applying a Boolean filter expression?

1. FILTER
2. SUM
3. YEAR
4. FORMAT

Correct Answer: 1

Explanation

FILTER evaluates a table and returns only the rows that satisfy a specified Boolean condition. It is commonly used as a table expression inside other DAX functions when a calculation needs a customized subset of records. For example, FILTER can return sales transactions where the amount exceeds a particular threshold. SUM performs numeric aggregation, YEAR extracts a year from a date, and FORMAT controls value presentation. Therefore, FILTER is the appropriate function when a table expression must be restricted according to a logical condition.

Question 289

A report designer wants users to switch between different dimensions, such as Product and Region, in the same visual without creating separate visuals. Which feature should be used?

1. Field parameter
2. Display folder
3. Data category
4. Calculation group

Correct Answer: 1

Explanation

A field parameter allows users to dynamically select different fields or measures for a visual. For example, a single chart can allow users to switch its axis between Product and Region using a parameter-driven selection. This reduces the need to create multiple separate visuals for each analytical perspective. Display folders organize model objects, data categories provide semantic metadata, and calculation groups manage reusable calculation logic. Therefore, a field parameter is the appropriate feature for allowing users to dynamically switch dimensions within the same visual.

Question 290

Which Power Query transformation changes the capitalization or other text characteristics of values in a text column?

1. Transform Text
2. Group By
3. Merge Queries
4. Pivot Column

Correct Answer: 1

Explanation

Power Query provides text transformation operations that can change characteristics such as uppercase, lowercase, or proper-case formatting. These transformations are useful for standardizing text values before they are loaded into a semantic model or analytical destination. Group By creates aggregations, Merge Queries combines information from related queries, and Pivot Column restructures data by converting values into columns. Therefore, text transformation is the appropriate approach when the goal is to standardize capitalization or similar characteristics within a text column.

Question 291

Which DAX function can return a value based on the first condition in a series that evaluates to TRUE?

1. SWITCH
2. SUM
3. DISTINCTCOUNT
4. VALUES

Correct Answer: 1

Explanation

SWITCH can evaluate multiple conditions and return the result associated with the first matching condition when used in its logical form. It is useful for implementing classifications and branching logic without deeply nested IF expressions. For example, different sales thresholds can produce different category labels. SUM performs numeric aggregation, DISTINCTCOUNT counts unique values, and VALUES returns a table of distinct values. Therefore, SWITCH is appropriate when a DAX expression needs to evaluate multiple possible conditions and return the corresponding result.

Question 292

Which Fabric feature provides a visual representation of how data and analytical items are connected across a solution?

1. Lineage view
2. Display folder
3. Slicer
4. Data category

Correct Answer: 1

Explanation

Lineage view provides a visual representation of dependencies between supported Fabric and Power BI items. It can help users understand how data sources, transformations, semantic models, and reports are connected. This is useful when assessing the impact of changes, troubleshooting dependencies, or documenting analytical solutions. Display folders organize fields inside semantic models, slicers provide report filtering, and data categories describe field semantics. Therefore, Lineage view is the appropriate feature when users need to visualize relationships among data and analytical assets.

Question 293

Which DAX function can calculate the sum of an expression evaluated row by row over a table?

1. SUMX
2. SUM
3. COUNT
4. MAX

Correct Answer: 1

Explanation

SUMX evaluates an expression for each row in a specified table and then adds the resulting values. It is useful when the calculation cannot simply reference a single numeric column. For example, a sales amount may need to be calculated as Quantity multiplied by Unit Price for every transaction before all results are summed. SUM directly aggregates a column, while COUNT counts values and MAX returns the largest value. Therefore, SUMX is the correct function when the sum depends on a row-level expression.

Question 294

Which Power Query operation is used to combine two queries horizontally by matching values in selected columns?

1. Merge Queries
2. Append Queries
3. Unpivot Columns
4. Remove Duplicates

Correct Answer: 1

Explanation

Merge Queries combines information from two queries by matching values in one or more selected columns. The operation is similar to a relational join and can add columns from one dataset to another based on a common key. Append Queries instead combines rows vertically, Unpivot Columns restructures multiple columns into rows, and Remove Duplicates eliminates repeated records. Therefore, Merge Queries is the appropriate operation when related information must be combined horizontally using matching keys.

Question 295

Which semantic-model feature can expose a simplified subset of a large model to a particular group of users?

1. Perspective
2. Hierarchy
3. Measure
4. Relationship

Correct Answer: 1

Explanation

A perspective provides a customized view of a semantic model by exposing selected model objects while hiding unrelated items from that particular perspective. This is useful in large enterprise models where finance, sales, and operations users may require different subsets of the same underlying model. A hierarchy organizes related fields, measures perform calculations, and relationships define how tables interact. Therefore, a perspective is the appropriate feature when the objective is to provide a simplified, audience-focused view without creating a separate physical model.

Question 296

Which DAX function returns the average of the values in a column?

1. AVERAGE
2. AVERAGEX
3. MEDIAN
4. SUMX

Correct Answer: 1

Explanation

AVERAGE calculates the arithmetic mean of the numeric values in a column. It is appropriate when the values to be averaged already exist in a column and no row-level expression needs to be evaluated first. AVERAGEX is used when an expression must be evaluated for each row before calculating the average. MEDIAN returns the middle value rather than the arithmetic mean, while SUMX performs row-by-row summation. Therefore, AVERAGE is the appropriate DAX function for directly calculating the mean of a numeric column.

Question 297

Which Fabric data-integration capability provides a low-code interface for transforming and loading data without requiring Spark or handwritten Python?

1. Dataflow Gen2
2. Notebook
3. Eventhouse
4. Report

Correct Answer: 1

Explanation

Dataflow Gen2 provides a low-code data preparation and integration experience based on Power Query. It allows users to connect to supported sources, transform data, and load the results into supported Fabric destinations without requiring them to write Spark or Python code. Notebooks are designed for code-based processing, Eventhouse is optimized for event and real-time analytics, and reports present analytical results. Therefore, Dataflow Gen2 is the appropriate choice for low-code transformation and loading workflows.

Question 298

Which DAX function can determine whether the current context contains exactly one distinct value for a column?

1. SELECTEDVALUE
2. HASONEVALUE
3. ALL
4. FILTER

Correct Answer: 2

Explanation

HASONEVALUE returns TRUE when the specified column contains exactly one distinct value in the current filter context. It is useful when a measure must determine whether the user has narrowed a context to a single item before performing conditional logic. SELECTEDVALUE can retrieve that single value and can provide an alternate result when multiple or no values exist. ALL removes filters and FILTER returns a filtered table. Therefore, HASONEVALUE is the appropriate function when the requirement is specifically to test for one distinct value.

Question 299

Which KQL operator is used to arrange query results according to one or more columns?

1. where
2. project
3. sort by
4. summarize

Correct Answer: 3

Explanation

The KQL sort by operator orders query results according to one or more specified columns. It can be used to arrange records in ascending or descending order, such as displaying the newest events first or ranking results by a numeric measure. The where operator filters records, project controls returned columns, and summarize performs grouped aggregation. Therefore, sort by is the appropriate Kusto Query Language operator when the requirement is to control the ordering of query results.

Question 300

A semantic model contains a Date table that includes dates for several years. A measure needs to return the sales value from the corresponding period in the previous year. Which DAX function is designed for this purpose?

1. DATEADD
2. SAMEPERIODLASTYEAR
3. TODAY
4. EDATE

Correct Answer: 2

Explanation

SAMEPERIODLASTYEAR returns a table containing dates shifted to the corresponding period in the previous year. It is commonly used with CALCULATE to create year-over-year measures, such as comparing current sales with sales from the same period one year earlier. DATEADD can also shift dates by a specified interval but provides more general date-shifting behavior. TODAY returns the current date, while EDATE shifts a date by a specified number of months. Therefore, SAMEPERIODLASTYEAR is specifically suited to previous-year period comparisons.