1|Page
DP600 – MICROSOFT Fabrics Actual Exam Newest
/DP600 – MICROSOFT Fabrics Practice Exam ||Verified
Exam!!/DP600 – MICROSOFT Fabrics Preparation With
150 Questions And Correct Answers With Rationales|
Already Graded A+||Newest Exam!!!
You are planning a Fabric analytics solution for the
following users:
2,000 Microsoft Power BI consumers without an individual
Power BI Pro license.
32 Power BI modelers with an individual Power BI Pro
license.
16 data scientists
You need to recommend a Fabric capacity SKU. The
solution must minimize costs.
What should you recommend? - Answer-F64
You have a Fabric workspace that contains a lakehouse
named Lakehouse1.
A user named User1 plans to use Lakehouse explorer to
read Lakehouse1 data.
,2|Page
You need to assign a workspace role to User1. The
solution must follow the principle of least privilege.
Which workspace role should you assign to User1? -
Answer-Contributor
You have a Fabric tenant that contains a workspace
named Workspace1. Workspace1 contains a lakehouse, a
data pipeline, a notebook, and several Microsoft Power BI
reports.
A user named User1 plans to use SQL to access the
lakehouse to analyze data. User1 must have the following
access:
User1 must have read-only access to the lakehouse.
User1 must NOT be able to access the rest of the items in
Workspace1.
User1 must NOT be able to use Spark to query the
underlying files in the lakehouse.
You need to configure access for User1.
What should you do? - Answer-Share the lakehouse with
User1 directly and select Read all SQL Endpoint data.
You have a Fabric tenant.
,3|Page
You notice a Fabric compute usage issue, which is
causing performance issues.
You need to increase the Fabric capacity unit size.
What should you use? - Answer-Azure portal
You have a Fabric tenant that has XMLA Endpoint set to
Read Write.
You need to use the XMLA endpoint to deploy changes to
only one table from the data model.
What is the main limitation of using XMLA endpoints for
the Microsoft Power BI deployment process? - Answer-A
PBIX file cannot be downloaded from the Power BI
service.
You have a Fabric tenant that contains a lakehouse.
On a local computer, you have a CSV file that contains a
static list of company office locations.
You need to recommend a method to perform a one-time
copy to ingest the CSV file into the lakehouse. The
solution must minimize administrative effort.
Which method should you recommend? - Answer-a local
file upload by using Lakehouse explorer
, 4|Page
You have a Fabric tenant that contains two lakehouses
named Lakehouse1 and Lakehouse2. Lakehouse1
contains a table named FactSales that is partitioned by a
column named CustomerID.
You need to create a shortcut to the FactSales table in
Lakehouse2. The shortcut must only connect to data for
CustomerID 100.
What should you do? - Answer-As you create the shortcut,
select the CustomerKey=100 folder under the FactSales
folder in Tables.
You have a Fabric workspace. The workspace contains a
Dataflow Gen2 query that displays dimensional product
information. The query table contains a column named
Product ID/Name that is a concatenation of Product ID
and Product Name values.
You need to use an applied step in Microsoft Power Query
Editor to create a new column for Product ID and Product
Name. The solution must use a single command to create
two new columns and remove the original combined
(Product ID/Name) column.
Which applied step should you use? - Answer-Split
Column
DP600 – MICROSOFT Fabrics Actual Exam Newest
/DP600 – MICROSOFT Fabrics Practice Exam ||Verified
Exam!!/DP600 – MICROSOFT Fabrics Preparation With
150 Questions And Correct Answers With Rationales|
Already Graded A+||Newest Exam!!!
You are planning a Fabric analytics solution for the
following users:
2,000 Microsoft Power BI consumers without an individual
Power BI Pro license.
32 Power BI modelers with an individual Power BI Pro
license.
16 data scientists
You need to recommend a Fabric capacity SKU. The
solution must minimize costs.
What should you recommend? - Answer-F64
You have a Fabric workspace that contains a lakehouse
named Lakehouse1.
A user named User1 plans to use Lakehouse explorer to
read Lakehouse1 data.
,2|Page
You need to assign a workspace role to User1. The
solution must follow the principle of least privilege.
Which workspace role should you assign to User1? -
Answer-Contributor
You have a Fabric tenant that contains a workspace
named Workspace1. Workspace1 contains a lakehouse, a
data pipeline, a notebook, and several Microsoft Power BI
reports.
A user named User1 plans to use SQL to access the
lakehouse to analyze data. User1 must have the following
access:
User1 must have read-only access to the lakehouse.
User1 must NOT be able to access the rest of the items in
Workspace1.
User1 must NOT be able to use Spark to query the
underlying files in the lakehouse.
You need to configure access for User1.
What should you do? - Answer-Share the lakehouse with
User1 directly and select Read all SQL Endpoint data.
You have a Fabric tenant.
,3|Page
You notice a Fabric compute usage issue, which is
causing performance issues.
You need to increase the Fabric capacity unit size.
What should you use? - Answer-Azure portal
You have a Fabric tenant that has XMLA Endpoint set to
Read Write.
You need to use the XMLA endpoint to deploy changes to
only one table from the data model.
What is the main limitation of using XMLA endpoints for
the Microsoft Power BI deployment process? - Answer-A
PBIX file cannot be downloaded from the Power BI
service.
You have a Fabric tenant that contains a lakehouse.
On a local computer, you have a CSV file that contains a
static list of company office locations.
You need to recommend a method to perform a one-time
copy to ingest the CSV file into the lakehouse. The
solution must minimize administrative effort.
Which method should you recommend? - Answer-a local
file upload by using Lakehouse explorer
, 4|Page
You have a Fabric tenant that contains two lakehouses
named Lakehouse1 and Lakehouse2. Lakehouse1
contains a table named FactSales that is partitioned by a
column named CustomerID.
You need to create a shortcut to the FactSales table in
Lakehouse2. The shortcut must only connect to data for
CustomerID 100.
What should you do? - Answer-As you create the shortcut,
select the CustomerKey=100 folder under the FactSales
folder in Tables.
You have a Fabric workspace. The workspace contains a
Dataflow Gen2 query that displays dimensional product
information. The query table contains a column named
Product ID/Name that is a concatenation of Product ID
and Product Name values.
You need to use an applied step in Microsoft Power Query
Editor to create a new column for Product ID and Product
Name. The solution must use a single command to create
two new columns and remove the original combined
(Product ID/Name) column.
Which applied step should you use? - Answer-Split
Column
