Microsoft Certified: Fabric Analytics Engineer Associate - (DP-600) Exam Questions

You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 is assigned to an F64 capacity and contains a lakehouse. The lakehouse contains one billion historical sales records and receives up to 10,000 new or updated sales records throughout the day at 15-minute intervals.

You plan to build a custom Microsoft Power BI semantic model and Power BI reports from the data. The solution must provide the best report performance while supporting near-real-time (NRT) data reporting.

Which Power BI semantic model storage mode should you use?

Select only one answer.

You are developing a complex semantic model that contains more than 20 date columns.

You need to conform the date format for all the columns as quickly as possible.

What should you use?

Select only one answer.

You have a Fabric workspace that contains a lakehouse named Lakehouse1.

Lakehouse1 requires additional time intelligence calculations added to its semantic model. The model has XMLA read/write permissions enabled.

You need to add a calculation group to the Lakehouse1 semantic model.

What should you use?

Select only one answer.

You are developing a large semantic model.

You have a fact table that contains 500 million rows. Most analytic queries will target aggregated data, but some users must still be able to view data on a detailed level.

You plan to create a composite model and implement user-defined aggregations.

Which three storage modes should you use for each type of table? Each correct answer presents part of the solution.

Select all answers that apply.

You have a Fabric workspace and a Microsoft Power BI semantic model that contains the following tables:

• Sales (ProductKey,CustomerKey,DateKey,SalesAmont)

• Product (ProductKey,ProductName,ProductCategory)

• Date (DateKey,Date,Month,Year)

• Customer (CustomerKey,CustmomerName,CustomerCity)

The Product table has a 1-to-many relationship with the Sales table based on ProductKey.

The Customer table has a 1-to-many relationship with the Sales table based on CustomerKey.

The Date table has a 1-to-many relationship with the Sales table based on DateKey.

You need to create a Power BI report so that end users can use a one column chart to analyze SalesAmount by ProductCategory or Year or CustomerCity. The solution must minimize development effort.

What should you do?

You have a Microsoft Power BI report that contains a table visual. The visual contains three DAX measures named Sales, Units, and Customers.

You need to apply logic-based DAX formatting to the Sales measure. The solution must minimize administrative effort and prevent the modification of the other two measures.

How should you apply the logic?

Select only one answer.

You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 is assigned to an F64 Fabric capacity and contains a warehouse.

You are working on a custom Microsoft Power BI semantic model that sources data from the warehouse tables. You apply optimization best practices to reduce the model size. You estimate that once the model is published to the Power BI service and fully loaded, it will approach 50 GB.

Which option should you configure for the semantic model from to enable the semantic model to refresh in the Power BI service?

Select only one answer.

You are working on a Microsoft Power BI report based on a Power BI semantic model that contains the following tables:

• Sales (SalesAmount,OrderDateKey,ShipDateKey)

• Date (DateKey, Date, Month, Quarter, Year)

You have connected the Date table to the Sales table on DateKey to OrderDateKey with a 1-to-many active relationship. You have connected the Date table to the Sales table on DateKey to ShipDateKey with a 1-to-many inactive relationship.

You need to create two measures that calculate Sales Amount Ordered and Sales Amount Shipped so that you can place them side-by-side in a table visual and analyze them by Year.

How should you create the measures?

You have an Azure SQL database.

You have a Microsoft Power BI report connected to a semantic model that uses a DirectQuery connection to the database.

You need to reduce the number of queries sent to the database when a user is interacting with the report by using filters and/or slicers.

What should you do?

Select only one answer

You have a Microsoft Power BI report page that takes longer than expected to display all its visuals.

You need to identify which report element consumes most of the rendering time. The solution must minimize administrative effort and how long it takes to capture the rendering information of each element on the report page.

What should you use?

Select only one answer.