Welcome to your Unlocking The Best of Power BI: Test Your Knowledge! Expert Level (2024) This quiz has multiple choice questions and each has only one correct answer.
Total Questions : 25
You have 30 Minutes to complete this quiz
To pass this quiz you need to score 80% or above
Today's Date : 6 July 2025
All the best!!
Name
Email
1. Which of the following is a benefit of using Power BI Pro?
2. In Power BI, what is the most important difference between tables related in a star schema and in a snowflake schema?
3. A slicer based on a TEXT column allows which of the following Slicer Setting Styles?
4. Which of the following best describes the function of "Keep Top Rows"?
5. Which statement about measures is correct?
6. I want to enable Object Level Security on a DataSet, so that I can hide PII data from general users. Which tool should I use to configure OLS?
7. I want to create a Measure to divide A by B and return the result. Which statement should I use?
8. Which of the following are not valid DAX functions?
9. Which of the following JOIN criteria returns NON-MATCHING ROWS from SECOND dataset?
10. If I want to filter a Dimension based on filters applied to a Fact, what do I use?
11. My data model includes two related tables, Customers and Orders. To determine the number of customers that have placed orders, I have to create a measure on the Orders table using which function?
12. Which of the following is a way to refresh data in a Power BI report?
13. The "Append Queries" functionality in Power Query implements which of the following?
14. A Table of a Data Model has been imported from a SQL Server Source? An user opens the Power Query Editor and deletes some columns. Which of the following should I implement on SQL Server to improve the loading time?
15. Which time intelligence function in DAX can be used for seeing month-on-month data?
16. Which of these JOIN conditions is not supported in PowerBI?
17. What is a Calculated Table?
18. A measure is defined as "Measure = USERPRINCIPALNAME()". What value would the measure display?
19. Which statement about calculated columns is true?
20. Which of the following lets you receive value from user on live time?
21. A slicer based on a DATE column allows which of the following Slicer Setting Styles?
22. I have 2 columns Customer and Sales and want to calculate sum of sales for a customer named Robert. Which function do you use?
23. Which of the following are TRUE about Calculated Columns?
24. A PowerBI Dataset has Row Level Security Enabled. User A has access to North America region, while User B has access to Europe region. User A creates a Report and shares it with User B. What will User B see when he opens the report?
25. A slicer based on a DECIMAL or WHOLE NUMBER column allows which of the following Slicer Setting Styles?
