Microsoft Certified: Fabric Analytics Engineer Associate - (DP-600) Exam Questions
Question 11 Single Choice
You publish a very large Microsoft Power BI semantic model to a Power BI workspace.
The model refresh will take two hours.
In Power BI Desktop, you limit the data you work with by using parameters.
You need to update the definition of a measure.
What can you use to update the measure definition without having to refresh the model in the Power BI service?
Select only one answer.
Question 12 Single Choice
You are working with a large semantic model.
You need to identify which columns have contributed the most to the model size so that you can focus design efforts on either removing them from the model or reducing their cardinality.
Which external tool can you use to get information about the size of each table and column in a model?
Select only one answer.
Question 13 Single Choice
You have a DAX measure that contains the following code.
- Variance KPI =
- IF( [Variance] > 0.80, "Amazing!", IF( [Variance] > 0.60, "Good", "Bad" ) )
You need to optimize the measure so that it will calculate faster.
Which code should you use?
Select only one answer.
Question 14 Single Choice
You are designing a Microsoft Power BI semantic model that contains a measure named CompanyCosts.
You need to restrict access to CompanyCosts and ensure that only a user named User1 can view the measure in reports.
What should you implement?
Select only one answer.
Question 15 Multiple Choice
You are developing a large Microsoft Power BI semantic model that will contain a fact table. The table will contain 400 million rows.
You plan to leverage user-defined aggregations to speed up the performance of the most frequently run queries.
You need to confirm that the queries are mapped to aggregated data in the tables.
Which two tools should you use? Each correct answer presents part of the solution.
Select all answers that apply.
Question 16 Single Choice
You have a Microsoft Power BI semantic model assigned to you for ownership and maintenance.
You need to perform an audit on the model to identify and resolve potential performance or design issues.
Which Tabular Editor tool should you use?
Select only one answer.
Question 17 Single Choice
You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 contains two data warehouses named Warehouse1 and Warehouse2. Warehouse1 contains HR data. Warehouse2 contains sales data.
You are analyzing the sales data in Warehouse2 by using the SQL analytics endpoint.
You need to recommend a solution that utilizes a query to combine the sales data from Warehouse2 with the HR data from Warehouse1. The solution must minimize development effort and data movement.
What should you recommend?
Select only one answer.
Question 18 Single Choice
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?
Select only one answer.
Question 19 Single Choice
You have a Fabric workspace that contains a Microsoft Power BI report named Sales.
You plan to use Dataflow Gen2 to add an additional 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 labeled as Regular.
What should you select on the Add column tab in Power Query Editor?
Select only one answer.
Question 20 Single Choice
You have a Fabric workspace named Workspace1 that contains a data pipeline named Pipeline1.
You plan to use the Office 365 Outlook activity to send an email message each time Pipeline1 experiences issues with pipeline connectors.
You need to connect the Office 365 Outlook activity to each main pipeline activity. The solution must minimize the number of email messages sent by the activity.
Which connection should you use for the Office 365 Outlook activity?
Select only one answer.
