Câu 53: AWS Certified Data Engineer - Associate DEA-C01

A company's data engineer needs to optimize the performance of table SQL queries. The company stores data in an Amazon Redshift cluster. The data engineer cannot increase the size of the cluster because of budget constraints. The company stores the data in multiple tables and loads the data by using the EVEN distribution style. Some tables are hundreds of gigabytes in size. Other tables are less than 10 MB in size. Which solution will meet these requirements?

1. A. Keep using the EVEN distribution style for all tables. Specify primary and foreign keys for all tables.
2. B. Use the ALL distribution style for large tables. Specify primary and foreign keys for all tables.
3. C. Use the ALL distribution style for rarely updated small tables. Specify primary and foreign keys for all tables. — đáp án hiện tại
4. D. Specify a combination of distribution, sort, and partition keys for all tables.