Chapter 37 Flashcards

1
Q

What does that mean when we say data is horizontally wide

A

There are many columns

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What does that mean when we say data is vertically wide

A

tens of thousands of rows

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is ETL_A

A

Agriculture Economic Threshold Level

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are the 3 phases in building DWH

A
  1. Planning and Design
  2. Building and Testing
  3. Roll-Out and Maintenance
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is dimensional modeling

A

Dimensional modeling is a technique used to model databases for analytical applications.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What schema is simplified in nature in DSS world

A

star schema

How well did you know this?
1
Not at all
2
3
4
5
Perfectly