Exam AWS Certified Big Data - Specialty topic 2 question 8 discussion

Exam question from Amazon's AWS Certified Big Data - Specialty

Question #: 8
Topic #: 2

[All AWS Certified Big Data - Specialty Questions]

An organization would like to run analytics on their Elastic Load Balancing logs stored in Amazon S3 and join this data with other tables in Amazon S3. The users are currently using a BI tool connecting with JDBC and would like to keep using this BI tool.
Which solution would result in the LEAST operational overhead?

A. Trigger a Lambda function when a new log file is added to the bucket to transform and load it into Amazon Redshift. Run the VACUUM command on the Amazon Redshift cluster every night.
B. Launch a long-running Amazon EMR cluster that continuously downloads and transforms new files from Amazon S3 into its HDFS storage. Use Presto to expose the data through JDBC.
C. Trigger a Lambda function when a new log file is added to the bucket to transform and move it to another bucket with an optimized data structure. Use Amazon Athena to query the optimized bucket.
D. Launch a transient Amazon EMR cluster every night that transforms new log files and loads them into Amazon Redshift.

Show Suggested Answer

Suggested Answer: C 🗳️

by VB at Sept. 22, 2019, 5:02 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

VB

Highly Voted 3 years, 8 months ago

C is correct ... "Q: Does Athena support other BI Tools and SQL Clients? Yes. Amazon Athena comes with an ODBC and JDBC driver that you can use with other business intelligence tools and SQL clients. Learn more about using an ODBC or JDBC driver with Athena.". This satisfies the requirement.

upvoted 13 times

...

susan8840

Most Recent 3 years, 7 months ago

C is LEAST operational overhead. Others may require existing BI tool to change

upvoted 4 times

...

san2020

3 years, 7 months ago

my selection C

upvoted 3 times

...

harry_123

3 years, 7 months ago

C is LEAST operational overhead

upvoted 4 times

...

cybe001

3 years, 8 months ago

Why not D, you can use JDBC to connect to Redshift

upvoted 1 times

shwang

3 years, 7 months ago

Vote D as well

upvoted 1 times

...

Corram

3 years, 7 months ago

Cause imagine you were a manager, and your employee would create a transient EMR cluster + a Amazon Redshift database just for some log file viewing in a BI tool, you'd be quite pissed with him too ;) admittedly, technically it would work tho

upvoted 3 times

...