AWS Certified Data Engineer Associate DEA-C01 Practice Question
An analytics team ingests clickstream logs into Amazon S3 and uses nightly AWS Glue Spark jobs to aggregate the data and load it into Amazon Redshift. Auditors must be able to trace each Redshift column back to the exact S3 objects that produced it to verify data accuracy. Which approach delivers automatic column-level data lineage with minimal operational overhead?
Run the transformations with AWS Glue ETL jobs and use the AWS Glue Data Catalog's built-in lineage features to track sources and targets.
Attach custom S3 object tags that identify lineage and propagate the tags through each Glue job using job parameters.
Schedule Amazon Inspector assessments of the Redshift cluster to generate data provenance reports.
Enable AWS CloudTrail data events for S3 and Redshift and analyze the logs in Amazon Athena to reconstruct lineage.
AWS Glue records lineage information every time a supported crawler or ETL job runs. When Glue jobs read objects in S3 and write tables in Amazon Redshift, the Glue Data Catalog is updated with table- and column-level lineage that shows the relationship between the S3 sources and the Redshift targets. This information can be explored in the Glue console or queried through the Glue API, requiring no custom tagging or additional services. Adding custom tags (object metadata) or parsing CloudTrail logs would require manual maintenance and do not provide column-level lineage, while Amazon Inspector does not offer data lineage capabilities.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is AWS Glue Data Catalog?
Open an interactive chat with Bash
How does AWS Glue track data lineage automatically?
Open an interactive chat with Bash
Why are custom tags and CloudTrail logs unsuitable for column-level lineage?
Open an interactive chat with Bash
AWS Certified Data Engineer Associate DEA-C01
Data Store Management
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .