Crucial Exams

AWS Certified Data Engineer Associate DEA-C01 Practice Question

An e-commerce company stores 100 TB of Parquet files in Amazon S3. Multiple analytics teams need millisecond-latency access with Amazon Athena and Amazon Redshift Spectrum. Security requires row-level and column-level restrictions without adding new data copies. Which approach meets requirements with the lowest operational overhead and no additional storage cost?

  • Register the S3 locations in AWS Lake Formation and grant row- and column-level Lake Formation permissions that are respected by Athena and Redshift Spectrum.

  • Use S3 Object Lambda to dynamically remove unauthorized rows and columns when Athena or Redshift Spectrum access the objects.

  • Load the data into an Amazon Redshift RA3 cluster and use column-level security plus materialized views to filter rows for each team.

  • Copy each dataset into separate S3 prefixes per team and restrict Amazon Athena workgroups to those prefixes with bucket policies.

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