Engineering > EXAM > AWS Big Data Certification - Domain 4 – Analysis (All)

AWS Big Data Certification - Domain 4 – Analysis

Document Content and Description Below

AWS Big Data Certification - Domain 4 – Analysis FALSE - ANS-Redshift - All tables require a sortkey - true or false? EVEN (default), KEY, ALL - ANS-Redshift - Three distribution styles in table d ... esign 1 MB - ANS-Redshift - What is the default block size? Tracks min and max values for each block - ANS-Redshift - What is a Zone Map? Compound and Interleaved (and single-key) - ANS-Redshift - Two (3) types of sort keys Contains all columns in the sort key, highest weight given to first column - ANSRedshift - What is a Compound sort key Gives equal weight to all columns in the sort key - ANS-Redshift - What is an Interleaved sort key Joins, order by, group by, window functions - ANS-Redshift - What is a Compound sort key good for WHERE clause columns with one or more columns in sort key, multiple different queries, different filters - ANS-Redshift - What is an Interleaved sort key good for FALSE - only compound and single-column sort keys do - ANS-Redshift - Interleaved sort keys respect data loaded in order Compound - ANS-Redshift - What is the default sort key type VACUUM and ANALYZE - ANS-Redshift - What two operations should be performed if you have a compound sort key that's had a lot of data loaded over time and performance has diminished TRUE - ANS-Redshift - Data load and vacuum operations are slower with interleaved sort keys - true or false? FALSE - defined in bytes - ANS-Redshift - CHAR and VARCHAR data types are defined in characters - true or false?... [Show More]

Last updated: 3 years ago

Preview 1 out of 7 pages

Buy Now

Instant download

We Accept: