AWS Certified Data Engineer - Associate DEA-C01Demo

By Amazon · Question Mode

QuestionQ308

Data Operations and Support

A retail company keeps transaction, store-location, and customer-information tables on four reserved ra3.4xlarge Amazon Redshift cluster nodes. All three tables use even table distribution.

The company updates the store-location table only once or twice every few years.

A data engineer observes that Redshift queues are slowing because the entire store-location table is repeatedly broadcast to all four compute nodes for most queries. The data engineer wants to improve query performance by minimizing broadcasts of the store-location table.

Which solution meets these requirements in the MOST cost-effective way?

  • A Change the distribution style of the store location table from EVEN distribution to ALL distribution.
  • B Change the distribution style of the store location table to KEY distribution based on the column that has the highest dimension.
  • C Add a join column named store_id into the sort key for all the tables.
  • D Upgrade the Redshift reserved node to a larger instance size in the same instance family.
Explanation

Amazon Redshift DISTSTYLE ALL places a complete copy of a table on every compute node, so joins can use the store-location rows locally instead of broadcasting the table during query execution. Although this distribution style increases storage, load, and maintenance costs, it is well suited to an infrequently updated table and avoids recurring query-time data movement.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!