Free DATA-ENGINEER-ASSOCIATE Web TestEngine Demo

Q44 Multiple choice

A company has a data processing pipeline that runs multiple SQL queries in sequence against an Amazon Redshift cluster. The company merges with a second company. The original company modifies a query that aggregates sales revenue data to join sales tables from both companies. The sales table for the first company is named Table S1. The sales table for the second company is named Table S2. Table S1
contains 10 billion records. Table S2 contains 900 million records.
The query becomes slow after the modification. A data engineer must improve the query performance.

Which solutions will meet these requirements? (Choose two.)

Select all that apply.

A
Use the KEY distribution style for both sales tables. Select a low cardinality column to use for the join.
B
Use the KEY distribution style for both sales tables. Select a high cardinality column to use for the join.
C
Use the EVEN distribution style for Table S1. Use the ALL distribution style for Table S2.
D
Use the Amazon Redshift query optimizer to review and select optimizations to implement.
E
Use Amazon Redshift Advisor to review and select optimizations to implement.

DATA-ENGINEER-ASSOCIATE Web TestEngine demo