Crucial Exams

AWS Certified Data Engineer Associate DEA-C01 Practice Question

An ecommerce company has stored 3 TB of semi-structured Parquet data in Amazon S3. A data engineer must quickly generate column-level statistics, discover data types, null counts, and value distributions to decide which cleansing rules to apply. The solution should require no code and provide interactive visual summaries inside the AWS console. Which approach meets these requirements?

  • Apply LF-tags to the dataset in AWS Lake Formation and review the tag report.

  • Issue an ANALYZE TABLE command in Amazon Athena to collect statistics for the tables.

  • Import the files into an Amazon QuickSight SPICE dataset and inspect the field wells for summary statistics.

  • Run an AWS Glue DataBrew profile job on the S3 dataset and review the generated data profile in the DataBrew console.

AWS Certified Data Engineer Associate DEA-C01
Data Operations and Support
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