DataTalks - 2nd edition - Power Up Your Power BI

What is DAX?

• The formula expression language used in Power BI

• The name of a specific visualisation in Power BI

• The time needed to display a visual on the screen

• A synonym for measure

Where can you see the total size of your report?

• Performance Analyzer

• Vertipaq Analyzer

• Power BI Service

• The size of the pbix file

What is the most optimal combination of cardinality and filter direction?

• Both directions with many-to-one

• Single direction with one-to-many

• Single direction with one-to-one

• Both directions with many-to-many

How many points can you have at max in your report?

• 20

• 25

• 30

• 35

If you need the result of a calculation as a filter, what type of calculation do you need to use?

• Measure

• Not possible

• It doesn't matter

• Calculated Column

What functionality can you use to create a visual with more details on an existing visual that appears when hovering?

• Tooltip

• Drillthrough

• Field parameter

• Embedded visual

What is the impact of the auto date time function?

• All dates are automatically converted to datetime

• Local date tables are generated

• Performance of your report will improve

• Automatically adjust to local timezone

Which statement is correct?

• Both calculated columns and measures are computed at row level

• Both calculated columns and measures consume space in memory

• A calculated column is added to a table and a measure isn't

• A measure is added to a table and a calculated column isn't

Which answer is not a disadvantage of a Snowflake schema?

• Complex queries

• Updatability

• Granularity

• Heat sensitive

What is not a characteristic of a star schema?

• Many-to-many relations

• Factual data separated from descriptive data

• Business oriented

• Industry standard