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.)
lalitjhawar
Highly Voted 9 months agoPalee
Most Recent 2 days, 18 hours agoVidhi212
3 months, 1 week agoSambitParida
3 months, 1 week agorsmf
4 months, 3 weeks agomohamedTR
5 months, 1 week agoHunkyBunky
9 months agoartworkad
9 months agotgv
9 months agoGHill1982
9 months ago