Table of Contents
Introduction to Power BI
🔒 Please log in to unlock this course.
Microsoft Power Platform Mastery
Locked. Enroll to see all important links.
MCQ Section
MCQ 1
What is Power BI?
Locked. Enroll to open this MCQ.
MCQ 2
What is the primary purpose of Power BI?
Locked. Enroll to open this MCQ.
MCQ 3
What does "BI" stand for in Power BI?
Locked. Enroll to open this MCQ.
MCQ 4
Which company developed Power BI?
Locked. Enroll to open this MCQ.
MCQ 5
Which of the following is a common use of Power BI?
Locked. Enroll to open this MCQ.
MCQ 6
What type of users commonly use Power BI?
Locked. Enroll to open this MCQ.
MCQ 7
Which feature makes Power BI valuable for decision-making?
Locked. Enroll to open this MCQ.
MCQ 8
Which of the following best describes a dashboard in Power BI?
Locked. Enroll to open this MCQ.
MCQ 9
Why do organizations use Power BI?
Locked. Enroll to open this MCQ.
MCQ 10
Which statement best summarizes Power BI?
Locked. Enroll to open this MCQ.
MCQ 11
What is Power BI Desktop?
Locked. Enroll to open this MCQ.
MCQ 12
What is the Power BI Service?
Locked. Enroll to open this MCQ.
MCQ 13
Which Power BI component allows users to view reports on smartphones and tablets?
Locked. Enroll to open this MCQ.
MCQ 14
Which Power BI component is typically used first when creating a new report?
Locked. Enroll to open this MCQ.
MCQ 15
What is the main difference between a report and a dashboard in Power BI?
Locked. Enroll to open this MCQ.
MCQ 16
What is a common source of data for Power BI?
Locked. Enroll to open this MCQ.
MCQ 17
Why is data refresh important in Power BI?
Locked. Enroll to open this MCQ.
MCQ 18
A company wants daily sales reports to automatically display current sales figures. Which Power BI…
Locked. Enroll to open this MCQ.
MCQ 19
What is the typical Power BI workflow?
Locked. Enroll to open this MCQ.
MCQ 20
A sales manager wants a single screen showing revenue, profit, and sales trends at a glance. What…
Locked. Enroll to open this MCQ.
MCQ 21
What is Power Query in Power BI?
Locked. Enroll to open this MCQ.
MCQ 22
Why is data transformation important in Power BI?
Locked. Enroll to open this MCQ.
MCQ 23
What is a dataset in Power BI?
Locked. Enroll to open this MCQ.
MCQ 24
Which visualization is best suited for comparing sales across different regions?
Locked. Enroll to open this MCQ.
MCQ 25
What is the purpose of a filter in Power BI?
Locked. Enroll to open this MCQ.
MCQ 26
What is a slicer in Power BI?
Locked. Enroll to open this MCQ.
MCQ 27
Which visualization is commonly used to display a single important metric such as Total Sales?
Locked. Enroll to open this MCQ.
MCQ 28
What does a KPI visual typically show?
Locked. Enroll to open this MCQ.
MCQ 29
What is Drill Down in Power BI?
Locked. Enroll to open this MCQ.
MCQ 30
What makes Power BI reports interactive?
Locked. Enroll to open this MCQ.
MCQ 31
What is DAX in Power BI?
Locked. Enroll to open this MCQ.
MCQ 32
What is a Measure in Power BI?
Locked. Enroll to open this MCQ.
MCQ 33
What is a Calculated Column?
Locked. Enroll to open this MCQ.
MCQ 34
Why are relationships important in Power BI?
Locked. Enroll to open this MCQ.
MCQ 35
Which relationship type is most common in Power BI data models?
Locked. Enroll to open this MCQ.
MCQ 36
In a Star Schema, what is a Fact Table?
Locked. Enroll to open this MCQ.
MCQ 37
In a Star Schema, what is a Dimension Table?
Locked. Enroll to open this MCQ.
MCQ 38
What is the primary advantage of Import Mode in Power BI?
Locked. Enroll to open this MCQ.
MCQ 39
What is DirectQuery in Power BI?
Locked. Enroll to open this MCQ.
MCQ 40
A company wants managers to see only data from their own region in reports. Which Power BI feature…
Locked. Enroll to open this MCQ.
MCQ 41
A Power BI report uses Import Mode and contains 100 million sales records. Users complain that…
Locked. Enroll to open this MCQ.
MCQ 42
Which scenario is MOST suitable for DirectQuery instead of Import Mode?
Locked. Enroll to open this MCQ.
MCQ 43
Which statement best describes filter context in DAX?
Locked. Enroll to open this MCQ.
MCQ 44
What will happen if a Sales table has no relationship with a Product table, and a report attempts…
Locked. Enroll to open this MCQ.
MCQ 45
A report contains a measure: Total Sales = SUM(Sales[Amount]). A user applies a filter for Year =…
Locked. Enroll to open this MCQ.
MCQ 46
Which data model design generally provides the BEST reporting performance and maintainability?
Locked. Enroll to open this MCQ.
MCQ 47
A company wants executives to see company-wide data while regional managers see only their region's…
Locked. Enroll to open this MCQ.
MCQ 48
What is the primary purpose of an On-Premises Data Gateway?
Locked. Enroll to open this MCQ.
MCQ 49
Which DAX object consumes storage space in the data model?
Locked. Enroll to open this MCQ.
MCQ 50
A Power BI developer notices that report performance is slow. The model contains many unnecessary…
Locked. Enroll to open this MCQ.
MCQ 51
Which DAX function is primarily used to modify the filter context of a calculation?
Locked. Enroll to open this MCQ.
MCQ 52
What is the primary purpose of the ALL() function in DAX?
Locked. Enroll to open this MCQ.
MCQ 53
Which DAX expression would most likely be used to calculate a percentage of total sales?
Locked. Enroll to open this MCQ.
MCQ 54
What is Context Transition in DAX?
Locked. Enroll to open this MCQ.
MCQ 55
Why might a Power BI developer use USERELATIONSHIP() in DAX?
Locked. Enroll to open this MCQ.
MCQ 56
Which statement about bi-directional filtering is TRUE?
Locked. Enroll to open this MCQ.
MCQ 57
What is a Composite Model in Power BI?
Locked. Enroll to open this MCQ.
MCQ 58
Which feature helps improve performance by storing summarized data while detailed data remains…
Locked. Enroll to open this MCQ.
MCQ 59
What is the primary benefit of Incremental Refresh?
Locked. Enroll to open this MCQ.
MCQ 60
A report takes 20 seconds to load. Which Power BI tool should be used FIRST to identify which…
Locked. Enroll to open this MCQ.