exam questions

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

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 Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
GiorgioGss
Highly Voted 1 year, 1 month 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 10 months, 3 weeks 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 1 week, 4 days ago
Selected Answer: B
B makes sense
upvoted 1 times
...
lsj900605
5 months, 2 weeks 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
...
Selected Answer: B
Athena datasource doesn't specifially enable Spark access
upvoted 2 times
...
andrologin
9 months, 3 weeks 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
11 months, 1 week 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, 1 month ago
Selected Answer: B
https://docs.aws.amazon.com/athena/latest/ug/notebooks-spark-getting-started.html
upvoted 3 times
...
kj07
1 year, 1 month 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, 1 month 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, 2 months ago
Selected Answer: C
https://docs.aws.amazon.com/athena/latest/ug/notebooks-spark.html
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago