Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-600

Free Microsoft DP-600 Exam Braindumps (page: 17)

Page 8 of 41
PDF with 198 Questions

HOTSPOT (Drag and Drop is not supported)
You have a Fabric tenant that contains a workspace named Workspace_DEV. Workspace_DEV contains the semantic models shown in the following table.



Workspace_DEV contains the dataflows shown in the following table.



You create a new workspace named Workspace_TEST.

You create a deployment pipeline named Pipeline1 to move items from Workspace_DEV to Workspace_TEST.

You run Pipeline1.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:




Box 1: No
No - DF1 will be deployed to Workspace_TEST.

DF1 is a Dataflow Gen1 and is configured with a scheduled refresh policy. Gen1 dataflows cannot be integrated into data pipelines.

NOTE: Microsoft Fabric Data Factory, Getting from Dataflow Generation 1 to Dataflow Generation 2 Dataflow Gen2 is the new generation of dataflows. The new generation of dataflows resides alongside the
Power BI Dataflow (Gen1) and brings new features and improved experiences. The following section provides a comparison between Dataflow Gen1 and Dataflow Gen2.



Box 2: Yes
Yes - Data from Model1 will be deployed to Workspace_TEST.

Assign a workspace to an empty stage
When you assign content to an empty stage, a new workspace is created on a capacity for the stage you deploy to. All the metadata in the reports, dashboards, and semantic models of the original workspace is copied to the new workspace in the stage you're deploying to.

After the deployment is complete, refresh the semantic models so that you can use the newly copied content. The semantic model refresh is required because data isn't copied from one stage to another.

Box 3: Yes
Yes - The scheduled refresh policy for Model1 will be deployed to Workspace_TEST:


Reference:

https://learn.microsoft.com/en-us/fabric/data-factory/dataflows-gen2-overview



You have a Fabric tenant.

You are creating a Fabric Data Factory pipeline.

You have a stored procedure that returns the number of active customers and their average sales for the current month.

You need to add an activity that will execute the stored procedure in a warehouse. The returned values must be available to the downstream activities of the pipeline.

Which type of activity should you add?

  1. Get metadata
  2. Switch
  3. Lookup
  4. Append variable

Answer(s): C

Explanation:

The Fabric Lookup activity can retrieve a dataset from any of the data sources supported by Microsoft Fabric. You can use it to dynamically determine which objects to operate on in a subsequent activity, instead of hard coding the object name. Some object examples are files and tables.

Lookup activity reads and returns the content of a configuration file or table. It also returns the result of executing a query or stored procedure. The output can be a singleton value or an array of attributes, which can be consumed in a subsequent copy, transformation, or control flow activities like ForEach activity.


Reference:

https://learn.microsoft.com/en-us/fabric/data-factory/lookup-activity



You have a Fabric tenant that contains a semantic model. You need to modify object-level security (OLS) for the model. What should you use?

  1. the Fabric service
  2. Microsoft Power BI Desktop
  3. ALM Toolkit
  4. Tabular Editor

Answer(s): D

Explanation:

Microsoft Fabric Security, Object-level security (OLS)
To create roles on Power BI Desktop semantic models, use external tools such as Tabular Editor. Configure object-level security using tabular editor
In Power BI Desktop, create the model and roles that will define your OLS rules.

On the External Tools ribbon, select Tabular Editor. If you don’t see the Tabular Editor button, install the program. When open, Tabular Editor will automatically connect to your model.



In the Model view, select the drop-down menu under Roles. The roles you created in step one will appear.



Select the role you want to enable an OLS definition for, and expand the Table Permissions.



Set the permissions for the table or column to None or Read.

After you define object-level security for the roles, save your changes. Screenshot of saving role definitions.

In Power BI Desktop, publish your semantic model to the Power BI Service.

8. In the Power BI Service, navigate to the Security page by selecting the more options menu on the semantic model, and assign members or groups to their appropriate roles.


Reference:

https://learn.microsoft.com/en-us/fabric/security/service-admin-object-level-security



HOTSPOT (Drag and Drop is not supported)
You have a Fabric tenant that contains a workspace named Enterprise. Enterprise contains a semantic model named Model1. Model1 contains a date parameter named Date1 that was created in Power Query.

You build a deployment pipeline named Enterprise Data that includes two stages named Development and Test. You assign the Enterprise workspace to the Development stage.

You need to perform the following actions:
Create a workspace named Enterprise [Test] and assign the workspace to the Test stage. Configure a rule that will modify the value of Date1 when changes are deployed to the Test stage.

Which two settings should you use? To answer, select the appropriate settings in the answer area.

NOTE: Each correct answer is worth one point.

Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:




Box 1: Add workspace button (with a +sign)
Create a workspace named Enterprise [Test] and assign the workspace to the Test stage.

Box 2: Deployment rule [Upper right corner]


Configure a rule that will modify the value of Date1 when changes are deployed to the Test stage. In the pipeline stage you want to create a deployment rule for, select Deployment rules


Reference:

https://learn.microsoft.com/en-us/fabric/cicd/deployment-pipelines/create-rules



You have a Fabric tenant that contains a workspace named Workspace1 and a user named User1. Workspace1 contains a warehouse named DW1.

You share DW1 with User1 and assign User1 the default permissions for DW1. What can User1 do?

  1. Build reports by using the default dataset.
  2. Read data from the tables in DW1.
  3. Connect to DW1 via the Azure SQL Analytics endpoint.
  4. Read the underlying Parquet files from OneLake.

Answer(s): A

Explanation:

By default, when a user is granted access to a Microsoft Fabric warehouse (DW1), they receive the Viewer
role. The Viewer role allows users to:
Build reports using the default dataset associated with the warehouse.

Read data from the dataset but not directly from tables unless explicitly granted additional permissions.



Viewing page 17 of 41
Viewing questions 81 - 85 out of 198 questions



Post your Comments and Discuss Microsoft DP-600 exam prep with other Community members:

DP-600 Exam Discussions & Posts