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

An analytics team frequently runs complex Amazon Athena queries on a dataset stored in an Amazon S3 bucket, with AWS Glue Data Catalog serving as the metadata repository. They've identified a slowdown in Athena query plans and attribute it to the excessive number of S3 partitions. The team needs to enhance query performance and reduce the time Athena takes in query planning.

Which two measures should the team take to meet these performance goals? (Select TWO.)

A : Implement AWS Glue Elastic Views to automate partition management.

B : Employ Athena's partition projection for dynamic partitioning based on common query patterns.

C : Merge small S3 objects into larger ones using AWS Glue's data transformation jobs.

D : Use Athena DML statements to reorganize data into fewer, more meaningful partitions.

E : Transform the data that is in the S3 bucket to Apache Parquet format.

Answer: B,E

Question 3

A data engineering team at an online retail company is optimizing the performance of their Amazon Redshift data warehouse. The warehouse contains a large sales table with millions of rows and a smaller products table. Queries often join these two tables, and the team wants to optimize the query performance, especially for these join operations.

Which Redshift distribution style should the team use for the sales and products tables to enhance query performance?

A : Configure the sales table to ALL distribution and the products table to EVEN distribution.

B : Configure the sales table to AUTO distribution and the products table to ALL distribution.

C : Configure the sales table to EVEN distribution and the products table to KEY distribution.

D : Configure KEY distribution for both the sales and products tables based on the join column.

Answer: B

Question 4

A data engineer at a healthcare company needs to implement a solution to ensure that sensitive patient data in an Amazon S3 bucket is encrypted at rest. The company's security policy mandates the use of customer-managed keys for encryption to meet compliance requirements. The data engineer must also ensure that key usage can be audited.

Which of the following would be the MOST suitable solution?

A : Use server-side encryption with AWS KMS managed keys (SSE-KMS), create a customer managed key, and enable logging and auditing via AWS CloudTrail.

B : Encrypt data client-side using a customer-managed encryption library before uploading to S3, and utilize AWS CloudWatch for monitoring access.

C : Implement server-side encryption with AWS KMS managed keys (SSE-KMS), using an AWS managed key (default key), and track key usage through AWS Config.

D : Enable server-side encryption on the S3 bucket with Amazon S3 managed keys (SSE-S3) and use AWS CloudTrail to audit key usage.

Answer: A

Question 5

As a Cloud Data Engineering Consultant, you are assisting a client in setting up a data warehouse using Amazon Redshift. The client's data warehouse stores sensitive financial information and is used by various departments within the organization, each requiring different levels of access. The client emphasizes the need for secure data sharing practices that would allow specific teams to access only the data relevant to their work. They seek your advice on implementing a solution within Amazon Redshift to grant permissions effectively and securely for sharing data across different teams.

To meet the client's need for secure, role-specific data access in their Amazon Redshift data warehouse, which of the following approaches would you recommend?

A : Utilize Redshift Spectrum to create external schemas and tables, granting access to these external tables to specific IAM roles assigned to different teams.

B : Configure Amazon Redshift Security Groups to control which teams can access the data warehouse, assigning specific IP address ranges for each team.

C : Leverage Amazon Redshift's Row-Level Security (RLS) feature to control access to rows of data based on user attributes such as team or role, enabling fine-grained access control within shared tables.

D : Implement Redshift Data Sharing to share live data across different Redshift clusters, using Redshift's ALTER DATASHARE command to add and manage consumer clusters' access to the data.

Answer: C