Question 1

A data engineer needs to maintain a central metadata repository that users access through Amazon EMR and

Amazon Athena queries. The repository needs to provide the schema and properties of many tables. Some of

the metadata is stored in Apache Hive. The data engineer needs to import the metadata from Hive into the

central metadata repository.

Which solution will meet these requirements with the LEAST development effort?

Options :

A : Use Amazon EMR and Apache Ranger.

B : Use a Hive metastore on an EMR cluster.

C : Use the AWS Glue Data Catalog.

D : Use a metastore on an Amazon RDS for MySQL DB instance.

Answer: C

Question 2

A company is migrating a legacy application to an Amazon S3 based data lake. A data engineer reviewed data

that is associated with the legacy application. The data engineer found that the legacy data contained some

duplicate information.

The data engineer must identify and remove duplicate information from the legacy application data.

Which solution will meet these requirements with the LEAST operational overhead?

Options :

A :

Write a custom extract, transform, and load (ETL) job in Python. Use the DataFramedrop duplicatesf) function by importingthe Pandas library to perform data deduplication.

B :

Write an AWS Glue extract, transform, and load (ETL) job. Usethe FindMatches machine learning(ML) transform to transform the data to perform data deduplication.

C :

Write a custom extract, transform, and load (ETL) job in Python. Import the Python dedupe library. Use the dedupe library to perform data deduplication.

D :

Write an AWS Glue extract, transform, and load (ETL) job. Import the Python dedupe library. Use the dedupe library to perform data deduplication.

Answer: B

Question 3

A Cloud Data Engineering Team is responsible for maintaining a large-scale application hosted on AWS. The team needs to analyze the application's logs efficiently to monitor performance and identify issues.

These logs are currently stored in JSON format in an Amazon S3 bucket and are frequently updated. The team wants to leverage a service that can query these logs directly from S3 with minimal setup and maintenance, allowing them to quickly derive insights and patterns.

Which AWS service should they choose for this purpose?

Options :

A : Configure Amazon EMR with Apache Spark to process and analyze the log data stored in S3.

B : Set up an Amazon OpenSearch Service domain to index the log data, enabling powerful search and analysis capabilities.

C : Use Amazon Athena to directly query the logs in S3 using SQL-like queries without the need for loading data into a separate analytics tool.

D : Deploy a custom log analysis solution on Amazon EC2 instances, utilizing tools like Elasticsearch for querying and analysis.

Answer: C

Question 4

A data engineer is using Amazon Athena to analyze sales data that is in Amazon S3. The data engineer writes

a query to retrieve sales amounts for 2023 for several products from a table named sales_data. However, the

query does not return results for all of the products that are in the sales_data table. The data engineer needs to

troubleshoot the query to resolve the issue.

The data engineer's original query is as follows:

SELECT product_name, sum(sales_amount)

FROM sales_data

WHERE year = 2023

GROUP BY product_name

How should the data engineer modify the Athena query to meet these requirements?

Options :

A : Replace sum(sales amount) with count(*J for the aggregation.

B : Change WHERE year = 2023 to WHERE extractlyear FROM sales data) = 2023.

C : Add HAVING sumfsales amount) > 0 after the GROUP BY clause.

D : Remove the GROUP BY clause

Answer: B

Question 5

A data engineer needs to create an Amazon Athena table based on a subset of data from an existing Athena

table named cities_world. The cities_world table contains cities that are located around the world. The data

engineer must create a new table named cities_us to contain only the cities from cities_world that are located

in the US.

Which SQL statement should the data engineer use to meet this requirement?

Options :

A :

B :

C :

D :

Answer: A

Confidently Practice Online with Free AWS-DEA-C01 Exam Cram

Buying Options: