HFMA
Certified Specialist Business Intelligence
Complete Exam Review
(With Solutions)
2026
1
,1. Case: A regional health system faces declining inpatient volumes but
rising outpatient activity. Which strategic industry trend should leaders
prioritize to align services and preserve margin?
- A. Expand inpatient bed capacity
- B. Invest in ambulatory care platforms and value‑based care
capabilities
- C. Reduce outpatient hours to cut costs
- D. Eliminate population health programs
Answer: B. Invest in ambulatory care platforms and value‑based care
capabilities
Rationale: Industry shift toward outpatient care and value‑based
reimbursement requires investment in ambulatory access and population
health to sustain revenue and manage total cost of care.
2. Case: A hospital wants to improve throughput and reduce length of
stay. Which operational metric from business of providing healthcare
services best links clinical flow to financial performance?
- A. Patient satisfaction only
- B. Average length of stay (ALOS) and case mix–adjusted bed
occupancy rate
- C. Number of cafeteria meals served
- D. Number of parking violations
Answer: B. Average length of stay (ALOS) and case mix–adjusted bed
occupancy rate
Rationale: ALOS and occupancy, adjusted for case mix, directly affect
capacity, variable cost per case, and revenue opportunities.
3. Case: A BI team must choose a data model to support near‑real‑time
operational dashboards. Which discipline principle is most important
when selecting the architecture?
- A. Aesthetic design only
- B. Data latency, governance, and scalability to support operational
decision cycles
2
, - C. Use spreadsheets exclusively
- D. Ignore data lineage
Answer: B. Data latency, governance, and scalability to support
operational decision cycles
Rationale: BI discipline requires architecture that balances timeliness,
data quality, and scalability for reliable operational insights.
4. Case: A BI developer needs to join large encounter and cost tables for
analytics. Which technical skill is most critical to ensure performant
queries?
- A. Knowledge of advanced SQL joins, indexing strategies, and query
optimization
- B. Ability to write long Excel macros only
- C. Manual copy‑paste of datasets
- D. Use of unindexed full table scans for every query
Answer: A. Knowledge of advanced SQL joins, indexing strategies, and
query optimization
Rationale: Efficient SQL and indexing are essential to process large
healthcare datasets with acceptable performance.
5. Case: A BI analyst is asked to evaluate whether a new care pathway
reduces readmissions. Which quantitative approach best isolates the
pathway effect?
- A. Simple pre/post comparison without controls
- B. Difference‑in‑differences analysis with matched control cohort and
risk adjustment
- C. Anecdotal clinician reports only
- D. Random selection of unrelated metrics
Answer: B. Difference‑in‑differences analysis with matched control
cohort and risk adjustment
Rationale: DID with matching and adjustment controls for secular
trends and confounding, improving causal inference.
6. Case: A change management consultant must secure clinician adoption
3
Certified Specialist Business Intelligence
Complete Exam Review
(With Solutions)
2026
1
,1. Case: A regional health system faces declining inpatient volumes but
rising outpatient activity. Which strategic industry trend should leaders
prioritize to align services and preserve margin?
- A. Expand inpatient bed capacity
- B. Invest in ambulatory care platforms and value‑based care
capabilities
- C. Reduce outpatient hours to cut costs
- D. Eliminate population health programs
Answer: B. Invest in ambulatory care platforms and value‑based care
capabilities
Rationale: Industry shift toward outpatient care and value‑based
reimbursement requires investment in ambulatory access and population
health to sustain revenue and manage total cost of care.
2. Case: A hospital wants to improve throughput and reduce length of
stay. Which operational metric from business of providing healthcare
services best links clinical flow to financial performance?
- A. Patient satisfaction only
- B. Average length of stay (ALOS) and case mix–adjusted bed
occupancy rate
- C. Number of cafeteria meals served
- D. Number of parking violations
Answer: B. Average length of stay (ALOS) and case mix–adjusted bed
occupancy rate
Rationale: ALOS and occupancy, adjusted for case mix, directly affect
capacity, variable cost per case, and revenue opportunities.
3. Case: A BI team must choose a data model to support near‑real‑time
operational dashboards. Which discipline principle is most important
when selecting the architecture?
- A. Aesthetic design only
- B. Data latency, governance, and scalability to support operational
decision cycles
2
, - C. Use spreadsheets exclusively
- D. Ignore data lineage
Answer: B. Data latency, governance, and scalability to support
operational decision cycles
Rationale: BI discipline requires architecture that balances timeliness,
data quality, and scalability for reliable operational insights.
4. Case: A BI developer needs to join large encounter and cost tables for
analytics. Which technical skill is most critical to ensure performant
queries?
- A. Knowledge of advanced SQL joins, indexing strategies, and query
optimization
- B. Ability to write long Excel macros only
- C. Manual copy‑paste of datasets
- D. Use of unindexed full table scans for every query
Answer: A. Knowledge of advanced SQL joins, indexing strategies, and
query optimization
Rationale: Efficient SQL and indexing are essential to process large
healthcare datasets with acceptable performance.
5. Case: A BI analyst is asked to evaluate whether a new care pathway
reduces readmissions. Which quantitative approach best isolates the
pathway effect?
- A. Simple pre/post comparison without controls
- B. Difference‑in‑differences analysis with matched control cohort and
risk adjustment
- C. Anecdotal clinician reports only
- D. Random selection of unrelated metrics
Answer: B. Difference‑in‑differences analysis with matched control
cohort and risk adjustment
Rationale: DID with matching and adjustment controls for secular
trends and confounding, improving causal inference.
6. Case: A change management consultant must secure clinician adoption
3
