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

 

Question 161

Which Microsoft Fabric capability allows users to analyze data with SQL without requiring them to work directly with Spark notebooks?

1. Eventstream
2. SQL analytics endpoint
3. Real-Time hub
4. Dataflow Gen2

Correct Answer: 2

Explanation

The SQL analytics endpoint provides a SQL-based interface for querying supported lakehouse tables. It is useful for analysts and developers who prefer SQL rather than Spark-based development. The endpoint allows users to query structured data using familiar SQL syntax while the underlying lakehouse remains part of the broader Fabric environment. Eventstream and Real-Time hub focus on streaming scenarios, while Dataflow Gen2 is primarily used for data integration and transformation. Therefore, the SQL analytics endpoint is the appropriate choice for SQL-based analysis of lakehouse data.

Question 162

Which DAX function returns the current filter context’s maximum value from an expression evaluated over a table?

1. MINX
2. COUNTX
3. MAXX
4. AVERAGEX

Correct Answer: 3

Explanation

MAXX is an iterator function that evaluates an expression for each row of a table and returns the largest resulting value. It is useful when the maximum cannot be obtained simply by referencing an existing numeric column and instead requires a row-level calculation. MINX returns the smallest result, COUNTX counts expression results, and AVERAGEX calculates an average. Therefore, MAXX is appropriate when a DAX calculation needs to evaluate an expression across rows and then identify the highest resulting value.

Question 163

A Power Query query needs to keep only rows where SalesAmount is greater than 10,000. Which operation should be applied?

1. Filter Rows
2. Pivot Column
3. Append Queries
4. Transpose

Correct Answer: 1

Explanation

Filter Rows allows Power Query to retain records that meet a specified condition. In this scenario, a filter can be applied to SalesAmount so that only rows with values greater than 10,000 remain in the query result. This reduces unwanted data before it reaches downstream analytical models. Pivot Column changes the structure of data, Append Queries combines rows from multiple tables, and Transpose switches rows and columns. Therefore, Filter Rows is the correct operation for restricting records according to a numerical condition.

Question 164

Which semantic-model feature allows a measure to use a predefined expression repeatedly without duplicating the calculation in multiple visuals?

1. Calculated table
2. Measure
3. Relationship
4. Hierarchy

Correct Answer: 2

Explanation

A measure stores a reusable DAX calculation that can be referenced by multiple visuals and reports connected to the semantic model. Measures are evaluated dynamically according to the current filter and evaluation context, making them suitable for business metrics such as revenue, margin, or customer count. A calculated table creates a table expression, relationships connect model objects, and hierarchies organize fields for navigation. Therefore, a measure is the appropriate semantic-model feature when a calculation should be defined once and reused across multiple visuals.

Question 165

Which Microsoft Fabric capability is intended to provide a centralized experience for discovering organizational data assets?

1. OneLake catalog
2. Deployment pipeline
3. Notebook
4. Eventstream

Correct Answer: 1

Explanation

The OneLake catalog provides discovery capabilities for data and analytical assets within Microsoft Fabric. It helps users locate relevant organizational data and understand available resources rather than requiring them to search manually through numerous workspaces and items. Deployment pipelines support content lifecycle management, notebooks provide code-based development, and Eventstream focuses on real-time event processing. Therefore, the OneLake catalog is the appropriate capability when the primary requirement is discovering available organizational data assets.

Question 166

Which DAX function can return the median value of a numeric column?

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

Correct Answer: 2

Explanation

MEDIAN returns the middle value of a numeric dataset when the values are ordered. It can be useful for analytical scenarios where the average may be influenced by unusually high or low values. For example, median transaction value can provide a different perspective from average transaction value when transaction amounts vary significantly. AVERAGE calculates the arithmetic mean, MAX returns the largest value, and SUM calculates a total. Therefore, MEDIAN is the appropriate DAX function when the middle value of a numeric distribution is required.

Question 167

A Fabric developer needs to move a table from a source system into a destination as part of a scheduled workflow. Which pipeline activity is most appropriate?

1. Wait
2. Copy data
3. For Each
4. Web

Correct Answer: 2

Explanation

The Copy Data activity is designed to move data from supported source systems into supported destinations. It can be incorporated into a Fabric data pipeline and executed according to the pipeline’s scheduling and orchestration requirements. Activities such as Wait pause execution, For Each supports iterative processing, and Web can interact with web-based endpoints where supported. Therefore, Copy Data is the appropriate pipeline activity when the primary requirement is transferring a table from a source system to a destination.

Question 168

Which Power BI capability allows a report page to contain a visual that displays detailed information based on the context passed from another page?

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

Correct Answer: 2

Explanation

Drillthrough allows a report user to move from a summary visual to another page containing detailed information filtered by the selected context. A report can have a dedicated customer, product, or transaction detail page that receives the relevant filter when the user initiates drillthrough. A tooltip displays information when hovering, a slicer provides filtering controls, and a bookmark stores a predefined report state. Therefore, Drillthrough is the appropriate capability for navigating to a contextual detail page based on a selected data point.

Question 169

Which DAX function can return a value from a related table when evaluated in an appropriate row context?

1. RELATED
2. CALCULATE
3. FILTER
4. VALUES

Correct Answer: 1

Explanation

RELATED retrieves a value from a related table when an appropriate relationship exists and the calculation is evaluated in a suitable row context. It is commonly used in calculated columns when an attribute from a related dimension needs to be brought into another table. CALCULATE modifies filter context, FILTER returns a filtered table expression, and VALUES returns distinct values from a column or table expression. Therefore, RELATED is the appropriate function for retrieving a corresponding value from a related table.

Question 170

Which Microsoft Fabric item is most appropriate for storing raw files together with managed analytical tables?

1. Warehouse
2. Lakehouse
3. Eventhouse
4. Semantic model

Correct Answer: 2

Explanation

A lakehouse combines data-lake storage with managed analytical tables and is designed to support both file-based and structured data workloads. Raw files can be stored alongside tables, allowing engineering and analytical workloads to work from a common Fabric data foundation. A Warehouse focuses on structured SQL analytics, Eventhouse targets real-time event data, and a semantic model provides the analytical layer used for reporting. Therefore, a lakehouse is the most appropriate Fabric item for storing raw files together with managed analytical tables.

Question 171

Which DAX function can remove filters from a specific column while allowing filters on other columns to remain active?

1. ALLSELECTED
2. REMOVEFILTERS
3. FORMAT
4. RELATED

Correct Answer: 2

Explanation

REMOVEFILTERS can remove filters from specified tables or columns when used within a DAX calculation. This allows developers to control which filters should be ignored while other parts of the current evaluation context remain active. It is frequently used with CALCULATE for calculations such as percentages of totals. ALLSELECTED has different behavior because it works with selections retained from the surrounding query context. FORMAT changes value representation and RELATED retrieves related values. Therefore, REMOVEFILTERS is the appropriate function for explicitly clearing filters from selected model objects.

Question 172

A semantic model has a Sales fact table and a Product dimension. Which table should normally contain descriptive fields such as ProductName and ProductCategory?

1. Sales
2. Product
3. Date
4. Measures table

Correct Answer: 2

Explanation

Descriptive attributes such as ProductName and ProductCategory normally belong in the Product dimension. The Sales fact table should primarily contain measurable business events and keys that connect those events to dimensions. Keeping descriptive information in dimensions supports a star-schema design and allows users to filter and group sales consistently by product attributes. The Date table is intended for calendar-related attributes, while a measures table is used for organizing calculations. Therefore, the Product dimension is the appropriate location for ProductName and ProductCategory.

Question 173

Which Power Query transformation changes a column’s values from one data type to another, such as text to whole number?

1. Change Type
2. Group By
3. Merge Queries
4. Fill Down

Correct Answer: 1

Explanation

Change Type modifies the data type assigned to a column in Power Query. Converting a text representation of a number into a whole-number or decimal type allows the value to participate correctly in numerical calculations and aggregations. Group By summarizes rows, Merge Queries combines related information from another table, and Fill Down propagates values into blank cells. Therefore, Change Type is the appropriate transformation when the underlying data needs to be interpreted using a different data type.

Question 174

Which DAX function can calculate the number of distinct products sold under the current filter context?

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

Correct Answer: 3

Explanation

DISTINCTCOUNT returns the number of unique values in a specified column within the current evaluation context. If ProductID is placed in the function, the result represents the number of distinct products visible under the active report filters. COUNT counts qualifying values rather than necessarily unique values, COUNTROWS counts records, and SUMX performs row-by-row expression evaluation followed by summation. Therefore, DISTINCTCOUNT is the correct function for calculating the number of unique products represented in the current context.

Question 175

Which Fabric lifecycle feature allows teams to compare supported content between development and production stages before deploying changes?

1. Real-Time hub
2. Deployment pipelines
3. OneLake shortcut
4. Dataflow parameter

Correct Answer: 2

Explanation

Deployment pipelines support controlled movement of supported Fabric and Power BI content through lifecycle stages such as development, test, and production. Teams can review and compare changes between stages before promoting content, helping reduce the risk of publishing unfinished or unintended modifications. Real-Time hub supports discovery of event data, OneLake shortcuts reference external data, and dataflow parameters control configurable transformation values. Therefore, Deployment pipelines are the appropriate lifecycle feature for comparing and managing content across development and production stages.

Question 176

Which Power BI feature can display additional report information when a user points to a data point without navigating to another page?

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

Correct Answer: 1

Explanation

A tooltip displays additional information when a user hovers over a supported visual element. Report authors can configure tooltip content to provide supplementary measures, descriptions, or even dedicated tooltip pages without requiring the user to leave the current report page. Drillthrough navigates to another page, bookmarks save predefined report states, and slicers provide interactive filtering. Therefore, Tooltip is the appropriate Power BI feature when users need contextual information to appear during hover interactions without navigating away from the current page.

Question 177

Which DAX function can evaluate an expression for each row of a table and return the smallest resulting value?

1. MIN
2. MINX
3. MAXX
4. SUMX

Correct Answer: 2

Explanation

MINX is an iterator function that evaluates an expression for each row of a table and returns the smallest result produced by that expression. It is useful when the required minimum must first be calculated from row-level logic rather than directly taken from an existing column. MIN returns the minimum value from a column, MAXX finds the largest row-level expression result, and SUMX aggregates row-level expressions by addition. Therefore, MINX is appropriate when the minimum must be determined after evaluating an expression for each row.

Question 178

Which modeling practice can help improve semantic-model performance by avoiding unnecessary high-cardinality columns?

1. Add more unique identifiers to every visual
2. Remove unused high-cardinality columns
3. Duplicate all dimension tables
4. Enable bidirectional filtering everywhere

Correct Answer: 2

Explanation

Unused high-cardinality columns can consume significant storage and may reduce semantic-model efficiency. Removing columns that are not required for relationships, calculations, filtering, grouping, or reporting can reduce model size and improve processing characteristics. Adding unique identifiers unnecessarily increases cardinality, duplicated dimensions increase model complexity, and excessive bidirectional filtering can create ambiguous filter paths. Therefore, removing unused high-cardinality columns is a practical modeling optimization that can help improve semantic-model performance.

Question 179

Which Microsoft Fabric feature is specifically intended for transforming data through a graphical, low-code Power Query interface?

1. Dataflow Gen2
2. Eventhouse
3. Warehouse
4. Deployment pipeline

Correct Answer: 1

Explanation

Dataflow Gen2 provides a graphical, low-code data preparation experience based on Power Query. It allows users to connect to supported sources, clean and transform data, and write the resulting data to supported destinations. This makes it useful when transformation logic needs to be developed without relying entirely on code-based notebooks. Eventhouse is designed for real-time analytics, Warehouse provides structured SQL analytics, and deployment pipelines manage content lifecycle. Therefore, Dataflow Gen2 is the appropriate Fabric capability for low-code Power Query transformations.

Question 180

Which DAX function can return a table containing the dates from the current period shifted to the previous year?

1. DATE
2. SAMEPERIODLASTYEAR
3. MONTH
4. FORMAT

Correct Answer: 2

Explanation

SAMEPERIODLASTYEAR returns a table containing dates corresponding to the same period in the previous year based on the current date context. It is commonly used with CALCULATE to create year-over-year analytical measures. For example, a measure can compare current sales against sales for the equivalent period of the previous year. DATE creates date values, MONTH extracts a month number, and FORMAT changes value representation. Therefore, SAMEPERIODLASTYEAR is the appropriate DAX function for shifting the current date period back by one year.