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

 

Question 201

Which Power Query capability allows transformations to be translated into operations that execute at the data source instead of locally?

1. Query folding
2. Data profiling
3. Column distribution
4. Group By

Correct Answer: 1

Explanation

Query folding allows Power Query to translate supported transformation steps into native operations that can be executed by the underlying data source. This can improve performance because the source performs more of the processing and less data needs to be transferred for local processing. Whether folding is available depends on the connector and transformations being applied. Data profiling provides information about data quality, while Group By creates aggregations. Therefore, query folding is the capability responsible for pushing supported transformations toward the source.

Question 202

A semantic model contains a Customer table with CustomerID and CustomerName. The report should display CustomerName in a dropdown while using CustomerID internally for filtering. Which modeling feature is most appropriate for controlling the displayed field?

1. Calculation group
2. Sort by Column
3. Field parameter
4. Perspective

Correct Answer: 4

Explanation

A perspective can provide a customized, business-focused view of a semantic model by exposing selected tables and fields to users. It is useful when a large model contains many technical objects but different users need a simplified analytical experience. Sort by Column controls the ordering of one column according to another, while field parameters dynamically switch fields in visuals. Calculation groups manage reusable calculation logic. Therefore, a perspective is appropriate when the objective is to present a controlled subset of semantic-model objects to a particular audience.

Question 203

Which Kusto Query Language operator is used to select specific columns from a query result and optionally create calculated expressions?

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

Correct Answer: 2

Explanation

The Kusto Query Language project operator controls which columns appear in the resulting dataset. It can also create calculated expressions or rename projected columns, making it useful for shaping query output. The where operator filters rows according to conditions, summarize performs aggregation, and count returns a row count. For example, a KQL query can use project to return only CustomerId, Region, and a calculated value. Therefore, project is the appropriate operator when selecting or deriving columns in a KQL result.

Question 204

What is the primary purpose of a perspective in a Power BI semantic model?

1. To refresh the semantic model automatically
2. To define row-level security
3. To present a focused subset of model objects to users
4. To replace relationships between tables

Correct Answer: 3

Explanation

A perspective provides a customized view of a semantic model by exposing a selected subset of tables, columns, measures, and other supported model objects. This is particularly useful for large enterprise models where different groups need access to relevant analytical areas without being presented with the entire model structure. Perspectives do not replace relationships, perform refresh operations, or provide row-level security. Security requirements should be handled with appropriate security roles and permissions. Therefore, presenting a focused subset of model objects is the primary purpose of a perspective.

Question 205

A Power Query transformation is causing a previously foldable query to stop folding. What should the developer investigate first?

1. Whether the report theme changed
2. Whether a transformation that cannot be translated to the source was introduced
3. Whether the semantic model has a tooltip
4. Whether the workspace has a deployment pipeline

Correct Answer: 2

Explanation

When query folding stops, the developer should inspect the transformation steps to determine whether a newly introduced operation cannot be translated into a native operation supported by the source. Some Power Query transformations can prevent subsequent steps from being pushed back to the source. Identifying the step where folding breaks can help the developer redesign the transformation sequence or choose another operation. Report themes, tooltips, and deployment pipelines do not determine whether a Power Query transformation can fold to the source.

Question 206

Which DAX function is useful when a calculation should apply a table expression as a filter and return a table rather than a scalar value?

1. CALCULATETABLE
2. FORMAT
3. CONCATENATEX
4. COUNT

Correct Answer: 1

Explanation

CALCULATETABLE evaluates a table expression in a modified filter context and returns a table. It is useful when DAX logic needs to change filtering conditions and then produce a filtered or transformed table that can be consumed by another table expression. CALCULATE performs a similar filter-context modification but returns a scalar expression. FORMAT converts values to text, CONCATENATEX combines text values, and COUNT counts values. Therefore, CALCULATETABLE is the appropriate function when the required result of context modification is a table rather than a scalar.

Question 207

Which permission generally allows a user to build new reports or other analytical content using an existing Power BI semantic model?

1. Read
2. Build
3. Write
4. Owner

Correct Answer: 2

Explanation

Build permission allows users to create new reports, visualizations, or other analytical content based on an existing semantic model, subject to the model and workspace configuration. This permission is distinct from simply being able to view an existing report. Write permissions relate to modifying supported content or items, while Owner represents broader control over an item or resource. Read access alone does not generally provide the ability to build new content from a semantic model. Therefore, Build is the relevant permission for this analytical reuse scenario.

Question 208

In Kusto Query Language, which operator is primarily used to filter rows according to a Boolean condition?

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

Correct Answer: 3

Explanation

The where operator filters records in Kusto Query Language according to a specified Boolean condition. For example, a query can use where to return only events whose severity is equal to a particular value or timestamps fall within a selected period. The project operator selects or calculates columns, extend adds calculated columns, and summarize groups records and performs aggregations. Filtering early in a query can also reduce the amount of data processed by later operations. Therefore, where is the appropriate operator for row-level filtering in KQL.

Question 209

A semantic model contains multiple sales measures, and users want to analyze the model through different business perspectives without duplicating the underlying data. Which feature can organize model objects into user-oriented views?

1. Perspectives
2. Dataflows
3. Pipelines
4. Shortcuts

Correct Answer: 1

Explanation

Perspectives allow a semantic model to expose organized subsets of model objects for different analytical audiences. For example, finance users might work with financial measures and dimensions, while sales users might receive a view focused on customers, products, and sales metrics. Perspectives do not duplicate the underlying model data. Dataflows handle data preparation, pipelines provide orchestration, and shortcuts provide references to data stored elsewhere. Therefore, perspectives are appropriate when the goal is to organize the same semantic model into user-oriented analytical views.

Question 210

Which DAX function can transfer the values from one column or table expression into the filter context of another column?

1. ALL
2. TREATAS
3. IF
4. SUM

Correct Answer: 2

Explanation

TREATAS applies the values from a table expression as filters to one or more columns in the model. It is particularly useful when a direct relationship does not exist between tables but a calculation needs to use matching values as if a relationship were present for that calculation. ALL removes filters, IF evaluates a logical condition, and SUM performs aggregation. TREATAS can therefore support advanced filtering scenarios without requiring a permanent physical relationship between the participating tables.

Question 211

Which DAX function returns all values from a specified table or column while removing filters applied to it?

1. SELECTEDVALUE
2. ALL
3. RANKX
4. MEDIAN

Correct Answer: 2

Explanation

The ALL function removes filters from a specified table or column and returns the resulting values. It is frequently used in calculations such as percentages of totals, where the numerator should respect the current context while the denominator should represent a broader unfiltered population. SELECTEDVALUE retrieves a single selected value, RANKX calculates rankings, and MEDIAN returns the middle value of a set. Therefore, ALL is appropriate when a calculation needs to remove existing filters from a table or column.

Question 212

A data engineer needs to create a reusable Power Query transformation that can accept different input values each time it is called. Which feature is most appropriate?

1. Power Query function
2. Bookmark
3. Calculation group
4. Workspace role

Correct Answer: 1

Explanation

A Power Query custom function can encapsulate reusable transformation logic and accept parameters as inputs. This makes it useful when the same sequence of transformations needs to be applied to multiple datasets, files, or parameter values. Instead of duplicating transformation steps, the developer can define the logic once and invoke the function as needed. Bookmarks control report states, calculation groups manage reusable semantic calculations, and workspace roles control access. Therefore, a Power Query function is the appropriate feature for reusable parameterized transformation logic.

Question 213

Which DAX function is designed to return a table with added calculated columns based on an existing table expression?

1. ADDCOLUMNS
2. DISTINCTCOUNT
3. DIVIDE
4. HASONEVALUE

Correct Answer: 1

Explanation

ADDCOLUMNS evaluates an existing table expression and adds one or more calculated columns to the resulting table. Each added column can be based on a DAX expression evaluated in the relevant row context. This function is useful in advanced table calculations and when additional derived values are needed without modifying the physical model. DISTINCTCOUNT counts unique values, DIVIDE performs division, and HASONEVALUE checks whether one distinct value exists in the current context. Therefore, ADDCOLUMNS is the appropriate function for extending a table expression with calculated columns.

Question 214

Which DAX function can determine whether exactly one distinct value of a column exists in the current filter context?

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

Correct Answer: 3

Explanation

HASONEVALUE returns TRUE when the specified column has exactly one distinct value in the current filter context. It is useful when calculations need to behave differently depending on whether the report is filtered to a single category, customer, product, or other attribute. VALUES returns a table containing distinct values, ISBLANK checks whether an expression is blank, and SWITCH evaluates multiple conditions or values. Therefore, HASONEVALUE is the appropriate function for testing whether exactly one distinct value is present in the current context.

Question 215

Which Fabric warehouse object can encapsulate a reusable SQL query so users can query the resulting logical dataset without storing a separate copy of its rows?

1. View
2. Notebook
3. Dataflow
4. Eventstream

Correct Answer: 1

Explanation

A SQL view provides a reusable logical representation of a query in a warehouse. Instead of storing a separate copy of the query’s result rows as another physical table, the view stores the query definition and returns its results when queried. Views are useful for abstraction, simplifying repeated queries, and presenting controlled datasets to users. Notebooks support code-based data processing, Dataflows provide data transformation, and Eventstreams handle streaming scenarios. Therefore, a view is the appropriate warehouse object for encapsulating a reusable SQL query.

Question 216

A report author wants a DAX percentage-of-total calculation to respect the filters selected by the user but ignore only the visual’s row-level grouping. Which function can be useful for preserving relevant external selections?

1. ALL
2. ALLSELECTED
3. REMOVEFILTERS
4. DISTINCT

Correct Answer: 2

Explanation

ALLSELECTED can preserve filters coming from the broader user selection while removing certain more granular filters introduced by the current visual context. This makes it useful for calculations such as visual percentages of total, where the denominator should respect slicers and other external selections while comparing values across the visual’s categories. ALL and REMOVEFILTERS can remove broader filters, potentially producing a different total. DISTINCT returns unique values. Therefore, ALLSELECTED is useful when the calculation needs to retain relevant selections while changing the immediate visual context.

Question 217

Which Fabric lakehouse area is primarily intended for storing files that have not yet been represented as managed lakehouse tables?

1. Tables
2. Files
3. Measures
4. Perspectives

Correct Answer: 2

Explanation

The Files area of a Fabric lakehouse is intended for storing files in OneLake, including raw or staged data that has not been organized into managed lakehouse tables. Data engineers can use this area as part of ingestion and preparation workflows before transforming data into structured Delta tables in the Tables area. Measures and perspectives belong to semantic-model concepts rather than lakehouse storage areas. Therefore, Files is the appropriate area when the requirement is to store files before or instead of registering them as managed tables.

Question 218

Which DAX function can retrieve the current value of a column when a single value is available and otherwise return a specified alternate result?

1. SELECTEDVALUE
2. CALCULATETABLE
3. SUMMARIZE
4. FILTER

Correct Answer: 1

Explanation

SELECTEDVALUE returns the single value of a column when the current filter context contains exactly one distinct value. It can also accept an alternate result that is returned when there are zero or multiple values. This makes it useful for dynamic report titles, labels, and conditional calculations based on user selections. CALCULATETABLE returns a table under a modified filter context, SUMMARIZE creates a summarized table, and FILTER returns rows satisfying a condition. Therefore, SELECTEDVALUE is the appropriate function for this single-selection scenario.

Question 219

Which DAX function can create a summarized table by grouping data according to specified columns?

1. SUMMARIZE
2. DIVIDE
3. COALESCE
4. RELATED

Correct Answer: 1

Explanation

SUMMARIZE creates a summary table by grouping data according to specified columns and can include additional expressions. It is useful for advanced DAX table calculations where grouped results need to be generated dynamically. DIVIDE performs arithmetic division, COALESCE returns the first nonblank expression, and RELATED retrieves a value from a related table. SUMMARIZE should be used carefully in complex models because its behavior depends on filter and evaluation context. For creating a grouped summary table from existing model data, SUMMARIZE is the relevant function.

Question 220

A semantic model has an active relationship between Sales[OrderDate] and Date[Date]. The model also contains an inactive relationship between Sales[ShipDate] and Date[Date]. A measure must calculate results using ShipDate instead of OrderDate. Which approach should be used?

1. Remove the Date table
2. Activate the inactive relationship inside CALCULATE
3. Convert both relationships to bidirectional
4. Duplicate every Sales measure

Correct Answer: 2

Explanation

An inactive relationship can be temporarily activated for a calculation by using USERELATIONSHIP inside CALCULATE. In this scenario, the model can retain OrderDate as the active relationship while a specific measure evaluates sales according to ShipDate. This avoids unnecessary duplication of tables or measures and keeps the model structure manageable. Converting relationships to bidirectional filtering is not required and can introduce unwanted filter propagation. Therefore, activating the inactive ShipDate relationship within CALCULATE is the appropriate approach.