AHIC Data Analytics and Data Management 2

Question 1

Which data warehouse architecture pattern stores pre-aggregated data in subject-oriented structures to optimize query performance?

Accepted Answer

Star schema

Answer

Star schema stores fact tables surrounded by denormalized dimension tables, enabling fast OLAP query performance through pre-aggregation.

Question 2

A health system wants to predict patient readmission risk. Which machine learning approach is most appropriate when labeled outcome data is available?

Accepted Answer

Supervised classification

Answer

Supervised classification uses labeled historical data (readmitted vs. not) to train a model that predicts outcomes for new patients.

Question 3

In healthcare data governance, which role is primarily responsible for defining data quality standards and authorizing data access policies?

Accepted Answer

Data steward

Answer

Data stewards own the business definition, quality standards, and access policies for their assigned data domains.

Question 4

An analyst receives a dataset where patient age is recorded as '999' for unknown values. This is an example of which data quality dimension issue?

Accepted Answer

Lack of validity

Answer

Validity refers to data conforming to defined formats, ranges, and rules; '999' for age violates the valid range for a real patient age.

Question 5

Which SQL window function calculates a running total without collapsing rows into a single aggregate result?

Accepted Answer

SUM() OVER (ORDER BY ...)

Answer

SUM() OVER (ORDER BY ...) is a window function that computes a cumulative sum while retaining each individual row in the result set.

(AHIC) AMIA Health Informatics Certification Practice Test

(AHIC) AMIA Health Informatics Certification Practice Test

AHIC Data Analytics and Data Management 2