Exam AWS Certified Data Engineer - Associate DEA-C01 All Questions

View all questions & answers for the AWS Certified Data Engineer - Associate DEA-C01 exam

Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 45 discussion

Exam question from Amazon's AWS Certified Data Engineer - Associate DEA-C01

Question #: 45
Topic #: 1

[All AWS Certified Data Engineer - Associate DEA-C01 Questions]

A company uses Amazon Athena to run SQL queries for extract, transform, and load (ETL) tasks by using Create Table As Select (CTAS). The company must use Apache Spark instead of SQL to generate analytics.
Which solution will give the company the ability to use Spark to access Athena?

A. Athena query settings
B. Athena workgroup
C. Athena data source
D. Athena query editor

Show Suggested Answer

Suggested Answer: B 🗳️

by rralucard_ at Feb. 2, 2024, 9:33 a.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

GiorgioGss

Highly Voted 1 year, 5 months ago

Selected Answer: B

https://docs.aws.amazon.com/athena/latest/ug/notebooks-spark-getting-started.html "To use Apache Spark in Amazon Athena, you create an Amazon Athena workgroup that uses a Spark engine."

upvoted 9 times

...

pypelyncar

Highly Voted 1 year, 2 months ago

Selected Answer: C

The Athena data source acts as a bridge between Athena and other analytics engines, such as Apache Spark. By using the Athena data source connector, you can access data stored in various formats (e.g., CSV, JSON, Parquet) and locations (e.g., Amazon S3, Apache Hive Metastore) through Spark applications

upvoted 5 times

...

Tester_TKK

Most Recent 4 months ago

Selected Answer: B

B makes sense

upvoted 1 times

...

lsj900605

9 months, 1 week ago

Selected Answer: B

It is B, not C. The workgroup is for organizing, controlling, and monitoring queries. The Data source is the mechanism that enables Spark to query data via Athena. It allows Spark to interact with Athena. The question focuses on enabling Apache Spark within Athena to generate analytics instead of using SQL. Thus, you must create a Spark-enabled workgroup

upvoted 2 times

...

theloseralreadytaken

9 months, 4 weeks ago

Selected Answer: B

Athena datasource doesn't specifially enable Spark access

upvoted 2 times

...

andrologin

1 year, 1 month ago

Selected Answer: B

https://docs.aws.amazon.com/athena/latest/ug/notebooks-spark-getting-started.html To get started with Apache Spark on Amazon Athena, you must first create a Spark enabled workgroup. After you switch to the workgroup, you can create a notebook or open an existing notebook. When you open a notebook in Athena, a new session is started for it automatically and you can work with it directly in the Athena notebook editor.

upvoted 2 times

...

lalitjhawar

1 year, 2 months ago

C. Athena data source The Athena data source is a specific connector or library that allows Apache Spark to interact with data stored in Amazon Athena. This connector enables Spark to read data from Athena tables directly into Spark DataFrames or RDDs (Resilient Distributed Datasets), allowing you to perform analytics and transformations using Spark's capabilities.

upvoted 4 times

...

blackgamer

1 year, 4 months ago

Selected Answer: B

https://docs.aws.amazon.com/athena/latest/ug/notebooks-spark-getting-started.html

upvoted 3 times

...

kj07

1 year, 5 months ago

B is the correct answer. https://aws.amazon.com/blogs/big-data/explore-your-data-lake-using-amazon-athena-for-apache-spark/ You need an Athena workgroup as a prerequisite to use Apache Spark.

upvoted 1 times

...

damaldon

1 year, 5 months ago

B. is the correct answer. To use Apache Spark in Amazon Athena, you create an Amazon Athena workgroup that uses a Spark engine. https://docs.aws.amazon.com/athena/latest/ug/notebooks-spark-getting-started.html

upvoted 3 times

...

rralucard_

1 year, 6 months ago

Selected Answer: C

https://docs.aws.amazon.com/athena/latest/ug/notebooks-spark.html

upvoted 2 times

...