Home Library Explore SAT

Home Library Explore SAT

Data Warehouse Flashcards | StudBud

Explore/Data Warehouse

Data Warehouse

8 terms·StudBud Administration·11 plays

Designing and building BI solution

Flashcards8 cardsFPractice quizPHost liveL

Questions 8

Answers

1
SCD Type 0
No History. Update record directly.
Keeping history, row versioning
Fixed Dimension. No changes allowed, dimension never changes
Keeping history, previous value column
2
SCD Type 3
No History. Update record directly.
Keeping history, previous value column
Fixed Dimension. No changes allowed, dimension never changes
Keeping history, row versioning
3
OLAP databases are optimized for______________
low write and low read workloads.
heavy write, low read workloads.
heavy read, low write workloads.
heavy read and heavy write workloads.
4
SCD Type 1
Fixed Dimension. No changes allowed, dimension never changes
Keeping history, previous value column
No History. Update record directly.
Keeping history, row versioning
5
OLTP is a ___________
batch processing system
real-time processing system
6
Why BI?
Support better decision making
Design beautiful reports
Reshape your data
Collect and store data
7
SCD Type 2
Fixed Dimension. No changes allowed, dimension never changes
Keeping history, row versioning
No History. Update record directly.
Keeping history, previous value column
8
SSBI is to _____________
allow skilled & experienced teams to perform data analytics
allow less tech-savvy end users to perform data analytics