Business Intelligence and Analytics MBA 2025 — 55 Q&A
Complete Study Guide
Series:
CrashCourses Professional Study Series
Author:
Dr Z. Moomba, MBChB, MRCPsych | BethelWellness Ltd
Exam Target:
Business Intelligence MBA
Year:
2025/2026
Format:
55 Questions with Verified Answers and Rationales
>
Author's Note:
This document is an original work produced for the CrashCourses Professional Study Series.
Clinical questions and professional scenarios were composed by Dr Z. Moomba based on current
exam objectives, published guidelines, and evidence-based sources (2024–2025). All patient
names, ages, and case details are fictional. Any resemblance to existing published Q&A banks is
coincidental. For personal study use only — not for reproduction or redistribution.
SECTION A — FOUNDATIONS
Question 1
A global retail company is migrating its legacy data systems to a modern architecture. The Chief
Data Officer wants a solution that can store vast amounts of structured, semi-structured, and
unstructured raw data without needing to define the schema upon ingestion. Which architectural
component is most appropriate for this requirement?
A) Enterprise Data Warehouse
B) Data Lake
C) OLAP Cube
D) Operational Data Store
,Answer: B
Rationale:
a) A Data Lake is designed to store massive volumes of raw data in its native format until it is
needed, supporting structured, semi-structured, and unstructured data.
b) The key discriminating feature is "schema-on-read" (no need to define schema upon ingestion)
as opposed to "schema-on-write" used in data warehouses.
c) An Enterprise Data Warehouse (A) fails because it requires data to be structured and
transformed (ETL) before loading (schema-on-write).
d) Examiner Pearl: Data lakes are highly cost-effective for raw storage but risk becoming "data
swamps" without proper metadata management and governance [DAMA-DMBOK 2nd Ed].
Question 2
A regional bank processes thousands of ATM transactions, wire transfers, and account updates
per minute. The system handling these workloads must ensure ACID (Atomicity, Consistency,
Isolation, Durability) properties to maintain data integrity. What type of system is this?
A) OLAP
B) OLTP
C) Data Lakehouse
D) Master Data Management (MDM)
Answer: B
Rationale:
a) Online Transaction Processing (OLTP) systems are optimized for managing high volumes of
short, fast transactional data requiring strict ACID compliance.
b) The presence of "thousands of transactions per minute" and the strict requirement for "ACID
properties" directly points to an operational database rather than an analytical one.
c) OLAP (A) is incorrect because it is optimized for complex queries and read-heavy analytical
workloads, not rapid, concurrent transactional writes.
d) Examiner Pearl: Remember the distinction: OLTP is for running the business (fast writes),
whereas OLAP is for understanding the business (fast reads of historical data) [Kimball 2013].
Question 3
,When designing a dimensional model for a healthcare provider's patient admissions, the data
engineering team creates a central table containing measurable metrics such as "length of stay,"
"admission cost," and "treatment duration." What is this central table called?
A) Dimension Table
B) Bridge Table
C) Fact Table
D) Snowflake Table
Answer: C
Rationale:
a) A Fact Table in dimensional modeling sits at the center of a star schema and contains the
quantitative, measurable data (facts) about a business event.
b) The metrics mentioned ("length of stay," "admission cost") are numeric, additive, or semi-
additive measurements, which define a fact table's contents.
c) A Dimension Table (A) fails because it contains descriptive attributes (who, what, where, when)
used to filter and group the facts, not the numerical measurements themselves.
d) Examiner Pearl: Every fact table should be designed with a declared "grain," which represents
the lowest level of detail captured by a single row in the table [Kimball Group 2025].
Question 4
A supply chain director wants to transition from traditional nightly batch processing to a modern
ELT (Extract, Load, Transform) approach utilizing cloud data warehouses like Snowflake or
BigQuery. What is the primary advantage of ELT over traditional ETL?
A) It performs data transformations on a separate, dedicated on-premises server.
B) It leverages the scalable compute power of the target data warehouse to perform
transformations.
C) It prevents raw, untransformed data from ever landing in the data warehouse.
D) It enforces a strict relational schema before data can be extracted from the source.
Answer: B
Rationale:
a) ELT loads raw data directly into the target cloud data warehouse and then uses the warehouse's
massively parallel processing (MPP) capabilities to transform the data.
, b) The key feature is leveraging the scalable, elastic compute power of modern cloud platforms to
handle heavy transformations post-loading.
c) Option C fails because the defining characteristic of ELT is exactly the opposite: raw data does
land in the data warehouse before transformation.
d) Examiner Pearl: ELT has become the dominant paradigm in 2025 due to the separation of
compute and storage in cloud data warehouses, lowering the cost of storing raw data [AWS Data
Analytics 2025].
Question 5
A marketing analyst is building a dashboard to track the success of a new email campaign. They
decide to use a Star Schema for their dataset. Which of the following is a key characteristic of a
Star Schema?
A) Dimension tables are highly normalized into multiple related tables.
B) It is optimized for high-speed transaction processing.
C) Dimension tables are denormalized and connected directly to a central fact table.
D) It relies heavily on complex join operations across dozens of tables for simple queries.
Answer: C
Rationale:
a) A Star Schema features a central fact table surrounded by denormalized dimension tables,
resembling a star shape.
b) Denormalization of dimension tables (storing redundant descriptive data in a single table) is the
hallmark of a Star Schema, speeding up read performance.
c) Option A describes a Snowflake Schema, where dimensions are normalized to save space, at
the cost of query complexity.
d) Examiner Pearl: While Snowflake schemas save storage space, Star schemas are heavily
preferred in modern BI tools (like Power BI) because the simplified joins drastically improve query
performance [Microsoft Power BI Architecture 2025].
Question 6
A SaaS company is defining its performance metrics. They establish a metric measuring the
number of qualified sales leads generated this month to predict future revenue. What type of
indicator is "qualified sales leads" in this context?
A) Lagging Indicator
Complete Study Guide
Series:
CrashCourses Professional Study Series
Author:
Dr Z. Moomba, MBChB, MRCPsych | BethelWellness Ltd
Exam Target:
Business Intelligence MBA
Year:
2025/2026
Format:
55 Questions with Verified Answers and Rationales
>
Author's Note:
This document is an original work produced for the CrashCourses Professional Study Series.
Clinical questions and professional scenarios were composed by Dr Z. Moomba based on current
exam objectives, published guidelines, and evidence-based sources (2024–2025). All patient
names, ages, and case details are fictional. Any resemblance to existing published Q&A banks is
coincidental. For personal study use only — not for reproduction or redistribution.
SECTION A — FOUNDATIONS
Question 1
A global retail company is migrating its legacy data systems to a modern architecture. The Chief
Data Officer wants a solution that can store vast amounts of structured, semi-structured, and
unstructured raw data without needing to define the schema upon ingestion. Which architectural
component is most appropriate for this requirement?
A) Enterprise Data Warehouse
B) Data Lake
C) OLAP Cube
D) Operational Data Store
,Answer: B
Rationale:
a) A Data Lake is designed to store massive volumes of raw data in its native format until it is
needed, supporting structured, semi-structured, and unstructured data.
b) The key discriminating feature is "schema-on-read" (no need to define schema upon ingestion)
as opposed to "schema-on-write" used in data warehouses.
c) An Enterprise Data Warehouse (A) fails because it requires data to be structured and
transformed (ETL) before loading (schema-on-write).
d) Examiner Pearl: Data lakes are highly cost-effective for raw storage but risk becoming "data
swamps" without proper metadata management and governance [DAMA-DMBOK 2nd Ed].
Question 2
A regional bank processes thousands of ATM transactions, wire transfers, and account updates
per minute. The system handling these workloads must ensure ACID (Atomicity, Consistency,
Isolation, Durability) properties to maintain data integrity. What type of system is this?
A) OLAP
B) OLTP
C) Data Lakehouse
D) Master Data Management (MDM)
Answer: B
Rationale:
a) Online Transaction Processing (OLTP) systems are optimized for managing high volumes of
short, fast transactional data requiring strict ACID compliance.
b) The presence of "thousands of transactions per minute" and the strict requirement for "ACID
properties" directly points to an operational database rather than an analytical one.
c) OLAP (A) is incorrect because it is optimized for complex queries and read-heavy analytical
workloads, not rapid, concurrent transactional writes.
d) Examiner Pearl: Remember the distinction: OLTP is for running the business (fast writes),
whereas OLAP is for understanding the business (fast reads of historical data) [Kimball 2013].
Question 3
,When designing a dimensional model for a healthcare provider's patient admissions, the data
engineering team creates a central table containing measurable metrics such as "length of stay,"
"admission cost," and "treatment duration." What is this central table called?
A) Dimension Table
B) Bridge Table
C) Fact Table
D) Snowflake Table
Answer: C
Rationale:
a) A Fact Table in dimensional modeling sits at the center of a star schema and contains the
quantitative, measurable data (facts) about a business event.
b) The metrics mentioned ("length of stay," "admission cost") are numeric, additive, or semi-
additive measurements, which define a fact table's contents.
c) A Dimension Table (A) fails because it contains descriptive attributes (who, what, where, when)
used to filter and group the facts, not the numerical measurements themselves.
d) Examiner Pearl: Every fact table should be designed with a declared "grain," which represents
the lowest level of detail captured by a single row in the table [Kimball Group 2025].
Question 4
A supply chain director wants to transition from traditional nightly batch processing to a modern
ELT (Extract, Load, Transform) approach utilizing cloud data warehouses like Snowflake or
BigQuery. What is the primary advantage of ELT over traditional ETL?
A) It performs data transformations on a separate, dedicated on-premises server.
B) It leverages the scalable compute power of the target data warehouse to perform
transformations.
C) It prevents raw, untransformed data from ever landing in the data warehouse.
D) It enforces a strict relational schema before data can be extracted from the source.
Answer: B
Rationale:
a) ELT loads raw data directly into the target cloud data warehouse and then uses the warehouse's
massively parallel processing (MPP) capabilities to transform the data.
, b) The key feature is leveraging the scalable, elastic compute power of modern cloud platforms to
handle heavy transformations post-loading.
c) Option C fails because the defining characteristic of ELT is exactly the opposite: raw data does
land in the data warehouse before transformation.
d) Examiner Pearl: ELT has become the dominant paradigm in 2025 due to the separation of
compute and storage in cloud data warehouses, lowering the cost of storing raw data [AWS Data
Analytics 2025].
Question 5
A marketing analyst is building a dashboard to track the success of a new email campaign. They
decide to use a Star Schema for their dataset. Which of the following is a key characteristic of a
Star Schema?
A) Dimension tables are highly normalized into multiple related tables.
B) It is optimized for high-speed transaction processing.
C) Dimension tables are denormalized and connected directly to a central fact table.
D) It relies heavily on complex join operations across dozens of tables for simple queries.
Answer: C
Rationale:
a) A Star Schema features a central fact table surrounded by denormalized dimension tables,
resembling a star shape.
b) Denormalization of dimension tables (storing redundant descriptive data in a single table) is the
hallmark of a Star Schema, speeding up read performance.
c) Option A describes a Snowflake Schema, where dimensions are normalized to save space, at
the cost of query complexity.
d) Examiner Pearl: While Snowflake schemas save storage space, Star schemas are heavily
preferred in modern BI tools (like Power BI) because the simplified joins drastically improve query
performance [Microsoft Power BI Architecture 2025].
Question 6
A SaaS company is defining its performance metrics. They establish a metric measuring the
number of qualified sales leads generated this month to predict future revenue. What type of
indicator is "qualified sales leads" in this context?
A) Lagging Indicator
