DEA-C01 practice question 20 of 25

A company maintains an Amazon Redshift provisioned cluster that the company uses for extract, transform, and load (ETL) operations to support…

Choose your answer, then check it against the explanation.

A company maintains an Amazon Redshift provisioned cluster that the company uses for extract, transform, and load (ETL) operations to support critical analysis tasks. A sales team within the company maintains a Redshift cluster that the sales team uses for business intelligence (BI) tasks. The sales team recently requested access to the data that is in the ETL Redshift cluster so the team can perform weekly summary analysis tasks. The sales team needs to join data from the ETL cluster with data that is in the sales team's BI cluster. The company needs a solution that will share the ETL cluster data with the sales team without interrupting the critical analysis tasks. The solution must minimize usage of the computing resources of the ETL cluster. Which solution will meet these requirements?

Answer options

Correct Answer:

Explanation

Amazon Redshift data sharing is the most precise solution for this scenario. It allows the ETL cluster (producer) to share live, read-only data with the sales team's BI cluster (consumer). The key benefit is workload isolation: all queries from the sales team run on their own BI cluster's compute resources. This directly fulfills the requirement to minimize resource usage on the critical ETL cluster and prevents any interruption to its primary tasks. The sales team can also join the shared data with their local tables, meeting all specified needs without data duplication or movement.

References

1. Amazon Redshift Database Developer Guide. (n.d.). Sharing data across clusters in Amazon Redshift. AWS.

Section: "Overview of data sharing in Amazon Redshift"

Content: "With Amazon Redshift data sharing

you can securely and easily share live data across Amazon Redshift clusters... Data sharing queries that access shared data run on the consumer cluster. They don't affect the performance of the producer cluster." This directly supports the choice of option A.

2. Amazon Redshift Database Developer Guide. (n.d.). Workload isolation. AWS.

Section: "Data sharing for workload isolation"

Content: "You can isolate different workloads while providing access to the same data... For example

you can set up a central ETL cluster... and a consumer cluster for BI... The BI queries run on the consumer cluster and don't affect the performance of the ETL cluster." This describes the exact scenario and solution in the question.

3. Amazon Redshift Database Developer Guide. (n.d.). UNLOAD. AWS.

Section: "UNLOAD" command syntax and description.

Content: The documentation describes UNLOAD as a command that reads data from the database and writes it to files. This operation is executed by and consumes the resources of the cluster where the command is run

which refutes the resource minimization goal in option D.

Question 20 of 25

Keep practicing

Take the free DEA-C01 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test