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

 

Question 121

Which Microsoft Fabric item is designed to combine data lake capabilities with structured table management for analytics?

1. Dashboard
2. Lakehouse
3. Scorecard
4. Deployment pipeline

Correct Answer: 2

Explanation

A Microsoft Fabric lakehouse combines data lake storage capabilities with structured table management for analytical workloads. It can store files and tables in OneLake and can be accessed through Spark-based experiences and a SQL analytics endpoint. This makes the lakehouse suitable for organizations that need flexible storage alongside structured analytical processing. Dashboards and scorecards focus on presenting information, while deployment pipelines manage supported content across lifecycle stages. Therefore, a lakehouse is the appropriate Fabric item when both data-lake flexibility and structured analytics are required.

Question 122

Which DAX function returns 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 in a table or table expression. It is particularly useful when the calculation needs to count records rather than values within a specific column. For example, a measure can use COUNTROWS to determine how many orders remain after the current report filters are applied. COUNT counts qualifying values in a column, DISTINCTCOUNT counts unique values, and SUMX performs row-level expression evaluation followed by summation. Therefore, COUNTROWS is the correct DAX function for counting rows in a table expression.

Question 123

A Power BI developer wants to let users switch a visual between Sales, Profit, and Quantity without creating separate visuals. Which feature should be used?

1. Bookmarks
2. Field parameters
3. Drillthrough
4. Tooltips

Correct Answer: 2

Explanation

Field parameters allow report users to dynamically switch the fields or measures used by a visual. A developer can configure a parameter containing Sales, Profit, and Quantity, allowing users to select which metric the visual displays. This provides flexibility while avoiding multiple duplicate visuals. Bookmarks save predefined report states, drillthrough navigates to detail pages, and tooltips provide contextual information during hover interactions. Therefore, field parameters are the appropriate feature for allowing users to dynamically switch between multiple measures in a visual.

Question 124

Which Microsoft Fabric component is optimized for storing structured data in tables and querying it with SQL for analytical workloads?

1. Eventstream
2. Notebook
3. Warehouse
4. Dataflow Gen2

Correct Answer: 3

Explanation

A Microsoft Fabric Warehouse is designed for structured analytical data and provides SQL-based querying capabilities. It is suitable for workloads that require relational tables, analytical queries, and warehouse-style data organization. Eventstream handles streaming events, notebooks provide interactive code-based processing, and Dataflow Gen2 supports data ingestion and transformation. Therefore, a Warehouse is the appropriate Fabric component when an organization needs structured analytical storage with SQL querying capabilities.

Question 125

Which Power Query operation can combine columns from two related tables by matching a common key?

1. Merge Queries
2. Append Queries
3. Fill Down
4. Unpivot Columns

Correct Answer: 1

Explanation

Merge Queries combines data from two tables by matching values in one or more selected columns. For example, a Sales table can be merged with a Customer table using CustomerID to bring customer attributes into the sales dataset. Append Queries instead combines rows from tables with compatible structures. Fill Down propagates values into blank cells, while Unpivot Columns reshapes data from a wide structure into an attribute-value format. Therefore, Merge Queries is the appropriate Power Query operation when related tables need to be combined using a common key.

Question 126

Which DAX function is useful when a measure needs to calculate a value after changing the current filter context?

1. SUM
2. CALCULATE
3. MIN
4. DISTINCT

Correct Answer: 2

Explanation

CALCULATE evaluates an expression after modifying the current filter context. It is one of the most important DAX functions for creating analytical measures because it can apply additional filters, remove existing filters, or alter how the expression is evaluated. SUM performs straightforward aggregation, MIN returns a minimum value, and DISTINCT returns unique values. Therefore, CALCULATE is the appropriate function when a measure must evaluate a calculation under a changed or specifically controlled filter context.

Question 127

A semantic model contains sensitive salary information that should be hidden from certain users while other model objects remain accessible. Which capability should be considered?

1. Incremental refresh
2. Object-level security
3. Field parameters
4. Conditional formatting

Correct Answer: 2

Explanation

Object-level security can restrict access to specific tables or columns within a semantic model. This makes it appropriate when sensitive salary information needs to be hidden from certain users while those users can continue accessing other approved model content. Incremental refresh controls how data is refreshed, field parameters provide dynamic field selection, and conditional formatting affects visual appearance. Therefore, object-level security should be considered when access to sensitive model objects must be restricted independently of broader report access.

Question 128

Which Microsoft Fabric feature provides a visual map of relationships between data sources, semantic models, reports, and other supported analytical items?

1. Lineage view
2. Slicer
3. Dataflow parameter
4. DAX measure

Correct Answer: 1

Explanation

Lineage view provides a visual representation of dependencies among supported Fabric and Power BI items. It can help users understand where data originates, how it moves through data preparation and modeling stages, and which downstream reports depend on a particular item. This is valuable for impact analysis, troubleshooting, and governance. Slicers filter report content, dataflow parameters configure transformations, and DAX measures perform calculations. Therefore, lineage view is the appropriate feature when a visual representation of analytical dependencies is required.

Question 129

Which DAX function returns the smallest value from a column under the current filter context?

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

Correct Answer: 3

Explanation

The MIN function returns the smallest value in a column according to the current evaluation context. Because DAX calculations respond to filters, the result can change based on selections made in reports. For example, a minimum sales measure may return different results when users filter by region or product category. MAX returns the largest value, SUM calculates a total, and COUNTROWS counts rows. Therefore, MIN is the appropriate DAX function when a calculation needs to identify the lowest value within the active context.

Question 130

A report author needs a page that automatically filters to the customer selected on another report page. Which feature should be configured?

1. Drillthrough
2. Conditional formatting
3. Data category
4. Calculation group

Correct Answer: 1

Explanation

Drillthrough allows users to navigate from one report page to another while carrying the selected data context to the destination page. A report author can configure a customer field as a drillthrough filter and create a dedicated customer-detail page. When a user selects a customer and invokes drillthrough, the destination page is filtered for that customer. Conditional formatting changes visual appearance, data categories provide metadata, and calculation groups manage reusable calculations. Therefore, Drillthrough is the appropriate feature for this navigation scenario.

Question 131

Which Microsoft Fabric capability can reference an external storage location from a lakehouse without requiring a separate physical copy of the referenced data?

1. OneLake shortcut
2. Semantic model
3. Report bookmark
4. Workspace role

Correct Answer: 1

Explanation

OneLake shortcuts provide references to supported external data locations without requiring the data to be physically copied into the Fabric storage location. This can simplify data integration and reduce unnecessary duplication while allowing Fabric workloads to access the referenced data. Semantic models provide an analytical layer, bookmarks save report states, and workspace roles manage permissions. Therefore, a OneLake shortcut is the appropriate capability when external data needs to be accessed from Fabric without creating another physical copy.

Question 132

Which DAX function can calculate a distinct count of customers based on the current report context?

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

Correct Answer: 2

Explanation

DISTINCTCOUNT counts unique values in a column within the current evaluation context. When applied to a CustomerID column, it can provide the number of distinct customers represented by the current filters. This is different from COUNTROWS, which counts records and may count multiple transactions for the same customer. SUMX performs row-by-row expression evaluation, while AVERAGE calculates a mean. Therefore, DISTINCTCOUNT is the appropriate DAX function when a report needs to display the number of unique customers.

Question 133

Which Fabric capability is intended for ingesting and processing continuous streams of event data?

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

Correct Answer: 1

Explanation

Eventstream is designed for real-time event ingestion, transformation, and routing within Microsoft Fabric. It can work with supported streaming sources and direct event data toward appropriate destinations for further processing or analysis. Dataflow Gen2 is generally used for data integration and transformation workflows, while warehouses and semantic models are primarily associated with structured analytical workloads. Therefore, Eventstream is the appropriate Fabric capability when continuous event data needs to be ingested and processed in real time.

Question 134

A Power BI report needs to show the percentage contribution of each product to the total sales amount. Which DAX approach is appropriate?

1. Create a measure that compares current sales with a filter-adjusted total
2. Convert the sales column to text
3. Create a separate workspace for each product
4. Use a report bookmark

Correct Answer: 1

Explanation

A percentage-of-total calculation generally requires a DAX measure that compares the current product’s sales with an appropriate total while controlling the filter context. Functions such as CALCULATE and REMOVEFILTERS can be used to evaluate the overall total while preserving relevant filters such as date or region. Converting sales to text prevents numerical calculations, separate workspaces do not address the calculation, and bookmarks only save report states. Therefore, a filter-aware DAX measure is the appropriate approach for calculating each product’s percentage contribution.

Question 135

Which Power Query transformation removes rows that contain duplicate values based on selected columns?

1. Replace Values
2. Remove Duplicates
3. Split Column
4. Fill Down

Correct Answer: 2

Explanation

Remove Duplicates eliminates repeated records based on the selected columns. It is useful for cleaning source data when duplicate customer, product, or reference records could produce inaccurate analytical results. The operation can be applied to one or more columns depending on how uniqueness should be determined. Replace Values substitutes specific values, Split Column separates data into multiple columns, and Fill Down propagates values into empty cells. Therefore, Remove Duplicates is the appropriate transformation for eliminating repeated records according to selected fields.

Question 136

Which Power BI feature allows users to explore a hierarchy from a higher level such as Year down to Month?

1. Drill down
2. Bookmark
3. Tooltip
4. Slicer

Correct Answer: 1

Explanation

Drill down allows users to navigate through levels of a hierarchy within a visual. For example, a time hierarchy can allow users to begin at Year, move to Quarter, then Month, and finally Day. This provides interactive exploration of different levels of detail without requiring separate visuals for every level. Bookmarks store predefined report states, tooltips provide additional information on hover, and slicers filter data. Therefore, Drill down is the appropriate feature for exploring hierarchical data from summarized levels to greater detail.

Question 137

Which Microsoft Fabric feature can be used to automate a sequence of data activities according to dependencies and execution order?

1. Data pipeline
2. Sensitivity label
3. Semantic model
4. Report theme

Correct Answer: 1

Explanation

A Fabric data pipeline can orchestrate multiple data activities and define their execution sequence and dependencies. This enables organizations to automate repeatable workflows such as copying source data, triggering transformations, and performing subsequent processing steps. A sensitivity label classifies content, a semantic model organizes analytical data and business logic, and a report theme controls report appearance. Therefore, a data pipeline is the appropriate Fabric feature for automating a sequence of dependent data-processing activities.

Question 138

Which DAX function can return the total of a numeric column while respecting the current filter context?

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

Correct Answer: 1

Explanation

SUM adds the numeric values in a column according to the current evaluation context. When used in a measure, the result automatically responds to applicable report filters such as date, product, customer, or region. This makes SUM a fundamental DAX function for creating measures that display totals dynamically. MAX and MIN return extreme values rather than totals, while DISTINCT returns unique values. Therefore, SUM is the appropriate DAX function when a measure needs to calculate the total of a numeric column under the active filter context.

Question 139

A large semantic model contains a column with highly repetitive categorical values. Which modeling choice can help reduce storage requirements?

1. Use an appropriate categorical or lower-cardinality representation
2. Add additional unique values to the column
3. Convert the column into a report bookmark
4. Create a separate workspace for every category

Correct Answer: 1

Explanation

Columns with repetitive categorical values can often be stored efficiently when the model uses appropriate data types and structures that take advantage of lower cardinality. Reducing unnecessary uniqueness and selecting suitable representations can help improve compression and reduce memory consumption. Adding unique values increases cardinality and generally works against efficient storage. Bookmarks and workspaces do not change the underlying column storage characteristics. Therefore, using an appropriate categorical representation and avoiding unnecessary cardinality can contribute to a more efficient semantic model.

Question 140

Which Microsoft Fabric capability allows an organization to move supported analytics content through controlled development and production stages?

1. Deployment pipelines
2. OneLake shortcuts
3. Eventstream
4. Power Query

Correct Answer: 1

Explanation

Deployment pipelines provide a structured lifecycle for promoting supported analytics content through separate stages, such as development, test, and production. This helps teams validate changes before making them available to production users and supports more controlled release practices. OneLake shortcuts provide references to external data, Eventstream handles real-time event processing, and Power Query performs data transformation. Therefore, deployment pipelines are the appropriate Fabric capability when an organization needs controlled movement of analytics content through development and production environments.