DP -600 FABRIC ANALYTICS ENGINEER PRACTICE
SET
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 modellers 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?
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.
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?
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?
Share the lakehouse with User1 directly and select Read all SQL Endpoint data.
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?
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?
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?
a local file upload by using Lakehouse explorer
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?
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?
Split Column
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?
view
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
reports that submit very selective queries.
You plan to create a Fabric lakehouse or warehouse to store company sales data.
Developers must be able to build reports from the lakehouse or warehouse based on
, the sales data. The developers must also be able to do ad-hoc analysis of the legacy
data at the end of each year.
You need to recommend which Fabric architecture to create and the process for
integrating the accounting data into Fabric. The solution must minimize
administrative effort and costs.
What should you recommend?
Ingest the sales data into the Fabric lakehouse and set up a shortcut to the legacy
accounting data in the storage account.
You have a Fabric workspace that contains a data pipeline with a fact table and two
dimension tables. The fact table contains customer data. One dimension table
contains customer information and a column with Customer ID information, and
the other dimension table contains calendar information and a column with Date ID
information.
You need to ensure that each customer's sales data is provisioned to their own
Parquet file under the Parquet folder structure.
Which data pipeline configuration should you implement?
Partition by customer ID on the fact table.
You have a Fabric workspace that contains a Microsoft Power BI report named
Sales.
You plan to use Dataflow Gen2 to add column to the report. The new column must
be based on the unit price of a product. Any product that has a unit price that is
greater than $1,000 must be labeled as High, while any product that has a unit price
that is less than $1,000 must be labelled as Regular.
What should you select on the Add column tab in Power Query Editor?
Conditional column
You have a Fabric tenant that contains a lakehouse named Lakehouse1.
You have an external Snowflake database that contains a table with 200 million
rows.
SET
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 modellers 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?
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.
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?
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?
Share the lakehouse with User1 directly and select Read all SQL Endpoint data.
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?
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?
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?
a local file upload by using Lakehouse explorer
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?
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?
Split Column
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?
view
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
reports that submit very selective queries.
You plan to create a Fabric lakehouse or warehouse to store company sales data.
Developers must be able to build reports from the lakehouse or warehouse based on
, the sales data. The developers must also be able to do ad-hoc analysis of the legacy
data at the end of each year.
You need to recommend which Fabric architecture to create and the process for
integrating the accounting data into Fabric. The solution must minimize
administrative effort and costs.
What should you recommend?
Ingest the sales data into the Fabric lakehouse and set up a shortcut to the legacy
accounting data in the storage account.
You have a Fabric workspace that contains a data pipeline with a fact table and two
dimension tables. The fact table contains customer data. One dimension table
contains customer information and a column with Customer ID information, and
the other dimension table contains calendar information and a column with Date ID
information.
You need to ensure that each customer's sales data is provisioned to their own
Parquet file under the Parquet folder structure.
Which data pipeline configuration should you implement?
Partition by customer ID on the fact table.
You have a Fabric workspace that contains a Microsoft Power BI report named
Sales.
You plan to use Dataflow Gen2 to add column to the report. The new column must
be based on the unit price of a product. Any product that has a unit price that is
greater than $1,000 must be labeled as High, while any product that has a unit price
that is less than $1,000 must be labelled as Regular.
What should you select on the Add column tab in Power Query Editor?
Conditional column
You have a Fabric tenant that contains a lakehouse named Lakehouse1.
You have an external Snowflake database that contains a table with 200 million
rows.
