Advanced Microsoft Certified: Power BI
Data Analyst Associate Multiple Choice
Questions (MCQs) with Answers and
Explanations for Professional Certification
Exams
1.A Power BI analyst imports sales data from multiple regional databases and notices
duplicate customer records. Which Power Query operation should be performed first to
improve data quality?
A. Merge Queries
B. Group By
C. Pivot Column
D. Remove Duplicates
Explanation: Removing duplicate records is an essential data cleansing step that ensures
accurate analysis and prevents double-counting.
2. A report contains a Date table related to a Sales table. Which DAX function should be
used to calculate year-to-date revenue?
A. FILTER
B. SUMMARIZE
C. COUNTROWS
D. TOTALYTD
Explanation: TOTALYTD calculates cumulative values from the beginning of the year to the
current context and is commonly used in time intelligence calculations.
3. Which storage mode provides the fastest query performance for moderate-sized datasets
in Power BI?
A. DirectQuery
B. Dual
, C. Live Connection
D. Import
Explanation: Import mode loads data into memory, providing superior performance compared
with DirectQuery.
4. A Power BI report author wants to restrict regional managers so they only see sales data
for their assigned territories. Which feature should be implemented?
A. Object-Level Security
B. Sensitivity Labels
C. Dataflows
D. Row-Level Security (RLS)
Explanation: Row-Level Security restricts access to specific records based on user roles and
permissions.
5. Which DAX function returns the total number of rows in a table?
A. SUM
B. DISTINCT
C. CALCULATE
D. COUNTROWS
Explanation: COUNTROWS is used to determine the number of records in a table and is often
used in measures.
6. An analyst wants to combine two tables vertically by appending records. Which Power
Query transformation should be used?
A. Merge Queries
B. Group By
C. Split Column
D. Append Queries
Data Analyst Associate Multiple Choice
Questions (MCQs) with Answers and
Explanations for Professional Certification
Exams
1.A Power BI analyst imports sales data from multiple regional databases and notices
duplicate customer records. Which Power Query operation should be performed first to
improve data quality?
A. Merge Queries
B. Group By
C. Pivot Column
D. Remove Duplicates
Explanation: Removing duplicate records is an essential data cleansing step that ensures
accurate analysis and prevents double-counting.
2. A report contains a Date table related to a Sales table. Which DAX function should be
used to calculate year-to-date revenue?
A. FILTER
B. SUMMARIZE
C. COUNTROWS
D. TOTALYTD
Explanation: TOTALYTD calculates cumulative values from the beginning of the year to the
current context and is commonly used in time intelligence calculations.
3. Which storage mode provides the fastest query performance for moderate-sized datasets
in Power BI?
A. DirectQuery
B. Dual
, C. Live Connection
D. Import
Explanation: Import mode loads data into memory, providing superior performance compared
with DirectQuery.
4. A Power BI report author wants to restrict regional managers so they only see sales data
for their assigned territories. Which feature should be implemented?
A. Object-Level Security
B. Sensitivity Labels
C. Dataflows
D. Row-Level Security (RLS)
Explanation: Row-Level Security restricts access to specific records based on user roles and
permissions.
5. Which DAX function returns the total number of rows in a table?
A. SUM
B. DISTINCT
C. CALCULATE
D. COUNTROWS
Explanation: COUNTROWS is used to determine the number of records in a table and is often
used in measures.
6. An analyst wants to combine two tables vertically by appending records. Which Power
Query transformation should be used?
A. Merge Queries
B. Group By
C. Split Column
D. Append Queries
