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

 

Question 141

Which Microsoft Fabric item is designed for storing and analyzing data using Kusto Query Language (KQL)?

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

Correct Answer: 1

Explanation

Eventhouse is a Microsoft Fabric item designed for real-time analytics and supports querying event and telemetry data with Kusto Query Language (KQL). It is well suited for high-volume, time-oriented data such as application telemetry, IoT events, and operational logs. A lakehouse supports both files and structured tables, notebooks provide code-based development, and Dataflow Gen2 focuses on data integration and transformation. Therefore, Eventhouse is the appropriate Fabric item when KQL-based analysis of real-time event data is required.

Question 142

Which DAX function can return the first non-blank expression from a list of expressions?

1. COALESCE
2. SUM
3. COUNTROWS
4. MAX

Correct Answer: 1

Explanation

COALESCE evaluates multiple expressions and returns the first expression that is not BLANK. It is useful when a measure needs to provide a fallback value when the preferred calculation produces a blank result. For example, a report can use COALESCE to display an alternative value when a primary measure has no result. SUM calculates totals, COUNTROWS counts rows, and MAX returns the largest value. Therefore, COALESCE is the appropriate DAX function when the first available nonblank result is required.

Question 143

A data model contains a Date dimension and a Sales fact table. Which relationship direction is generally preferred for a standard star schema?

1. Both directions for every relationship
2. Fact table to dimension only
3. Dimension to fact table
4. No filter direction

Correct Answer: 3

Explanation

In a standard star schema, filters generally flow from dimension tables toward fact tables. For example, selecting a year from the Date dimension should filter the related Sales fact rows. This creates predictable filtering behavior and helps avoid unnecessary ambiguity that can occur with excessive bidirectional relationships. Bidirectional filtering may be useful in specific scenarios but should not automatically be applied everywhere. Therefore, a dimension-to-fact filtering direction is generally preferred for a conventional star-schema semantic model.

Question 144

Which Power Query feature allows a transformation to use a parameterized value that can be changed without rewriting the query logic?

1. Query parameter
2. Bookmark
3. Calculation group
4. Report tooltip

Correct Answer: 1

Explanation

Power Query parameters allow values used by queries and transformations to be defined separately from the transformation logic. A parameter can represent information such as a server name, folder path, date boundary, or environment-specific setting. Changing the parameter can alter the query behavior without requiring the underlying transformation steps to be rewritten. Bookmarks, calculation groups, and tooltips serve reporting or semantic-model purposes rather than controlling Power Query input values. Therefore, a query parameter is the appropriate feature for this requirement.

Question 145

Which DAX function can return a value from the previous period when working with a properly configured date table?

1. DATE
2. PREVIOUSMONTH
3. FORMAT
4. DISTINCT

Correct Answer: 2

Explanation

PREVIOUSMONTH returns a table containing dates from the previous month in the current evaluation context and is commonly used in time-intelligence calculations. It can be combined with functions such as CALCULATE to create measures comparing current-period results with the previous month. DATE constructs a date, FORMAT changes the displayed representation of a value, and DISTINCT returns unique values. Therefore, PREVIOUSMONTH is the appropriate DAX function when a calculation needs to evaluate the previous month’s date context.

Question 146

Which Microsoft Fabric capability allows a report to consume a centrally managed model containing relationships and business measures?

1. Semantic model
2. Eventstream
3. Data pipeline
4. OneLake shortcut

Correct Answer: 1

Explanation

A semantic model provides a centralized analytical layer containing tables, relationships, measures, hierarchies, and other business logic. Reports can connect to the semantic model and use its standardized definitions rather than recreating calculations independently. Eventstream is intended for streaming data, data pipelines orchestrate data-processing activities, and OneLake shortcuts provide references to external data. Therefore, a semantic model is the appropriate Fabric capability when reports need to consume centrally managed analytical definitions.

Question 147

Which Power Query operation converts rows into columns based on values in a selected field?

1. Unpivot
2. Pivot Column
3. Merge Queries
4. Remove Duplicates

Correct Answer: 2

Explanation

Pivot Column transforms values from a selected column into separate columns, using another column to provide the values placed in those new columns. This is useful when source data is stored in a long format but the analytical requirement calls for a wider structure. Unpivot performs the opposite type of reshaping by converting columns into rows. Merge Queries combines related tables, while Remove Duplicates eliminates repeated records. Therefore, Pivot Column is the appropriate Power Query operation when values need to become separate columns.

Question 148

Which DAX function can return the rank of a value relative to other values in a specified context?

1. RANKX
2. SUMX
3. COUNTX
4. AVERAGEX

Correct Answer: 1

Explanation

RANKX evaluates an expression over a table and determines the relative rank of a value within that set. It is useful for scenarios such as ranking products by revenue, customers by sales, or employees by performance. SUMX calculates a sum of row-level expressions, COUNTX counts results from an expression, and AVERAGEX calculates an average. Therefore, RANKX is the appropriate DAX function when a report requires a ranking based on a measure or expression.

Question 149

A developer needs to inspect how filters affect a measure during evaluation. Which DAX function can return a table representing the values currently visible for a column?

1. VALUES
2. SUM
3. FORMAT
4. MAX

Correct Answer: 1

Explanation

VALUES can return the distinct values visible for a specified column under the current evaluation context. This makes it useful when developing DAX expressions that need to work with the values currently available after filters have been applied. It can also help create more advanced calculations involving the current context. SUM performs numerical aggregation, FORMAT changes display formatting, and MAX returns the highest value. Therefore, VALUES is the appropriate function when a calculation needs access to the distinct values currently represented in a column.

Question 150

Which Fabric capability can help identify whether a report or semantic model depends on another analytical item before that item is changed?

1. Lineage view
2. Slicer
3. Tooltip
4. DAX variable

Correct Answer: 1

Explanation

Lineage view displays dependencies between supported Fabric and Power BI items and can help identify upstream and downstream relationships. Before changing a semantic model, dataflow, or other analytical item, developers can review lineage to determine which reports or models may depend on it. This supports impact analysis and helps reduce unexpected effects from changes. Slicers filter data, tooltips provide contextual information, and DAX variables store intermediate expressions. Therefore, lineage view is the appropriate capability for dependency analysis before making changes.

Question 151

Which DAX function returns the day number from a date value?

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

Correct Answer: 3

Explanation

The DAY function returns the day-of-month component from a date value, producing an integer from 1 through 31 depending on the date. It can be useful when calculations or classifications require the numeric day component. YEAR extracts the year, MONTH returns the month number, and WEEKDAY returns a number representing the day of the week. Therefore, DAY is the correct DAX function when a calculation needs to retrieve the day portion of a date.

Question 152

A semantic model contains an inactive relationship between OrderDate and a Date table. Which DAX function can activate a specific inactive relationship for a calculation?

1. USERELATIONSHIP
2. DISTINCTCOUNT
3. CONCATENATE
4. FORMAT

Correct Answer: 1

Explanation

USERELATIONSHIP allows a DAX calculation to activate an existing inactive relationship for the duration of that calculation. This is particularly useful when a fact table contains multiple date columns, such as OrderDate and ShipDate, that connect to the same Date dimension. The model can keep one relationship active by default while calculations selectively use another relationship when needed. DISTINCTCOUNT counts unique values, CONCATENATE combines text, and FORMAT changes value representation. Therefore, USERELATIONSHIP is the appropriate function for this scenario.

Question 153

Which Microsoft Fabric capability can be used to monitor and investigate events generated by applications and other real-time sources?

1. Eventhouse
2. Report bookmark
3. Calculation group
4. Semantic model

Correct Answer: 1

Explanation

Eventhouse is designed for real-time analytical workloads involving event and telemetry data. It provides a suitable environment for storing and querying large volumes of continuously generated events and can support KQL-based analysis. This makes it useful for investigating application activity, operational events, and other real-time information. Bookmarks manage report states, calculation groups support reusable semantic calculations, and semantic models provide a business-oriented analytical layer. Therefore, Eventhouse is the appropriate choice for monitoring and investigating supported real-time event data.

Question 154

Which Power Query operation can remove rows where a required column contains blank or null values?

1. Remove Rows
2. Merge Queries
3. Pivot Column
4. Append Queries

Correct Answer: 1

Explanation

Power Query provides row-removal operations that can be used to exclude records containing blank, null, or otherwise unwanted values. Removing such rows can be useful when a required field must contain a valid value before data is loaded into the analytical model. Merge Queries combines related tables, Pivot Column reshapes data, and Append Queries combines rows from multiple tables. Therefore, a Remove Rows transformation is appropriate when records with missing required values need to be excluded during data preparation.

Question 155

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

1. CONCATENATEX
2. SUMX
3. COUNTROWS
4. MINX

Correct Answer: 1

Explanation

CONCATENATEX iterates over a table and concatenates the resulting text expressions into a single text value. It is useful for creating comma-separated lists or other dynamically generated textual summaries based on the current filter context. SUMX performs numerical summation over row-level expressions, COUNTROWS counts rows, and MINX returns the minimum result from an expression. Therefore, CONCATENATEX is the appropriate DAX function when text from multiple rows needs to be combined into one result.

Question 156

Which Microsoft Fabric feature can help an organization identify approved or trusted analytical content for broader consumption?

1. Endorsement
2. Eventstream
3. Notebook
4. Data pipeline

Correct Answer: 1

Explanation

Fabric and Power BI endorsement capabilities help organizations communicate that analytical content has been reviewed or is recommended for use. Depending on organizational governance practices, content can be promoted or certified to help users identify trusted resources. This can be especially valuable in environments containing many reports and semantic models created by different teams. Eventstream handles real-time events, notebooks support code-based processing, and data pipelines orchestrate workflows. Therefore, endorsement is the appropriate feature for communicating organizational trust in analytical content.

Question 157

Which DAX function can return a date shifted by a specified number of months?

1. EDATE
2. FORMAT
3. DISTINCT
4. COUNT

Correct Answer: 1

Explanation

EDATE returns a date that occurs a specified number of months before or after a starting date. It can be useful for calculations involving rolling periods, maturity dates, subscription periods, or other month-based date shifts. FORMAT changes the displayed representation of a value, DISTINCT returns unique values, and COUNT counts qualifying values. Therefore, EDATE is the appropriate DAX function when a calculation needs to shift a date by a specified number of months.

Question 158

A report contains several visuals, but a user should be able to return to a predefined filter and navigation state with one click. Which feature is suitable?

1. Bookmark
2. Dataflow
3. Row-level security
4. Object-level security

Correct Answer: 1

Explanation

Bookmarks capture a predefined state of a report, including supported filter, slicer, visibility, and navigation settings. They can be connected to buttons or other report elements so users can quickly return to a saved view. Dataflows prepare and transform data, row-level security restricts records according to user context, and object-level security controls access to model objects. Therefore, a bookmark is the appropriate feature when users need one-click access to a predefined report state.

Question 159

Which semantic-model technique can help prevent ambiguous filtering caused by unnecessary bidirectional relationships?

1. Prefer single-direction relationships where appropriate
2. Make every relationship bidirectional
3. Remove all dimension tables
4. Duplicate every measure

Correct Answer: 1

Explanation

Single-direction relationships can provide more predictable filter propagation and help reduce ambiguity in a semantic model. In a conventional star schema, filters generally flow from dimensions to fact tables, which creates a clear analytical path. Bidirectional relationships can be useful for specific requirements but should not be enabled indiscriminately because multiple filter paths can produce unexpected behavior or ambiguity. Removing dimensions would weaken the model, while duplicating measures does not address relationship behavior. Therefore, using single-direction relationships where appropriate is the preferred modeling technique.

Question 160

Which Microsoft Fabric feature allows a developer to use SQL queries directly against tables in a Warehouse?

1. SQL query editor
2. Report bookmark
3. Eventstream
4. Calculation group

Correct Answer: 1

Explanation

The SQL query editor provides an interface for writing and executing SQL queries against supported Fabric SQL resources, including Warehouse data. It is useful for developers and analysts who prefer SQL for inspecting tables, filtering records, joining data, and validating analytical results. Report bookmarks manage report states, Eventstream handles real-time event processing, and calculation groups provide reusable semantic calculations. Therefore, the SQL query editor is the appropriate feature when a developer needs to directly query Warehouse tables using SQL.