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

 

Question 81

Which Microsoft Fabric capability is used to organize related items such as lakehouses, warehouses, notebooks, and semantic models for collaborative work?

1. Workspace
2. OneLake shortcut
3. Calculation group
4. Data category

Correct Answer: 1

Explanation

A Fabric workspace provides a collaborative environment where related analytics items can be organized and managed together. Depending on permissions, users can work with items such as lakehouses, warehouses, notebooks, pipelines, semantic models, and reports within the workspace. OneLake shortcuts provide references to data, calculation groups manage reusable calculation logic, and data categories provide metadata-related functionality. Therefore, a workspace is the appropriate Fabric structure when a team needs a shared location for managing related analytics assets.

Question 82

A semantic model contains a Date table, but it has not been configured as the model’s official date table. What should the developer do when proper date-table behavior is required?

1. Mark the table as a date table
2. Convert it into a fact table
3. Remove all date columns
4. Create a second workspace

Correct Answer: 1

Explanation

Marking a table as a date table identifies it as the model’s dedicated calendar table and establishes appropriate date-table semantics. The table should contain a valid date column with the characteristics required for date-table usage. This is particularly important for reliable time-intelligence scenarios and consistent date-based analysis. Converting it into a fact table or removing date columns would prevent the required functionality, while creating another workspace does not affect semantic-model date behavior. Therefore, the developer should mark the appropriate table as a date table.

Question 83

Which DAX function can return the current year from a date value?

1. MONTH
2. DAY
3. YEAR
4. WEEKDAY

Correct Answer: 3

Explanation

The YEAR DAX function returns the year portion of a date value. It is useful when creating calculations, categories, or filters based on calendar years. MONTH returns the month number, DAY returns the day portion, and WEEKDAY returns a number representing the day of the week. Therefore, YEAR is the appropriate function when the requirement is to extract the year from a date. In analytical models, this type of date extraction can also support grouping and time-based reporting when appropriately designed.

Question 84

Which Microsoft Fabric feature provides a way to schedule and manage repeated data refresh or processing operations?

1. Data pipeline
2. Report tooltip
3. Calculation group
4. Sensitivity label

Correct Answer: 1

Explanation

A Fabric data pipeline can be scheduled to execute supported activities repeatedly according to defined timing requirements. Pipelines are useful for orchestrating ingestion, transformation, and related data-processing tasks as part of automated workflows. Report tooltips provide additional visual information, calculation groups provide reusable calculation logic, and sensitivity labels classify content. Therefore, a data pipeline is the appropriate feature when a Fabric solution needs recurring data-processing operations to run automatically according to a schedule.

Question 85

Which Power Query feature allows an analyst to group records by one or more columns and calculate summaries such as totals or counts?

1. Group By
2. Replace Values
3. Unpivot
4. Split Column

Correct Answer: 1

Explanation

The Group By operation in Power Query groups rows according to selected columns and can calculate aggregations such as sum, count, minimum, maximum, or average. For example, sales records can be grouped by region to calculate total revenue for each region. Replace Values changes specific values, Unpivot reshapes columns into rows, and Split Column divides a column into multiple columns. Therefore, Group By is the appropriate Power Query operation when the goal is to summarize records according to selected categories.

Question 86

Which Microsoft Fabric component provides a code-first environment where Python can be used to explore and transform data?

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

Correct Answer: 1

Explanation

Fabric notebooks provide a code-first development environment that supports languages such as Python for data exploration, engineering, transformation, and analytical tasks. They integrate with Fabric data resources and can use Spark-based processing for scalable workloads. Warehouses provide structured SQL analytics, while dashboards and scorecards focus primarily on monitoring and presenting information. Therefore, a notebook is the appropriate Fabric component when developers need a flexible Python-based environment for exploring or transforming data.

Question 87

Which semantic-model design generally makes dimensions easier to reuse across multiple fact tables?

1. Conformed dimensions
2. Duplicate calculated columns
3. Independent report filters
4. Separate workspaces

Correct Answer: 1

Explanation

Conformed dimensions use consistent definitions and keys across multiple fact tables. For example, a shared Date dimension can be used consistently with Sales, Inventory, and Budget fact tables. This makes analysis across different business processes more consistent because the same dimension attributes can be used to filter and compare multiple fact tables. Duplicate calculated columns and independent filters do not establish a common dimensional definition, while separate workspaces do not solve the modeling requirement. Therefore, conformed dimensions are the appropriate approach for reusable dimensions across fact tables.

Question 88

Which DAX function is commonly used to remove filters from a table or column when evaluating a measure?

1. REMOVEFILTERS
2. FORMAT
3. CONCATENATE
4. DATE

Correct Answer: 1

Explanation

REMOVEFILTERS is a DAX function used to remove filters from specified tables or columns when evaluating an expression. It is commonly used with CALCULATE to create measures that compare a filtered value with a broader total. For example, a percentage-of-total measure may remove a product filter while retaining other relevant filters. FORMAT changes the display representation of a value, CONCATENATE combines text, and DATE constructs a date value. Therefore, REMOVEFILTERS is the appropriate function for explicitly removing filters during DAX evaluation.

Question 89

A Power BI developer wants to prevent users from seeing a particular table while still allowing them to access other model objects. Which capability should be considered?

1. Object-level security
2. Row-level security
3. Incremental refresh
4. Field parameters

Correct Answer: 1

Explanation

Object-level security can restrict access to specific objects in a semantic model, such as tables or columns, for users assigned to appropriate roles. This is useful when users should be able to access the broader model but must not see particular sensitive objects. Row-level security restricts records rather than model objects, incremental refresh manages data-refresh processing, and field parameters provide dynamic field or measure selection. Therefore, object-level security is the capability to consider when access to a specific table needs to be restricted.

Question 90

Which Microsoft Fabric feature can help an organization identify the source of data used by a report and the downstream reports affected by a model?

1. Lineage view
2. Slicer
3. Bookmark
4. DAX variable

Correct Answer: 1

Explanation

Lineage view provides a visual representation of relationships and dependencies between supported Fabric and Power BI items. It can help users trace upstream sources and understand downstream dependencies involving dataflows, semantic models, reports, and other analytical content. This information is valuable when investigating data origins or assessing the possible impact of changes. Slicers filter report data, bookmarks save report states, and DAX variables improve calculation organization. Therefore, lineage view is the appropriate feature for understanding data flow and downstream dependencies.

Question 91

Which DAX function returns the largest value in a column after the current filters have been applied?

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

Correct Answer: 2

Explanation

MAX returns the largest value from a column according to the current evaluation context. Because DAX calculations operate within filter context, the result can change when report users select different dates, products, regions, or other dimensions. MIN returns the smallest value, COUNT counts qualifying values, and SUMX performs row-by-row expression evaluation followed by aggregation. Therefore, MAX is the appropriate function when a measure needs to identify the highest value available under the active filters.

Question 92

A company stores raw files and structured tables together in a Fabric lakehouse. Which storage layer provides the unified foundation for this data?

1. OneLake
2. Power BI cache
3. Analysis Services
4. Report workspace

Correct Answer: 1

Explanation

OneLake is the unified storage foundation for Microsoft Fabric. A Fabric lakehouse can contain structured tables and files while using OneLake as its underlying storage layer. This architecture provides a common organizational data foundation for Fabric workloads and reduces the need for separate storage silos. Power BI cache is related to report or model processing, Analysis Services is an analytical modeling technology, and a workspace organizes Fabric items rather than acting as the underlying data lake. Therefore, OneLake is the correct storage layer.

Question 93

Which Power Query operation can split a single text column into multiple columns based on a delimiter such as a comma?

1. Split Column
2. Group By
3. Append Queries
4. Fill Down

Correct Answer: 1

Explanation

Split Column can divide a single column into multiple columns according to a selected delimiter or another supported splitting method. For example, a column containing values such as “City, Country” can be separated into two columns using the comma as the delimiter. Group By summarizes rows, Append Queries combines records from multiple tables, and Fill Down propagates values into blank cells. Therefore, Split Column is the appropriate Power Query operation when a text field needs to be divided based on a delimiter.

Question 94

Which Power BI feature can allow a user to move from yearly sales results to quarterly or monthly detail within the same visual?

1. Drill down
2. Object-level security
3. Dataflow
4. Deployment pipeline

Correct Answer: 1

Explanation

Drill down allows users to move through hierarchical levels within a visual, such as Year to Quarter to Month to Day. This provides interactive exploration of data at different levels of granularity without requiring users to navigate to another report. Object-level security controls model-object access, dataflows prepare data, and deployment pipelines manage content movement. Therefore, Drill down is the appropriate Power BI feature when users need to explore increasingly detailed levels of a hierarchy within the same visual.

Question 95

Which DAX function can return the current month number from a date?

1. MONTH
2. YEAR
3. DAY
4. WEEKNUM

Correct Answer: 1

Explanation

The MONTH DAX function returns the month number from a date, with values ranging from 1 through 12. It can be used when analytical calculations or categorization require the numeric month associated with a date. YEAR returns the year, DAY returns the day of the month, and WEEKNUM returns a week number. Therefore, MONTH is the appropriate DAX function when a calculation needs to extract the month number from a date value.

Question 96

Which Microsoft Fabric capability is designed to support near-real-time analytics over high-volume event data?

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

Correct Answer: 1

Explanation

Eventhouse is designed for real-time analytics scenarios involving high-volume event and telemetry data. It is optimized for workloads where information arrives continuously and needs to be queried and analyzed with low latency. KQL can be used to explore supported event data in these environments. A Warehouse focuses on structured relational analytics, Dataflow Gen2 supports data integration and transformation, and semantic models provide a business-facing analytical layer. Therefore, Eventhouse is the appropriate Fabric component for near-real-time analytics over large volumes of event data.

Question 97

A developer needs to create a measure that calculates sales only for products belonging to a specific category while retaining other report filters. Which DAX function is central to this requirement?

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

Correct Answer: 1

Explanation

CALCULATE is central to this requirement because it evaluates an expression after applying or modifying filters. A measure can use CALCULATE to apply a category-specific condition while allowing other applicable filters, such as date or region, to remain active. DISTINCT returns unique values, FORMAT changes the display representation of a value, and RELATED retrieves a related value through an existing relationship. Therefore, CALCULATE is the appropriate DAX function for creating a measure that evaluates sales under a specific category filter.

Question 98

Which semantic-model optimization can reduce memory usage when a numeric column contains values that do not require decimal precision?

1. Use an appropriate lower-precision numeric data type
2. Convert the column to a report bookmark
3. Add more calculated columns
4. Enable bidirectional filtering

Correct Answer: 1

Explanation

Using an appropriate numeric data type can reduce storage requirements when the data does not require unnecessary precision. For example, a whole-number column should not be stored as a high-precision decimal type when decimal values are not needed. Reducing unnecessary precision can contribute to a more efficient semantic model, particularly when the column contains many rows. Bookmarks, calculated columns, and bidirectional filtering do not provide this type of storage optimization. Therefore, selecting an appropriate numeric data type is the correct approach.

Question 99

Which Microsoft Fabric capability can be used to copy data from a source into a destination as part of an orchestrated workflow?

1. Copy activity in a data pipeline
2. Sensitivity label
3. Report tooltip
4. Calculation group

Correct Answer: 1

Explanation

A Copy activity within a Fabric data pipeline can move data from a supported source to a supported destination as part of an orchestrated workflow. This capability is useful for building repeatable ingestion processes and can be combined with other pipeline activities to create end-to-end data workflows. Sensitivity labels classify content, report tooltips provide additional visual information, and calculation groups manage reusable semantic calculations. Therefore, a Copy activity in a data pipeline is the appropriate choice for moving data as part of an orchestrated process.

Question 100

Which approach generally improves the maintainability of a semantic model by separating business calculations from individual report visuals?

1. Define reusable measures in the semantic model
2. Create separate calculations manually in every visual
3. Duplicate the entire semantic model for each report
4. Store calculations only in report titles

Correct Answer: 1

Explanation

Reusable measures centralize business calculations within the semantic model, allowing multiple reports and visuals to use consistent definitions. This improves maintainability because a calculation can be updated in one location rather than recreated independently across many visuals. It also supports consistent business logic and reduces duplication. Creating separate calculations in every visual increases maintenance effort, duplicating models creates unnecessary complexity, and report titles are not appropriate locations for analytical calculations. Therefore, defining reusable measures in the semantic model is the preferred approach.