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

 

Question 61

Which Microsoft Fabric capability allows a lakehouse to reference data stored externally without physically copying the data into OneLake?

1. OneLake shortcut
2. Deployment pipeline
3. Semantic model
4. Calculation group

Correct Answer: 1

Explanation

OneLake shortcuts allow Fabric items to reference data from supported external locations without requiring a separate physical copy of the source data in OneLake. This can simplify data access and help reduce unnecessary duplication while allowing Fabric workloads to work with referenced data. Deployment pipelines manage content promotion, semantic models provide an analytical modeling layer, and calculation groups manage reusable calculation logic. Therefore, OneLake shortcuts are the appropriate capability when a lakehouse needs to access externally stored data without first copying it into OneLake.

Question 62

A data analyst needs to remove leading and trailing spaces from a text column before matching customer names. Which Power Query transformation should be used?

1. Fill Down
2. Trim
3. Pivot
4. Group By

Correct Answer: 2

Explanation

The Trim transformation removes unnecessary leading and trailing spaces from text values. This is useful when inconsistent whitespace can prevent values from matching correctly during joins, comparisons, or duplicate detection. For example, customer names containing accidental spaces may otherwise be treated as different values from correctly formatted names. Fill Down propagates values into empty rows, Pivot changes the structure of data, and Group By summarizes records. Therefore, Trim is the appropriate Power Query transformation for cleaning unwanted spaces around text values.

Question 63

Which DAX function can return the smallest numeric value from a column?

1. MIN
2. MAX
3. SUM
4. DISTINCTCOUNT

Correct Answer: 1

Explanation

The MIN DAX function returns the smallest numeric value in a column within the current evaluation context. It can be used for analytical calculations such as finding the lowest transaction value, minimum temperature, or earliest numeric measurement when the relevant data type is appropriate. MAX returns the highest value, SUM calculates a total, and DISTINCTCOUNT counts unique values. Therefore, MIN is the correct function when a calculation needs to identify the lowest value from a column while respecting the applicable filter context.

Question 64

A semantic model contains a very large fact table. Which modeling practice can help improve performance and reduce model size?

1. Add every available source column
2. Remove unnecessary columns
3. Create duplicate copies of every dimension
4. Use bidirectional relationships for all tables

Correct Answer: 2

Explanation

Removing unnecessary columns from a large fact table can reduce the amount of data stored in the semantic model and decrease processing requirements. Columns that are not used for filtering, grouping, relationships, calculations, or reporting generally provide little analytical value while increasing model size. Adding unnecessary columns has the opposite effect, and excessive duplicated dimensions or bidirectional relationships can increase model complexity. Therefore, reducing the fact table to only the required fields is a practical semantic-model optimization technique.

Question 65

Which Microsoft Fabric experience is primarily intended for creating interactive analytical reports and visualizations?

1. Power BI
2. Eventstream
3. Data pipeline
4. Notebook

Correct Answer: 1

Explanation

Power BI within Microsoft Fabric provides the reporting and visualization capabilities used to create interactive analytical reports. Report authors can build visuals, apply filters, configure interactions, and present insights based on semantic models and other supported data sources. Eventstream focuses on real-time event processing, data pipelines orchestrate data workflows, and notebooks provide code-based development and analysis. Therefore, Power BI is the Fabric experience primarily intended for interactive reporting and visualization.

Question 66

A developer wants a DAX calculation to evaluate an expression for every row of a table and then aggregate the results. Which type of function is appropriate?

1. Iterator function
2. Text function
3. Date formatting function
4. Metadata function

Correct Answer: 1

Explanation

Iterator functions in DAX evaluate an expression separately for each row of a specified table and then perform an aggregation or return a table result depending on the function. Examples include SUMX, AVERAGEX, and COUNTX. They are useful when the calculation cannot be expressed simply as an aggregation of a single existing column. Text and date-formatting functions serve different purposes, while metadata functions provide information about model objects or context. Therefore, an iterator function is appropriate when row-by-row expression evaluation is required before aggregation.

Question 67

Which Microsoft Fabric feature provides a centralized place to discover real-time events and streaming data available to users?

1. Real-Time hub
2. Workspace settings
3. Calculation group
4. Report bookmark

Correct Answer: 1

Explanation

The Real-Time hub provides a centralized discovery experience for real-time data, events, streams, and related resources in Microsoft Fabric. It helps users locate available streaming information and connect it to supported real-time analytics workflows. Workspace settings control configuration and permissions, calculation groups provide reusable semantic-model calculations, and bookmarks store report states. Therefore, Real-Time hub is the appropriate Fabric capability when users need to discover and work with available real-time event sources.

Question 68

Which Power Query operation can replace a specific text value with another value throughout a selected column?

1. Replace Values
2. Append Queries
3. Unpivot Columns
4. Transpose

Correct Answer: 1

Explanation

Replace Values allows a Power Query user to substitute one value with another within a selected column. It is useful for correcting inconsistent labels, standardizing categories, replacing known errors, or cleaning source-system values before loading data into an analytical model. Append Queries combines rows from different tables, Unpivot Columns changes columns into attribute-value rows, and Transpose changes rows into columns and vice versa. Therefore, Replace Values is the appropriate transformation when a particular text value needs to be substituted throughout a column.

Question 69

A company wants report users to see only the sales records associated with their own region. Which semantic-model security technique should be implemented?

1. Object-level security
2. Row-level security
3. Workspace deletion
4. Sensitivity labeling

Correct Answer: 2

Explanation

Row-level security restricts the records visible to users according to defined filtering rules. For example, a regional sales manager can be mapped to a region and a security rule can limit the manager’s queries to sales rows associated with that region. Object-level security is intended to restrict access to model objects such as tables or columns rather than individual records. Workspace deletion and sensitivity labels do not provide row-based filtering. Therefore, row-level security is the appropriate technique for limiting users to their own regional sales data.

Question 70

Which Power BI feature allows users to navigate from a summary visual to a dedicated detailed page filtered by the selected data point?

1. Drillthrough
2. Slicer
3. Bookmark
4. Tooltip

Correct Answer: 1

Explanation

Drillthrough allows users to navigate from a summary report page to a dedicated detail page while passing the selected context to that page. For example, selecting a particular customer in a sales summary can open a customer-detail page filtered for that customer. Slicers provide interactive filtering, bookmarks save report states, and tooltips display additional information during hover interactions. Therefore, Drillthrough is the appropriate feature when a report needs dedicated detailed pages based on a selected data point.

Question 71

Which Microsoft Fabric component is designed to ingest and transform data using a low-code Power Query experience?

1. Dataflow Gen2
2. Warehouse
3. Eventhouse
4. Semantic model

Correct Answer: 1

Explanation

Dataflow Gen2 provides a low-code data integration and transformation experience based on Power Query. It can connect to supported data sources, perform transformations, and write results to supported Fabric destinations. This makes it useful for recurring data preparation workflows without requiring users to write extensive programming code. A Warehouse stores structured analytical data, an Eventhouse is designed for real-time analytics, and a semantic model provides the business-facing analytical layer. Therefore, Dataflow Gen2 is the appropriate component for Power Query-based ingestion and transformation.

Question 72

Which DAX function can return a table containing the unique values from a column?

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

Correct Answer: 1

Explanation

The VALUES function can return a one-column table containing the distinct values from a specified column within the current evaluation context. It is frequently used in DAX expressions where a calculation needs to operate over the unique members of a column. SUM aggregates numeric values, AVERAGE calculates a mean, and MAX returns the largest value. Therefore, VALUES is the appropriate DAX function when a table of distinct column values is required for further calculation or filtering logic.

Question 73

A data model contains a Customer dimension and Sales fact table. Which table should normally contain the unique CustomerKey values used to establish the relationship?

1. Sales fact table
2. Customer dimension
3. Report page
4. Calculation group

Correct Answer: 2

Explanation

The Customer dimension should normally contain one unique row for each CustomerKey. The Sales fact table can then contain multiple transactions associated with the same CustomerKey. This creates the common one-to-many relationship between a dimension and fact table. Keeping unique business entities in dimension tables supports predictable filtering and aggregation and is a fundamental principle of dimensional modeling. The report page and calculation group are unrelated to relationship keys. Therefore, the Customer dimension should contain the unique CustomerKey values used as the relationship’s one-side key.

Question 74

Which Microsoft Fabric capability can help identify downstream items that depend on a semantic model before the model is modified?

1. Lineage view
2. Slicer
3. Data type conversion
4. Conditional formatting

Correct Answer: 1

Explanation

Lineage view helps users understand dependencies between supported Fabric and Power BI items. Before modifying a semantic model, developers can review downstream assets such as reports and other dependent content to understand what may be affected by the change. This supports safer development and impact assessment. Slicers filter report data, data type conversion is a preparation operation, and conditional formatting changes how report values are displayed. Therefore, lineage view is the appropriate capability for examining downstream dependencies before changing a semantic model.

Question 75

Which DAX function is commonly used to evaluate a measure after applying a specified filter or modifying the existing filter context?

1. CALCULATE
2. CONCATENATE
3. FORMAT
4. LEFT

Correct Answer: 1

Explanation

CALCULATE evaluates an expression after modifying the existing filter context. It is central to advanced DAX because it allows measures to respond to specific filtering requirements, such as calculating sales for a particular category, removing a filter, or evaluating a result over a different time period. CONCATENATE combines text values, FORMAT changes the displayed representation of a value, and LEFT returns characters from the beginning of a text string. Therefore, CALCULATE is the appropriate function for changing filter context during a DAX calculation.

Question 76

A Fabric team wants to use a single reusable analytical definition that can serve multiple reports and maintain centralized business logic. What should they create?

1. Semantic model
2. Report bookmark
3. Power Query parameter
4. Data pipeline trigger

Correct Answer: 1

Explanation

A semantic model provides a centralized analytical layer containing tables, relationships, measures, calculations, and other business logic that can be consumed by multiple reports. Using a shared semantic model helps maintain consistent definitions for metrics and reduces the need to recreate the same calculations independently in different reports. Bookmarks control report states, Power Query parameters help configure data transformations, and pipeline triggers control workflow execution. Therefore, a semantic model is the appropriate reusable analytical definition for serving multiple reports.

Question 77

Which Power Query transformation converts columns containing attribute values into rows, creating an attribute-value structure?

1. Merge
2. Append
3. Unpivot
4. Aggregate

Correct Answer: 3

Explanation

Unpivot converts multiple columns into rows, usually producing an attribute column and a corresponding value column. This is useful when source data is organized in a wide format but the analytical model requires a normalized attribute-value structure. For example, separate columns for January, February, and March can be transformed into rows containing Month and Amount. Merge combines tables based on keys, Append combines rows from separate tables, and Aggregate summarizes data. Therefore, Unpivot is the correct transformation for converting columns into attribute-value rows.

Question 78

Which feature allows a Power BI report to display a visual showing the same measure across different selected dimensions without manually creating separate visuals?

1. Field parameters
2. Row-level security
3. Dataflow Gen2
4. Incremental refresh

Correct Answer: 1

Explanation

Field parameters allow report users to dynamically switch fields or measures used by a visual. A report author can configure a parameter containing multiple dimensions or measures, allowing users to choose what the visual analyzes without requiring separate visuals for every possible selection. Row-level security controls data visibility, Dataflow Gen2 handles data preparation, and incremental refresh controls how model data is refreshed. Therefore, field parameters are the appropriate feature for creating flexible visuals that dynamically switch analytical fields or measures.

Question 79

Which Microsoft Fabric item is optimized for querying and analyzing high-volume event and telemetry data using KQL?

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

Correct Answer: 1

Explanation

Eventhouse is designed for real-time analytics scenarios involving large volumes of event, telemetry, and time-oriented data. It integrates with Kusto Query Language (KQL), making it suitable for analyzing continuously generated information such as application telemetry, operational events, and IoT data. A Warehouse is optimized for structured relational analytics, a Lakehouse combines data-lake and analytical capabilities, and Dataflow Gen2 focuses on data ingestion and transformation. Therefore, Eventhouse is the appropriate Fabric item for high-volume event and telemetry analytics using KQL.

Question 80

A report developer wants to display a metric with different colors or visual indicators depending on whether values meet defined thresholds. Which Power BI feature can be used?

1. Conditional formatting
2. Dataflow refresh
3. Deployment pipeline
4. Relationship filtering

Correct Answer: 1

Explanation

Conditional formatting allows report authors to change the appearance of supported visuals based on data values or defined rules. For example, values above a target can be displayed differently from values below the target, making important trends and exceptions easier to identify. Dataflow refresh manages data-processing schedules, deployment pipelines manage content movement, and relationship filtering controls how model filters propagate. Therefore, conditional formatting is the appropriate Power BI feature when visual indicators need to change according to defined numerical thresholds.