ExamPark
Course menuDEA-C01

Exams / DEA-C01 / Redshift Spectrum, federated queries and materialized views / Question 1

DEA-C01 practice question: Redshift Spectrum, federated queries and materialized views (1 of 2)

Data Store Management A free question from our original DEA-C01 practice exam. Try it, then open the answer to see why each option is right or wrong.

Last verified against current AWS documentation ·How we write our questions

A ski resort group keeps live lift-pass account data in an Amazon Aurora PostgreSQL database. Three years of ride logs sit in Amazon S3 in Parquet format and are queried through Amazon Redshift Spectrum.

Each Monday, the finance team needs one report that joins current account status from Aurora with the ride logs in S3. The account data changes during the week, and the team does not want a nightly copy of the operational database.

Which approach meets these requirements?

Choose one answer.

  1. A. Create an external schema with a secret for the Aurora credentials, then run one query joining live Aurora and Spectrum tables.
  2. B. Use AWS DMS to copy the Aurora tables into Redshift every night, and run the report against the copies with the Spectrum external tables.
  3. C. Export the Aurora tables to CSV each Monday with a manual query, upload them to S3, and join the files with the ride logs in Spectrum.
  4. D. Connect Amazon Athena to Aurora with a JDBC connection, and move the ride logs into the Aurora database as a table before the report runs.
Show the answer and explanation

Answer: A

  • A. Right: Correct. Redshift federated queries read the Aurora tables live through an external schema, and Spectrum reads the Parquet logs in S3. One query joins both sources, so no nightly copy or manual export is needed. Learn more: Querying data with federated queries in Amazon Redshift (opens in a new tab)
  • B. Wrong: A nightly copy works, but the account data is stale for most of the week, and the team asked to avoid copying the operational database. The option therefore misses a stated requirement.
  • C. Wrong: Manual exports are slow and error-prone, and the data is a copy taken at export time. The option adds weekly work that the team wants to remove.
  • D. Wrong: Moving three years of logs into the operational database adds load and storage to the system the team wants to protect. The option also changes the data layout more than the report requires.

Explanation

Federated queries let Redshift read live operational data in Aurora PostgreSQL, while Spectrum reads the Parquet logs in S3, so one query can join both. The credentials stay in Secrets Manager through a secret reference. Nightly copies, manual exports and moving logs into the operational database each add a copy or a manual step.

Study

Keep practicing

Answer questions with a score at the end, or practice just this topic with the explanation after each one. No sign-up needed.

Take the free DEA-C01 practice examPractice Redshift Spectrum, federated queries and materialized viewsAll Redshift Spectrum, federated queries and materialized views questions

Want more on Redshift Spectrum, federated queries and materialized views? The 5 full-length practice sets have 10 more Redshift Spectrum, federated queries and materialized views questions, 325 in all, none of them in the free exam. One payment of $14.99, no subscription. See the practice sets