DP-600 FABRIC ANALYTICS ENGINEER PRACTICE SET
1. You are planning a Fabric analytics solution for the following users - Answer -
2,000 Microsoft Power BI consumers without an individual Power BI Pro li-
cense.
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
2. You have a Fabric workspace that contains a lakehouse named Lakehouse1.
A user named User1 plans to use Lakehouse explorer to read Lakehouse1
data. 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
3. 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 - Answer -
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.
4. You have a Fabric tenant.
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
5. 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.
6. 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
7. You have a Fabric tenant that contains two lakehouses named
Lakehouse1 and Lakehouse2. Lakehouse1 contains a table named
FactSales that is parti- tioned 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.
8. 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
9. You have a Fabric workspace that contains a Microsoft Power BI report.
, You need to modify the column names in the Power BI report without changing
the original names in the underlying Delta table.
Which warehouse object should you create? - Answer - view
10. You have a Fabric tenant.
Your company has 1 TB of legacy accounting data stored in an Azure Data Lake
Storage Gen2 account. The data is queried only once a year for a few ad-hoc
1. You are planning a Fabric analytics solution for the following users - Answer -
2,000 Microsoft Power BI consumers without an individual Power BI Pro li-
cense.
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
2. You have a Fabric workspace that contains a lakehouse named Lakehouse1.
A user named User1 plans to use Lakehouse explorer to read Lakehouse1
data. 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
3. 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 - Answer -
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.
4. You have a Fabric tenant.
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
5. 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.
6. 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
7. You have a Fabric tenant that contains two lakehouses named
Lakehouse1 and Lakehouse2. Lakehouse1 contains a table named
FactSales that is parti- tioned 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.
8. 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
9. You have a Fabric workspace that contains a Microsoft Power BI report.
, You need to modify the column names in the Power BI report without changing
the original names in the underlying Delta table.
Which warehouse object should you create? - Answer - view
10. You have a Fabric tenant.
Your company has 1 TB of legacy accounting data stored in an Azure Data Lake
Storage Gen2 account. The data is queried only once a year for a few ad-hoc
