30 exam-style questions across all four domains. Select an answer for each, then submit for instant scoring with detailed explanations.
0 / 30 answered
1
Prepare the Data
You need to combine 12 monthly sales CSV files with identical columns into one table. Which Power Query operation should you use?
2
Prepare the Data
A customer table has blank email addresses and duplicate customer IDs. Which Power Query profiling feature would you check FIRST to find the blank emails?
3
Prepare the Data
Your DirectQuery report is slow. You notice a Power Query step that adds a complex custom column early in the transformation. What is the likely issue?
4
Prepare the Data
You want to find all customers who have placed NO orders. Your Customers table and Orders table share CustomerID. Which merge join kind returns this?
5
Prepare the Data
A date column imported as text is sorting alphabetically (April before January). What is the fix?
6
Prepare the Data
Which storage mode should you choose for a 50-million-row sales table that must show real-time inventory levels?
7
Prepare the Data
What is the difference between 'distinct' and 'unique' in column distribution?
8
Model the Data
In a star schema, what is the role of a fact table?
9
Model the Data
You have an Orders table with both OrderDate and ShipDate, each related to a Date table. Only one relationship is active. How do you write a measure using the inactive ShipDate relationship?
10
Model the Data
What is 'context transition' in DAX?
11
Model the Data
Which DAX function would you use to calculate 'sales for the same period last year'?
12
Model the Data
A measure calculates correctly at product level but shows wrong totals at category level. DAX: SUMX(Sales, Sales[Qty] * Sales[Price]). What's wrong?
13
Model the Data
You need a 'percent of category total' measure. Which pattern is correct?
14
Model the Data
When should you use a calculated column instead of a measure?
15
Model the Data
What does ALL('Date'[Year]) do inside CALCULATE?
16
Model the Data
A model has a many-to-many relationship between Sales and Promotions. What should you do?
17
Visualise and Analyse
The CFO wants to see how profit changed step-by-step from starting revenue through each cost category to ending profit. Which visual?
18
Visualise and Analyse
A user wants to right-click a bar in a sales chart and jump to a detail page showing that customer's order history. What feature enables this?
19
Visualise and Analyse
What's the difference between a Power BI report and a dashboard?
20
Visualise and Analyse
The compliance team needs a pixel-perfect, printable monthly financial statement exported to PDF. What should you build?
21
Visualise and Analyse
Which AI visual helps users explore what factors drive a metric up or down?
22
Visualise and Analyse
You want a custom tooltip that shows a mini trend chart when hovering over a bar. What do you use?
23
Manage and Secure
You've created an RLS role in Power BI Desktop with the DAX filter [Region] = 'East'. What else must you do before users are actually restricted?
24
Manage and Secure
You need dynamic RLS where each salesperson sees only their own territory. Your Sales table has a SalespersonEmail column. What's the DAX filter?
25
Manage and Secure
A user with the Viewer workspace role tries to edit a report. What happens?
26
Manage and Secure
Your deployment pipeline has Development, Test, and Production stages. In which direction does content deploy?
27
Manage and Secure
An on-premises SQL Server database needs scheduled refresh in the Power BI service. What's required?
28
Manage and Secure
What's the difference between 'Promoted' and 'Certified' dataset endorsement?
29
Manage and Secure
A colleague suggests using 'Publish to web' to share a confidential sales report with the team. What's wrong?
30
Manage and Secure
Your 500M-row fact table takes 4 hours to refresh. What feature would most reduce refresh time?