Implement and manage semantic models

Question 1

You have the following measure that you are reviewing as part of a model audit.

RANKX( ALL( ‘Product’[Product Name] ), [Sales],, DESC, Skip )

You need to identify what the measure is calculating.

Which statement accurately describes the DAX measure?

Answer 1

ranks the product names by Sales, with the largest values getting the smallest (e.g. 1,2,3) ranks, and when product names have tied values, then the next rank value, after a tie, is the rank value of the tie plus the count of tied values

Question 2

You are profiling the data stored in a Fabric lakehouse.

You run the following statement.

df.describe().show()

Which three functions will be included in the results for the numeric data? Each correct answer presents a complete solution.

Answer 2

COUNT
MEAN
STD (standard deviation)
describe is used to generate descriptive statistics of the DataFrame. For numeric data, results include COUNT, MEAN, STD, MIN, and MAX, while for object data it will also include TOP, UNIQUE, and FREQ.

Question 3

You have a Microsoft Power BI report that contains two metrics named starting balance and ending balance. Additional fields are used for the customer segment.

You need to recommend a visual to display the value breakdown between the starting and ending balance of each customer segment.

Which visual should you recommend?

Answer 3

waterfall chart

Question 4

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.

Answer 4

Aggregated tables should use Import mode.
The detailed fact table should use DirectQuery mode.
Dimension tables should use Dual mode.

Question 5

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?

Answer 5

Large semantic model storage format

Question 6

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?

Answer 6

Add apply buttons to all the basic filters.

Question 7

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.

Answer 7

DAX Studio
SQL Server Profiler

Question 8

You are using DAX Studio to connect to and troubleshoot a Microsoft Power BI report that is performing poorly.

You need to capture the queries generated by the report.

Which feature in DAX Studio should you enable?

Answer 8

All Queries trace

Question 9

What feature must be enabled for you to manage Power BI semantic models from external tools?

Answer 9

Read-write XMLA endpoint.

Question 10

The _______ and ________ functions can be used to convert a date string to a date in datetime format.

Answer 10

The DATEVALUE and CONVERT functions can be used to convert a date string to a date in datetime format in DAX.

Question 11

You are working as a data scientist for a financial services firm and are tasked with quickly generating visual reports from DataFrames to aid in exploratory data analysis. What library in Python you can use to facilitate this process?
- Seaborn
- reportrender
-powerbiclient
-powerbireports

Answer 11

powerbiclient