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

    Topic 1: AWS Certified Data Engineer - Associate

    Topic 1: AWS Certified Data Engineer - Associate

    A company uses an on-premises Microsoft SQL Server database to store financial transaction data. The company migrates the transaction data from the on-premises database to AWS at the end of each month. The company has noticed that the cost to migrate data from the on-premises database to an Amazon RDS for SQL Server database has increased recently.

    The company requires a cost-effective solution to migrate the data to AWS. The solution must cause minimal downtown for the applications that access the database.

    Which AWS service should the company use to meet these requirements?

    Choose your answer

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

  • Question 17 of 316

    Topic 1: AWS Certified Data Engineer - Associate

    Topic 1: AWS Certified Data Engineer - Associate

    A data engineer is building a data pipeline on AWS by using AWS Glue extract, transform, and load (ETL) jobs. The data engineer needs to process data from Amazon RDS and MongoDB, perform transformations, and load the transformed data into Amazon Redshift for analytics. The data updates must occur every hour.

    Which combination of tasks will meet these requirements with the LEAST operational overhead? (Choose two.)

    Choose your answer

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

  • Question 18 of 316

    Topic 1: AWS Certified Data Engineer - Associate

    Topic 1: AWS Certified Data Engineer - Associate

    A company uses an Amazon Redshift cluster that runs on RA3 nodes. The company wants to scale read and write capacity to meet demand. A data engineer needs to identify a solution that will turn on concurrency scaling.

    Which solution will meet this requirement?

    Choose your answer

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

  • Question 19 of 316

    Topic 1: AWS Certified Data Engineer - Associate

    Topic 1: AWS Certified Data Engineer - Associate

    A data engineer must orchestrate a series of Amazon Athena queries that will run every day. Each query can run for more than 15 minutes.

    Which combination of steps will meet these requirements MOST cost-effectively? (Choose two.)

    Choose your answer

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

  • Question 20 of 316

    Topic 1: AWS Certified Data Engineer - Associate

    Topic 1: AWS Certified Data Engineer - Associate

    A company is migrating on-premises workloads to AWS. The company wants to reduce overall operational overhead. The company also wants to explore serverless options.

    The company's current workloads use Apache Pig, Apache Oozie, Apache Spark, Apache Hbase, and Apache Flink. The on-premises workloads process petabytes of data in seconds. The company must maintain similar or better performance after the migration to AWS.

    Which extract, transform, and load (ETL) service will meet these requirements?

    Choose your answer

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