Amazon BDS-C00 Exam - Topic 7 Question 104 Discussion

Actual exam question for Amazon's BDS-C00 exam

Question #: 104
Topic #: 7

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?

ATrigger 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.

BLaunch 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.

CTrigger 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.

DLaunch a transient Amazon EMR cluster every night that transforms new log files and loads them into Amazon Redshift.

Show Suggested Answer

Suggested Answer: D

by Ozell at Sep 18, 2024, 05:44 AM

Limited Time Offer

25%

Off

Get Premium BDS-C00 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Viola

3 months ago

C is definitely the way to go, less hassle overall!

upvoted 0 times

...

Fletcher

3 months ago

I think D might be better for more control over the data.

upvoted 0 times

...

Martin

3 months ago

Wait, can Lambda really handle that much data?

upvoted 0 times

...

Edda

4 months ago

I agree, using Athena is super efficient!

upvoted 0 times

...

Darrel

4 months ago

Option C seems like the best choice for low overhead.

upvoted 0 times

...

Shawnee

4 months ago

I practiced a similar question, and I think option C is the best because it uses Athena, which is serverless and easier to manage.

upvoted 0 times

...

Brice

4 months ago

I feel like option A could lead to issues with the VACUUM command in Redshift, which might add more maintenance work.

upvoted 0 times

...

Royal

4 months ago

I'm not entirely sure, but I think option B with EMR could be more complex to manage since it involves a long-running cluster.

upvoted 0 times

...

Rachael

5 months ago

I remember we discussed how using Lambda functions can help reduce operational overhead, so option C might be a good choice.

upvoted 0 times

...

Fannie

5 months ago

I'm leaning towards option C as well. Keeping the data optimized in S3 and using a serverless service like Athena feels like the cleanest approach here.

upvoted 0 times

...

Dexter

5 months ago

Option A with Redshift seems straightforward, but I'm worried about the operational overhead of running VACUUM commands every night. That could get messy.

upvoted 0 times

...

Emmanuel

5 months ago

I'm a bit confused by the differences between the EMR options. Option B seems to have a long-running cluster, while option D has a transient one. I'll need to think through the tradeoffs there.

upvoted 0 times

...

Brittney

5 months ago

I think option C looks the most promising. Using a Lambda function to transform and optimize the data, then querying it with Athena, seems like it would have the least operational overhead compared to the other options.

upvoted 0 times

...

Tina

5 months ago

Hmm, I'm a little unsure about this one. The wording is a bit tricky, and I want to make sure I understand the context before selecting an answer.

upvoted 0 times

...

Erasmo

10 months ago

I'd go with option E: hire a team of monkeys to manually transcribe the logs into a spreadsheet. Guaranteed zero operational overhead!

upvoted 0 times

Juan

9 months ago

Yeah, using Lambda to transform and move the logs to an optimized bucket for querying with Athena sounds efficient.

upvoted 0 times

...

Malika

9 months ago

I agree, option C seems like the best choice to minimize operational overhead.

upvoted 0 times

...

Kenneth

9 months ago

That's a creative solution, but I think we should stick with the options provided.

upvoted 0 times

...

Belen

10 months ago

I'm not a fan of long-running clusters, so B is out for me. I think I'll go with C - the optimized data structure and Athena seem like the way to go.

upvoted 0 times

Tamekia

8 months ago

Definitely, it seems like the most efficient choice.

upvoted 0 times

...

Louvenia

8 months ago

C sounds like a good option with the optimized data structure and Athena.

upvoted 0 times

...

Dominque

8 months ago

Yeah, I prefer a more streamlined solution.

upvoted 0 times

...

Darrin

10 months ago

I agree, long-running clusters can be a hassle.

upvoted 0 times

...

Sarah

10 months ago

Haha, I remember this kind of question from my AWS certification prep! Personally, I'd go for C. Athena is just so darn convenient.

upvoted 0 times

...

Son

10 months ago

Hmm, I'm leaning towards D. The transient EMR cluster seems like the simplest solution, and Redshift integration should work well with the BI tool.

upvoted 0 times

...

Gussie

10 months ago

This is a tricky one! I'm torn between C and D, but I think C might have the edge in terms of operational overhead.

upvoted 0 times

Edison

10 months ago

Yeah, I agree. Using Lambda to transform and move the files to an optimized bucket seems like a good solution.

upvoted 0 times

...

Luisa

10 months ago

I think C is the way to go, it seems like it would be less overhead.

upvoted 0 times

...

Nu

10 months ago

I prefer option D. Launching a transient EMR cluster every night for transformation and loading seems like a good approach.

upvoted 0 times

...

Altha

11 months ago

I agree with King. Using Lambda to transform and move files to an optimized bucket seems efficient.

upvoted 0 times

...

King

11 months ago

I think option C would result in the least operational overhead.

upvoted 0 times

...