AWS Certified Data Engineer Associate Exam Questions & Answers

All 65 questions

1. Q1 A media agency stores its re-creatable assets on Amazon Simple Storage Service (Amazon S3) buckets. The assets are accessed by a large…
2. Q2 In designing a data pipeline for high availability and fault tolerance, which AWS services should be used together to ensure data is…
3. Q3 A financial services company is planning to consolidate various data sources for a centralized analytics platform on AWS. These data sources include…
4. Q4 A business analytics team is tasked with configuring a provisioned Amazon EMR cluster optimized for executing Apache Spark jobs to analyze extensive…
5. Q5 A legacy application is built using a tightly-coupled monolithic architecture. Due to a sharp increase in the number of users, the application…
6. Q6 A company runs daily ETL jobs using AWS Glue to transform data from an S3 data lake into a data warehouse. They…
7. Q7 A data engineer is using DynamoDB with DAX enabled for a high-throughput application. However, during peak times, they notice some requests are…
8. Q8 A company wants to ensure data accuracy and trustworthiness in its ETL pipeline. Which AWS service offers features to establish data lineage…
9. Q9 The head data engineer at an international news outlet is tasked with optimizing the real-time ingestion of streaming news data. The platform…
10. Q10 A gaming company is developing a mobile game that streams score updates to a backend processor and then publishes results on a…
11. Q11 The data engineering team at an e-commerce company processes transactions into Amazon Kinesis Data Streams using the Kinesis Producer Library (KPL). The…
12. Q12 A startup is developing a serverless application with a Vue.js frontend, which interacts with a backend via Amazon API Gateway. They need…
13. Q13 For a data pipeline that integrates data from multiple sources into Amazon Redshift, which AWS service or feature should be utilized to…
14. Q14 To comply with data sovereignty laws, a multinational company needs to prevent specific data from leaving the regional boundaries. Which AWS service…
15. Q15 A data engineering team at an online retail company is optimizing the performance of their Amazon Redshift data warehouse. The warehouse contains…
16. Q16 A company stores sensitive documents in an Amazon S3 bucket. They need to ensure that these documents can only be accessed by…
17. Q17 When visualizing data for analysis using AWS services, which tools can be utilized to create interactive dashboards and visualizations from processed data?…
18. Q18 A company is using AWS Config to track changes to their resources and ensure compliance. They also want to integrate Amazon CloudTrail…
19. Q19 A multinational corporation wants to aggregate, analyze, and visualize logs from various AWS services and on-premises resources for business intelligence. The solution…
20. Q20 A company is building a serverless image processing application. They want to trigger an AWS Lambda function automatically whenever a new image…
21. Q21 The technology team at a Wall Street trading firm uses DynamoDB to facilitate high-frequency trading where multiple trades can try and update…
22. Q22 A data engineer has configured an AWS Glue job to read data from an Amazon S3 bucket by setting up the AWS…
23. Q23 Which AWS service offers data engineers the ability to visually create, schedule, and manage complex ETL workflows without writing code?
24. Q24 A company plans to move 10 TB of multimedia content from their local servers to AWS, with a portion of the data…
25. Q25 A data engineering team is using Amazon DynamoDB to store user profiles and needs to enable DynamoDB Streams to track real-time changes…
26. Q26 A legal firm wishes to store highly confidential case files in Amazon S3, with a requirement that only designated lawyers can view…
27. Q27 As part of a workflow, the data engineering team at a company pushes data from Amazon Kinesis Data Firehose to Amazon Simple…
28. Q28 A leading retail analytics company requires processing customer transaction datasets generated during holiday seasons, where data volume can peak unpredictably. The Lead…
29. Q29 A healthcare company needs to monitor its Amazon S3 buckets for sensitive health data and generate alerts if this data is accessed…
30. Q30 A company is using OpenSearch to store customer orders and product data. They want to ensure that even if a node in…
31. Q31 A market research firm collects extensive survey data in .csv format, stored with numerous columns. The data analysts primarily focus on a…
32. Q32 A company plans to migrate its on-premises Oracle database to Amazon Aurora PostgreSQL. They need to ensure a seamless migration of both…
33. Q33 A data engineer is using Amazon QuickSight to visualize data stored in Amazon S3. They want to ensure fast performance by caching…
34. Q34 The data engineering team at a social media company has noticed that while some of the images stored in Amazon S3 are…
35. Q35 A large SQL Server database on RDS contains historical transaction data. A process is needed to automate the following requirements: regularly identify…
36. Q36 A global media company uses a fleet of Amazon EC2 instances (behind an Application Load Balancer) to power its video streaming application.…
37. Q37 A company stores its user information in a MySQL database table called user. The name column has the users' names stored in…
38. Q38 Your company has deployed an application that will perform a lot of overwrites and deletes on data and require the latest information…
39. Q39 When troubleshooting a data processing application that frequently times out during peak load times on AWS Lambda, what is the FIRST step…
40. Q40 A company's real-time streaming application is running on AWS. As the data is ingested, a job runs on the data and takes…
41. Q41 An e-commerce platform uses Amazon MemoryDB for Redis to store session data and shopping cart information for users. The company must ensure…
42. Q42 A company is deploying a stateful application on Amazon EC2 that requires temporary storage for processing large datasets with maximum I/O. The…
43. Q43 In a distributed computing environment on AWS, which service is best suited for managing stateful workflows that require complex orchestration across multiple…
44. Q44 A company runs a real-time data processing application that uses Kinesis Client Library (KCL) to help consume and process data from the…
45. Q45 A data engineer at a retail company needs to run complex queries on large datasets stored in Amazon Redshift. These queries often…
46. Q46 A financial company wants to enable its business users to perform interactive data analysis without needing in-depth knowledge of querying languages. The…
47. Q47 A retail company uses AWS Glue DataBrew to clean and prepare customer data for analytics. The data is stored in various formats,…
48. Q48 A data engineering team wants to orchestrate multiple Amazon ECS task types running on Amazon EC2 instances that are part of the…
49. Q49 A company maintains its datasets in JSON and .csv formats in an Amazon S3 bucket and utilizes Amazon RDS for Microsoft SQL…
50. Q50 A retail company is using Amazon Redshift as their data warehouse for analytical queries. They have large volumes of transactional data being…
51. Q51 A healthcare company collects user health information on a daily basis and stores this data on Amazon S3 which is then queried…
52. Q52 A company is using AWS Lake Formation to set up a secure data lake. They need to ensure that data from both…
53. Q53 A DevOps team is responsible for monitoring and troubleshooting a fleet of EC2 instances running web applications in AWS. They need an…
54. Q54 Your organization uses Amazon Redshift for data warehousing and has recently been experiencing frequent and unpredictable performance issues when executing queries across…
55. Q55 A data engineering team is developing a new application that requires intermittent access to a relational database. The application’s usage is expected…
56. Q56 A Redshift cluster administrator is tasked with sharing live data from a production Redshift cluster to another Redshift cluster in a different…
57. Q57 An e-commerce website hosted on AWS experiences intermittent performance issues during peak hours. Which of the following services can help identify the…
58. Q58 A gaming company needs to distribute real-time gameplay data to multiple processing systems for analytics and player matchmaking. Which AWS service should…
59. Q59 In a complex, multi-tenant SaaS environment, a senior data engineer needs to implement a feature within their ingestion pipeline that allows for…
60. Q60 A company is building a serverless image processing pipeline using AWS Lambda and Amazon S3. When an image is uploaded to an…
61. Q61 A data engineer needs to build and train a machine learning model using TensorFlow and deploy it for real-time inference with minimal…
62. Q62 A data engineer needs to query data from multiple sources, including an Amazon RDS PostgreSQL database and an on-premises PostgreSQL database. The…
63. Q63 An Extract, Transform, and Load (ETL) job needs to be implemented which will process data uploaded to an Amazon S3 bucket daily.…
64. Q64 The data engineering team at an e-commerce company wants to migrate from Amazon Simple Queue Service (Amazon SQS) Standard queues to FIFO…
65. Q65 A bank is using Amazon Simple Queue Service (Amazon SQS) to migrate several core banking applications to the cloud to ensure high…