Q20 — AWS DEA-C01 Ch.1

Question 20 of 100 | ← Chapter 1

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?

• A. Set up the sales team BI cluster as a consumer of the ETL cluster by using Redshift data sharing. ✓
• B. Create materialized views based on the sales team's requirements. Grant the sales team direct access to the ETL cluster.
• C. Create database views based on the sales team's requirements. Grant the sales team direct access to the ETL cluster.
• D. Unload a copy of the data from the ETL cluster to an Amazon S3 bucket every week. Create an Amazon Redshift Spectrum table based On the content of the ETL cluster.

Correct Answer: A. Set up the sales team BI cluster as a consumer of the ETL cluster by using Redshift data sharing.

Explanation

答案A正确。Redshift数据共享功能允许一个集群（如销售团队的BI集群）成为另一个集群（ETL集群）的数据消费者，这样可以在不中断ETL集群关键分析任务的情况下共享数据，同时能最小化ETL集群计算资源的使用。B选项直接授予销售团队对ETL集群的直接访问可能会干扰关键分析任务，并可能带来安全风险。C选项创建数据库视图并直接授予访问权限也存在类似的问题。D选项每周将数据卸载到S3桶并创建RedshiftSpectrum表，过程较为繁琐，且可能影响数据的及时性。综上，A选项是符合要求的解决方案。