Amazon
Amazon DEA-C01
AWS Certified Data Engineer - Associate
Practice questions with verified answers, detailed explanations, and community discussions.
- 316
- Questions
- today
- Last updated
- Guest
- Your plan
25 free questions
Question 6 of 316
Topic 1: AWS Certified Data Engineer - AssociateTopic 1: AWS Certified Data Engineer - Associate
A company created an extract, transform, and load (ETL) data pipeline in AWS Glue. A data engineer must crawl a table that is in Microsoft SQL Server. The data engineer needs to extract, transform, and load the output of the crawl to an Amazon S3 bucket. The data engineer also must orchestrate the data pipeline.
Which AWS service or feature will meet these requirements MOST cost-effectively?
Choose your answer
Pick an answer to check it, or press Show answer to see the correct one.
Question 7 of 316
Topic 1: AWS Certified Data Engineer - AssociateTopic 1: AWS Certified Data Engineer - Associate
A financial services company stores financial data in Amazon Redshift. A data engineer wants to run real-time queries on the financial data to support a web-based trading application. The data engineer wants to run the queries from within the trading application.
Which solution will meet these requirements with the LEAST operational overhead?
Choose your answer
Pick an answer to check it, or press Show answer to see the correct one.
Question 8 of 316
Topic 1: AWS Certified Data Engineer - AssociateTopic 1: AWS Certified Data Engineer - Associate
A company uses Amazon Athena for one-time queries against data that is in Amazon S3. The company has several use cases. The company must implement permission controls to separate query processes and access to query history among users, teams, and applications that are in the same AWS account.
Which solution will meet these requirements?
Choose your answer
Pick an answer to check it, or press Show answer to see the correct one.
Question 9 of 316
Topic 1: AWS Certified Data Engineer - AssociateTopic 1: AWS Certified Data Engineer - Associate
A data engineer needs to schedule a workflow that runs a set of AWS Glue jobs every day. The data engineer does not require the Glue jobs to run or finish at a specific time.
Which solution will run the Glue jobs in the MOST cost-effective way?
Choose your answer
Pick an answer to check it, or press Show answer to see the correct one.
Question 10 of 316
Topic 1: AWS Certified Data Engineer - AssociateTopic 1: AWS Certified Data Engineer - Associate
A data engineer needs to create an AWS Lambda function that converts the format of data from .csv to Apache Parquet. The Lambda function must run only if a user uploads a .csv file to an Amazon S3 bucket.
Which solution will meet these requirements with the LEAST operational overhead?
Choose your answer
Pick an answer to check it, or press Show answer to see the correct one.