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

 

Question 241

Which semantic model storage mode is most appropriate when data should be imported into the model for fast in-memory analytical queries?

1. DirectQuery
2. Direct Lake
3. Import
4. Live connection

Correct Answer: 3

Explanation

Import mode loads data into the semantic model so that queries can primarily use the model’s in-memory analytical engine. This can provide fast report performance because the data is already available within the model rather than requiring a query to be sent to the source for every interaction. DirectQuery keeps data at the source, while Direct Lake is designed specifically for Fabric data stored in OneLake. Therefore, Import is the appropriate storage mode when the requirement is to load data into the semantic model for in-memory analysis.

Question 242

Which Kusto Query Language operator adds a calculated column to the result of a query without removing the existing columns?

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

Correct Answer: 1

Explanation

The extend operator creates calculated columns while retaining the existing columns in the query result. It is useful when analysts need to derive values from existing fields, such as calculating a duration, extracting information, or creating a classification. The project operator can select or calculate columns but controls the resulting column set, while summarize performs aggregation and where filters records. Therefore, extend is the appropriate KQL operator when a calculated column should be added while keeping the existing query columns available.

Question 243

A semantic model contains a large number of measures. Which feature can organize measures into logical folders to make them easier for report authors to find?

1. Perspectives
2. Display folders
3. Hierarchies
4. Data categories

Correct Answer: 2

Explanation

Display folders organize columns and measures into logical groups within the semantic model interface. They are especially useful in enterprise models containing many measures because report authors can locate related calculations more easily without changing the underlying model structure. Perspectives can expose selected model objects, hierarchies organize fields into navigable levels, and data categories provide semantic information about fields. Therefore, display folders are the appropriate feature when the goal is to organize numerous measures into logical groups for easier discovery.

Question 244

Which DAX function can return the first nonblank expression from a list of expressions?

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

Correct Answer: 2

Explanation

COALESCE evaluates multiple expressions and returns the first expression that is not BLANK. It is useful when a measure needs a fallback value or when several possible sources may contain a valid result. For example, a calculation could return a primary value when available and use a secondary value when the primary result is blank. SWITCH handles conditional branches, FILTER returns filtered rows, and ALL removes filters. Therefore, COALESCE is the appropriate function for selecting the first available nonblank result.

Question 245

Which Fabric capability can help identify and explore data assets available across an organization’s Fabric environment?

1. OneLake catalog
2. Performance Analyzer
3. Bookmark
4. Field parameter

Correct Answer: 1

Explanation

The OneLake catalog provides capabilities for discovering and exploring data assets across Microsoft Fabric. It helps users understand available data and supported items so they can locate information relevant to analytical workloads. Performance Analyzer focuses on report performance, bookmarks preserve report states, and field parameters allow users to switch fields or measures dynamically. Therefore, OneLake catalog is the appropriate capability when the objective is to discover and explore available Fabric data assets rather than analyze report execution or configure report interactions.

Question 246

Which DAX function removes filters from a specified table or column while evaluating a calculation?

1. VALUES
2. REMOVEFILTERS
3. SELECTEDVALUE
4. RANKX

Correct Answer: 2

Explanation

REMOVEFILTERS explicitly removes filters from specified tables or columns when used in a DAX calculation. It is commonly used inside CALCULATE when a measure needs to evaluate a result without certain filters affecting the calculation. For example, it can help calculate a total across all products while still preserving unrelated filters. VALUES returns distinct values, SELECTEDVALUE retrieves a single selected value, and RANKX calculates rankings. Therefore, REMOVEFILTERS is the appropriate function when specific existing filters need to be cleared.

Question 247

Which Power Query operation combines columns from two queries by matching values in one or more key columns?

1. Append Queries
2. Merge Queries
3. Group By
4. Fill Down

Correct Answer: 2

Explanation

Merge Queries combines information from two queries by matching values in selected columns, similar to a relational join. It is useful when one query contains transaction data and another contains descriptive information that needs to be added using a common key. Append Queries instead combines rows vertically from multiple queries. Group By creates aggregated results, while Fill Down propagates values into subsequent rows. Therefore, Merge Queries is the appropriate operation when columns from another query must be brought in using matching key values.

Question 248

A Fabric analyst wants to calculate the average of a row-level expression rather than simply averaging an existing column. Which DAX function should be used?

1. AVERAGE
2. AVERAGEX
3. SUM
4. COUNT

Correct Answer: 2

Explanation

AVERAGEX evaluates an expression for each row in a specified table and then calculates the average of the resulting values. This makes it useful when the value being averaged must first be calculated from one or more columns. AVERAGE operates directly on a column and is suitable when no row-level expression is required. SUM calculates totals, while COUNT counts values. Therefore, AVERAGEX is the appropriate function when an analytical calculation requires the average of derived row-level results.

Question 249

Which Power Query transformation removes duplicate records based on selected columns?

1. Remove Duplicates
2. Replace Values
3. Split Column
4. Transpose

Correct Answer: 1

Explanation

Remove Duplicates eliminates repeated rows according to the columns selected by the developer. This is useful for cleaning source data when duplicate records could distort counts, relationships, or analytical results. The columns selected determine how Power Query identifies records as duplicates. Replace Values changes matching values, Split Column separates one column into multiple columns, and Transpose changes rows into columns and columns into rows. Therefore, Remove Duplicates is the appropriate transformation when repeated records need to be eliminated from a query.

Question 250

Which DAX function can evaluate an expression for every row of a table and then return the sum of the resulting values?

1. SUMX
2. SUM
3. CALCULATE
4. VALUES

Correct Answer: 1

Explanation

SUMX is an iterator that evaluates an expression for each row of a table and then adds the resulting values together. It is particularly useful when the value being aggregated is calculated rather than directly stored in a single column. For example, SUMX can calculate quantity multiplied by unit price for each transaction and then add those results. SUM simply adds values from a column, while CALCULATE changes filter context and VALUES returns distinct values. Therefore, SUMX is appropriate for row-level calculated aggregation.

Question 251

Which Fabric feature allows a report visual to display additional information when a user hovers over a data point?

1. Drillthrough page
2. Tooltip
3. Bookmark
4. Perspective

Correct Answer: 2

Explanation

A tooltip provides additional contextual information when users hover over a data point in a report visual. Report authors can configure tooltip content to show supporting metrics or other relevant information without requiring users to navigate away from the current visual. Drillthrough navigates to another report page, bookmarks save specific report states, and perspectives organize semantic-model objects. Therefore, a tooltip is the appropriate feature when additional information should appear during a hover interaction while keeping the user on the same report view.

Question 252

Which DAX function can return the number of rows in a table expression?

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

Correct Answer: 1

Explanation

COUNTROWS returns the number of rows contained in a table or table expression. It is useful when the calculation needs to count records rather than count nonblank values in a particular column. COUNT operates on a column and counts nonblank values, while DISTINCTCOUNT counts unique values in a column. SUMX performs row-by-row expression evaluation and aggregation. Therefore, COUNTROWS is the appropriate DAX function when the requirement is to determine how many rows exist in a table expression.

Question 253

Which Fabric lakehouse table format provides transactional capabilities and supports features such as schema enforcement and versioned data?

1. CSV
2. Delta Lake
3. JSON
4. Parquet without Delta metadata

Correct Answer: 2

Explanation

Delta Lake provides transactional capabilities for lakehouse tables and supports features such as schema management and table versioning. Fabric lakehouses use Delta tables as a core structured storage format, enabling analytical workloads to work with reliable tabular data in OneLake. CSV and JSON are file formats rather than transactional table formats, while Parquet can store columnar data but does not by itself provide the complete Delta transaction layer. Therefore, Delta Lake is the appropriate choice for transactional lakehouse table storage.

Question 254

Which DAX function can return a table containing distinct values from a specified column?

1. VALUES
2. FORMAT
3. DIVIDE
4. IF

Correct Answer: 1

Explanation

VALUES can return a table containing the distinct values of a specified column within the current filter context. It is frequently used in advanced DAX calculations where a table of available values is required for iteration, filtering, or relationship-related logic. FORMAT converts values to text, DIVIDE performs division, and IF evaluates a logical condition. VALUES can also reflect the current filter context, making it useful when calculations need to work with the values currently visible to the evaluation context.

Question 255

Which Power Query transformation is useful for converting a column containing values such as “First Last” into separate First and Last columns?

1. Group By
2. Split Column
3. Merge Queries
4. Pivot Column

Correct Answer: 2

Explanation

Split Column can divide one column into multiple columns according to a delimiter, character position, or other supported rule. For example, a full-name column containing “First Last” can be split at the space character to create separate First and Last columns. Group By creates aggregations, Merge Queries combines information from related queries, and Pivot Column transforms values into columns. Therefore, Split Column is the appropriate Power Query transformation when one field needs to be divided into separate components.

Question 256

Which DAX function can calculate the number of unique values in a column?

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

Correct Answer: 2

Explanation

DISTINCTCOUNT returns the number of unique, nonblank values in a specified column. It is commonly used for metrics such as unique customers, distinct products, or individual transactions identified by unique keys. COUNT counts nonblank values regardless of duplication, COUNTROWS counts records in a table, and SUM adds numeric values. Therefore, DISTINCTCOUNT is the appropriate function when the requirement is to determine how many different values exist in a column rather than simply counting all populated entries.

Question 257

Which semantic-model object is designed to group related calculation logic so multiple measures can use reusable calculation items?

1. Calculation group
2. Display folder
3. Hierarchy
4. Perspective

Correct Answer: 1

Explanation

A calculation group organizes reusable calculation items that can modify or apply calculation logic across multiple measures. This can reduce duplication when implementing patterns such as time intelligence or other reusable analytical calculations. Display folders organize fields visually, hierarchies provide navigable levels, and perspectives expose selected model objects to users. Calculation groups therefore provide a modeling mechanism for centralizing reusable calculation behavior rather than creating separate versions of similar logic for every measure.

Question 258

Which DAX function can return the current date as a date value when a model calculation is evaluated?

1. TODAY
2. DATE
3. YEAR
4. MONTH

Correct Answer: 1

Explanation

TODAY returns the current date according to the environment in which the DAX expression is evaluated. It can be useful for calculations involving the current day, such as determining whether records are recent or calculating the age of dates relative to today. DATE constructs a date from individual components, while YEAR and MONTH extract specific components from a date value. Therefore, TODAY is the appropriate DAX function when a calculation needs the current date rather than a manually constructed or extracted date component.

Question 259

Which Power Query feature can help identify the percentage of valid, empty, and error values in a selected column during data preparation?

1. Column quality
2. Column distribution
3. Column profile
4. Query dependency

Correct Answer: 1

Explanation

Column quality provides an overview of the quality of values within a column, including categories such as valid, empty, and error values. This is useful during data preparation because it can quickly highlight columns that contain missing or problematic records. Column distribution focuses on value distribution and frequency, while column profile provides more detailed statistics for a selected column. Query dependency shows relationships among queries. Therefore, Column quality is the appropriate feature for quickly assessing valid, empty, and error values.

Question 260

Which DAX function can return the current year as a numeric value from a date expression?

1. MONTH
2. DAY
3. YEAR
4. DATE

Correct Answer: 3

Explanation

YEAR extracts the year component from a date expression and returns it as a numeric value. It is commonly used when calculations or classifications need to group dates by year or compare records against a particular year. MONTH returns the month number, DAY returns the day number, and DATE constructs a date from year, month, and day components. Therefore, YEAR is the appropriate DAX function when the requirement is to retrieve the year portion of an existing date value.