Learn Power BI

In a data model diagram the boxes contain ______ of data, where each line item within the box is a ______.

Star schemas use fact tables and tables.

Tables should always be as granular as possible so that users can drill into every single transaction

The dashed line between the two tables indicates that it is _______ relationship.

A date table must contain a column of type 'date' with unique values.

With a single cross-filter direction between two tables with a one-to-many relationship, filtering will be done by

Benefits of a date table include [select all that apply]

Power BI automatically enters these values as a hierarchy

Which of the following does not compress as well that the other methods?

An inactive relationship will never be used unless ________.

Power BI autodetects relationships based on column names

Total Price shown below is

This DAX function [select all that apply]

Total Sales for 2015 = CALCULATE(SUM('Sales OrderDetails'[Total Price]), YEAR('Sales OrderDetails'[orderdate]) = 2015)

Tables with different levels of granularity need to be reconciled before establishing a relationship between the tables.

Which cardinality is not recommended?

Which cardinality is a default when relationships are automatically created?

The solid line between the two tables indicates that it is _______ relationship.

This function returns a complete range of dates that are automatically determined from your dataset

A date table is any table containing a date range in one of the columns. There is no 'official' date table in Power BI.

This function

Sales by Ship Date = CALCULATE(Sales[TotalPrice], USERELATIONSHIP('Calendar'[Date], Sales[ShipDate]))

This type of dimension table has multiple valid relationships with fact tables, meaning that the same dimension can be used to filter multiple columns or tables of data.

A best practice before running the performance analyzer is to clear these [select all that apply]

If the same expression is repeated multiple times in a calculation

The performance analyzer shows the time to complete the following categories [select all that apply]

Which of the following is not a query reduction option

Benefits of variables include [select all that apply]

Which of the following is not an option for using aggregation in a data model

What are reasons to use DirectQuery [select all that apply]

Best practice is to use the Auto date/time option enabled only when you

To clear the data cache, you can either ______ or connect DAX Studio to the data model and then call Clear Cache.

Which of the following are characteristic of DirectQuery [select all that apply]

Variables help simplify the task of troubleshooting your DAX calculation by evaluating each variable separately and by recalling them after the ______ expression.

Using aggregations in the data model can [select all that apply]