Free Amazon AWS-DEA-C01 Exam Questions

Question 1

Files from multiple data sources arrive in an Amazon S3 bucket on a regular basis. A data engineer wants to ingest new files into Amazon Redshift in near real time when the new files arrive in the S3 bucket. Which solution will meet these requirements?

A : Use the query editor v2 to schedule a COPY command to load new files into Amazon Redshift.

B : Use the zero-ETL integration between Amazon Aurora and Amazon Redshift to load new files into Amazon Redshift.

C : Use AWS Glue job bookmarks to extract, transform, and load (ETL) load new files into Amazon Redshift.

D : Use S3 Event Notifications to invoke an AWS Lambda function that loads new files into Amazon Redshift.

Answer: D

Question 2

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 3

As a Data Engineer, you've been given the task of enhancing the performance of a business analytics application. This application predominantly performs complex, read-intensive queries against large, historical datasets.

The data is currently housed in a MySQL database on Amazon RDS. However, due to the increasing dataset size and query complexity, query performance has significantly degraded. To address this issue, you are considering implementing Amazon ElastiCache.

Which caching strategy would be most effective in this scenario to improve query performance?

A : Use ElastiCache for Memcached implementing an Invalidation strategy, where cache entries are invalidated or updated whenever the database write operations occur.

B : Implement ElastiCache for Redis using a Lazy-Loading strategy, loading data into the cache only when it is requested.

C : Utilize ElastiCache for Memcached with a Write-Through caching strategy, ensuring data is written to both the cache and the database simultaneously.

D : Deploy ElastiCache for Redis with a Write-Around caching strategy, where data is written directly to the database and only the data read from the database is cached.

Answer: B

Question 4

A company receives test results from testing facilities that are located around the world. The company storesthe test results in millions of 1 KB JSON files in an Amazon S3 bucket. A data engineer needs to process thefiles, convert them into Apache Parquet format, and load them into Amazon Redshift tables. The dataengineer uses AWS Glue to process the files, AWS Step Functions to orchestrate the processes, and AmazonEventBridge to schedule jobs.The company recently added more testing facilities. The time required to process files is increasing. The dataengineer must reduce the data processing time.Which solution will MOST reduce the data processing time?

A : Use AWS Lambda to group the raw input files into larger files. Write the larger files back to Amazon S3. Use AWS Glue to process the files. Load the files into the Amazon Redshift tables.

B : Use the AWS Glue dynamic frame file-grouping option to ingest the raw input files. Process the files. Load the files into the Amazon Redshift tables.

C : Use the Amazon Redshift COPY command to move the raw input files from Amazon S3 directly into the Amazon Redshift tables. Process the files in Amazon Redshift.

D : Use Amazon EMR instead of AWS Glue to group the raw input files. Process the files in Amazon EMR. Load the files into the Amazon Redshift tables.

Answer: B

Question 5

Files from multiple data sources arrive in an Amazon S3 bucket on a regular basis. A data engineer wants to ingest new files into Amazon Redshift in near real time when the new files arrive in the S3 bucket. Which solution will meet these requirements?

A : Use the query editor v2 to schedule a COPY command to load new files into Amazon Redshift.

B : Use the zero-ETL integration between Amazon Aurora and Amazon Redshift to load new files into Amazon Redshift.

C : Use AWS Glue job bookmarks to extract, transform, and load (ETL) load new files into Amazon Redshift.

D : Use S3 Event Notifications to invoke an AWS Lambda function that loads new files into Amazon Redshift.

Answer: D