Topic 1 Question 59

AWS Certified Data Engineer - Associate

Topic 1 Question 59
A company needs to build a data lake in AWS. The company must provide row-level data access and column-level data access to specific teams. The teams will access the data by using Amazon Athena, Amazon Redshift Spectrum, and Apache Hive from Amazon EMR. Which solution will meet these requirements with the LEAST operational overhead?
- Use Amazon S3 for data lake storage. Use S3 access policies to restrict data access by rows and columns. Provide data access through Amazon S3.
- Use Amazon S3 for data lake storage. Use Apache Ranger through Amazon EMR to restrict data access by rows and columns. Provide data access by using Apache Pig.
- Use Amazon Redshift for data lake storage. Use Redshift security policies to restrict data access by rows and columns. Provide data access by using Apache Spark and Amazon Athena federated queries.
- Use Amazon S3 for data lake storage. Use AWS Lake Formation to restrict data access by rows and columns. Provide data access through AWS Lake Formation.
ユーザの投票
コメント(4)
- 正解だと思う選択肢: D
  https://docs.aws.amazon.com/lake-formation/latest/dg/cbac-tutorial.html Option D, using Amazon S3 for data lake storage and AWS Lake Formation for access control, is the most suitable solution. It meets the requirements for row-level and column-level access control and integrates well with Amazon Athena, Amazon Redshift Spectrum, and Apache Hive on EMR, all with lower operational overhead compared to the other options.
  
  👍 4
  rralucard_2024/02/02
- Option D is the best solution to meet the requirements with the least operational overhead.
  
  Using Amazon S3 for storage and AWS Lake Formation for access control and data access delivers the following advantages:
  
  S3 provides a highly durable, available, and scalable data lake storage layer Lake Formation enables fine-grained access control down to column and row-level Integrates natively with Athena, Redshift Spectrum, and EMR for simplified data access Fully managed service minimizes admin overhead vs self-managing Ranger or piecemeal solutions
  
  👍 4
  Felix_G2024/03/02
- 正解だと思う選択肢: D
  this id D
  
  👍 3
  cas_tori2024/08/16
シャッフルモード

ユーザの投票

コメント(4)