Report Studio

Query Studio

Analysis Studio

Metric Studio

Short and Fat

Long and Thin

Long and Fat

Short and thin

Clean Data

Dirty Data

Clean and Dirty Data

None of above

Type One

Type Two

Type Three

None of above

Unsorted data for Aggregator

Sorted data for Aggregator

Does not matter if we use Sorted or Unsorted data for Aggregation

None of the above

First load data into fact tables then dimension tables, then Aggregates if any

First load data into dimension tables, then fact tables, then Aggregates if any

First Aggregates then load data into dimension tables, then fact tables

Does not matter if we load either of fact, dimensions, or aggregates

Normalizing the data

Denormalizing the data

Both 1 & 2

None of the above

Self Join

Inner Join

Outter Join

Both 1 & 2

Normalized

Denormalized

none

All of the above

First level data mart

Second level data mart

All of these

None of Above

Similar Data

Isolated data

None of Above

Both 1& 2

First Step

Second Step

Third Step

Fourth Step

Fact table with no dimensions

Factless fact table

Fact table with two or three dimensions

Fact table with to many dimensions

They are different

They are either same or one is subset of another

When they can be compared mathematically

None of these

Transaction Number, bill of lading number, invoice number may be DD.

DD has no attributes

DD does not join to actual dimension table

All of the above are correct

Second level data mart

First level data mart

All of these

None of above

Similar Data

Isolated data

Unique data

None of Above

Clean Data

Dirty Data

Clean and Dirty Data

None of above

True

False

True

False