Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 208 discussion

Exam question from Amazon's AWS Certified Data Engineer - Associate DEA-C01

Question #: 208
Topic #: 1

[All AWS Certified Data Engineer - Associate DEA-C01 Questions]

A company has as JSON file that contains personally identifiable information (PII) data and non-PII data. The company needs to make the data available for querying and analysis.

The non-PII data must be available to everyone in the company. The PII data must be available only to a limited group of employees.

Which solution will meet these requirements with the LEAST operational overhead?

A. Store the JSON file in an Amazon S3 bucket. Configure AWS Glue to split the file into one file that contains the PII data and one file that contains the non-PII data. Store the output files in separate S3 buckets. Grant the required access to the buckets based on the type of user.
B. Store the JSON file in an Amazon S3 bucket. Use Amazon Macie to identify PII data and to grant access based on the type of user.
C. Store the JSON file in an Amazon S3 bucket. Catalog the file schema in AWS Lake Formation. Use Lake Formation permissions to provide access to the required data based on the type of user.
D. Create two Amazon RDS PostgreSQL databases. Load the PII data and the non-PII data into the separate databases. Grant access to the databases based on the type of user.

Show Suggested Answer

Suggested Answer: C 🗳️

by habros at June 17, 2025, 4:38 a.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

habros

1 week, 5 days ago

Selected Answer: C

Lake Formation is best used to control data in data lakes. JSON data will most likely be stored in S3 and DynamoDB, but DynamoDB can store JSON objects but not JSON files. Storing as S3 = data lake. Data lake = Lake Formation to control access https://docs.aws.amazon.com/lake-formation/latest/dg/lf-permissions-overview.html

upvoted 1 times

...