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

 

Question 321

Which DAX function can return the first expression that is not blank from multiple expressions?

1. FILTER
2. SWITCH
3. COALESCE
4. ALL

Correct Answer: 3

Explanation

COALESCE evaluates multiple expressions and returns the first one that is not BLANK. It is useful when a calculation has a preferred result but needs one or more fallback values if the preferred expression is blank. For example, a measure can return a primary value and then use an alternative calculation when the first result is unavailable. FILTER returns a filtered table, SWITCH evaluates conditions or matching values, and ALL removes filters. Therefore, COALESCE is the appropriate DAX function for selecting the first available nonblank result.

Question 322

Which Fabric feature allows a user to analyze a semantic model from Excel or another external analytical experience without creating a separate copy of the model data?

1. Build permission
2. OneLake shortcut
3. Eventstream
4. Dataflow Gen2

Correct Answer: 1

Explanation

Build permission allows users to create new content based on an existing semantic model, including supported external analytical scenarios such as analyzing data through Excel. The permission provides the ability to reuse the model rather than requiring users to duplicate its underlying data. OneLake shortcuts provide references to data, Eventstream handles streaming workloads, and Dataflow Gen2 performs data preparation. Therefore, Build permission is the relevant permission when users need to consume a semantic model as a source for additional analytical work.

Question 323

Which Kusto Query Language operator groups records and can calculate multiple aggregations within each group?

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

Correct Answer: 2

Explanation

The summarize operator groups records according to one or more expressions and can calculate aggregations such as count, sum, average, minimum, and maximum for each group. For example, a KQL query can group application events by application name while calculating both the number of events and their average duration. Project controls returned columns, where filters records, and extend creates calculated columns. Therefore, summarize is the appropriate KQL operator when grouped analytical results require one or more aggregations.

Question 324

Which semantic-model feature allows a field to be organized inside a named folder without changing its underlying data or calculation?

1. Display folder
2. Data category
3. Relationship
4. Calculation group

Correct Answer: 1

Explanation

Display folders organize measures and columns into named groups within the semantic-model interface. They are especially useful in large models where many calculations or fields need to be arranged logically for report authors. A display folder does not alter the field’s underlying values or calculation logic. Data categories provide semantic metadata, relationships define connections between tables, and calculation groups provide reusable calculation items. Therefore, Display folder is the appropriate feature when the objective is simply to improve the organization and discoverability of model fields.

Question 325

A report contains a measure that should calculate sales only for products belonging to the “Accessories” category while retaining other relevant report filters. Which DAX function is commonly used to create this calculation?

1. VALUES
2. CALCULATE
3. DISTINCT
4. COUNTROWS

Correct Answer: 2

Explanation

CALCULATE is commonly used to modify filter context for a measure. It can apply a filter such as Product Category equal to Accessories while retaining other applicable filters unless they are explicitly changed. This makes CALCULATE fundamental for creating filtered business measures. VALUES returns a table of distinct values, DISTINCT produces unique values, and COUNTROWS counts rows in a table expression. Therefore, CALCULATE is the appropriate DAX function when a measure needs to evaluate sales under an additional category-specific filter.

Question 326

Which Power Query transformation is appropriate for replacing errors with a specified value rather than removing the affected rows?

1. Remove Errors
2. Replace Errors
3. Remove Duplicates
4. Filter Rows

Correct Answer: 2

Explanation

Replace Errors substitutes error values with a value specified by the developer. This is useful when an error should be converted into a meaningful default or corrected representation rather than causing the entire record to be removed. Remove Errors takes the opposite approach by deleting rows containing errors. Remove Duplicates handles repeated records, while Filter Rows restricts the result based on conditions. Therefore, Replace Errors is the appropriate transformation when erroneous values need to be replaced while preserving the affected rows.

Question 327

Which Fabric item is most appropriate for storing relational data and supporting T-SQL-based analytical queries in a warehouse-style environment?

1. Eventhouse
2. Lakehouse
3. Warehouse
4. Notebook

Correct Answer: 3

Explanation

Fabric Warehouse is designed for relational analytical workloads and provides a SQL-centric environment based on T-SQL. It is suitable for structured data, relational objects, and analytical queries where users expect traditional warehouse capabilities. Eventhouse is optimized for event and real-time analytics, while Lakehouse provides data-lake-oriented storage and analytical capabilities. Notebooks provide code-based development rather than a relational warehouse environment. Therefore, Warehouse is the appropriate Fabric item when T-SQL-based relational analytics is the primary requirement.

Question 328

Which DAX function can remove filters from a calculation while preserving filters coming from other columns that are not specified?

1. REMOVEFILTERS
2. FORMAT
3. CONCATENATEX
4. MEDIAN

Correct Answer: 1

Explanation

REMOVEFILTERS clears filters from the specified table or columns while leaving other filter context unaffected unless those areas are also explicitly modified. It is useful when a measure needs to ignore a particular dimension but continue respecting selections from other dimensions. FORMAT changes value representation, CONCATENATEX combines text values, and MEDIAN calculates a middle value. Therefore, REMOVEFILTERS is appropriate when a DAX calculation needs precise control over which filters are removed without broadly clearing the entire evaluation context.

Question 329

Which Power Query transformation can aggregate records by one or more columns and calculate results such as Sum, Count, or Average?

1. Group By
2. Split Column
3. Replace Values
4. Unpivot Columns

Correct Answer: 1

Explanation

Group By creates aggregated results based on one or more selected columns. It can calculate operations such as Sum, Count Rows, Average, Minimum, and Maximum for groups of records. For example, sales transactions can be grouped by region to calculate total revenue for each region. Split Column separates values into multiple fields, Replace Values substitutes matching values, and Unpivot Columns converts columns into rows. Therefore, Group By is the appropriate Power Query transformation when records need to be summarized by one or more grouping fields.

Question 330

Which DAX function can return the current filter-context value when exactly one value is selected, with an optional alternate result?

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

Correct Answer: 3

Explanation

SELECTEDVALUE returns a scalar value when exactly one distinct value is present in the current filter context. It also allows an alternate result to be specified when multiple or no values are selected. This makes it useful for dynamic titles, labels, and calculations based on user selections. HASONEVALUE only tests whether one distinct value exists, VALUES returns a table, and FILTER returns rows that satisfy a condition. Therefore, SELECTEDVALUE is the appropriate function when the actual selected scalar value is required.

Question 331

Which Fabric capability provides a centralized location for discovering data assets, understanding their properties, and locating relevant analytical content?

1. OneLake catalog
2. Deployment pipeline
3. Performance Analyzer
4. Bookmark

Correct Answer: 1

Explanation

The OneLake catalog helps users discover and explore data assets across Microsoft Fabric. It provides a centralized experience for finding relevant items and understanding available data resources, supporting data discovery and governance workflows. Deployment pipelines are used for lifecycle management, Performance Analyzer investigates report performance, and bookmarks preserve report states. Therefore, OneLake catalog is the appropriate Fabric capability when users need to locate and explore available data assets rather than manage deployment or report interactions.

Question 332

Which DAX function evaluates a condition and returns one result when true and another when false?

1. IF
2. MAXX
3. VALUES
4. DISTINCTCOUNT

Correct Answer: 1

Explanation

IF evaluates a logical condition and returns one expression when the condition evaluates to TRUE and another expression when it evaluates to FALSE. It is commonly used for conditional classifications, thresholds, flags, and business rules. MAXX evaluates expressions across rows, VALUES returns distinct values, and DISTINCTCOUNT counts unique values. IF is especially useful when a calculation has two possible outcomes. Therefore, IF is the appropriate DAX function when a calculation needs to return different results according to a Boolean condition.

Question 333

Which KQL operator is used to restrict the columns returned by a query while optionally creating calculated expressions?

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

Correct Answer: 2

Explanation

The project operator controls which columns are returned by a Kusto Query Language query. It can also rename columns or create calculated expressions as part of the resulting projection. This makes project useful for producing a focused query result containing only the fields needed for analysis. Where filters records, count calculates the number of records, and summarize performs grouped aggregation. Therefore, project is the appropriate KQL operator when the query should control the columns included in its final output.

Question 334

Which semantic-model relationship direction is generally preferred in a standard star schema to provide predictable filtering?

1. Both directions for every relationship
2. From fact tables to dimensions only
3. From dimensions toward fact tables
4. No filter direction

Correct Answer: 3

Explanation

In a standard star schema, filtering generally flows from dimension tables toward fact tables. For example, selecting a product category in a Product dimension can filter the related rows in a Sales fact table. This design provides predictable filter propagation and helps avoid unnecessary ambiguity. Bidirectional relationships can be useful in specific modeling scenarios but should not be enabled indiscriminately. Therefore, dimension-to-fact filtering is the commonly preferred direction for relationships in a well-designed star schema.

Question 335

Which Power Query feature allows a developer to inspect the sequence of transformations that have been applied to a query?

1. Applied Steps
2. Column Quality
3. Data Category
4. Lineage View

Correct Answer: 1

Explanation

Applied Steps displays the sequence of transformation operations performed on a Power Query query. Each step represents a stage in the query’s transformation process, allowing developers to review, modify, reorder, or remove transformations where appropriate. Column Quality provides information about valid, empty, and error values, Data Category belongs to semantic modeling, and Lineage View shows dependencies among analytical assets. Therefore, Applied Steps is the appropriate feature for reviewing the transformation sequence applied within a Power Query query.

Question 336

Which DAX function can rank a value against other values in a table according to an expression?

1. RANKX
2. RANK
3. ORDERBY
4. TOPVALUE

Correct Answer: 1

Explanation

RANKX evaluates an expression across a table and determines the rank of a value relative to the other evaluated values. It is useful for creating rankings such as top customers by revenue, products by sales, or regions by performance. The function supports different ordering options and can be combined with filter context to produce context-sensitive rankings. The other listed names do not provide the same standard DAX functionality. Therefore, RANKX is the appropriate DAX function for ranking values based on an expression.

Question 337

Which Fabric development feature is intended to maintain a history of supported workspace item changes through a connected Git repository?

1. Deployment pipeline
2. Git integration
3. Eventstream
4. SQL analytics endpoint

Correct Answer: 2

Explanation

Git integration allows supported Fabric workspace items to synchronize with a Git repository, enabling source-control workflows and change tracking. Developers can work with repository-based versions of supported items and synchronize changes between the workspace and source control. Deployment pipelines address lifecycle promotion between environments, Eventstream handles streaming data, and SQL analytics endpoints provide SQL access to structured lakehouse data. Therefore, Git integration is the appropriate feature when source-control history and repository synchronization are required.

Question 338

Which DAX function can count the number of nonblank values in a numeric column?

1. COUNT
2. COUNTROWS
3. DISTINCTCOUNT
4. SUM

Correct Answer: 1

Explanation

COUNT counts nonblank values in a column and is useful when the requirement is to determine how many populated numeric or date entries exist. It does not remove duplicates from the count. COUNTROWS counts rows in a table, DISTINCTCOUNT counts unique values, and SUM calculates a numeric total. Therefore, COUNT is the appropriate DAX function when the requirement is specifically to count nonblank values in a column, regardless of whether some values are repeated.

Question 339

Which Fabric lakehouse feature allows users to reference supported external data without creating another physical copy of that data?

1. OneLake shortcut
2. Warehouse view
3. Calculation group
4. Field parameter

Correct Answer: 1

Explanation

A OneLake shortcut provides a logical reference to supported data stored elsewhere without requiring a separate physical copy in the destination location. This can help organizations reduce duplication and maintain centralized data while still making it accessible to Fabric workloads. A warehouse view represents reusable SQL logic, a calculation group manages reusable semantic calculations, and a field parameter controls dynamic report fields or measures. Therefore, OneLake shortcut is the appropriate feature when external data should be accessed without duplicating its underlying storage.

Question 340

Which DAX function can evaluate an expression for each row and return the highest resulting value?

1. MAX
2. MAXX
3. SUMX
4. AVERAGEX

Correct Answer: 2

Explanation

MAXX is an iterator that evaluates an expression for each row in a specified table and returns the largest resulting value. It is useful when the maximum cannot be obtained directly from a column because the value must first be calculated. For example, MAXX can evaluate Quantity multiplied by Unit Price for each transaction and return the largest calculated transaction value. MAX works directly on a column, SUMX calculates a total, and AVERAGEX calculates an average. Therefore, MAXX is the appropriate function for row-level maximum calculations.