Skip to content
ExamCup

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

Unlock more questions
Show
Question map
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25

  • Question 11 of 316

    Topic 1: AWS Certified Data Engineer - Associate

    Topic 1: AWS Certified Data Engineer - Associate

    A data engineer needs Amazon Athena queries to finish faster. The data engineer notices that all the files the Athena queries use are currently stored in uncompressed .csv format. The data engineer also notices that users perform most queries by selecting a specific column.

    Which solution will MOST speed up the Athena query performance?

    Choose your answer

    Pick an answer to check it, or press Show answer to see the correct one.

  • Question 12 of 316

    Topic 1: AWS Certified Data Engineer - Associate

    Topic 1: AWS Certified Data Engineer - Associate

    A manufacturing company collects sensor data from its factory floor to monitor and enhance operational efficiency. The company uses Amazon Kinesis Data Streams to publish the data that the sensors collect to a data stream. Then Amazon Kinesis Data Firehose writes the data to an Amazon S3 bucket.

    The company needs to display a real-time view of operational efficiency on a large screen in the manufacturing facility.

    Which solution will meet these requirements with the LOWEST latency?

    Choose your answer

    Pick an answer to check it, or press Show answer to see the correct one.

  • Question 13 of 316

    Topic 1: AWS Certified Data Engineer - Associate

    Topic 1: AWS Certified Data Engineer - Associate

    A company stores daily records of the financial performance of investment portfolios in .csv format in an Amazon S3 bucket. A data engineer uses AWS Glue crawlers to crawl the S3 data.

    The data engineer must make the S3 data accessible daily in the AWS Glue Data Catalog.

    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 14 of 316

    Topic 1: AWS Certified Data Engineer - Associate

    Topic 1: AWS Certified Data Engineer - Associate

    A company loads transaction data for each day into Amazon Redshift tables at the end of each day. The company wants to have the ability to track which tables have been loaded and which tables still need to be loaded.

    A data engineer wants to store the load statuses of Redshift tables in an Amazon DynamoDB table. The data engineer creates an AWS Lambda function to publish the details of the load statuses to DynamoDB.

    How should the data engineer invoke the Lambda function to write load statuses to the DynamoDB table?

    Choose your answer

    Pick an answer to check it, or press Show answer to see the correct one.

  • Question 15 of 316

    Topic 1: AWS Certified Data Engineer - Associate

    Topic 1: AWS Certified Data Engineer - Associate

    A data engineer needs to securely transfer 5 TB of data from an on-premises data center to an Amazon S3 bucket. Approximately 5% of the data changes every day. Updates to the data need to be regularly proliferated to the S3 bucket. The data includes files that are in multiple formats. The data engineer needs to automate the transfer process and must schedule the process to run periodically.

    Which AWS service should the data engineer use to transfer the data in the MOST operationally efficient way?

    Choose your answer

    Pick an answer to check it, or press Show answer to see the correct one.