Free Microsoft DP-600 Exam Dumps Questions & Answers

You have a Fabric tenant that contains two lakehouses.
You are building a dataflow that will combine data from the lakehouses. The applied steps from one of the queries in the dataflow is shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

Folding in Power Query refers to operations that can be translated into source queries. In this case, " some " of the steps can be folded, which means that some transformations will be executed at the data source level. The steps that cannot be folded will be executed within the Power Query engine. Custom steps, especially those that are not standard query operations, are usually executed within Power Query engine rather than being pushed down to the source system.
References =
Query folding in Power Query
Power Query M formula language

You have a semantic model named Model 1. Model 1 contains five tables that all use Import mode. Model1 contains a dynamic row-level security (RLS) role named HR. The HR role filters employee data so that HR managers only see the data of the department to which they are assigned.
You publish Model1 to a Fabric tenant and configure RLS role membership. You share the model and related reports to users.
An HR manager reports that the data they see in a report is incomplete.
What should you do to validate the data seen by the HR Manager?

• A.Select Test as role to view the data as the HR role.
• B.Select Test as role to view the report as the HR manager,
• C.Ask the HR manager to open the report in Microsoft Power Bl Desktop.
• D.Filter the data in the report to match the intended logic of the filter for the HR department.

You need to recommend a solution to group the Research division workspaces.
What should you include in the recommendation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

Comprehensive Detailed Explanation
The requirement is to logically group the Research division workspaces and support filtering in the OneLake data hub.
Why Domain?
Microsoft Fabric allows you to assign workspace domains (e.g., Finance, HR, Research).
This provides a logical grouping of workspaces within the organization.
Domains are the only supported way to enable filtering in OneLake data hub by department.
Capacity or tenant grouping would not allow filtering by department in OneLake.
Why OneLake data hub?
The OneLake data hub is the centralized interface to browse and discover data assets across the organization.
With workspace domains configured, users can filter directly in the OneLake data hub by domain (e.g.,
"Research").
The Fabric Admin portal and Entra admin center are used for administration, not for workspace filtering in data discovery.
Correct Selection for the Hotspot
Grouping method: Domain
Tool: OneLake data hub
References
Workspace domains in Microsoft Fabric
Discover and filter data in OneLake data hub
Final Answer:
Grouping method = Domain
Tool = OneLake data hub

You have a Fabric warehouse that contains a table named Staging.Sales. Staging.Sales contains the following columns.

You need to write a T-SQL query that will return data for the year 2023 that displays ProductID and ProductName arxl has a summarized Amount that is higher than 10,000. Which query should you use?

• A.
• B.
• C.
• D.

You have a Fabric tenant that contains the workspaces shown in the following table.

You have a deployment pipeline named Pipeline1 that deploys items from Workspace_DEV to Workspace_TEST. In Pipeline1, all items that have matching names are paired.
You deploy the contents of Workspace_DEV to Workspace_TEST by using Pipeline1.
What will the contents of Workspace_TEST be once the deployment is complete?

• A.Lakehouse1Notebook1Pipeline1SemanticModel1
• B.Lakehouse1Lakehouse2Notebook1Notebook2Pipeline1SemanticModel1
• C.Lakehouse2Notebook2SemanticModel1
• D.Lakehouse2Notebook2Pipeline1SemanticModel1