Quiz 2, Q7. A company utilizes Amazon Redshift

[drsparrow]

A company utilizes Amazon Redshift for its primary data warehousing needs tied to an e-commerce application. Recently, they added a new SQL report for their sales data, which needs to compare specific columns from this year’s sales against historical data. Data older than one year is stored in an Amazon S3 bucket. This new report has resulted in slower performance and increased query times. The company needs a solution to enhance system performance and speed up these queries.

What is the MOST efficient solution to meet these requirements?

The correct is:
Use the report’s SQL statement to retrieve data directly from Amazon S3. Save these results in a Redshift materialized view. Adjust the report to refresh using SQL REFRESH and then extract data from the materialized view.

This is once again a bit out of context because it does not say you are using Redshift Spectrum to query data in S3 in the answer, but rather “retrieve data directly from Amazon S3” which you cannot do.

I think the answer is missing the Redshift Spectrum part.