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

 

Question 261

A Fabric semantic model uses Direct Lake mode. Under which circumstance can the model use DirectQuery behavior for a query instead of directly reading the Delta tables?

1. When a report contains a slicer
2. When the model contains measures
3. When a supported Direct Lake query cannot be served directly from the required data
4. When the semantic model has a date table

Correct Answer: 3

Explanation

Direct Lake is designed to read data directly from Delta tables in OneLake, but certain scenarios can cause a query to fall back to DirectQuery behavior. This can occur when the requested operation or data source cannot be served through the normal Direct Lake path. Understanding fallback behavior is important when designing and troubleshooting Fabric semantic models because query performance can differ between Direct Lake and DirectQuery execution. Slicers, measures, and date tables alone do not automatically force DirectQuery behavior. Therefore, an unsupported or unavailable Direct Lake query path is the relevant condition.

Question 262

Which Kusto Query Language expression is commonly used to filter records to events that occurred within the last 24 hours?

1. ago(24h)
2. now(24h)
3. past(24h)
4. datetime(24h)

Correct Answer: 1

Explanation

The KQL ago() function returns a datetime value representing a specified time interval before the current time. A condition such as Timestamp >= ago(24h) can therefore be used to return events from approximately the previous 24 hours. now() returns the current datetime rather than subtracting an interval, while past() and datetime(24h) are not the appropriate functions for this purpose. The ago() function is particularly useful in Eventhouse and other time-oriented KQL workloads where queries frequently need relative time filtering.

Question 263

Which semantic-model security mechanism restricts access to particular tables or columns rather than filtering individual rows?

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

Correct Answer: 2

Explanation

Object-level security restricts users from accessing specific tables, columns, or other supported model objects. This differs from row-level security, which controls which rows users can see while still allowing access to the secured table or column. Workspace permissions control access to Fabric items, while sensitivity labels classify and protect information according to organizational policies. Object-level security is therefore appropriate when the requirement is to prevent users from accessing particular model objects rather than simply limiting the rows returned from them.

Question 264

A Power Query developer wants to inspect which transformation step causes query folding to stop. Which approach is most useful?

1. Check the report theme
2. Inspect the native query or folding indicators at individual steps
3. Change the workspace role
4. Add a bookmark

Correct Answer: 2

Explanation

Inspecting query-folding indicators and, where supported, viewing the native query can help identify the transformation step at which folding stops. Developers can evaluate individual Power Query steps and determine whether the source is still receiving a translated operation. This makes it easier to locate transformations that cannot be pushed to the data source and redesign the query if necessary. Report themes, workspace roles, and bookmarks do not provide information about Power Query folding behavior. Therefore, examining individual steps and native-query behavior is the appropriate troubleshooting approach.

Question 265

Which Fabric warehouse capability allows a developer to create reusable logic that can be queried as though it were a table without physically storing a separate copy of the results?

1. View
2. Warehouse table
3. Pipeline
4. Notebook

Correct Answer: 1

Explanation

A warehouse view stores a SQL query definition rather than a separate physical copy of its result set. Users can query the view similarly to a table while the underlying SQL definition determines the returned data. Views can simplify complex queries, provide consistent business logic, and create abstraction layers for consumers. A physical warehouse table stores data, while pipelines orchestrate activities and notebooks support code-based processing. Therefore, a view is the appropriate warehouse capability when reusable query logic is required without maintaining a separate result copy.

Question 266

Which DAX function is useful when a calculation should return a specific expression only when a condition is met, otherwise returning another expression?

1. ALL
2. IF
3. VALUES
4. RANKX

Correct Answer: 2

Explanation

The IF function evaluates a logical condition and returns one expression when the condition is TRUE and another when it is FALSE. It is commonly used for conditional classifications, flags, thresholds, and business rules. For example, a measure could return “Target Met” when sales exceed a target and “Target Not Met” otherwise. ALL modifies filtering, VALUES returns distinct values, and RANKX evaluates rankings. Therefore, IF is the appropriate DAX function for straightforward two-outcome conditional calculations.

Question 267

Which Fabric workspace role generally provides the broadest level of control over workspace content and settings?

1. Viewer
2. Contributor
3. Member
4. Admin

Correct Answer: 4

Explanation

The Admin workspace role provides the broadest level of control among the standard Fabric workspace roles. Workspace administrators can manage workspace settings, membership, and content according to the permissions available in the environment. Viewer provides primarily consumption access, Contributor focuses on creating and modifying content, and Member provides broader content management capabilities than Contributor. The exact effective permissions can also depend on item-level security and organizational configuration. Therefore, Admin is the role associated with the highest standard level of workspace control.

Question 268

Which Power Query operation is generally used to create a query containing only the rows that satisfy a specified condition?

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

Correct Answer: 1

Explanation

Filter Rows restricts the records returned by a Power Query query according to conditions applied to one or more columns. It can be used to retain records such as transactions from a particular region, dates within a specified period, or products meeting a business condition. Pivot Column restructures values into columns, Merge Queries combines information from another query, and Transpose exchanges rows and columns. Therefore, Filter Rows is the appropriate Power Query operation when only records meeting defined criteria should remain in the result.

Question 269

Which DAX function can test whether an expression is evaluated at a particular hierarchy level in a visual?

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

Correct Answer: 2

Explanation

ISINSCOPE determines whether a specified column is currently being used as a level in a hierarchy within the visual’s evaluation context. This makes it useful for measures that should behave differently at levels such as Year, Quarter, Month, or Product Category. HASONEVALUE checks whether one distinct value exists, SELECTEDVALUE retrieves a single value when available, and COALESCE handles blank results. Therefore, ISINSCOPE is the appropriate function when a DAX measure needs to detect the current hierarchy level displayed by a visual.

Question 270

Which Fabric capability is designed to connect streaming data sources to real-time processing and destinations through a low-code interface?

1. Eventstream
2. Dataflow Gen2
3. Deployment pipeline
4. Semantic model

Correct Answer: 1

Explanation

Eventstream is designed for real-time data ingestion and processing within Microsoft Fabric. It provides a low-code experience for connecting supported streaming sources, applying transformations or processing, and directing events toward supported destinations. Dataflow Gen2 is primarily intended for data transformation and ingestion workflows rather than continuous event-stream processing. Deployment pipelines manage lifecycle promotion, while semantic models support analytical modeling. Therefore, Eventstream is the appropriate Fabric capability for building low-code real-time streaming workflows.

Question 271

A semantic model contains a calculation group with several calculation items. What is the primary benefit of using the calculation group?

1. It replaces all relationships in the model
2. It allows reusable calculation logic to be applied across multiple measures
3. It stores raw source files
4. It automatically creates report visuals

Correct Answer: 2

Explanation

Calculation groups allow reusable calculation logic to be applied across multiple measures without creating separate versions of each measure. For example, a calculation group can contain time-intelligence items such as current period, prior period, or year-to-date calculations and apply them to different base measures. This reduces duplicated DAX logic and can simplify large semantic models. Calculation groups do not replace relationships, store source files, or automatically generate report visuals. Therefore, reusable calculation logic across multiple measures is their primary benefit.

Question 272

Which DAX function can remove filters while retaining filters from columns that are not explicitly specified?

1. REMOVEFILTERS
2. FORMAT
3. COUNTROWS
4. CONCATENATEX

Correct Answer: 1

Explanation

REMOVEFILTERS removes filters from the specified table or columns while leaving filters on other columns or tables intact unless they are also explicitly affected by the calculation. It is commonly used inside CALCULATE to control exactly which parts of the filter context should be cleared. FORMAT changes value representation, COUNTROWS counts table rows, and CONCATENATEX combines text values. Therefore, REMOVEFILTERS is appropriate when a calculation must clear selected filters while preserving unrelated filter context.

Question 273

Which KQL operator can calculate the number of records in a result set after filtering?

1. count
2. project
3. extend
4. sort

Correct Answer: 1

Explanation

The KQL count operator returns the number of records in the input result set. It is commonly used after filtering to determine how many events meet a particular condition. For example, a query can first use where to select error events and then use count to determine the total number of matching records. Project selects columns, extend adds calculated columns, and sorting changes the order of results. Therefore, count is the appropriate KQL operator for obtaining the number of records in a filtered result.

Question 274

A data engineer wants to expose a Delta table stored in another OneLake location inside a lakehouse without duplicating its data. Which option should be considered?

1. OneLake shortcut
2. Import mode
3. Calculation group
4. Power BI bookmark

Correct Answer: 1

Explanation

A OneLake shortcut can provide access to supported data stored in another location without physically copying the underlying data into the destination. This is useful for reducing data duplication and creating logical access paths to centrally managed datasets. Import mode relates to semantic-model storage, calculation groups manage reusable DAX calculations, and bookmarks store report states. Therefore, a OneLake shortcut is the appropriate option when a Delta table needs to be referenced from another location without creating a duplicate copy of the data.

Question 275

Which semantic-model feature allows a column such as Month Name to be displayed while another column such as Month Number controls its order?

1. Data category
2. Sort by Column
3. Display folder
4. Perspective

Correct Answer: 2

Explanation

Sort by Column allows one column to control the ordering of another column. This is particularly useful for month names because alphabetical sorting would normally place April before February and January, while a numeric month column can establish chronological order. The displayed field remains Month Name while Month Number determines its sequence. Data categories provide metadata, display folders organize model fields, and perspectives expose selected model objects. Therefore, Sort by Column is the correct feature for controlling the order of displayed categorical values.

Question 276

Which DAX function can evaluate an expression across a table and return the minimum result produced by that expression?

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

Correct Answer: 2

Explanation

MINX is an iterator that evaluates an expression for every row in a specified table and returns the smallest resulting value. It is useful when the value being evaluated must be calculated from row-level data rather than retrieved directly from a single column. MIN returns the minimum value from a column, AVERAGE calculates an arithmetic mean, and SUMX evaluates an expression and adds its results. Therefore, MINX is the appropriate function when the minimum must be derived from a row-by-row expression.

Question 277

Which Fabric development feature can synchronize supported workspace items with a Git repository for version control?

1. Git integration
2. Eventstream
3. OneLake catalog
4. Dataflow Gen2

Correct Answer: 1

Explanation

Git integration connects supported Fabric workspace items with a Git repository so development teams can use source control for supported content. This can help track changes, collaborate across development work, and synchronize workspace content with a repository. Eventstream handles streaming data, OneLake catalog supports data discovery, and Dataflow Gen2 provides data transformation capabilities. Therefore, Git integration is the appropriate feature when the requirement is to maintain supported Fabric development artifacts through a version-controlled repository.

Question 278

Which DAX function can return the number of distinct values in a column while respecting the current filter context?

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

Correct Answer: 2

Explanation

DISTINCTCOUNT counts unique nonblank values in a specified column within the current evaluation context. Because DAX measures respond to filters, the resulting count can change when users filter the report by dates, products, regions, or other dimensions. COUNT counts nonblank values including duplicates, COUNTROWS counts rows in a table, and SUM aggregates numeric values. Therefore, DISTINCTCOUNT is the appropriate function when the business requirement is to count unique entities such as customers, products, or transaction identifiers.

Question 279

Which Power Query transformation is most appropriate when values from several columns need to be converted into attribute-value rows?

1. Pivot Column
2. Split Column
3. Unpivot Columns
4. Group By

Correct Answer: 3

Explanation

Unpivot Columns transforms multiple columns into rows, typically producing attribute and value columns. This is useful when source data has separate columns for categories, months, or other repeated attributes but the analytical model requires a normalized row-based structure. Pivot Column performs the opposite type of restructuring by turning values into separate columns. Split Column divides one field, while Group By creates aggregations. Therefore, Unpivot Columns is the appropriate transformation when several columns need to be converted into attribute-value rows.

Question 280

Which DAX function can return the number of rows remaining after a table expression has been filtered?

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

Correct Answer: 2

Explanation

COUNTROWS returns the number of rows in a table expression, including a table generated by FILTER or another DAX table function. This makes it useful when a calculation needs to count records that satisfy a specific condition. COUNT operates on a column and counts nonblank values, DISTINCTCOUNT counts unique column values, and MAXX evaluates an expression across rows to find the maximum. Therefore, COUNTROWS is the appropriate function for counting the records remaining after a table expression has been filtered.