
Ultimate access to all questions.
In a scenario where you need to perform complex data aggregations on a large dataset stored in Amazon Redshift, what strategies would you employ to optimize the performance of these aggregations? Consider the use of indexes, distribution styles, and sorting keys.
A
Increase the number of nodes in the Redshift cluster to improve aggregation performance.
B
Use appropriate distribution styles and sorting keys to optimize data layout.
C
Create indexes on the columns used in aggregation queries.
D
Use AWS Glue to preprocess and aggregate data before loading into Redshift.