Free AWS-DEA-C01 Exam Questions - Easiest Way for Success

Prepare for the Amazon AWS-DEA-C01 exam questions with our authentic preparation materials, including free AWS-DEA-C01 practice exam questions and answers. TheExamsLab provides all the support you need to succeed in the AWS Certified Data Engineer - Associate AWS-DEA-C01 exam. This dedication to student success is why we have the most satisfied AWS-DEA-C01 certification exam candidates worldwide.

Page: 1 / 89

Total 441 Questions | Updated On: Sep 14, 2024

Add To Cart

Question 1

A Cloud Data Engineer is tasked with setting up a secure and reliable connection from an AWS-based analytics service to an on-premises Microsoft SQL Server database. The goal is to perform regular data import operations.

Which approach would be most effective and secure for accomplishing this task?

A : Configure an AWS Lambda function within the VPC to use a JDBC connection with the database credentials hard-coded for simplicity and speed.

B : Implement an AWS Direct Connect link between the on-premises network and AWS, and use a JDBC connection with database credentials stored in Amazon RDS.

C : Use AWS DataSync with an ODBC connection to the SQL Server, ensuring the connection over the internet is encrypted with TLS.

D : Establish a VPN connection between the on-premises network and AWS VPC, and then use JDBC with SSL encryption to connect to the SQL Server.

Answer: D

Question 2

A company has a production AWS account that runs company workloads. The company's security team

created a security AWS account to store and analyze security logs from the production AWS account. The

security logs in the production AWS account are stored in Amazon CloudWatch Logs.

The company needs to use Amazon Kinesis Data Streams to deliver the security logs to the security AWS

account.

Which solution will meet these requirements?

A : Create a destination data stream in the production AWS account. In the security AWS account, create an IAM role that has cross-account permissions to Kinesis Data Streams in the production AWS account.

B : Create a destination data stream in the security AWS account. Create an IAM role and a trust policy to grant CloudWatch Logs the permission to put data into the stream. Create a subscription filter in the security AWS account.

C : Create a destination data stream in the production AWS account. In the production AWS account, create an IAM role that has cross-account permissions to Kinesis Data Streams in the security AWS account

D : Create a destination data stream in the security AWS account. Create an IAM role and a trust policy to grant CloudWatch Logs the permission to put data into the stream. Create a subscription filter in the production AWS account.

Answer: D

Question 3

A data engineering team wants to run SQL queries on their Amazon Redshift cluster from various applications without managing database connections. Which AWS service allows them to submit and manage these queries efficiently?

A : Implement AWS Lambda with Redshift as a trigger for query execution.

B : Use the Amazon Redshift Query Editor for direct SQL execution.

C : Use the Amazon Redshift Data API to run and manage SQL queries.

D : Deploy Amazon EC2 instances to host applications that connect to Redshift.

Answer: C

Question 4

A company plans to move 10 TB of multimedia content from their local servers to AWS, with a portion of the data being updated weekly. These updates must be reflected in the Amazon S3 bucket where the data will be stored. The multimedia content consists of large image and video files.

To automate and schedule these data transfers effectively, which AWS service should the company employ?

A : Use AWS Transfer for SFTP to secure and automate data transfer to S3.

B : Use AWS DataSync to automate and schedule the ongoing transfer of files to Amazon S3.

C : Set up an AWS Snowball job for periodic data transfer to Amazon S3.

D : Deploy an AWS Storage Gateway to synchronize and manage data transfers to S3.

Answer: B

Question 5

A company is deploying a stateful application on Amazon EC2 that requires temporary storage for processing large datasets with maximum I/O. The application must also maintain a smaller subset of essential state data that needs to persist beyond the life of the instance. The company needs a storage solution that ensures the essential data is not lost if the EC2 instance is stopped or terminated.

Which combination of storage solutions should the company choose?

A : Attach Amazon EBS volumes for essential state data and use Amazon DynamoDB for temporary data.

B : Attach additional Amazon EBS volumes for temporary data processing and rely on the root device volume for essential state data.

C : Attach Amazon EC2 instance store volumes for temporary data processing and Amazon Elastic Block Store (EBS) for essential state data.

D : Implement a combination of Amazon EC2 instance store volumes for rapid I/O and EBS snapshots for daily backups of essential data.

Answer: C

Page: 1 / 89

Total 441 Questions | Updated On: Sep 14, 2024

Add To Cart