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

 

Question 341

Which Fabric capability is primarily used to orchestrate activities such as copying data, running notebooks, and triggering dataflows in a defined sequence?

1. Semantic model
2. Data pipeline
3. Eventhouse
4. Perspective

Correct Answer: 2

Explanation

A Data pipeline in Microsoft Fabric is designed to orchestrate data movement and processing activities. It can execute operations such as copying data, running notebooks, invoking dataflows, and controlling the sequence of activities through dependencies. This makes pipelines useful for building repeatable data-integration workflows. Semantic models are used for analytical modeling, Eventhouse supports real-time event analytics, and perspectives organize model objects for users. Therefore, a Data pipeline is the appropriate Fabric capability when multiple data-processing activities need to be coordinated.

Question 342

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

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

Correct Answer: 1

Explanation

MEDIAN returns the middle value of a numeric column when the values are ordered. If the number of observations is even, the function calculates the median according to DAX’s defined behavior for the two central values. MEDIAN is useful when the middle tendency of a dataset is more representative than the arithmetic average, particularly when extreme values could influence an average. AVERAGE calculates the arithmetic mean, MAX returns the largest value, and COUNT counts populated values. Therefore, MEDIAN is the appropriate function for this requirement.

Question 343

Which Power Query transformation converts values in a column into separate columns based on the unique values found in another field?

1. Unpivot Columns
2. Pivot Column
3. Split Column
4. Fill Down

Correct Answer: 2

Explanation

Pivot Column transforms row values into separate columns based on the values selected for pivoting. It is useful when data is stored in a normalized attribute-value structure but a wider representation is required for a particular analytical or reporting purpose. Unpivot Columns performs the reverse type of restructuring by converting columns into rows. Split Column divides a field, while Fill Down propagates values into subsequent rows. Therefore, Pivot Column is the appropriate transformation when unique values need to become separate columns.

Question 344

Which semantic-model security feature filters the rows visible to users according to defined roles or rules?

1. Object-level security
2. Workspace permissions
3. Row-level security
4. Sensitivity labels

Correct Answer: 3

Explanation

Row-level security restricts the rows that users can see based on security roles and filtering expressions. For example, a regional sales representative can be restricted to records belonging to the representative’s assigned region. Object-level security instead controls access to model objects such as tables or columns. Workspace permissions govern access to Fabric items, while sensitivity labels classify and protect information. Therefore, Row-level security is the appropriate feature when users should have access to the same model but see different subsets of its rows.

Question 345

Which DAX function can return a table expression after applying filter conditions to another table expression?

1. FILTER
2. CALCULATE
3. SUM
4. YEAR

Correct Answer: 1

Explanation

FILTER returns a table containing only the rows that satisfy a specified condition. It is useful when a calculation requires a custom subset of a table rather than simply applying a basic filter to a column. FILTER can be nested inside other DAX functions and is frequently used when more complex row-level conditions are required. CALCULATE modifies filter context and returns a scalar expression, SUM performs aggregation, and YEAR extracts a date component. Therefore, FILTER is the appropriate function for producing a conditionally filtered table expression.

Question 346

A Power Query query contains several transformations that can be translated to the source system. What is the main benefit of query folding?

1. It stores additional copies of source data
2. It pushes supported transformations to the data source
3. It converts all data into JSON
4. It automatically creates semantic-model measures

Correct Answer: 2

Explanation

Query folding allows supported Power Query transformations to be translated and pushed back to the underlying data source for execution. This can reduce the amount of data transferred to the Fabric environment and allow the source system to perform operations using its own processing capabilities. Query folding can therefore improve refresh efficiency and scalability when the source supports the required transformations. It does not create additional copies of data, convert all values to JSON, or automatically create semantic-model measures. Therefore, pushing transformations to the source is its main benefit.

Question 347

Which DAX function can calculate a value from a table while using a modified filter context and return a table result?

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

Correct Answer: 2

Explanation

CALCULATETABLE evaluates a table expression after modifying the filter context. It is useful in advanced DAX calculations where a filtered or transformed table is required as the result rather than a scalar value. CALCULATE performs similar filter-context modification but returns a scalar expression. FILTER returns rows that satisfy a condition, while VALUES returns distinct values from a column or table. Therefore, CALCULATETABLE is the appropriate function when filter context must be changed and the final result needs to remain a table expression.

Question 348

Which Fabric item is designed for code-based data engineering and analytical development using languages such as Python and Spark?

1. Notebook
2. Warehouse
3. Dashboard
4. Data category

Correct Answer: 1

Explanation

Fabric Notebooks provide an interactive environment for code-based data engineering, data analysis, and other analytical workloads. They support Spark-based processing and can be used with languages such as Python and SQL depending on the workload. Notebooks are useful when transformations or analytical procedures require programmatic logic that may be more complex than low-code tools can conveniently provide. Warehouses focus on SQL-based relational analytics, dashboards present information, and data categories provide semantic metadata. Therefore, Notebook is the appropriate Fabric item for code-based Spark-oriented development.

Question 349

Which DAX function can combine text values from multiple rows into a single text result using a specified delimiter?

1. CONCATENATE
2. CONCATENATEX
3. FORMAT
4. COMBINEVALUES

Correct Answer: 2

Explanation

CONCATENATEX iterates over a table and combines the resulting text values into a single string, optionally using a delimiter. It is useful for creating dynamic labels or summaries such as a comma-separated list of selected products. CONCATENATE combines two text expressions, while FORMAT converts values to text using formatting rules. COMBINEVALUES combines expressions using a delimiter but is designed for a different modeling purpose. Therefore, CONCATENATEX is the appropriate function when multiple row values need to be combined into one text result.

Question 350

Which Fabric capability helps developers understand dependencies between a semantic model and reports that consume it?

1. Lineage view
2. Dataflow
3. Eventstream
4. Field parameter

Correct Answer: 1

Explanation

Lineage view provides a visual representation of relationships and dependencies among supported Fabric and Power BI items. It can help developers determine which reports depend on a semantic model and understand how upstream data assets contribute to downstream content. This information is useful when assessing the potential impact of changes or troubleshooting analytical solutions. Dataflows focus on data transformation, Eventstream handles streaming data, and field parameters control dynamic report fields. Therefore, Lineage view is the appropriate capability for dependency analysis.

Question 351

Which DAX function can determine whether a value is blank?

1. ISBLANK
2. HASONEVALUE
3. COALESCE
4. SELECTEDVALUE

Correct Answer: 1

Explanation

ISBLANK evaluates an expression and returns TRUE when the result is BLANK. It is useful when a measure needs to handle missing results differently from populated values. For example, a calculation can use ISBLANK to determine whether a visual should display a special message or whether a fallback calculation should be used. HASONEVALUE tests the number of distinct values, COALESCE returns the first nonblank expression, and SELECTEDVALUE retrieves a single selected value. Therefore, ISBLANK is the direct function for detecting blank results.

Question 352

Which Power Query feature allows a parameterized transformation to be reused with different input values?

1. Custom function
2. Conditional column
3. Group By
4. Remove Rows

Correct Answer: 1

Explanation

A custom function can accept parameters and execute the same transformation logic against different inputs. This is useful when multiple files, tables, or entities have a similar structure and need consistent preparation. Instead of duplicating many transformation steps, the developer can define the logic once and invoke it with different parameters. Conditional columns create values based on conditions, Group By performs aggregation, and Remove Rows eliminates records. Therefore, a custom function is the appropriate Power Query feature for reusable parameterized transformations.

Question 353

Which DAX function can divide one expression by another while allowing a result to be specified when the denominator is zero or blank?

1. DIVIDE
2. QUOTIENT
3. SUMX
4. PRODUCT

Correct Answer: 1

Explanation

DIVIDE performs division while allowing an alternate result to be supplied when the denominator is zero or blank. This makes it safer for analytical measures than manually using the division operator in situations where invalid denominators may occur. For example, a percentage measure can return zero or BLANK instead of producing an error when the denominator has no value. SUMX performs row-level summation, while the other listed functions do not provide the same DAX analytical behavior. Therefore, DIVIDE is the appropriate function.

Question 354

Which Fabric capability is most appropriate for continuously processing streaming telemetry and querying it with KQL?

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

Correct Answer: 2

Explanation

Eventhouse is designed for real-time analytical workloads involving streaming events, telemetry, logs, and other time-oriented data. It supports Kusto Query Language, making it suitable for continuously ingested event data that needs rapid exploration and analysis. A Warehouse is designed primarily for relational SQL analytics, Dataflow Gen2 handles data preparation and integration, and semantic models provide business-oriented analytical modeling. Therefore, Eventhouse is the appropriate Fabric capability for continuously processing telemetry and analyzing it with KQL.

Question 355

Which DAX function can return the maximum value produced by an expression evaluated over every row of a table?

1. MAX
2. MAXX
3. TOPN
4. SUMX

Correct Answer: 2

Explanation

MAXX evaluates an expression for every row in a specified table and returns the largest resulting value. It is useful when the value being compared is derived from calculations rather than stored directly in a single column. For example, an expression can calculate revenue per transaction before MAXX identifies the largest resulting revenue. MAX works directly on a column, TOPN returns a specified number of top rows, and SUMX calculates a sum. Therefore, MAXX is the appropriate function for row-level maximum calculations.

Question 356

Which semantic-model design approach is generally recommended for analytical reporting because it separates descriptive attributes from measurable transactional data?

1. Snowflake-only model
2. Star schema
3. Flat single-table model
4. Many-to-many model for every relationship

Correct Answer: 2

Explanation

A star schema separates fact tables containing measurable events from dimension tables containing descriptive attributes. This structure generally provides clear relationships, predictable filtering, and efficient analytical querying. For example, a Sales fact table can connect to Product, Customer, and Date dimensions. A flat table can introduce unnecessary duplication, while indiscriminate many-to-many relationships can create ambiguity and more complicated filter behavior. Snowflake structures can be appropriate in some situations but add additional relationships. Therefore, the star schema is generally recommended for analytical semantic models.

Question 357

Which KQL operator filters records according to a Boolean condition?

1. where
2. extend
3. project
4. summarize

Correct Answer: 1

Explanation

The KQL where operator filters records according to a Boolean condition. It can be used to restrict results to events matching criteria such as a specific status, application, severity, or time range. For example, a query can use where to retain only records where Status equals “Error.” Extend creates calculated columns, project controls returned columns, and summarize performs grouped aggregation. Therefore, where is the appropriate KQL operator when the objective is to remove records that do not satisfy a specified condition.

Question 358

Which semantic-model feature can organize fields into a hierarchy such as Year, Quarter, Month, and Day for easier navigation in visuals?

1. Perspective
2. Hierarchy
3. Display folder
4. Data category

Correct Answer: 2

Explanation

A hierarchy organizes related fields into ordered levels that users can navigate in visuals. A date hierarchy, for example, can contain Year, Quarter, Month, and Day, allowing users to move between different levels of detail. Perspectives expose selected model objects, display folders organize fields visually within the model, and data categories provide semantic metadata. Therefore, Hierarchy is the appropriate semantic-model feature when related fields need to be structured into navigable levels for reporting and analysis.

Question 359

Which DAX function can return a table containing the distinct values visible for a column under the current filter context?

1. ALL
2. VALUES
3. FILTER
4. DISTINCTCOUNT

Correct Answer: 2

Explanation

VALUES returns the distinct values of a column or table within the current evaluation context. Because DAX calculations respond to filters, the result can change according to selections made in a report. VALUES is commonly used in advanced calculations where a table of currently available values is required for further processing. ALL removes filters, FILTER creates a conditionally filtered table, and DISTINCTCOUNT returns a scalar count of unique values. Therefore, VALUES is the appropriate function when the distinct values themselves are required.

Question 360

Which Power Query transformation removes rows that contain a specified value or meet a selected condition?

1. Remove Rows
2. Merge Queries
3. Pivot Column
4. Fill Down

Correct Answer: 1

Explanation

Remove Rows provides options for excluding records according to conditions such as a specified value, errors, blank rows, or other supported criteria. It is useful when unwanted records should be eliminated during data preparation before the data reaches downstream analytical models. Merge Queries combines information from related queries, Pivot Column restructures data into columns, and Fill Down propagates values. Therefore, Remove Rows is the appropriate Power Query transformation when records meeting a defined removal condition should be excluded.