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
Goldie
3 days ago
I think C, D, and B are the best choices. Easy to implement.
upvoted 0 times
...
Merlyn
8 days ago
B is user-friendly. QuickSight makes graphs simple.
upvoted 0 times
...
Antione
13 days ago
I’m not sure about B. Isn’t it more complex?
upvoted 0 times
...
Rex
18 days ago
Agreed! C for querying, D for metadata, and B for visualization.
upvoted 0 times
...
Sheridan
23 days ago
I think C, D, and B are the best choices. Easy to implement.
upvoted 0 times
...
Joseph
29 days ago
QuickSight is a solid option for graphs!
upvoted 0 times
...
Stephaine
1 month ago
I don't think DynamoDB is the best choice for metadata here.
upvoted 0 times
...
Malinda
3 months ago
Wait, can Athena really handle 100 GB efficiently?
upvoted 0 times
...
Rima
3 months ago
B sounds good for visualization too!
upvoted 0 times
...
Penney
3 months ago
Definitely C and D for sure!
upvoted 0 times
...
Mila
3 months ago
A is not really needed here, right?
upvoted 0 times
...
Kristal
3 months ago
Wait, can Athena really handle 100 GB efficiently?
upvoted 0 times
...
Izetta
3 months ago
I think E is overkill for metadata.
upvoted 0 times
...
Larue
4 months ago
B sounds good for visualization too!
upvoted 0 times
...
Leatha
4 months ago
Definitely C and D for sure!
upvoted 0 times
...
Daisy
4 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
4 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
4 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
5 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