Power BI Level 2

Please provide your name *

1. In which View within PowerBI will the visuals be assembled and displayed? *

Data View Report View Table View Model View

2. What is the name of the tool with which data is extracted from different types of files into PowerBI? *

Visualisation Gallery Power Pivot Power Query Data Field

3. What is the name of the tool with which the relationships between the data are created within PowerBI? *

Power Pivot Unpivot Columns Groupby Function Power Query

4. Which one of the following DAX functions would create a calendar or date table in PowerBI? *

DATERANGE CALENDARDATE DAYMONTHYEAR CALENDARAUTO

5. What does a “measure” in PowerBI refer to? *

A calculation, function or relationship added within the Data Field The relationship between two data points in the Model View Calculated steps within the Query Editor to clean the data Filter fields to refresh the data when new data is added to the query

6. What does the CALCULATE function in DAX do in PowerBI? *

It stores the calculated table in the data model for faster row-by-row lookups It evaluates a given expression after taking a modified filter context into account It performs complex mathematical calculations like square roots It automatically detects syntax errors in the measures before refreshing data

7. What is the primary purpose of the "Small Multiples" feature in Power BI? *

To automatically compress large data models and reduce file sizes for easier sharing To create backup copies of your dashboard in case the main file gets corrupted To generate small icons and images for custom report navigation buttons To split a single visual into multiple smaller versions of itself based on a specific category

8. What is the primary purpose of a "Zoom Slider" in a Power BI visual? *

To increase the font size of all text and data labels across the entire report page for accessibility To control the playback speed of an animated scatter plot or time-series video visual To let report viewers closely examine a specific section of data in a chart without filtering out the rest of the dataset To accelerate the data refresh speed of the semantic model by focusing on recent time periods

9. What is the primary purpose of the "Play Axis" feature in Power BI visuals like the Scatter Chart? *

To automatically animate a visual over a specific dimension, such as time, allowing users to watch how data changes sequentially To force a visual to automatically toggle between dark mode and light mode based on the time of day To embed and control background music or audio commentary inside a report page To gamify the report by letting users play interactive mini-games during data load times

10. Which visual in PowerBI breaks down a single metric across multiple dimensions so you can see how different categories contribute to the total? *

Smart Narrative Paginated Report Decomposition Tree Specialised Q&A Visual