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

 

Question 21

Which Microsoft Fabric item provides a Spark-based environment for interactive data engineering and analytical code?

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

Correct Answer: 2

Explanation

A Microsoft Fabric notebook provides an interactive environment for writing and executing code for data engineering, data preparation, exploration, and analytical workloads. Fabric notebooks can use Apache Spark capabilities and support languages such as Python, depending on the configured environment. A Warehouse is designed for structured SQL-based analytics, while dashboards and reports focus on presenting analytical results. Therefore, when users need a code-based Spark environment for processing and exploring data, a Fabric notebook is the appropriate item.

Question 22

A semantic model contains a Product table with a unique ProductKey and a Sales table containing multiple records for each product. Which relationship should normally be created?

1. Many-to-many
2. One-to-one
3. One-to-many from Product to Sales
4. Many-to-one from Product to Sales

Correct Answer: 3

Explanation

The Product table contains one unique row for each ProductKey, while the Sales table can contain many transactions associated with the same product. Therefore, the normal relationship is one-to-many from Product to Sales. This pattern is common in dimensional models, where a dimension table contains unique descriptive entities and a fact table contains multiple business events. A many-to-many relationship is unnecessary when the product key is unique in the dimension. One-to-one also does not represent the multiple sales records associated with each product.

Question 23

Which Power Query operation changes columns from rows into separate columns based on their values?

1. Unpivot
2. Merge
3. Pivot
4. Append

Correct Answer: 3

Explanation

The Pivot operation transforms values from rows into separate columns. It is useful when source data contains categories in one column and corresponding values in another column, but the analytical structure requires those categories to become individual columns. Unpivot performs the opposite type of structural transformation by converting columns into rows. Merge combines tables based on matching columns, while Append combines rows from multiple tables. Therefore, Pivot is the correct Power Query operation when values need to become separate columns based on their categories.

Question 24

A Fabric analyst needs to combine all rows from two tables that have compatible column structures. Which operation should be used?

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

Correct Answer: 1

Explanation

Append combines rows from two or more tables into a single table. It is appropriate when the tables represent similar entities or periods and have compatible structures. For example, monthly sales tables could be appended to create a larger table containing records from multiple months. Merge is instead used to combine columns from related tables based on matching keys. Pivot changes the shape of data, while Group By summarizes rows. Therefore, Append is the appropriate operation when the requirement is to combine the rows of compatible tables.

Question 25

Which component is primarily responsible for transforming data through Power Query in Microsoft Fabric?

1. Dataflow Gen2
2. Eventstream
3. Dashboard
4. Scorecard

Correct Answer: 1

Explanation

Dataflow Gen2 uses Power Query capabilities to ingest and transform data within Microsoft Fabric. It provides a low-code approach for tasks such as filtering, joining, reshaping, cleansing, and changing data types before the resulting data is loaded into supported destinations. Eventstream focuses on real-time event processing, while dashboards and scorecards are presentation and monitoring components. Therefore, Dataflow Gen2 is the appropriate Fabric component when Power Query-based data transformation is required as part of a data integration process.

Question 26

Which relationship type should be used when a dimension contains unique keys and a fact table contains repeated instances of those keys?

1. One-to-one
2. Many-to-many
3. One-to-many
4. One-way cross-filtering only

Correct Answer: 3

Explanation

A one-to-many relationship is normally used when the dimension table contains one unique occurrence of a key and the fact table contains many rows with that same key. For example, a single customer can have many sales transactions. This structure supports dimensional modeling and allows filters from the dimension to propagate to related fact records. A one-to-one relationship requires uniqueness on both sides, while many-to-many is used for more complex relationships where keys can repeat on both sides. Therefore, one-to-many is the standard relationship in this scenario.

Question 27

Which Microsoft Fabric capability can be used to orchestrate data movement and transformation activities in a repeatable workflow?

1. Data pipeline
2. Semantic model
3. Dashboard
4. Scorecard

Correct Answer: 1

Explanation

A Fabric data pipeline provides orchestration capabilities for data integration workflows. It can coordinate activities such as copying data, running transformations, and triggering other supported operations in a defined sequence. This allows data engineering teams to build repeatable processes instead of manually performing each operation. Semantic models are designed for analytical modeling, dashboards present information, and scorecards track objectives and metrics. Therefore, a data pipeline is the appropriate Fabric component when multiple data-processing activities need to be orchestrated into a repeatable workflow.

Question 28

A semantic model has a table containing Date, Year, Month, and MonthNumber columns. Which feature can organize these fields into a reusable date hierarchy for reporting?

1. Hierarchy
2. Calculation group
3. Parameter
4. Dataflow

Correct Answer: 1

Explanation

A hierarchy organizes related fields into levels that users can navigate through during analysis. A date hierarchy can contain levels such as Year, Quarter, Month, and Day, allowing report users to move between different levels of time detail. This makes analytical exploration more intuitive and can simplify visual configuration. Calculation groups manage reusable calculation logic, parameters provide configurable values or selections, and dataflows perform data preparation. Therefore, a hierarchy is the appropriate modeling feature for organizing date-related fields into navigable levels.

Question 29

Which DAX function is commonly used to modify the filter context of an expression?

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

Correct Answer: 2

Explanation

The CALCULATE function is one of the most important DAX functions for modifying filter context when evaluating an expression. It can add, remove, or modify filters before the expression is evaluated, making it fundamental for many analytical measures. SUM performs aggregation, COUNTROWS counts rows, and DISTINCTCOUNT counts distinct values. Although these functions are frequently used within measures, they do not provide the same general filter-context modification capability as CALCULATE. Therefore, CALCULATE is the correct choice for changing the evaluation context of a DAX expression.

Question 30

A report requires a measure that returns the total sales amount while ignoring a filter applied to the Product table. Which DAX concept is most relevant?

1. Filter modification
2. Data type conversion
3. Relationship creation
4. Column renaming

Correct Answer: 1

Explanation

Filter modification is the relevant DAX concept when a measure must calculate a result while changing or removing filters from a particular table or column. Functions such as CALCULATE can modify the filter context, while functions such as REMOVEFILTERS can remove filters from specified tables or columns. This allows a measure to calculate a total independently of a particular product filter while retaining other relevant filters. Data type conversion, relationship creation, and column renaming address different modeling or preparation requirements and do not directly solve this calculation problem.

Question 31

Which Microsoft Fabric item is optimized for analytical queries over large volumes of structured data using SQL?

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

Correct Answer: 1

Explanation

A Fabric Warehouse is designed for analytical workloads involving structured relational data and supports SQL-based querying. It is suitable for organizations that require a centralized analytical store with tables and familiar warehouse concepts. Notebooks provide code-based processing environments, Eventstream supports real-time event processing, and Dataflows are used for data ingestion and transformation. A Warehouse is therefore the appropriate item when the primary requirement is to store and analyze large volumes of structured data through SQL queries.

Question 32

A developer wants to query a Fabric lakehouse using SQL without creating a traditional warehouse first. Which endpoint can provide SQL access to lakehouse data?

1. SQL analytics endpoint
2. Power BI gateway
3. Dataflow destination
4. Deployment pipeline

Correct Answer: 1

Explanation

A Fabric lakehouse provides a SQL analytics endpoint that enables users to query supported lakehouse data using SQL. This gives analysts and developers a familiar relational query experience while the underlying data remains associated with the lakehouse. A Power BI gateway provides connectivity to external or on-premises sources, a dataflow destination is used to store transformed data, and deployment pipelines manage supported content across stages. Therefore, the SQL analytics endpoint is the appropriate choice when SQL access to lakehouse data is required.

Question 33

Which modeling practice generally reduces ambiguity and improves usability in a Power BI semantic model?

1. Creating unnecessary bidirectional relationships
2. Using a clear star schema
3. Storing every attribute in one large table
4. Removing all dimension tables

Correct Answer: 2

Explanation

A clear star schema generally improves semantic model usability by separating measurable business events into fact tables and descriptive information into dimension tables. This structure creates predictable relationships and makes filtering and aggregation easier to understand. Excessive bidirectional relationships can introduce ambiguity and unexpected filtering behavior. Placing everything into one large table can make maintenance and analytical modeling more difficult, while removing dimensions eliminates useful descriptive structures. Therefore, a well-designed star schema is generally a strong modeling practice for Power BI semantic models.

Question 34

Which DAX function returns the number of rows in a table or filtered table expression?

1. DISTINCT
2. COUNTROWS
3. VALUES
4. FILTER

Correct Answer: 2

Explanation

COUNTROWS returns the number of rows in a table or table expression after the applicable filter context has been evaluated. It is commonly used in measures that need to count records rather than count values in a specific column. DISTINCT returns a table containing unique values, VALUES returns a table of values affected by context, and FILTER returns a filtered table based on a specified condition. Therefore, COUNTROWS is the DAX function specifically intended to count rows in a table or table expression.

Question 35

An analyst needs to create a calculated value that changes according to the current filters applied to a report. Which model object is normally preferred?

1. Measure
2. Static text column
3. Workspace role
4. Data source credential

Correct Answer: 1

Explanation

A measure is normally preferred for calculations that should respond dynamically to the current filter context in a report. Measures are evaluated when a visual queries the semantic model, allowing their results to change according to selections such as dates, products, regions, or customers. A calculated column is evaluated during model processing and stores values at the row level, while workspace roles and credentials serve administrative purposes. Therefore, a measure is the appropriate model object when the calculation needs to respond dynamically to report filters.

Question 36

Which Microsoft Fabric feature can provide a graphical representation of relationships and dependencies between data assets?

1. Lineage view
2. Query editor
3. Dataflow refresh history
4. Report bookmark

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 understand how data moves through an analytical environment, such as how a source connects to a dataflow, semantic model, and report. This is useful for impact analysis, troubleshooting, and understanding data dependencies. Query editors are used for data transformation or querying, refresh history provides operational information, and bookmarks control report navigation. Therefore, lineage view is the appropriate feature for visualizing analytical asset dependencies.

Question 37

A report contains a visual that is slow because a measure performs expensive calculations over a large model. Which tool can help investigate DAX query performance?

1. Performance Analyzer
2. Sensitivity label
3. Deployment pipeline
4. Workspace calendar

Correct Answer: 1

Explanation

Power BI Performance Analyzer can help identify how long different report elements take to load and can provide information useful for investigating visual and query performance. This can help developers determine whether a particular visual or calculation is contributing to slow report interaction. Sensitivity labels classify content, deployment pipelines support lifecycle management, and workspace calendars are unrelated to DAX performance analysis. Therefore, Performance Analyzer is an appropriate tool for investigating report performance when expensive measures or visuals may be responsible for delays.

Question 38

Which Power BI feature allows a user to save a specific combination of filters, slicers, and visual states for quick navigation?

1. Bookmarks
2. Dataflows
3. Relationships
4. Gateways

Correct Answer: 1

Explanation

Bookmarks capture the current state of a report page, including supported filters, slicer selections, visual visibility, and other report-view settings. They can be used to create navigation experiences, reset report views, or provide different predefined perspectives within a report. Dataflows handle data preparation, relationships define how model tables interact, and gateways provide connectivity to supported data sources. Therefore, bookmarks are the appropriate Power BI feature when users need to save and quickly restore a particular report state.

Question 39

A semantic model contains a column with customer identifiers that should not be visible to report consumers. Which security capability can restrict access to the column?

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

Correct Answer: 2

Explanation

Object-level security (OLS) can restrict access to specific model objects, including tables or columns, for defined users or roles. It is useful when users should be able to access a semantic model but must not see particular sensitive objects. Row-level security instead controls which rows users can access while generally leaving the model structure available. Incremental refresh controls data processing, and dataflow parameters support configurable data transformations. Therefore, object-level security is the appropriate capability when access to a particular column needs to be restricted.

Question 40

Which approach can improve semantic model performance by reducing unnecessary columns and data that are not required for reporting?

1. Importing every source column
2. Removing unused columns and reducing unnecessary data
3. Creating bidirectional relationships everywhere
4. Adding calculated columns for every business rule

Correct Answer: 2

Explanation

Removing unused columns and unnecessary data can reduce the size and complexity of a semantic model. Smaller models generally require fewer resources for storage and processing and can improve query and refresh efficiency. Including every available source column increases model size without necessarily adding analytical value. Excessive bidirectional relationships can introduce complexity and unexpected filter propagation, while unnecessary calculated columns can increase model processing and memory requirements. Therefore, keeping only the data required for reporting is an important technique for maintaining an efficient semantic model.