Free AWS Certified Data Engineer (DEA-C01) Practice Test 13

Free AWS Certified Data Engineer Associate Exam (DEA-C01) Practice Test 13 supports candidates who are close to a first technical offer and need one more proof point. Training projects show effort. The DEA-C01 shows an outside standard. Because AWS is the cloud companies worldwide rely on most, that standard matches how employers already build data platforms. Certification benefits include a resume line recruiters recognize and a calmer story in final rounds, which helps convert interviews into job offers in AWS and data engineering.

First offers usually sit in the junior band, with a clear climb after. Junior data engineers often average about $72,000, with stronger entry offers toward $105,000. Mid-level data engineers often reach $119,000 to $156,000. Senior data engineers often reach about $147,000 to $181,000 or more. Companies hiring AWS data engineers include UnitedHealth Group, CVS Health, and Kaiser Permanente.

SynergisticIT JOPP helps jobseekers get certified, prepared, and hired at top tech companies through our Job Placement programs — Java DevOps Full Stack JOPP and Data Science JOPP.

If you want to learn how to get hired as a Data Engineer, Data Scientist, Data Analyst, AI or ML engineer, or a software engineer, contact SynergisticIT for expert upskilling and marketing connections to companies. Go to Contact Us and SynergisticIT JOPP.

Welcome to your AWS Data Engineer Associate – Test-13

Name

Phone

Q1. A company is implementing enhanced security measures for their AWS-based web application. They want to ensure secure communication between the applications clients and the server. Which of the following methods should they use to facilitate certificate-based authentication?

Select 1 option(s):

Enable AWS IAM roles to manage SSL/TLS certificates for the application.

Implement Amazon Cognito with user pools for SSL/TLS certificate management.

Use AWS Certificate Manager to provision, manage, and deploy SSL/TLS certificates.

Configure Amazon S3 to store and serve SSL/TLS certificates for the application.

Q2. A company is processing large datasets using Amazon EMR but wants to optimize costs. They typically run data processing jobs during off-peak hours. Which feature should they use to reduce costs without compromising on the processing capabilities?

Select 1 option(s):

Use Reserved Instances for their EMR clusters

Implement AWS Lambda for data processing

Utilize Amazon S3 Transfer Acceleration

Opt for Amazon EMR Spot Instances

Q3. A financial institution requires a solution for analyzing time-series data with efficient storage and fast query performance. The data is structured and they need to run frequent aggregations and time-based queries. Which AWS service is most suitable?

Select 1 option(s):

Amazon Redshift with Dense Compute nodes

Amazon RDS with Aurora

Amazon DynamoDB

Amazon S3 with AWS Glue

Q4. A startup is developing an IoT application that needs to process and store large volumes of incoming sensor data. The solution should offer fast and consistent read/write performance and be able to scale dynamically with the number of devices. Which AWS service is the best choice?

Select 1 option(s):

Amazon DynamoDB

Amazon RDS

Amazon EC2 with self-managed database

Amazon S3

Q5. The data engineering team needs to remove duplicates and standardize formats in a dataset stored in Amazon S3 before analysis. The dataset is large, and the cleansing process needs to be automated. Which AWS service is best suited for automating this data cleansing process?

Select 1 option(s):

AWS Lambda

Amazon QuickSight

AWS Glue DataBrew

Amazon EMR

Q6. A healthcare company wants to centralize its diverse data sources, including electronic health records, billing data, and patient-generated data, into a secure and manageable data lake. The solution should enable scalable storage, data cataloging, and fine-grained access control. Which AWS service is most appropriate for this requirement?

Select 1 option(s):

Amazon Redshift

AWS Lake Formation

Amazon RDS

Amazon DynamoDB

Q7. A retail company requires a storage solution for their online transaction processing (OLTP) system, which involves frequent read and write operations. The solution must ensure data integrity, support complex queries, and provide automated backup capabilities. Which AWS service is most suitable for this scenario?

Select 1 option(s):

Amazon DynamoDB

Amazon RDS

Amazon Redshift

Amazon S3

Q8. In an Amazon RDS environment, the database admin needs to ensure exclusive access to a database during a critical migration process. Which approach should they take to prevent other users from accessing the database during this time?

Select 1 option(s):

Implement RDS Automated Backups.

Use database-level access controls.

Enable Amazon RDS Encryption.

Scale up the RDS instance size.

Q9. An organization wants to automate AWS resource deployments using scripts run through the AWS CLI. They need to ensure that these scripts have the necessary permissions to perform actions on AWS resources. What is the best practice for granting these permissions?

Select 1 option(s):

Attach an IAM user policy directly to the IAM user and use its credentials in the AWS CLI.

Create an IAM role with the required permissions and configure the AWS CLI to assume this role.

Implement an AWS Lambda function with an execution role that the script can invoke through the AWS CLI.

Use AWS Access Keys for the root account in the AWS CLI for unrestricted access to resources.

Q10. An organization is setting up a secure MQTT connection for its IoT devices to communicate with AWS IoT Core. Which authentication method should they use to establish a certificate-based secure connection?

Select 1 option(s):

Use AWS IAM Access Keys for each IoT device to authenticate with AWS IoT Core.

Implement AWS Secrets Manager to store and manage certificates for MQTT connections.

Configure AWS IoT Core to use X.509 certificates for device authentication.

Deploy Amazon Cognito user pools to manage certificates for IoT device authentication.

Q11. A company is using AWS Lambda to process data files as they arrive in an Amazon S3 bucket. The Lambda function needs to be triggered automatically each time a new file is uploaded to the bucket. Which configuration ensures that the Lambda function is triggered correctly?

Select 1 option(s):

Configure an Amazon CloudWatch Events rule to monitor the S3 bucket and trigger the Lambda function.

Set up an S3 Event Notification to trigger the Lambda function upon file upload.

Use AWS Step Functions to poll the S3 bucket and trigger the Lambda function.

Implement an Amazon Kinesis Data Firehose delivery stream to monitor the S3 bucket and invoke the Lambda function.

Q12. A media company is using Amazon Kinesis Data Streams to collect real-time video playback data from various sources. They need to ensure that this data is simultaneously processed by multiple independent AWS Lambda functions for different analytical purposes. What is the most effective way to achieve this fan-out pattern?

Select 1 option(s):

Implement Amazon S3 Transfer Acceleration

Use Amazon SQS to decouple the data streams

Create multiple Kinesis Data Streams for each Lambda function

Configure multiple Lambda functions to read from the same Kinesis Data Stream

Q13. A data engineering team needs to process large amounts of log data stored in Amazon S3 using Apache Spark. They require a managed environment for Spark to simplify setup and management. Which AWS service should they use to meet these requirements?

Select 1 option(s):

AWS Lambda

Amazon EC2

Amazon EMR

Amazon RDS

Q14. A company wants to visualize streaming data in real-time to monitor the performance of their web application. Which combination of AWS services should be used to collect, process, and visualize this streaming data effectively?

Select 1 option(s):

Amazon Kinesis Data Streams for data collection, AWS Lambda for data processing, and Amazon QuickSight for visualization.

Amazon S3 for data collection, Amazon EC2 for data processing, and AWS Glue for visualization.

AWS Data Pipeline for data collection, Amazon Redshift for data processing, and Amazon QuickSight for visualization.

Amazon DynamoDB for data collection, AWS Step Functions for data processing, and Amazon CloudWatch for visualization.

Q15. A data engineering team is using Amazon DynamoDB for their application but occasionally encounters throttling issues due to high read/write throughput demands. What can they implement to manage the throughput more effectively and reduce the incidence of throttling?

Select 1 option(s):

Increase the read/write capacity units (RCUs/WCUs) of the DynamoDB table

Implement an Amazon S3 lifecycle policy

Use Amazon Kinesis Data Firehose for data ingestion

Configure Amazon RDS Multi-AZ deployments

Q16. A data engineering team is designing an AWS-based data processing solution where different team members require varied levels of access to AWS services and resources. How should they implement role-based authentication to manage access effectively?

Select 1 option(s):

Utilize Amazon Cognito to create different user pools for each team member.

Configure AWS IAM roles with specific permissions and assign them to team members.

Deploy AWS Lambda functions with distinct execution roles for each type of access requirement.

Set up Amazon S3 bucket policies for individual team members based on their role requirements.

Q17. An organization wants to analyze streaming data from social media platforms in real-time. The solution should handle high throughput and provide the ability to scale horizontally. Which AWS service combination is most suitable for cloud-based, distributed real-time analytics?

Select 1 option(s):

Amazon Kinesis and Amazon EMR

Amazon DynamoDB and AWS Lambda

Amazon EC2 and Amazon RDS

Amazon S3 and Amazon Athena

Q18. A data engineer is working on a project that requires running complex analytical queries on large datasets for business intelligence purposes. The engineer needs a data warehousing service that can handle these analytical workloads efficiently. Which AWS service should the engineer choose for this scenario?

Select 1 option(s):

Amazon S3

Amazon RDS

Amazon Redshift

AWS Glue

Q19. A data engineer needs to use the AWS Command Line Interface (CLI) for managing AWS resources. To securely manage AWS CLI access, which of the following is the recommended approach?

Select 1 option(s):

Generate an Access Key ID and Secret Access Key for the root account and configure them in the AWS CLI.

Use temporary security credentials by assuming an IAM role through AWS STS for the AWS CLI session.

Configure a Network Access Control List (NACL) to restrict CLI access to AWS resources.

Set up an Amazon Cognito user pool and use its credentials for AWS CLI access.

Q20. A company stores a vast amount of historical data in Amazon S3 and needs to perform ad-hoc analytics queries combining this data with their current data stored in an Amazon Redshift cluster. They require a solution that can query data across both storage systems without moving data. Which AWS service should they use?

Select 1 option(s):

Amazon Redshift Spectrum

AWS DataSync

Amazon DynamoDB

AWS Glue

Q21. A company is using Amazon Athena to analyze their web traffic data stored in Amazon S3. They need to compute a 30-day rolling average of website hits. The table web_traffic contains columns date and hits. What is the appropriate SQL query in Athena to perform this calculation?

Select 1 option(s):

SELECT date, AVG(hits) OVER (ORDER BY date ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) FROM web_traffic;

SELECT date, SUM(hits) / 30 FROM web_traffic GROUP BY date ORDER BY date;

SELECT date, AVG(hits) OVER (PARTITION BY date ORDER BY date ROWS 29 PRECEDING) FROM web_traffic;

SELECT date, SUM(hits) OVER (ORDER BY date RANGE BETWEEN INTERVAL ‘29‘ DAY PRECEDING AND CURRENT ROW) FROM web_traffic;

Q22. A research institution needs to archive large volumes of scientific data collected over decades. The data will be infrequently accessed but must be preserved for long-term storage and occasional analysis. Cost-effectiveness and data durability are primary concerns. Which AWS service should they use?

Select 1 option(s):

Amazon Glacier

Amazon RDS

Amazon EBS

Amazon Redshift

Q23. A data engineer needs to query a large dataset in Amazon S3 using Amazon Athena. The requirement is to generate a report that shows the total sales amount per product category for the last year. Which SQL query would accurately fulfill this requirement?

Select 1 option(s):

Q24. You are working on a data analytics project where you need to automate the execution of ETL (Extract, Transform, Load) jobs on a regular schedule. You also want to monitor the execution of these jobs and receive notifications in case of failures. Which AWS service can you use to schedule and orchestrate ETL jobs, as well as set up monitoring and notifications?

Select 1 option(s):

AWS Data Pipeline

Amazon Kinesis

Amazon DynamoDB

AWS Glue

Q25. A financial services firm needs to process high-frequency trading data with minimal latency. This requires a data pipeline capable of handling large volumes of data with high throughput and low response times. Which AWS service is best suited to build this high-performance data pipeline?

Select 1 option(s):

Amazon RDS

AWS Lambda

Amazon Kinesis

Amazon S3

Q26. A data analyst is using Amazon Redshift to analyze sales data. The analyst needs to create a pivot table that shows the total sales for each product category by month. The table sales_data has columns sale_date, category, and amount. Which SQL query correctly creates this pivot table in Amazon Redshift?

Select 1 option(s):

SELECT category, EXTRACT(MONTH FROM sale_date) AS month, SUM(amount) FROM sales_data GROUP BY category, month;

SELECT category, SUM(CASE WHEN EXTRACT(MONTH FROM sale_date) = 1 THEN amount ELSE 0 END) AS Jan, SUM(CASE WHEN EXTRACT(MONTH FROM sale_date) = 2 THEN amount ELSE 0 END) AS Feb, FROM sales_data GROUP BY category;

SELECT category, PIVOT(SUM(amount) FOR EXTRACT(MONTH FROM sale_date) IN (1 AS Jan, 2 AS Feb, )) FROM sales_data GROUP BY category;

SELECT EXTRACT(MONTH FROM sale_date) AS month, SUM(amount) FROM sales_data PIVOT (category) GROUP BY month;

Q27. You are working on a data engineering project where you need to extract specific data from a large dataset stored in an Amazon S3 bucket. The data you need to retrieve must meet specific criteria and include only relevant information. Which SQL operation should you use to filter and extract the required data from the dataset?

Select 1 option(s):

JOIN

SELECT

GROUP BY

ORDER BY

Q28. A company has deployed a multi-tier web application on AWS, where different teams are responsible for the front-end, back-end, and database management. To implement role-based access control, which approach should they follow?

Select 1 option(s):

Create a single IAM role with full access to all application tiers and share it among all teams.

Configure IAM roles for each team, granting permissions only to the specific AWS services and resources they manage.

Assign AWS IAM users to each team member, giving them access based on their individual job functions.

Use Amazon Cognito to manage access for the different application tiers.

Q29. The company wants to perform real-time aggregation of streaming data from IoT devices and visualize the results. The data needs to be aggregated based on device type and reported every hour. Which AWS service combination is best for this real-time data aggregation and visualization?

Select 1 option(s):

Amazon Kinesis Data Analytics for data aggregation and Amazon QuickSight for visualization.

Amazon S3 for data storage, AWS Lambda for aggregation, and Amazon QuickSight for visualization.

AWS Glue for real-time data aggregation and Amazon QuickSight for visualization.

Amazon DynamoDB for storing streaming data, Amazon Athena for aggregation, and Amazon QuickSight for visualization.

Q30. An organization is using AWS IAM to manage access to its AWS resources. They want to implement a policy where access permissions are dynamically assigned based on user attributes like job function. What type of authorization mechanism should they implement?

Select 1 option(s):

Configure IAM user policies that statically define permissions for each job function.

Apply attribute-based access control (ABAC) by using IAM policy conditions that reference user attributes.

Utilize AWS Security Groups to dynamically assign permissions based on user job function attributes.

Implement Amazon Cognito identity pools to manage permissions based on user job function.

Q31. A company is developing a data processing application that requires rapid scaling based on the workload. The application is containerized and needs to be deployed in a highly available and scalable environment. Which AWS service should be used to optimize container usage for these performance needs?

Select 1 option(s):

Amazon EC2

Amazon Elastic Container Service (Amazon ECS)

AWS Lambda

Q32. A data engineering team needs to create an interactive dashboard to visualize and analyze sales data stored in AWS. The dashboard should allow non-technical users to easily explore data and generate reports. Which AWS service is most appropriate for this requirement?

Select 1 option(s):

Amazon QuickSight

AWS Glue

Amazon Athena

Amazon Redshift

Q33. A data engineering team is using AWS Glue DataBrew to prepare datasets for a machine learning project. They need to perform a transformation that involves removing duplicates based on specific columns. Which of the following approaches should they use in AWS Glue DataBrew to achieve this?

Select 1 option(s):

Apply a “Find duplicates“ transformation based on the specified columns.

Use a custom SQL query to remove duplicates.

Implement a Python-based AWS Lambda function to process the dataset and remove duplicates.

Use the “Join“ transformation to merge the dataset with itself and filter out duplicates.

Q34. A Data Engineer is using AWS Lambda to aggregate and summarize data from multiple sources each night. The Lambda function runs longer than the default timeout period. Which action should the engineer take to ensure successful execution of the Lambda function?

Select 1 option(s):

Increase the memory allocation of the Lambda function.

Split the Lambda function into multiple, smaller functions.

Increase the timeout setting of the Lambda function.

Migrate the data processing workload to an EC2 instance.

Q35. A company is using an Amazon RDS instance and wants to restrict its access to only their office IP range for security reasons. Which method should they use to configure this access restriction?

Select 1 option(s):

Apply an AWS WAF Web ACL to the RDS instance

Configure Amazon RDS Security Groups

Implement Amazon VPC Network ACLs

Use AWS IAM Role Attachments

Q36. A financial services company needs to perform real-time data transformation and enrichment on streaming transaction data before loading it into a data warehouse. The solution should integrate easily with Amazon Redshift. Which AWS service combination would be most effective for this requirement?

Select 1 option(s):

AWS Lambda and Amazon DynamoDB

Amazon Kinesis Data Streams and AWS Glue

Amazon EC2 and Amazon RDS

Amazon Kinesis Data Firehose and Amazon Redshift

Q37. A company is using Amazon Athena to query logs stored in Amazon S3. They need to ensure that queries are cost-effective. Which strategy should they adopt to reduce the cost of querying with Athena?

Select 1 option(s):

Partition the data based on access patterns.

Implement Amazon QuickSight for querying instead of Athena.

Migrate the log data to Amazon DynamoDB and use Athena to query the DynamoDB tables.

Enable Amazon S3 Transfer Acceleration for the log data.

Q38. A data engineering team is implementing a new application that requires access to a database stored on Amazon RDS. They need a secure way to manage the database credentials and automate their rotation. Which AWS service should they use to achieve this?

Select 1 option(s):

Utilize AWS IAM Access Keys to store and rotate the database credentials.

Implement AWS Secrets Manager for secure credential storage and automatic rotation.

Store the credentials in Amazon S3 with server-side encryption and manually rotate them.

Use Amazon CloudWatch to store and automatically rotate the database credentials.

Q39. A streaming application is sending data to Amazon Kinesis Data Streams. The company wants to perform light data transformation using an AWS Lambda function before storing the data in Amazon S3. How should the data engineer set up the system to enable this process?

Select 1 option(s):

Configure Amazon RDS to trigger the Lambda function.

Use AWS Glue to call the Lambda function for data transformation.

Set up an Amazon Kinesis Data Firehose delivery stream between Kinesis Data Streams and Lambda.

Directly connect Kinesis Data Streams as a trigger to the Lambda function.

Q40. A data engineering team is determining whether to use AWS managed policies or customer managed policies for their new IAM roles in AWS. They need a policy that can be tailored specifically to their unique access requirements. Which type of policy should they choose?

Select 1 option(s):

Use AWS managed policies as they are predefined by AWS and can be directly attached to IAM roles.

Choose customer managed policies for the ability to create and customize their own policies.

Implement inline policies for each IAM role for specific access requirements.

Opt for AWS managed policies and modify them to suit their unique access requirements.

Q41. An organization needs to execute a data aggregation task whenever a new file is uploaded to a specific Amazon S3 bucket. The task involves several AWS services, including Lambda and Amazon RDS. Which AWS service is most appropriate for detecting the file upload and orchestrating the subsequent multi-service workflow?

Select 1 option(s):

AWS EventBridge

AWS CodePipeline

Amazon CloudWatch Logs

AWS Data Pipeline

Q42. A data analytics team needs to process a large volume of data using Apache Spark and Hadoop for complex ETL operations. The solution should scale dynamically based on workload and offer cost-effective storage. Which AWS service best fits these requirements?

Select 1 option(s):

Amazon Redshift

Amazon RDS

Amazon EMR

Amazon DynamoDB

Q43. A data engineering team is deploying a new application on AWS and needs to update the VPC security groups to ensure secure access to an Amazon RDS instance. The application requires that only specific IP addresses from the companys internal network can access the RDS instance. How should they configure the security group for the RDS instance?

Select 1 option(s):

Set the inbound rules to allow all traffic from any source.

Configure the inbound rules to allow traffic from the specific IP addresses on the required port.

Modify the outbound rules to restrict traffic to the specific internal IP addresses.

Use AWS WAF to control traffic from specific IP addresses to the RDS instance.

Q44. An organization is setting up IAM policies to control access to its AWS resources. They want to leverage prebuilt policies for common use cases but also require some policies that are specific to their organizational needs. What combination of IAM policy types should they use?

Select 1 option(s):

Rely solely on AWS managed policies for both common and specific organizational use cases.

Use customer managed policies for common use cases and AWS managed policies for specific needs.

Combine AWS managed policies for common use cases with customer managed policies for specific needs.

Implement inline policies for common use cases and customer managed policies for specific requirements.

Q45. A companys security policy mandates that all credentials for accessing critical internal services must be rotated every 90 days. They are managing these credentials on AWS. Which service should they use to comply with this policy while minimizing manual intervention?

Select 1 option(s):

Configure Amazon S3 lifecycle policies to rotate the credentials every 90 days.

Use AWS Secrets Manager to automate the credential rotation process.

Implement Amazon RDS with built-in mechanisms for automatic credential rotation.

Apply AWS Config rules to enforce and track credential rotation compliance.

Q46. A data engineer needs to write an SQL query to retrieve records from two tables, Sales and Customers. The query must join these tables on the CustomerID field and select sales records for customers located in New York. Which of the following SQL queries correctly fulfills these requirements?

Select 1 option(s):

Q47. A company is processing large datasets for machine learning models. They require scalable compute resources to handle variable workloads and reduce processing time. Which AWS service best fits these requirements for cloud computing and distributed processing?

Select 1 option(s):

Amazon RDS

AWS Lambda

Amazon EC2

Amazon S3

Q48. A development team is configuring an Amazon API Gateway to allow secure access to their backend services. They need to ensure that the API Gateway can authenticate requests using AWS IAM roles. What steps should they take to set up this authentication mechanism?

Select 1 option(s):

Enable AWS IAM user access for the API Gateway and assign users directly to the API.

Create an IAM role with the necessary permissions and configure the API Gateway to use AWS_IAM as the authorization type.

Implement an Amazon Cognito user pool to manage IAM roles for the API Gateway.

Set up an AWS Lambda authorizer to assign IAM roles to incoming requests to the API Gateway.

Q49. A company wants to implement a large-scale analytics solution on Azure that requires processing and analyzing big data in batch mode. They need a service that can handle complex data transformations and supports various data sources and programming languages. Which Azure service should they consider for this workload?

Select 1 option(s):

Azure Synapse Analytics

Azure Data Factory

Azure Databricks

Azure HDInsight

Q50. A data engineer needs to ensure that an AWS Lambda function can query data from an Amazon DynamoDB table. What is the recommended method for granting the necessary permissions to the Lambda function?

Select 1 option(s):

Directly attach an IAM user policy with DynamoDB access to the Lambda function.

Create an IAM role with permissions to access DynamoDB and associate it with the Lambda function.

Implement an AWS Security Group with rules allowing Lambda to access DynamoDB.

Use AWS Key Management Service (KMS) to grant the Lambda function access to DynamoDB.

Q51. A data engineering team is setting up an ETL pipeline where they need to temporarily store processed data before it is loaded into an Amazon Redshift cluster. Which AWS service is most appropriate to use as an intermediate data staging location in this scenario?

Select 1 option(s):

Amazon DynamoDB

Amazon EC2

Amazon S3

AWS Lambda

Q52. An analytics platform needs to connect to and query data from a PostgreSQL database and an Oracle database. What is the most effective way to establish these connections from the platform?

Select 1 option(s):

Use AWS Direct Connect

Implement RESTful API interfaces

Utilize Java Database Connectivity (JDBC)

Configure Amazon VPC Peering

Q53. A company needs to process and analyze large-scale log data generated by their web servers. The solution should support complex ETL jobs and allow for the flexible use of various big data frameworks and tools. Which AWS service is most suitable for these requirements?

Select 1 option(s):

Amazon RDS

Amazon S3

Amazon EMR

Amazon DynamoDB

Q54. An e-commerce company needs to process a variety of data, including transaction records (structured) and customer reviews (unstructured), to gain insights into customer behavior. The data processing solution must handle both high volume and variety. Which combination of AWS services is most appropriate for this requirement?

Select 1 option(s):

Amazon Kinesis and Amazon Redshift

Amazon EC2 and Amazon RDS

AWS Glue and Amazon Athena

Amazon S3 and Amazon QuickSight

Q55. A logistics company needs to process large volumes of sensor data from its fleet of vehicles in real time. The data will be used for tracking vehicle performance and route optimization. The solution must be highly available, scalable, and capable of handling high-throughput data streams. Which AWS service should they use?

Select 1 option(s):

Amazon MSK (Managed Streaming for Kafka)

Amazon RDS

Amazon DynamoDB

Amazon S3

Q56. A company needs to clean and transform incoming JSON data from various sources before storing it in Amazon Redshift for analysis. The transformation process includes filtering, aggregating, and enriching the data. Which AWS service is most appropriate for this ETL (Extract, Transform, Load) process?

Select 1 option(s):

AWS Lambda

Amazon EC2

AWS Glue

Amazon RDS

Q57. A financial services company needs to run complex, containerized data analytics workloads with Kubernetes. They require a service that can efficiently manage Kubernetes clusters and optimize resource usage based on the computational intensity of the workloads. Which AWS service is most suitable for this requirement?

Select 1 option(s):

Amazon RDS

Amazon Elastic Kubernetes Service (Amazon EKS)

Amazon EMR

Amazon DynamoDB

Q58. A company is experiencing rate limits when ingesting data into Amazon Kinesis Data Streams. Which approach should they take to manage and overcome these rate limits?

Select 1 option(s):

Increase the number of shards in the Kinesis Data Stream.

Configure AWS Lambda concurrent execution limits.

Implement Amazon RDS Read Replicas.

Apply an Amazon S3 Transfer Acceleration.

Q59. An AWS environment includes a web server and a database server, both hosted on separate EC2 instances within a VPC. The web server needs unrestricted access to the database server. What is the recommended way to update the VPC security groups to allow this access?

Select 1 option(s):

Configure the security group of the database server to allow inbound traffic from the security group attached to the web server.

Set up a Network Access Control List (NACL) to allow traffic from the web server‘s IP address to the database server.

Update the outbound rules of the web server‘s security group to allow all traffic to the database server‘s IP address.

Implement AWS IAM role-based access between the web server and database server.

Q60. A data engineering team is using Amazon Athena for ad-hoc querying of their data stored in Amazon S3. They need to optimize query performance for frequently accessed data. Which of the following actions should they take to achieve this?

Select 1 option(s):

Convert the data into a columnar format like Parquet.

Increase the number of nodes in the Amazon Athena cluster.

Store the data in Amazon RDS instead of Amazon S3.

Use Amazon Redshift Spectrum for querying instead of Athena.

Free AWS Certified Data Engineer (DEA-C01) Practice Test 13

Q1. A company is implementing enhanced security measures for their AWS-based web application. They want to ensure secure communication between the applications clients and the server. Which of the following methods should they use to facilitate certificate-based authentication?

Q2. A company is processing large datasets using Amazon EMR but wants to optimize costs. They typically run data processing jobs during off-peak hours. Which feature should they use to reduce costs without compromising on the processing capabilities?

Q3. A financial institution requires a solution for analyzing time-series data with efficient storage and fast query performance. The data is structured and they need to run frequent aggregations and time-based queries. Which AWS service is most suitable?

Q4. A startup is developing an IoT application that needs to process and store large volumes of incoming sensor data. The solution should offer fast and consistent read/write performance and be able to scale dynamically with the number of devices. Which AWS service is the best choice?

Q5. The data engineering team needs to remove duplicates and standardize formats in a dataset stored in Amazon S3 before analysis. The dataset is large, and the cleansing process needs to be automated. Which AWS service is best suited for automating this data cleansing process?

Q8. In an Amazon RDS environment, the database admin needs to ensure exclusive access to a database during a critical migration process. Which approach should they take to prevent other users from accessing the database during this time?

Q9. An organization wants to automate AWS resource deployments using scripts run through the AWS CLI. They need to ensure that these scripts have the necessary permissions to perform actions on AWS resources. What is the best practice for granting these permissions?

Q10. An organization is setting up a secure MQTT connection for its IoT devices to communicate with AWS IoT Core. Which authentication method should they use to establish a certificate-based secure connection?

Q11. A company is using AWS Lambda to process data files as they arrive in an Amazon S3 bucket. The Lambda function needs to be triggered automatically each time a new file is uploaded to the bucket. Which configuration ensures that the Lambda function is triggered correctly?

Q13. A data engineering team needs to process large amounts of log data stored in Amazon S3 using Apache Spark. They require a managed environment for Spark to simplify setup and management. Which AWS service should they use to meet these requirements?

Q14. A company wants to visualize streaming data in real-time to monitor the performance of their web application. Which combination of AWS services should be used to collect, process, and visualize this streaming data effectively?

Q15. A data engineering team is using Amazon DynamoDB for their application but occasionally encounters throttling issues due to high read/write throughput demands. What can they implement to manage the throughput more effectively and reduce the incidence of throttling?

Q16. A data engineering team is designing an AWS-based data processing solution where different team members require varied levels of access to AWS services and resources. How should they implement role-based authentication to manage access effectively?

Q17. An organization wants to analyze streaming data from social media platforms in real-time. The solution should handle high throughput and provide the ability to scale horizontally. Which AWS service combination is most suitable for cloud-based, distributed real-time analytics?

Q19. A data engineer needs to use the AWS Command Line Interface (CLI) for managing AWS resources. To securely manage AWS CLI access, which of the following is the recommended approach?

Q21. A company is using Amazon Athena to analyze their web traffic data stored in Amazon S3. They need to compute a 30-day rolling average of website hits. The table web_traffic contains columns date and hits. What is the appropriate SQL query in Athena to perform this calculation?

Q23. A data engineer needs to query a large dataset in Amazon S3 using Amazon Athena. The requirement is to generate a report that shows the total sales amount per product category for the last year. Which SQL query would accurately fulfill this requirement?

Q25. A financial services firm needs to process high-frequency trading data with minimal latency. This requires a data pipeline capable of handling large volumes of data with high throughput and low response times. Which AWS service is best suited to build this high-performance data pipeline?

Q28. A company has deployed a multi-tier web application on AWS, where different teams are responsible for the front-end, back-end, and database management. To implement role-based access control, which approach should they follow?

Q29. The company wants to perform real-time aggregation of streaming data from IoT devices and visualize the results. The data needs to be aggregated based on device type and reported every hour. Which AWS service combination is best for this real-time data aggregation and visualization?

Q30. An organization is using AWS IAM to manage access to its AWS resources. They want to implement a policy where access permissions are dynamically assigned based on user attributes like job function. What type of authorization mechanism should they implement?

Q32. A data engineering team needs to create an interactive dashboard to visualize and analyze sales data stored in AWS. The dashboard should allow non-technical users to easily explore data and generate reports. Which AWS service is most appropriate for this requirement?

Q33. A data engineering team is using AWS Glue DataBrew to prepare datasets for a machine learning project. They need to perform a transformation that involves removing duplicates based on specific columns. Which of the following approaches should they use in AWS Glue DataBrew to achieve this?

Q34. A Data Engineer is using AWS Lambda to aggregate and summarize data from multiple sources each night. The Lambda function runs longer than the default timeout period. Which action should the engineer take to ensure successful execution of the Lambda function?

Q35. A company is using an Amazon RDS instance and wants to restrict its access to only their office IP range for security reasons. Which method should they use to configure this access restriction?

Q37. A company is using Amazon Athena to query logs stored in Amazon S3. They need to ensure that queries are cost-effective. Which strategy should they adopt to reduce the cost of querying with Athena?

Q38. A data engineering team is implementing a new application that requires access to a database stored on Amazon RDS. They need a secure way to manage the database credentials and automate their rotation. Which AWS service should they use to achieve this?

Q39. A streaming application is sending data to Amazon Kinesis Data Streams. The company wants to perform light data transformation using an AWS Lambda function before storing the data in Amazon S3. How should the data engineer set up the system to enable this process?

Q40. A data engineering team is determining whether to use AWS managed policies or customer managed policies for their new IAM roles in AWS. They need a policy that can be tailored specifically to their unique access requirements. Which type of policy should they choose?

Q42. A data analytics team needs to process a large volume of data using Apache Spark and Hadoop for complex ETL operations. The solution should scale dynamically based on workload and offer cost-effective storage. Which AWS service best fits these requirements?

Q44. An organization is setting up IAM policies to control access to its AWS resources. They want to leverage prebuilt policies for common use cases but also require some policies that are specific to their organizational needs. What combination of IAM policy types should they use?

Q45. A companys security policy mandates that all credentials for accessing critical internal services must be rotated every 90 days. They are managing these credentials on AWS. Which service should they use to comply with this policy while minimizing manual intervention?

Q47. A company is processing large datasets for machine learning models. They require scalable compute resources to handle variable workloads and reduce processing time. Which AWS service best fits these requirements for cloud computing and distributed processing?

Q48. A development team is configuring an Amazon API Gateway to allow secure access to their backend services. They need to ensure that the API Gateway can authenticate requests using AWS IAM roles. What steps should they take to set up this authentication mechanism?

Q50. A data engineer needs to ensure that an AWS Lambda function can query data from an Amazon DynamoDB table. What is the recommended method for granting the necessary permissions to the Lambda function?

Q51. A data engineering team is setting up an ETL pipeline where they need to temporarily store processed data before it is loaded into an Amazon Redshift cluster. Which AWS service is most appropriate to use as an intermediate data staging location in this scenario?

Q52. An analytics platform needs to connect to and query data from a PostgreSQL database and an Oracle database. What is the most effective way to establish these connections from the platform?

Q53. A company needs to process and analyze large-scale log data generated by their web servers. The solution should support complex ETL jobs and allow for the flexible use of various big data frameworks and tools. Which AWS service is most suitable for these requirements?

Q58. A company is experiencing rate limits when ingesting data into Amazon Kinesis Data Streams. Which approach should they take to manage and overcome these rate limits?

Q59. An AWS environment includes a web server and a database server, both hosted on separate EC2 instances within a VPC. The web server needs unrestricted access to the database server. What is the recommended way to update the VPC security groups to allow this access?

Q60. A data engineering team is using Amazon Athena for ad-hoc querying of their data stored in Amazon S3. They need to optimize query performance for frequently accessed data. Which of the following actions should they take to achieve this?

Q1. A company is implementing enhanced security measures for their AWS-based web application. They want to ensure secure communication between the applications clients and the server. Which of the following methods should they use to facilitate certificate-based authentication?

Q45. A companys security policy mandates that all credentials for accessing critical internal services must be rotated every 90 days. They are managing these credentials on AWS. Which service should they use to comply with this policy while minimizing manual intervention?