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

 

Question 221

Which Fabric capability allows data stored outside the current lakehouse to be accessed through a reference without copying the underlying data?

1. Dataflow Gen2
2. OneLake shortcut
3. Deployment pipeline
4. Semantic model

Correct Answer: 2

Explanation

A OneLake shortcut provides a reference to data stored in another supported location without requiring the underlying data to be copied into the destination lakehouse. This can help reduce unnecessary duplication while allowing Fabric workloads to access data through OneLake. Shortcuts are particularly useful when organizations want to maintain data in its existing location while making it available to other analytical workloads. Dataflows transform data, deployment pipelines promote content, and semantic models provide analytical structures. Therefore, OneLake shortcut is the appropriate capability.

Question 222

Which DAX function is useful for replacing a blank result with another value, such as zero?

1. COALESCE
2. RANKX
3. TREATAS
4. SUMMARIZE

Correct Answer: 1

Explanation

COALESCE returns the first expression that does not evaluate to BLANK. It is commonly used to provide fallback values for measures, such as displaying zero instead of a blank result when no sales exist for a category. This can make reports easier to interpret and can simplify conditional logic. RANKX calculates rankings, TREATAS applies table values as filters, and SUMMARIZE creates grouped tables. Therefore, COALESCE is the appropriate DAX function when a blank result should be replaced by an alternative value.

Question 223

A data engineer needs to process a large set of transformations using Python and Spark within Microsoft Fabric. Which Fabric experience is most appropriate?

1. Report
2. Notebook
3. Dashboard
4. Semantic model

Correct Answer: 2

Explanation

A Fabric notebook provides an interactive environment for code-based data engineering and analytical workloads, including Python and Apache Spark. It can be used to read data, transform datasets, execute Spark operations, and write results to supported Fabric storage. Reports and dashboards focus on presenting analytical information, while semantic models organize data for business intelligence. A notebook is therefore appropriate when the workload requires programmable transformations and distributed processing using Spark rather than primarily visual or semantic-model development.

Question 224

Which semantic-model feature allows a user to organize related columns and measures into a navigable parent-child structure for reporting?

1. Hierarchy
2. Bookmark
3. Tooltip
4. Calculation group

Correct Answer: 1

Explanation

A hierarchy organizes related fields into multiple levels that users can navigate during analysis. For example, a Date hierarchy may contain Year, Quarter, Month, and Day, allowing users to move between levels in a visual. Hierarchies improve report usability by providing structured drill paths without requiring users to add each field separately. Bookmarks store report states, tooltips provide contextual information, and calculation groups organize reusable calculation logic. Therefore, a hierarchy is the appropriate semantic-model feature for organizing related fields into navigable levels.

Question 225

Which DAX function can rank rows based on the value of an expression within a specified table?

1. FILTER
2. RANKX
3. DISTINCT
4. VALUES

Correct Answer: 2

Explanation

RANKX evaluates an expression over a table and returns the ranking of a value within that set. It is commonly used for reports that need to identify top-performing products, customers, employees, or regions. The ranking can be affected by the evaluation context and can use ascending or descending ordering. FILTER restricts rows, DISTINCT returns unique values, and VALUES returns a table of distinct values from the specified column or table. Therefore, RANKX is the appropriate DAX function for creating rankings based on an expression.

Question 226

Which Power Query operation is most appropriate for changing rows into columns based on the unique values of a selected field?

1. Unpivot Columns
2. Append Queries
3. Pivot Column
4. Merge Queries

Correct Answer: 3

Explanation

Pivot Column transforms values from a selected column into separate columns, using another column to populate the resulting values. This is useful when data is stored in a normalized row-based structure but the analytical requirement needs certain categories represented as columns. Unpivot performs the opposite type of restructuring by converting columns into rows. Append combines rows from queries, while Merge combines columns using matching keys. Therefore, Pivot Column is the appropriate Power Query operation when values need to become separate columns.

Question 227

Which DAX function checks whether an expression evaluates to BLANK?

1. ISBLANK
2. HASONEVALUE
3. SELECTEDVALUE
4. SWITCH

Correct Answer: 1

Explanation

ISBLANK evaluates an expression and returns TRUE when that expression produces a blank result. It can be useful when report logic needs to display a message, substitute a value, or change behavior when data is unavailable. HASONEVALUE checks whether exactly one distinct value exists in the current filter context, SELECTEDVALUE retrieves a single selected value, and SWITCH handles multiple conditional outcomes. Therefore, ISBLANK is the appropriate function for testing whether a DAX expression has a blank result.

Question 228

A Power BI report should allow users to select either Revenue or Profit as the measure displayed by the same visual. Which feature is designed for this scenario?

1. Data category
2. Field parameter
3. Perspective
4. Display folder

Correct Answer: 2

Explanation

Field parameters allow report users to dynamically switch the fields or measures used by a visual. A parameter can contain multiple measures, such as Revenue and Profit, and users can select which one should be displayed without creating separate visuals for each measure. Data categories provide metadata about fields, perspectives organize model objects, and display folders help organize fields within a semantic model. Therefore, a field parameter is the appropriate feature for creating a user-controlled choice between different measures in the same visual.

Question 229

Which DAX function can concatenate text values from multiple rows into a single text result?

1. CONCATENATEX
2. COUNTROWS
3. MEDIANX
4. CALCULATE

Correct Answer: 1

Explanation

CONCATENATEX iterates over a table and combines the evaluated text values into a single string, optionally using a delimiter. It is useful for creating labels such as a comma-separated list of selected products or categories. COUNTROWS counts the rows in a table, MEDIANX evaluates an expression and returns its median, and CALCULATE modifies filter context for a scalar expression. Therefore, CONCATENATEX is the suitable DAX function when multiple text values need to be combined into one result.

Question 230

Which semantic-model design technique can help avoid ambiguity when multiple filtering paths exist between tables?

1. Use unnecessary bidirectional relationships
2. Prefer controlled single-direction relationships
3. Remove all dimensions
4. Create duplicate measures for every relationship

Correct Answer: 2

Explanation

Controlled single-direction relationships can help maintain predictable filter propagation and reduce ambiguous paths in a semantic model. In a typical star schema, filters commonly flow from dimension tables toward fact tables. Bidirectional relationships can be useful in specific scenarios, but using them broadly may create multiple filtering paths and unexpected results. Removing dimensions or duplicating measures does not solve relationship ambiguity effectively. Therefore, using appropriately designed single-direction relationships is a practical modeling approach for maintaining predictable filter behavior.

Question 231

Which Kusto Query Language operator is commonly used to group records and calculate aggregations such as counts or sums?

1. project
2. summarize
3. where
4. extend

Correct Answer: 2

Explanation

The summarize operator groups records according to specified grouping expressions and calculates aggregations such as count, sum, average, minimum, or maximum. It is a fundamental KQL operator for analytical queries over event and telemetry data. The where operator filters rows, project controls the columns returned, and extend creates calculated columns. For example, summarize can group events by application and calculate the number of events for each application. Therefore, summarize is the appropriate operator for grouped aggregation in Kusto Query Language.

Question 232

Which semantic-model property determines how a column is ordered when another column is used as its sorting basis?

1. Data category
2. Sort by Column
3. Perspective
4. Display folder

Correct Answer: 2

Explanation

Sort by Column allows one column to determine the ordering of another column. A common example is sorting month names chronologically using a month-number column instead of alphabetically. The displayed month name remains visible to users while the underlying numeric column controls the order. Data category provides semantic metadata, perspectives organize model objects for particular audiences, and display folders organize fields in the model interface. Therefore, Sort by Column is the appropriate feature when one column must control the ordering of another.

Question 233

A report contains a matrix with Year, Quarter, and Month levels. A user wants to move from the current level to a more detailed level within the same hierarchy. Which interaction should be used?

1. Drill down
2. Drillthrough
3. Bookmark
4. Tooltip

Correct Answer: 1

Explanation

Drill down allows users to move from a higher level to a more detailed level within a hierarchy displayed in a visual. For example, a matrix showing Year can be drilled down to Quarter and then Month. Drillthrough instead navigates to another report page containing details filtered according to the selected data point. Bookmarks store report states, while tooltips display additional contextual information. Therefore, drill down is the appropriate interaction when navigating through levels of a hierarchy within the same visual.

Question 234

Which Power Query feature allows a transformation to use a value that can be changed centrally without editing every transformation step?

1. Parameter
2. Bookmark
3. Measure
4. Hierarchy

Correct Answer: 1

Explanation

Power Query parameters allow values used by queries and transformations to be stored separately from the transformation logic. A parameter can represent values such as server names, folder paths, date boundaries, or filtering criteria and can be changed without manually editing every dependent step. Bookmarks belong to report navigation, measures are semantic-model calculations, and hierarchies organize fields for analysis. Therefore, a parameter is appropriate when transformation logic should depend on a centrally managed value that can be changed as needed.

Question 235

Which DAX function is useful for returning a different calculation depending on whether an expression matches one of several specified conditions?

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

Correct Answer: 1

Explanation

SWITCH can evaluate an expression or a series of conditions and return different results based on the matching case. It is useful for implementing business classifications, dynamic labels, or measures that require multiple possible outcomes. For example, a measure can return different text or calculations according to a selected metric or category. SUM adds numeric values, RELATED retrieves a value from a related table, and DISTINCTCOUNT counts unique values. Therefore, SWITCH is appropriate when several possible conditions need to produce different results.

Question 236

Which Fabric item is designed to orchestrate multiple data activities, dependencies, and scheduled execution as part of a data workflow?

1. Data pipeline
2. Semantic model
3. Report
4. Perspective

Correct Answer: 1

Explanation

A Fabric data pipeline is designed to orchestrate data movement and processing activities as part of an end-to-end workflow. It can contain multiple activities, define dependencies between them, and support scheduled or event-driven execution scenarios. This makes pipelines useful for coordinating ingestion, transformation, and downstream processing tasks. Semantic models provide analytical structures, reports present data to users, and perspectives organize model objects. Therefore, a data pipeline is the appropriate Fabric item for orchestrating multiple activities within a repeatable data workflow.

Question 237

Which DAX function evaluates an expression for each row of a table and then returns the highest resulting value?

1. MAXX
2. MAX
3. COUNT
4. VALUES

Correct Answer: 1

Explanation

MAXX is an iterator function that evaluates an expression for each row of a table and returns the highest resulting value. This makes it different from MAX, which evaluates a column directly rather than iterating through an expression for each row. For example, MAXX can calculate the largest extended sales amount when the value must first be derived from multiple columns. COUNT counts values, while VALUES returns a table of distinct values. Therefore, MAXX is appropriate when the maximum must be calculated from a row-level expression.

Question 238

Which Fabric development capability is intended to promote supported content through separate development, test, and production stages?

1. OneLake shortcut
2. Deployment pipeline
3. Power Query function
4. Data category

Correct Answer: 2

Explanation

Deployment pipelines support application lifecycle management by helping teams move supported Fabric and Power BI content through stages such as development, test, and production. This provides a structured way to promote changes while keeping different lifecycle environments separate. OneLake shortcuts provide references to data, Power Query functions provide reusable transformations, and data categories provide semantic metadata. Therefore, deployment pipelines are the appropriate capability for managing content promotion across development, testing, and production stages.

Question 239

Which DAX function can return the median of an expression evaluated across the rows of a table?

1. MEDIAN
2. MEDIANX
3. AVERAGE
4. COUNT

Correct Answer: 2

Explanation

MEDIANX evaluates an expression for each row of a table and returns the median of the resulting values. This is useful when the values being analyzed must first be calculated rather than taken directly from an existing column. MEDIAN operates directly on a column, while AVERAGE calculates the arithmetic mean and COUNT counts values. Therefore, MEDIANX is appropriate when the median must be determined from a row-by-row expression, such as calculated revenue per transaction or another derived metric.

Question 240

A semantic model needs a security rule that dynamically filters rows based on the identity of the currently signed-in user. Which approach is appropriate?

1. Static report bookmark
2. Dynamic row-level security
3. Conditional formatting
4. Display folder

Correct Answer: 2

Explanation

Dynamic row-level security can use the identity of the current user to determine which rows should be visible. DAX functions and security logic can reference the signed-in user’s identity and apply corresponding filters, allowing one security role to support different users or groups dynamically. Bookmarks control report states, conditional formatting changes visual presentation, and display folders organize model fields. Therefore, dynamic row-level security is the appropriate approach when data visibility must change according to the identity of the user accessing the semantic model.