Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Amazon DOP-C02 Exam - Topic 4 Question 59 Discussion

A company is storing 100 GB of log data in .csv format in an Amazon S3 bucket. SQL developers want to query this data and generate graphs to visualize it. The SQL developers also need an efficient, automated way to store metadata from the .csv file. Which combination of steps will meet these requirements with the LEAST amount of effort? (Select THREE.)
B) Filter the data through Amazon QuickSight to visualize the data. and C) Query the data with Amazon Athena. and E) Use Amazon DynamoDB as the persistent metadata store.
A) Filter the data through AWS X-Ray to visualize the data.
D) Use the AWS Glue Data Catalog as the persistent metadata store.
F) Query the data with Amazon Redshift.

Amazon DOP-C02 Exam - Topic 4 Question 59 Discussion

Actual exam question for Amazon's DOP-C02 exam
Question #: 59
Topic #: 4
[All DOP-C02 Questions]

A company is storing 100 GB of log data in .csv format in an Amazon S3 bucket. SQL developers want to query this data and generate graphs to visualize it. The SQL developers also need an efficient, automated way to store metadata from the .csv file. Which combination of steps will meet these requirements with the LEAST amount of effort? (Select THREE.)

Show Suggested Answer Hide Answer
Suggested Answer: B, C, E

Contribute your Thoughts:

0/2000 characters
Malinda
24 days ago
Wait, can Athena really handle 100 GB efficiently?
upvoted 0 times
...
Rima
29 days ago
B sounds good for visualization too!
upvoted 0 times
...
Penney
1 month ago
Definitely C and D for sure!
upvoted 0 times
...
Mila
1 month ago
A is not really needed here, right?
upvoted 0 times
...
Kristal
1 month ago
Wait, can Athena really handle 100 GB efficiently?
upvoted 0 times
...
Izetta
2 months ago
I think E is overkill for metadata.
upvoted 0 times
...
Larue
2 months ago
B sounds good for visualization too!
upvoted 0 times
...
Leatha
2 months ago
Definitely C and D for sure!
upvoted 0 times
...
Daisy
2 months ago
I think we discussed that using AWS Glue for metadata is efficient, but I wonder if there are other options that might work better.
upvoted 0 times
...
Shawnta
2 months ago
I feel like Amazon QuickSight is the go-to for visualizing data, so option B should be included. It seems like a straightforward choice.
upvoted 0 times
...
Kaitlyn
3 months ago
I'm a bit unsure about the metadata storage part. I think AWS Glue Data Catalog makes sense, but I also vaguely recall something about DynamoDB.
upvoted 0 times
...
Hermila
3 months ago
I remember practicing with Amazon Athena for querying S3 data, so I think option C is definitely one of the right answers.
upvoted 0 times
...

Save Cancel