Multiple choice technology

A Conformed Dimension is

  1. Created along with other dimension

  2. Does not have a primary key

  3. Used to join two Schemas

  4. Used to Join two Fact Table

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A conformed dimension is a dimension table with the same meaning and content across multiple fact tables in a data warehouse. It enables drill-across analysis by allowing different fact tables to be joined through the shared dimension, ensuring consistency in reporting. Option A is incorrect as conformed dimensions are not created together but are designed to be compatible. Option B is wrong as all dimensions have primary keys. Option C is vague.