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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Amazon BDS-C00 Exam - Topic 4 Question 90 Discussion

A customer has an Amazon S3 bucket. Objects are uploaded simultaneously by a cluster of servers from multiple streams of data. The customer maintains a catalog of objects uploaded in Amazon S3 using an Amazon DynamoDB table. This catalog has the following fields StreamName, TimeStamp, and ServerName, TimeStamp, and ServerName, from which ObjectName can be obtained.The customer needs to define the catalog to support querying for a given stream or server within a defined time range.Which DynamoDB table scheme is most efficient to support these queries?
B) Define a Primary Key with StreamName as Partition Key and TimeStamp followed by ServerName as Sort Key. Define a Global Secondary Index with ServerName as Partition Key and TimeStamp followed by StreamName.
A) Define a Primary Key with ServerName as Partition Key and TimeStamp as Sort Key. Don NOT define a Secondary Index or Global Secondary Index.
C) Define a Primary Key with ServerName as Partition Key. Define a Local Secondary Index with StreamName as Partition Key. Define a Global Secondary Index with TimeStamp as Partition Key.
D) Define a Primary Key with ServerName as Partition Key. Define a Local Secondary Index with TimeStamp as Partition Key. Define a Global Secondary Index with StreamName as Partition key and TimeStamp as Sort Key.

Amazon BDS-C00 Exam - Topic 4 Question 90 Discussion

Actual exam question for Amazon's BDS-C00 exam
Question #: 90
Topic #: 4
[All BDS-C00 Questions]

A customer has an Amazon S3 bucket. Objects are uploaded simultaneously by a cluster of servers from multiple streams of data. The customer maintains a catalog of objects uploaded in Amazon S3 using an Amazon DynamoDB table. This catalog has the following fields StreamName, TimeStamp, and ServerName, TimeStamp, and ServerName, from which ObjectName can be obtained.

The customer needs to define the catalog to support querying for a given stream or server within a defined time range.

Which DynamoDB table scheme is most efficient to support these queries?

Show Suggested Answer Hide Answer
Suggested Answer: B

by Ailene at Apr 19, 2024, 09:19 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Ardella
6 months ago
Not sure if a GSI is really necessary here, though.
upvoted 0 times
...
Carry
6 months ago
B gives the flexibility needed for those queries.
upvoted 0 times
...
Chau
7 months ago
Surprised that D has so many indexes, seems overkill!
upvoted 0 times
...
Latrice
7 months ago
I disagree, I think A is simpler and more efficient.
upvoted 0 times
...
Carole
7 months ago
Option B seems like the best choice for querying by stream and server.
upvoted 0 times
...
Hyun
7 months ago
I’m a bit confused about the difference between Local and Global Secondary Indexes in this context. I think I leaned towards option D in my practice, but I’m not entirely confident.
upvoted 0 times
...
Dino
7 months ago
I practiced a similar question where we had to optimize for both time and stream queries, and I feel like a composite key might be the way to go, but I’m torn between B and D.
upvoted 0 times
...
Micah
8 months ago
I think option B sounds familiar; it might allow for more flexibility with the Global Secondary Index, but I can't recall if it’s the most efficient setup.
upvoted 0 times
...
Shelton
8 months ago
I remember we discussed how using ServerName as the Partition Key could help with queries related to specific servers, but I'm not sure if that's the best choice for time range queries.
upvoted 0 times
...
Maia
8 months ago
I'm feeling pretty confident about this one. I've designed similar DynamoDB tables before, so I think I can apply that experience to select the most efficient option for the given requirements.
upvoted 0 times
...
Gladys
8 months ago
Okay, I think I've got a strategy here. The key is supporting queries by stream, server, and time range. I'll need to carefully choose the partition and sort keys to enable those queries efficiently.
upvoted 0 times
...
Tawna
8 months ago
Hmm, I'm a bit confused by all the different index options. I'll need to review the details on partition keys, sort keys, and global/local secondary indexes to make sure I understand the trade-offs.
upvoted 0 times
...
Josefa
8 months ago
This looks like a tricky DynamoDB table design question. I'll need to carefully consider the query requirements and how the different key options can support them.
upvoted 0 times
...
Man
8 months ago
Okay, let's see. The question mentions migrating a legacy install base, so I'm guessing we'll need to populate objects related to the existing products and contracts, like Assets and Subscriptions. And of course, the Order and Quote objects would be important for the new Salesforce CPQ system.
upvoted 0 times
...
Laticia
8 months ago
Hmm, I'm a bit confused by the different variable syntax options. I'll need to double-check the documentation to make sure I understand how to properly reference the custom column.
upvoted 0 times
...
Tiara
8 months ago
This question seems straightforward, but I want to make sure I understand the key differences between 'PREPARE' and 'EXECUTE' before selecting an answer.
upvoted 0 times
...
Rutha
8 months ago
I have a feeling that “Apply Both Direction DISABLED” wouldn't support any connection, especially for HTTP. I might lean towards Option A, but I'm not 100% sure.
upvoted 0 times
...
Beatriz
1 year ago
Option B is the clear winner here. I mean, who doesn't love a good ol' Global Secondary Index? It's like the secret sauce of DynamoDB queries!
upvoted 0 times
Paulene
12 months ago
I think I'll go with Option B as well. Thanks for the input!
upvoted 0 times
...
Margot
12 months ago
Definitely! Global Secondary Indexes can really speed up the query process.
upvoted 0 times
...
Irving
1 year ago
I agree, Option B with the Global Secondary Index seems like the best choice for efficient querying.
upvoted 0 times
...
...
Domingo
1 year ago
Option B is the way to go! Partition keys and sort keys for the win. Now I just need to remember what a 'sort key' is...
upvoted 0 times
Berry
1 year ago
Yes, having StreamName as the Partition Key and TimeStamp followed by ServerName as the Sort Key will make querying for a given stream or server within a defined time range much more efficient.
upvoted 0 times
...
Melissa
1 year ago
I agree, Option B seems like the best choice for this scenario. Sort keys help with organizing the data.
upvoted 0 times
...
...
Man
1 year ago
I agree, Option B looks like the best solution. The global secondary index allows for efficient queries on both stream and server.
upvoted 0 times
...
Jennifer
1 year ago
That's a good point, I see your reasoning. Option D does seem to offer more options for querying.
upvoted 0 times
...
Theron
1 year ago
I disagree, I believe option D is better because it allows for more flexibility in querying.
upvoted 0 times
...
Josue
1 year ago
Option B seems the most efficient to me. Querying by stream or server within a time range can be easily supported with the primary key and secondary indexes defined.
upvoted 0 times
Gladys
1 year ago
Yes, option B with the Global Secondary Index provides the necessary flexibility for the customer's querying needs.
upvoted 0 times
...
Terry
1 year ago
Option B does seem to cover all the requirements for querying by stream or server within a defined time range.
upvoted 0 times
...
Shawn
1 year ago
I agree, option B with the Global Secondary Index seems like the most efficient way to support those queries.
upvoted 0 times
...
Sheridan
1 year ago
I think option B is the best choice. It allows for efficient querying by stream or server within a time range.
upvoted 0 times
...
...
Jennifer
1 year ago
I think option B is the most efficient.
upvoted 0 times
...

Save Cancel