CSBI CERTIFIED SPECIALIST BUSINESS
INTELLIGENCE: COMPLETE 100-
QUESTION PRACTICE EXAM WITH
ANSWER RATIONALES (2026/2027
CURRICULUM) | VERIFIED ANSWERS
ALREADY GRADED A+
Question 1: Healthcare Analytics Transformation
What has changed most significantly for healthcare analytics in recent years?
A) Decreased computing power and increased costs
B) Increased computing power and storage with decreased costs, increased data
abundance, and more individuals with strong competencies
C) Reduced availability of healthcare data
D) Elimination of data privacy requirements
Correct Answer: B
Rationale: Healthcare analytics has been transformed by three key changes: (1)
increased computing power and storage with decreased costs, (2) increased
abundance of data in healthcare, and (3) an increase in individuals having strong
analytical competencies.
Question 2: Big Data Definition
Which of the following best defines "Big Data" in the healthcare context?
A) Data that is too small to be meaningful
B) The growth in available data, massive continually increasing volume of live and
stored data for analysis, and the increase in tools available for sophisticated analysis
C) Data that only comes from clinical sources
D) Data that cannot be stored electronically
,Correct Answer: B
Rationale: Big Data refers to the growth in available data, the massive continually
increasing volume of live and stored data for analysis, and the increase in tools
available for highly sophisticated ways to analyze it.
Question 3: Analytics Classification
A hospital system notices a 15% increase in 30-day readmissions. The BI team
creates a dashboard showing historical readmission trends by diagnosis,
physician, and discharge disposition. Which category of analytics does this
represent?
A) Predictive analytics
B) Prescriptive analytics
C) Descriptive analytics
D) Cognitive analytics
Correct Answer: C
Rationale: The team is analyzing historical data to understand what has already
happened—the defining characteristic of descriptive analytics. Predictive analytics
would forecast future readmission probabilities, while prescriptive analytics would
recommend interventions.
Question 4: Data Quality
Quality data must satisfy requirements including accuracy, completeness,
relevance, understanding, and trust. Which characteristic refers to mapping to
the "real world"?
A) Completeness
B) Relevance
C) Accuracy
D) Trustworthiness
Correct Answer: C
,Rationale: Data accuracy means mapping to the "real world." It has two
characteristics: form and content.
Question 5: Data Architecture
A BI architect must support 5 years of daily sales data (≈9 billion rows) with
frequent year-over-year queries. The CIO insists the model must be business-
friendly and performant. What is the most appropriate schema?
A) Third-normal-form (3NF) relational design
B) Star schema with conformed dimensions
C) Data Vault 2.0 ensemble model
D) Fully denormalized flat table
Correct Answer: B
Rationale: Kimball's star schema is purpose-built for large-scale, time-series
analytics; conformed dimensions guarantee semantic consistency across business
processes. 3NF favors OLTP integrity, not OLAP performance. Data Vault requires
additional marts for consumption.
Question 6: Data Quality Improvement Steps
A hospital's data-quality scorecard shows 4% of patient records have invalid ZIP
codes. Which data-profiling step is the immediate next action in the
governance process?
A) Define a business rule in the data-quality SLA
B) Root-cause analysis with column-pattern profiling
C) Mask the ZIP column for HIPAA compliance
D) Delete records to improve the score
Correct Answer: B
Rationale: DAMA-DMBOK prescribes root-cause profiling before remediation.
Profiling reveals whether the issue is upstream system entry, reference-data gaps, or
ETL mapping errors.
, Question 7: HIPAA Purpose
What does HIPAA primarily govern?
A) Hospital staffing requirements
B) How Protected Health Information (PHI) is protected and handled
C) Medical device regulations
D) Pharmaceutical pricing
Correct Answer: B
Rationale: HIPAA (Health Insurance Portability and Accountability Act) covers how
Protected Health Information (PHI) is protected and handled, establishing national
standards for the security and privacy of health information.
Question 8: Productivity Assessment
Productivity is generally assessed by:
A) Benchmarking how many inputs are required
B) Looking at the raw number of increased products and services offered
C) Looking at the ratio of outputs to inputs
D) Looking at market share
Correct Answer: C
Rationale: Productivity is assessed by the ratio of outputs to inputs. The three
general ways to assess productivity are partial productivity (output against a specific
input), multifactor productivity (output to a group of inputs), and total productivity
(broadest measure including all inputs).
Question 9: Big Data Characteristics
Which of the following is NOT one of the five core characteristics of Big Data?
INTELLIGENCE: COMPLETE 100-
QUESTION PRACTICE EXAM WITH
ANSWER RATIONALES (2026/2027
CURRICULUM) | VERIFIED ANSWERS
ALREADY GRADED A+
Question 1: Healthcare Analytics Transformation
What has changed most significantly for healthcare analytics in recent years?
A) Decreased computing power and increased costs
B) Increased computing power and storage with decreased costs, increased data
abundance, and more individuals with strong competencies
C) Reduced availability of healthcare data
D) Elimination of data privacy requirements
Correct Answer: B
Rationale: Healthcare analytics has been transformed by three key changes: (1)
increased computing power and storage with decreased costs, (2) increased
abundance of data in healthcare, and (3) an increase in individuals having strong
analytical competencies.
Question 2: Big Data Definition
Which of the following best defines "Big Data" in the healthcare context?
A) Data that is too small to be meaningful
B) The growth in available data, massive continually increasing volume of live and
stored data for analysis, and the increase in tools available for sophisticated analysis
C) Data that only comes from clinical sources
D) Data that cannot be stored electronically
,Correct Answer: B
Rationale: Big Data refers to the growth in available data, the massive continually
increasing volume of live and stored data for analysis, and the increase in tools
available for highly sophisticated ways to analyze it.
Question 3: Analytics Classification
A hospital system notices a 15% increase in 30-day readmissions. The BI team
creates a dashboard showing historical readmission trends by diagnosis,
physician, and discharge disposition. Which category of analytics does this
represent?
A) Predictive analytics
B) Prescriptive analytics
C) Descriptive analytics
D) Cognitive analytics
Correct Answer: C
Rationale: The team is analyzing historical data to understand what has already
happened—the defining characteristic of descriptive analytics. Predictive analytics
would forecast future readmission probabilities, while prescriptive analytics would
recommend interventions.
Question 4: Data Quality
Quality data must satisfy requirements including accuracy, completeness,
relevance, understanding, and trust. Which characteristic refers to mapping to
the "real world"?
A) Completeness
B) Relevance
C) Accuracy
D) Trustworthiness
Correct Answer: C
,Rationale: Data accuracy means mapping to the "real world." It has two
characteristics: form and content.
Question 5: Data Architecture
A BI architect must support 5 years of daily sales data (≈9 billion rows) with
frequent year-over-year queries. The CIO insists the model must be business-
friendly and performant. What is the most appropriate schema?
A) Third-normal-form (3NF) relational design
B) Star schema with conformed dimensions
C) Data Vault 2.0 ensemble model
D) Fully denormalized flat table
Correct Answer: B
Rationale: Kimball's star schema is purpose-built for large-scale, time-series
analytics; conformed dimensions guarantee semantic consistency across business
processes. 3NF favors OLTP integrity, not OLAP performance. Data Vault requires
additional marts for consumption.
Question 6: Data Quality Improvement Steps
A hospital's data-quality scorecard shows 4% of patient records have invalid ZIP
codes. Which data-profiling step is the immediate next action in the
governance process?
A) Define a business rule in the data-quality SLA
B) Root-cause analysis with column-pattern profiling
C) Mask the ZIP column for HIPAA compliance
D) Delete records to improve the score
Correct Answer: B
Rationale: DAMA-DMBOK prescribes root-cause profiling before remediation.
Profiling reveals whether the issue is upstream system entry, reference-data gaps, or
ETL mapping errors.
, Question 7: HIPAA Purpose
What does HIPAA primarily govern?
A) Hospital staffing requirements
B) How Protected Health Information (PHI) is protected and handled
C) Medical device regulations
D) Pharmaceutical pricing
Correct Answer: B
Rationale: HIPAA (Health Insurance Portability and Accountability Act) covers how
Protected Health Information (PHI) is protected and handled, establishing national
standards for the security and privacy of health information.
Question 8: Productivity Assessment
Productivity is generally assessed by:
A) Benchmarking how many inputs are required
B) Looking at the raw number of increased products and services offered
C) Looking at the ratio of outputs to inputs
D) Looking at market share
Correct Answer: C
Rationale: Productivity is assessed by the ratio of outputs to inputs. The three
general ways to assess productivity are partial productivity (output against a specific
input), multifactor productivity (output to a group of inputs), and total productivity
(broadest measure including all inputs).
Question 9: Big Data Characteristics
Which of the following is NOT one of the five core characteristics of Big Data?
