Question 1
In Excel Power Query, what is the name of the formula language used to write custom transformations?
Correct Answer:
M
Question 2
Which Excel feature allows you to load multiple related tables into a single in-memory data model and create relationships between them?
Correct Answer:
Power Pivot
Question 3
What is the key behavioral difference between a DAX measure and a DAX calculated column?
Correct Answer:
Calculated columns are computed at refresh and stored per row; measures are evaluated at query time within filter context
Question 4
Which DAX function modifies or replaces the filter context applied to an aggregation?
Correct Answer:
CALCULATE
Question 5
Which DAX function is an iterator that evaluates an expression for each row of a table and returns the sum?
Correct Answer:
SUMX
Question 1
Exam overview

About this Exam

Prepare with the BIDA Practice Questions - CFI Business Intelligence & Data Analyst Exam practice quiz. This question bank includes 100 questions covering power, function, table, returns, and tableau. Use it to review important concepts, identify knowledge gaps, and build confidence for the related exam, course, or assessment.

More details

Additional Information

BIDA Practice Questions - CFI Business Intelligence & Data Analyst Exam

This practice set contains 100 questions from the matching question bank and focuses on power, function, table, returns, and tableau. Work through each question carefully, review the provided solutions, and revisit topics that need more study before your next attempt.

This is an independent study resource intended for practice and review; it is not an official examination or an endorsement by any organization named in the title.

Quiz information

Frequently Asked Questions

The complete question count is available after full access is unlocked.
No fixed duration is currently configured for this quiz.
Question explanations are included where they are available in the quiz content, helping you review the reasoning after answering.
Yes. You can retake the practice test again as you continue studying during your available access period.
After your access is confirmed, you can continue into the complete practice exam from this quiz flow.
Unless explicitly stated otherwise, this page provides independent practice material for study and exam preparation and is not the official examination itself.
Keep studying

Related Questions