Amazon Exam BDS-C00 Topic 4 Question 90 Discussion

Actual exam question for Amazon's BDS-C00 exam

Question #: 90
Topic #: 4

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?

ADefine a Primary Key with ServerName as Partition Key and TimeStamp as Sort Key. Don NOT define a Secondary Index or Global Secondary Index.

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

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

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

Show Suggested Answer

Suggested Answer: B

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

Limited Time Offer

25%

29 days 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

Shawn

5 days ago

I agree, option B with the Global Secondary Index seems like the most efficient way to support those queries.

upvoted 0 times

...

Sheridan

7 days 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 months ago

I think option B is the most efficient.

upvoted 0 times

...