A data engineer at a retail company needs to run aws video
data-engineer video for a data engineer at a retail company needs to run complex queries on large datasets stored in Amazon Redshift. These queries often
Answer
Full Certification Question
A data engineer at a retail company needs to run complex queries on large datasets stored in Amazon Redshift. These queries often involve aggregating data from specific columns rather than all columns in a table. The engineer is looking for a way to optimize query performance. Which of the following Amazon Redshift features will provide the best optimization for the engineer's use case?