Crucial Exams

AWS Certified Data Engineer Associate DEA-C01 Practice Question

A retailer stores clickstream data as Parquet files in Amazon S3. Analysts query the data with Amazon Athena several times a day, and weekly batch jobs update or delete late-arriving records. The company uses AWS Lake Formation and must enforce row-level security while supporting ACID transactions with the least administration. Which approach meets these requirements?

  • Convert the dataset to a Lake Formation governed table and use LF tag-based policies to grant analysts SELECT access with row filters.

  • Create an external table in the AWS Glue Data Catalog and control access only with S3 bucket policies and Athena workgroup-level data filters.

  • Load the data into an Amazon Redshift cluster and share secure views through Lake Formation for row-level access.

  • Enable object-level ACLs on the S3 bucket and restrict rows by forcing analysts to use Athena views containing WHERE clauses.

AWS Certified Data Engineer Associate DEA-C01
Data Store Management
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot