Database Data Engineering Fundamentals - Performance Optimisation

Question 1

_________________ Avoid Full table scan. Enforce data uniqueness and integrity

a) indexing
b)partitioning

Answer 1

Indexing

Question 2

________________ reduce amount of data scanned. Helps with data lifecycle management. Enables parallel processing.

a) indexing
b)partitioning

Answer 2

Partitioning

i.e by month without having to a full scan of the entire month. Then be able to move off old partitions over time.

Question 3

___________ speeds up data transfer, reduce storage and disk reads. Columnar compression.

a) Indexing
b) partitioning
c) Compression

Answer 3

Compression

Format for Redshift:
GZIP, LZOP, BZIP2, ZSTD