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

 

Question 181

Which storage mode allows a semantic model to query data directly from a Fabric lakehouse without importing the data into the model?

1. Import
2. DirectQuery
3. Direct Lake
4. Dual

Correct Answer: 3

Explanation

Direct Lake is a storage mode designed for Microsoft Fabric that allows Power BI semantic models to read data directly from Delta tables in OneLake. Unlike Import mode, it does not require the data to be copied into the semantic model’s in-memory cache as the primary storage mechanism. This provides a way to build analytical models over Fabric data while minimizing traditional refresh requirements. DirectQuery instead sends queries to an underlying source, while Import stores data in the model. Therefore, Direct Lake is the appropriate choice.

Question 182

A developer wants to create a calculated result that returns “High” when sales exceed 100,000, “Medium” when sales exceed 50,000, and “Low” otherwise. Which DAX function is most suitable?

1. SWITCH
2. DIVIDE
3. DISTINCTCOUNT
4. RELATED

Correct Answer: 1

Explanation

SWITCH is useful when a DAX expression must return different results based on multiple conditions or values. It can evaluate a series of conditions and return the corresponding result, making it suitable for categorizing sales into High, Medium, and Low levels. DIVIDE performs division with optional error handling, DISTINCTCOUNT counts unique values, and RELATED retrieves a value from a related table. Therefore, SWITCH provides an efficient way to implement multiple conditional outcomes in a semantic-model calculation.

Question 183

Which Fabric capability provides source-control integration for supported workspace content by connecting a workspace to a Git repository?

1. Deployment pipelines
2. Git integration
3. Eventstream
4. OneLake catalog

Correct Answer: 2

Explanation

Git integration connects supported Microsoft Fabric workspace content with a Git repository, allowing teams to track changes and collaborate using source-control workflows. Developers can synchronize supported items between the workspace and the connected repository, helping manage changes throughout development. Deployment pipelines serve a different purpose by promoting content between lifecycle stages. Eventstream is designed for streaming data ingestion and processing, while OneLake catalog focuses on data discovery. Therefore, Git integration is the appropriate feature for source-control-based development workflows.

Question 184

Which DAX function safely performs division and can return an alternate result when the denominator is zero or blank?

1. QUOTIENT
2. DIVIDE
3. MOD
4. SUM

Correct Answer: 2

Explanation

DIVIDE is designed specifically for division in DAX and provides an optional alternate result when the denominator is zero or blank. This makes it safer for analytical measures than using a simple division operator in situations where missing or zero values may occur. For example, a percentage measure can use DIVIDE to avoid unwanted errors or invalid results. QUOTIENT returns an integer quotient, MOD returns a remainder, and SUM adds values. Therefore, DIVIDE is the most suitable function for safe ratio calculations.

Question 185

A Fabric analyst needs to inspect the execution time of individual report visuals to identify a slow visual. Which Power BI feature should be used?

1. Lineage view
2. Performance Analyzer
3. OneLake catalog
4. Deployment pipeline

Correct Answer: 2

Explanation

Performance Analyzer helps report developers investigate the performance of individual visuals. It can record how long visuals take to load and provide information that helps identify inefficient queries or rendering operations. This is useful when a report page contains a visual that responds noticeably slower than others. Lineage view focuses on dependencies between data and analytical assets, OneLake catalog supports discovery, and deployment pipelines manage lifecycle promotion. Therefore, Performance Analyzer is the appropriate feature for investigating visual-level report performance.

Question 186

Which DAX function can return a single value when exactly one value is selected in the current filter context?

1. SELECTEDVALUE
2. MAXX
3. COUNTROWS
4. ALL

Correct Answer: 1

Explanation

SELECTEDVALUE returns the value of a column when the current filter context contains exactly one distinct value. It is commonly used in dynamic titles, conditional calculations, and parameter-driven measures. An optional alternate result can be returned when zero or multiple values are selected. MAXX evaluates an expression across rows, COUNTROWS counts rows in a table, and ALL removes filters from a table or column. Therefore, SELECTEDVALUE is the appropriate DAX function when a calculation needs the currently selected single value.

Question 187

Which Power Query approach allows a developer to create a new query based on an existing query while keeping the original query available?

1. Replace Values
2. Reference
3. Remove Rows
4. Pivot Column

Correct Answer: 2

Explanation

The Reference operation creates a new query that uses the output of an existing query as its starting point while preserving the original query. This is useful when several transformation paths should originate from a common prepared dataset. Changes to the original query can flow into dependent referenced queries. Replace Values modifies matching values, Remove Rows eliminates records, and Pivot Column changes the data structure. Therefore, Reference is the appropriate Power Query approach when multiple queries need to build upon the same existing query.

Question 188

Which DAX function can return the year-to-date total for an expression when used with an appropriate date context?

1. TOTALYTD
2. YEAR
3. DATE
4. FORMAT

Correct Answer: 1

Explanation

TOTALYTD calculates a year-to-date value for an expression based on the current date context. It is commonly used for measures such as year-to-date revenue, expenses, or units sold. The function works with an appropriate date column and can be combined with other DAX logic to support time-based reporting. YEAR extracts the year component from a date, DATE constructs a date value, and FORMAT changes how values are displayed. Therefore, TOTALYTD is the suitable function for calculating cumulative results from the beginning of the year through the current context.

Question 189

A data engineer wants to prevent an intermediate Power Query query from being loaded into the final destination because it is used only as a staging query. What should be configured?

1. Enable Load should be disabled
2. The query should be deleted
3. The query should be converted into a parameter
4. The query should be published separately

Correct Answer: 1

Explanation

Disabling Enable Load prevents a Power Query query from being loaded into the destination while allowing the query to remain available as a staging or transformation component. This is useful when an intermediate query provides reusable logic for downstream queries but does not itself need to become part of the final dataset. Deleting the query would remove its transformation logic, while parameters serve a different purpose. Therefore, disabling Enable Load is the appropriate configuration for a staging query that should not be loaded.

Question 190

Which semantic-model design uses a separate table containing unique keys to resolve a many-to-many relationship between two business entities?

1. Bridge table
2. Factless report
3. Tooltip table
4. Calculation group

Correct Answer: 1

Explanation

A bridge table can resolve many-to-many relationships by providing a structured intermediary between two entities. It typically contains keys that establish relationships with the participating tables, allowing filtering and analysis to flow through a controlled model design. This approach is useful when a direct many-to-many relationship would produce ambiguous or difficult-to-manage filtering behavior. A calculation group manages reusable calculation logic, while tooltip tables and report constructs serve different purposes. Therefore, a bridge table is the appropriate modeling technique for many-to-many relationship scenarios.

Question 191

Which DAX function can preserve an existing filter while adding another filter condition to a CALCULATE expression?

1. KEEPFILTERS
2. FORMAT
3. COUNT
4. RELATED

Correct Answer: 1

Explanation

KEEPFILTERS modifies the behavior of filters applied within CALCULATE so that existing filters are preserved rather than being completely replaced by the new filter expression. This is useful when a measure needs to narrow an already filtered context instead of overriding it. FORMAT changes the representation of values, COUNT counts values, and RELATED retrieves a related value. Therefore, KEEPFILTERS is appropriate when a calculation needs to add filtering while retaining the existing filter context.

Question 192

A data engineer needs a pipeline to execute another activity only after a previous activity completes successfully. Which dependency condition should be configured?

1. On failure
2. On completion
3. On success
4. On skip

Correct Answer: 3

Explanation

The On success dependency condition allows a downstream pipeline activity to begin only when the preceding activity completes successfully. This is useful when later processing depends on the successful completion of an earlier operation, such as loading data before running transformations. On failure is used for failure-handling paths, while On completion can allow execution regardless of whether the previous activity succeeded or failed. On skip is associated with activities that were skipped. Therefore, On success is the appropriate dependency condition for this requirement.

Question 193

Which Fabric architecture component provides a unified organizational data lake for Fabric workloads?

1. OneLake
2. Power Query
3. Semantic model
4. Report

Correct Answer: 1

Explanation

OneLake is the unified data lake for Microsoft Fabric. It provides a centralized storage foundation for Fabric workloads and helps organizations work with data across different analytical experiences without maintaining separate data lakes for each workload. Lakehouses, warehouses, and other Fabric experiences can interact with data stored within the OneLake architecture. Power Query is used for data transformation, semantic models provide analytical modeling, and reports present analytical results. Therefore, OneLake is the component that serves as Fabric’s unified organizational data lake.

Question 194

Which DAX function can return a result based on whether a specified condition is true or false?

1. IF
2. SUMX
3. DISTINCT
4. RELATEDTABLE

Correct Answer: 1

Explanation

The IF function evaluates a logical condition and returns one result when the condition is true and another when it is false. It is useful for creating conditional classifications, flags, and calculations in DAX. For example, a measure can use IF to identify whether sales exceed a specified target. SUMX performs row-by-row aggregation, DISTINCT returns unique values, and RELATEDTABLE returns related rows from another table. Therefore, IF is the appropriate DAX function for implementing a straightforward true-or-false conditional result.

Question 195

Which Fabric option is most appropriate when a team needs to query structured data using T-SQL and manage relational warehouse objects?

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

Correct Answer: 1

Explanation

Microsoft Fabric Warehouse is designed for structured analytical workloads using T-SQL. It provides relational database capabilities for creating and querying tables, views, and other supported warehouse objects. This makes it appropriate for teams that need a SQL-centric environment for enterprise analytics and reporting. Eventstream focuses on event ingestion, notebooks support code-based development, and Dataflow Gen2 provides low-code data transformation. Therefore, Warehouse is the appropriate Fabric item when structured relational analytics and T-SQL are central requirements.

Question 196

Which DAX function returns a table containing only the rows that satisfy a specified condition?

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

Correct Answer: 1

Explanation

FILTER returns a table containing only the rows that meet a specified Boolean condition. It is commonly used inside other DAX functions when a calculation requires a customized subset of rows rather than an entire table. For example, FILTER can be used within CALCULATE to restrict calculations to records meeting a particular business rule. SUM calculates totals, MAX identifies the largest value, and FORMAT changes value presentation. Therefore, FILTER is the appropriate DAX function for returning rows that satisfy a specified condition.

Question 197

Which feature helps users understand dependencies between a semantic model, reports, and upstream data sources?

1. Performance Analyzer
2. Lineage view
3. Slicer
4. Bookmark

Correct Answer: 2

Explanation

Lineage view provides a visual representation of relationships and dependencies among supported Fabric and Power BI items. It helps users understand how data flows from upstream sources through datasets or semantic models to downstream reports and other analytical assets. This information can be valuable when planning changes, troubleshooting dependencies, or assessing the impact of modifications. Performance Analyzer focuses on report performance, while slicers and bookmarks provide report-interaction capabilities. Therefore, Lineage view is the appropriate feature for understanding analytical asset dependencies.

Question 198

Which DAX function can retrieve the value of a measure while applying a specific relationship between two tables for the calculation?

1. USERELATIONSHIP
2. CONCATENATEX
3. RANKX
4. MEDIANX

Correct Answer: 1

Explanation

USERELATIONSHIP activates an existing relationship for the duration of a calculation, typically within CALCULATE. It is useful when a model contains multiple relationships between tables, such as separate order-date and delivery-date relationships, and a measure needs to use a relationship that is not currently active. CONCATENATEX combines text values, RANKX calculates rankings, and MEDIANX evaluates an expression and returns its median. Therefore, USERELATIONSHIP is the appropriate function for activating a specific existing relationship during a calculation.

Question 199

Which Power Query transformation combines rows from two queries that have the same or compatible column structures?

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

Correct Answer: 2

Explanation

Append Queries combines rows from two or more queries into a single result. It is particularly useful when datasets have compatible structures, such as monthly sales tables that need to be consolidated into one table. Merge Queries serves a different purpose by joining columns from related tables based on matching keys. Group By creates summaries, while Conditional Column creates values according to defined rules. Therefore, Append Queries is the appropriate transformation when the requirement is to combine datasets vertically by adding their rows.

Question 200

Which semantic-model optimization can reduce unnecessary processing by removing fields that are not used for reporting, relationships, or calculations?

1. Add calculated columns to every table
2. Increase the number of relationships
3. Remove unused columns
4. Enable bidirectional filtering for all relationships

Correct Answer: 3

Explanation

Removing unused columns can reduce the amount of data stored and processed by a semantic model. Columns that are not needed for reporting, relationships, filtering, grouping, or calculations generally provide little analytical value while potentially increasing model size and processing requirements. Adding calculated columns and unnecessary relationships can increase complexity, while widespread bidirectional filtering may create inefficient or ambiguous filter paths. Therefore, removing unused columns is a practical model-optimization technique that can help improve efficiency and maintain a cleaner analytical structure.