New Year Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ac4s65

A company has a data processing pipeline that runs multiple SQL queries in sequence against...

Amazon Web Services Data-Engineer-Associate Full Course Access
Amazon Web Services Data-Engineer-Associate View All Questions

A company has a data processing pipeline that runs multiple SQL queries in sequence against an Amazon Redshift cluster. After a merger, a query joining two large sales tables becomes slow. Table S1 has 10 billion records, Table S2 has 900 million records.

The query performance must improve.

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 PDF/Engine
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions
buy now Data-Engineer-Associate pdf
Get 65% Discount on All Products, Use Coupon: "ac4s65"
Next
A data engineer is configuring an AWS Glue job to read data from an Amazon...
A financial company recently added more features to its mobile app.
Previous