4. Health Data Analytics

Data Warehousing — Quiz

Test your understanding of data warehousing with 5 practice questions.

Practice Questions

Question 1

Which key is used in a star schema dimension table to uniquely identify records and remain stable over time?

Question 2

An emergency department fact table records one row per patient per day. If the average daily unique patient visits is 200, approximately how many rows will the fact table contain in one non-leap year?

Question 3

In a clinical data warehouse, which Slowly Changing Dimension (SCD) type retains full history by adding a new record for each change and timestamping rows?

Question 4

Which metadata component details the origin, transformations, and destination of data within a data warehouse, enabling audit and impact analysis?

Question 5

During ETL, which data quality check ensures that foreign key values in the fact table correspond to existing keys in dimension tables?