Topic 1 Question 24
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?
Set up the sales team BI cluster as a consumer of the ETL cluster by using Redshift data sharing.
Create materialized views based on the sales team's requirements. Grant the sales team direct access to the ETL cluster.
Create database views based on the sales team's requirements. Grant the sales team direct access to the ETL cluster.
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.
ユーザの投票
コメント(13)
- 正解だと思う選択 肢: A
Initially I would go with B but that definitely will use more resource.
👍 5GiorgioGss2024/03/10 - 正解だと思う選択肢: A
A: redshift data sharing: https://docs.aws.amazon.com/redshift/latest/dg/data_sharing_intro.html With data sharing, you can securely and easily share live data across Amazon Redshift clusters. B: materialized view is only within 1 redshift cluster, across different tables
👍 5arvehisa2024/03/30 - 正解だと思う選択肢: D
In my opinion using Redshift Data Sharing will consume less resources. 'D' envolves using a S3 bucket.
👍 5lucas_rfsb2024/03/31
シャッフルモード