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

 

Question 101

Which Microsoft Fabric item provides a collaborative environment for running Spark code against analytical data?

1. Notebook
2. Warehouse
3. Report
4. Dashboard

Correct Answer: 1

Explanation

A Microsoft Fabric notebook provides an interactive development environment for writing and executing code against analytical data. It integrates with Spark and can support languages such as Python, making it useful for data engineering, transformation, exploration, and advanced analytics. A Warehouse is intended for structured SQL analytics, while reports and dashboards are primarily used to present analytical results. Therefore, when a developer needs a collaborative environment for running Spark-based code against Fabric data, a notebook is the appropriate item.

Question 102

A semantic model contains a Customer table and an Orders table. CustomerID is unique in Customer but appears many times in Orders. What cardinality should the relationship use?

1. One-to-one
2. Many-to-many
3. One-to-many
4. Many-to-one from Customer to Orders

Correct Answer: 3

Explanation

The Customer table contains one unique record for each CustomerID, while the Orders table can contain multiple orders for the same customer. Therefore, the relationship should have one-to-many cardinality from Customer to Orders. This is a standard dimensional-modeling pattern in which a dimension contains unique entities and a fact table contains multiple events associated with those entities. A one-to-one relationship would not allow repeated orders, while many-to-many is unnecessary when the customer key is unique on one side.

Question 103

Which Power Query operation combines rows from multiple tables that have similar structures?

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

Correct Answer: 2

Explanation

Append Queries combines rows from two or more tables into a single table. It is particularly useful when multiple tables contain similar columns and represent different periods, regions, or source partitions. For example, monthly sales tables can be appended to create one consolidated sales table. Merge Queries combines columns from related tables based on matching keys, while Group By summarizes records and Pivot Column changes the structure of values. Therefore, Append Queries is the appropriate operation when the requirement is to combine rows from similarly structured tables.

Question 104

Which DAX function is commonly used to count nonblank values in a column?

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

Correct Answer: 1

Explanation

COUNT counts nonblank values in a column when the column contains numeric values, dates, or other supported countable data. It differs from COUNTROWS, which counts rows in a table expression, and DISTINCTCOUNT, which counts unique values. SUM performs numerical addition rather than counting records. Selecting the appropriate counting function depends on whether the requirement concerns values, rows, or unique values. Therefore, COUNT is the appropriate DAX function when the goal is to count nonblank numeric or date values in a column.

Question 105

A report must allow users to select multiple product categories and dynamically filter the report. Which visual is most appropriate?

1. Card
2. Slicer
3. Gauge
4. KPI

Correct Answer: 2

Explanation

A slicer provides an interactive filtering control that allows report users to select one or multiple values from a field. When users select product categories in a slicer, connected report visuals can respond according to the model relationships and configured interactions. A card displays a single value, a gauge compares a value against a target, and a KPI visual presents performance information. Therefore, a slicer is the most appropriate visual when users need to interactively select multiple categories and filter a report.

Question 106

Which Microsoft Fabric capability can be used to expose a SQL-based analytical interface over supported lakehouse data?

1. SQL analytics endpoint
2. Real-Time hub
3. Eventstream
4. Notebook session

Correct Answer: 1

Explanation

The SQL analytics endpoint associated with a Fabric lakehouse provides a SQL-based interface for querying supported lakehouse tables. It allows users who are comfortable with SQL to analyze lakehouse data without requiring them to perform the same operations through Spark. Real-Time hub and Eventstream address real-time data scenarios, while a notebook session provides a development environment for code-based processing. Therefore, the SQL analytics endpoint is the appropriate capability when users need SQL access to supported lakehouse data.

Question 107

Which DAX function can return the sum of an expression evaluated for every row in a table?

1. SUM
2. SUMX
3. COUNT
4. MAX

Correct Answer: 2

Explanation

SUMX is an iterator function that evaluates an expression for each row of a specified table and then adds the resulting values together. This is useful when the value being aggregated must first be calculated from multiple columns or a more complex row-level expression. SUM directly aggregates values from a column and does not perform the same row-by-row expression evaluation. COUNT counts values and MAX returns the largest value. Therefore, SUMX is appropriate when the calculation requires an expression to be evaluated for every row before summation.

Question 108

Which modeling principle recommends keeping descriptive attributes in dimension tables and transactional measurements in fact tables?

1. Star schema design
2. Flat-file design
3. Single-table modeling
4. Unstructured modeling

Correct Answer: 1

Explanation

Star schema design separates business processes into fact tables containing measurable events and dimension tables containing descriptive attributes. For example, a Sales fact table can contain revenue and quantity, while Customer, Product, and Date dimensions provide descriptive context. This design creates clear relationships and supports efficient analytical filtering and aggregation. A flat-file or single-table approach combines different types of information and can become difficult to maintain as the model grows. Therefore, star schema design is the modeling principle described in the question.

Question 109

A developer needs to combine two datasets based on CustomerID while retaining every record from the first dataset, even when no match exists in the second dataset. Which join should be used?

1. Inner join
2. Full outer join
3. Left outer join
4. Right outer join

Correct Answer: 3

Explanation

A left outer join retains every record from the left dataset and includes matching information from the right dataset when a match exists. If a CustomerID from the first dataset has no corresponding record in the second dataset, that left-side record is still retained, with missing values for the unmatched right-side columns. An inner join would remove unmatched records, while right and full outer joins have different preservation rules. Therefore, a left outer join is appropriate when all records from the first dataset must remain.

Question 110

Which Microsoft Fabric capability is most appropriate for building a workflow that copies data, performs processing, and then executes subsequent activities in sequence?

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

Correct Answer: 1

Explanation

A Fabric data pipeline provides orchestration capabilities for coordinating multiple data-processing activities. A pipeline can include operations such as copying data, running transformations, invoking supported processing activities, and controlling execution order. This makes pipelines useful for building repeatable end-to-end data workflows. Semantic models provide analytical structures, reports present data to users, and sensitivity labels classify information. Therefore, a data pipeline is the appropriate Fabric item when several data operations must be coordinated in a defined sequence.

Question 111

Which DAX function can return the average value of an expression evaluated across rows of a table?

1. AVERAGE
2. AVERAGEX
3. SUMX
4. MEDIAN

Correct Answer: 2

Explanation

AVERAGEX is an iterator function that evaluates an expression for each row of a table and then calculates the average of the resulting values. This differs from AVERAGE, which calculates the arithmetic mean of values directly contained in a column. SUMX performs row-by-row evaluation followed by summation, while MEDIAN returns the middle value of a dataset according to its calculation rules. Therefore, AVERAGEX is the appropriate function when the average must be calculated from an expression evaluated separately for each row.

Question 112

Which Power BI capability can provide a detailed page showing information related to a selected customer, product, or other data point?

1. Drillthrough
2. Conditional formatting
3. Data category
4. Field parameter

Correct Answer: 1

Explanation

Drillthrough allows report users to navigate from a summary visual to a dedicated detail page while carrying the selected data context with them. For example, selecting a customer in a summary chart can open a customer-detail page filtered to that customer. Conditional formatting changes the appearance of visuals, data categories provide metadata for certain fields, and field parameters enable dynamic field or measure selection. Therefore, Drillthrough is the appropriate Power BI capability for navigating from summary information to contextual detail.

Question 113

A semantic model contains a large amount of historical data that rarely changes and a small recent period that changes frequently. Which feature can optimize refresh processing?

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

Correct Answer: 1

Explanation

Incremental refresh is designed for scenarios where only a portion of a dataset changes regularly. It allows the model to retain historical data while refreshing a defined recent period according to the configured policy. This can reduce unnecessary processing for large datasets and improve refresh efficiency. Bookmarks manage report states, conditional formatting affects visual presentation, and object-level security controls access to model objects. Therefore, incremental refresh is the appropriate feature when historical data remains stable while recent data changes frequently.

Question 114

Which DAX function can retrieve a related value from another table when an appropriate relationship exists?

1. RELATED
2. DISTINCT
3. FILTER
4. FORMAT

Correct Answer: 1

Explanation

RELATED retrieves a value from a related table when the model contains an appropriate relationship and the DAX expression is evaluated in a suitable row context. It is often used in calculated columns to bring an attribute from a related dimension into another table. DISTINCT returns unique values, FILTER creates a filtered table expression, and FORMAT changes the textual representation of a value. Therefore, RELATED is the appropriate DAX function when a value needs to be retrieved from a related table.

Question 115

Which Microsoft Fabric feature helps users discover available data products and other analytical assets in an organization?

1. OneLake catalog
2. DAX measure
3. Report bookmark
4. Workspace role

Correct Answer: 1

Explanation

The OneLake catalog provides capabilities for discovering data and analytical assets across Microsoft Fabric. It helps users locate relevant items and understand available organizational data resources. This type of discovery is important in large analytics environments where users may otherwise have difficulty identifying trusted or relevant datasets. DAX measures perform calculations, report bookmarks store report states, and workspace roles control permissions. Therefore, the OneLake catalog is the appropriate Fabric capability when the primary requirement is discovering available data and analytical assets.

Question 116

Which DAX function can be used to create a filtered table expression based on a Boolean condition?

1. FILTER
2. SUM
3. MAX
4. COUNT

Correct Answer: 1

Explanation

FILTER returns a table containing only the rows that satisfy a specified Boolean condition. It is commonly used in DAX expressions when more specific filtering logic is required than a simple column filter can provide. FILTER can be combined with functions such as CALCULATE to create more advanced measures. SUM performs aggregation, MAX returns the largest value, and COUNT counts values. Therefore, FILTER is the appropriate DAX function when a table expression needs to be restricted according to a defined condition.

Question 117

A data model has an Orders table with OrderDate and ShipDate. Which modeling approach can allow both dates to be analyzed using the same Date dimension?

1. Use separate role-playing relationships to the Date dimension
2. Remove one of the date columns
3. Create a separate workspace for each date
4. Convert both dates to text

Correct Answer: 1

Explanation

A single Date dimension can support multiple date roles, such as Order Date and Ship Date, through separate relationships. In a semantic model, one relationship may be active while another is inactive, and DAX can use appropriate techniques to evaluate calculations through the required relationship. This allows consistent calendar attributes to be reused for different business processes. Removing a date or converting it to text would reduce analytical capability, while separate workspaces do not address model relationships. Therefore, role-playing relationships are appropriate for this scenario.

Question 118

Which Power Query operation can identify and remove duplicate records from a dataset?

1. Remove Duplicates
2. Fill Down
3. Split Column
4. Transpose

Correct Answer: 1

Explanation

Remove Duplicates identifies repeated rows or repeated combinations of selected column values and retains a single instance according to the transformation’s behavior. It is useful when source systems contain duplicate customer, transaction, or reference records that could distort analysis. Fill Down propagates values into empty rows, Split Column divides one column into multiple columns, and Transpose changes rows into columns or columns into rows. Therefore, Remove Duplicates is the appropriate Power Query operation when duplicate records need to be eliminated during data preparation.

Question 119

Which Microsoft Fabric feature can provide a centralized location for real-time event discovery before users connect those events to analytical workflows?

1. Real-Time hub
2. Deployment pipeline
3. Semantic model
4. Dataflow Gen2

Correct Answer: 1

Explanation

Real-Time hub provides a centralized experience for discovering real-time data, event streams, and other supported event-oriented resources in Microsoft Fabric. It helps users locate available real-time information before incorporating it into appropriate analytical or processing workflows. Deployment pipelines manage lifecycle promotion, semantic models organize analytical data for reporting, and Dataflow Gen2 focuses on data ingestion and transformation. Therefore, Real-Time hub is the appropriate feature when the primary requirement is discovering available real-time event data.

Question 120

Which design choice can help ensure that multiple reports use the same definition of an organization’s total revenue metric?

1. Create a shared semantic model measure
2. Recalculate revenue independently in each visual
3. Store revenue only in report titles
4. Create a separate workspace for every metric

Correct Answer: 1

Explanation

Creating a shared measure in a semantic model centralizes the definition of total revenue so that multiple reports and visuals can use the same business logic. This improves consistency and reduces the risk that different report authors will implement slightly different revenue calculations. The measure can also respond dynamically to filters and report context. Recalculating revenue independently increases duplication and maintenance effort, while report titles and separate workspaces do not provide centralized calculation logic. Therefore, a shared semantic model measure is the appropriate design choice.