DEA-C01 · Question #97
DEA-C01 Question #97: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #97. The question stem and answer options stay visible for context.
Question
A retail company uses Amazon Aurora PostgreSQL to process and store live transactional data. The company uses an Amazon Redshift cluster for a data warehouse. An extract, transform, and load (ETL) job runs every morning to update the Redshift cluster with new data from the PostgreSQL database. The company has grown rapidly and needs to cost optimize the Redshift cluster. A data engineer needs to create a solution to archive historical data. The data engineer must be able to run analytics queries that effectively combine data from live transactional data in PostgreSQL, current data in Redshift, and archived historical data. The solution must keep only the most recent 15 months of data in Amazon Redshift to reduce costs. Which combination of steps will meet these requirements? (Choose two.)
Options
- AConfigure the Amazon Redshift Federated Query feature to query live transactional data that is in
- BConfigure Amazon Redshift Spectrum to query live transactional data that is in the PostgreSQL
- CSchedule a monthly job to copy data that is older than 15 months to Amazon S3 by using the
- DSchedule a monthly job to copy data that is older than 15 months to Amazon S3 Glacier Flexible
- ECreate a materialized view in Amazon Redshift that combines live, current, and historical data
Unlock DEA-C01 to see the answer
You've previewed enough free DEA-C01 questions. Unlock DEA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.