Which of the following is a type of NoSQL Database

End of Course Assessment >>> Which of the following is a type of NoSQL Database >>> Amazon DynamoDB: Building NoSQL Database-Driven Applications

1.

Question 1

Which of the following is a type of NoSQL Database? Select two.

1 / 1 point

Graphical store

Key-value store

Document database

Short-column database

Relational database

2.

Question 2

Which of the following can be added or changed after the creation of a DynamoDB table?

1 / 1 point

Local Secondary Index

Sort Key

Partition Key

Global Secondary Index

7.

Question 7

How many Scan queries need to be sent to DynamoDB to get all the items from the table if the table contains 10 items each with 200KB of data?

1 / 1 point

12.

Question 12

Which of the following statement is FALSE concerning secondary indexes in DynamoDB?

1 / 1 point

A table can have more Global Secondary Index than Local Secondary Index.

A Local Secondary Index can only be created at the time of creation of a table.

Local and Global Secondary Indexes are synchronously updated when the main table is updated.

A Global Secondary Index can have a different Partition Key than the main table.

14.

Question 14

What feature of DynamoDB is necessary to make use of Optimistic Locking?

1 / 1 point

Versioning of items

Conditional writes

Transaction support

Locking of items

4.

Question 4

The metric of ConsumedReadCapacityUnits is currently much lower than the Read Capacity Unit provisioned on a DynamoDB table. However, users are saying that they are receiving an error message of ProvisionedThroughputExceededException. What could be the issue?

1 / 1 point

The amount of Write Capacity Unit consumed is higher than normal and uses Read Capacity Units instead.

The BatchGetItem operation exceeds the maximum request of 100 items.

The queries aren’t uniformly distributed across all logical partition keys in the table.

The throughput exceeds the current throughput limit of the account.

8.

Question 8

A DynamoDB table is made up of a Partition Key of UserID, a Sort Key with the date and time and an attribute of Score providing the list of all the scores for a game. A dashboard needs to display the 5 highest scores from the table. What is the most efficient way to keep this dashboard in real time?

1 / 1 point

Use DynamoDB Stream and AWS Lambda to update the dashboard each time a higher score is added.

Scan the table to read all the entries and sort the data in the code to find the highest score.

Scan the table and use a FilterExpression for any score that is higher than the last 5 high scores every minute.

Query the table and issue a sort on the Score attribute with a limit of 5 every minute.

15.

Question 15

Given a table that has a Partition Key of UserID, an attribute named AccountLocked and many other attributes. The AccountLocked attribute is set to TRUE when the UserID is has its account locked and isn’t set when it’s not locked. Not many accounts are typically locked at a time compared to the hundreds of thousands of users in that table. What would be the most optimal way to get a list of all UserID that have their account locked (AccountLocked set to TRUE)?

1 / 1 point

Create an index with UserID as the Primary Key and AccountLocked as the Sort Key. Send a Query to the index to find the list of account locked.

Send a scan to the table with the attribute_exists filter expression.

Send a query to the table with the attribute_exists filter expression.

Create an index with UserID as the Primary Key and AccountLocked as the Sort Key. Send a Scan to the index to find the list of account locked.

3.

Question 3

Which of the following are part of the mandatory parameters when creating a DynamoDB table via the SDK with the on-demand read/write capacity mode? Select two.

1 / 1 point

Sort Key name

Partition Key name

Attribute Definitions

Table name

Read Capacity Unit and Write Capacity Unit

6.

Question 6

What are the two types of read/write capacity modes for processing reads and writes on your tables? Select 2.

1 / 1 point

Provisioned

Reserved

Dynamic

On-demand

Auto-Scale

11.

Question 11

How can the permissions of a user be restricted only query specific attributes with the least amount of work?

1 / 1 point

Use the Amazon DynamoDB Encryption Client to encrypt the data and don’t allow that user to access the key to decrypt it.

It’s not possible.

Create a Global Secondary Index (GSI) with only those specific attributes projected and only allow the GSI to be queried by the user.

Configure an Identity and Access Management Policy and apply it to the User.

13.

Question 13

What type of datasets stored in DynamoDB should be spread across more than one table?

1 / 1 point

Datasets with Many-to-One Relationships.

Datasets with similar access patterns.

Datasets with Time-Series Data.

Datasets with Many-to-Many Relationships.

5.

Question 5

Which of the following AWS service will help determine latency issues per query in DynamoDB?

1 point

Amazon CloudWatch Logs
AWS CloudTrail

AWS X-Ray
AWS Config

9.

Question 9

How can the data at rest that was encrypted by DynamoDB be decrypted?

1 point

Use the Amazon DynamoDB Encryption Client to decrypt the data on the client side.

In the query to DynamoDB, send the key to use to decrypt it and let DynamoDB handle the decryption.

Send a query to DynamoDB as normal and let it transparently decrypt the data.

Send a query to DynamoDB and use the AWS Key Management Service to decrypt the data on the client side.

10.

Question 10

Which statement is FALSE about DynamoDB Global Tables?

1 point

ll DynamoDB tables that are part of the DynamoDB Global Table can be written to.

The data is synchronous replicated between tables.

DynamoDB Streams is used to replicate the data between tables.

The tables must have the same write capacity management settings.

[rank_math_breadcrumb]

Which of the following is a type of NoSQL Database

End of Course Assessment >>> Which of the following is a type of NoSQL Database >>> Amazon DynamoDB: Building NoSQL Database-Driven Applications

1.

2.

7.

12.

14.

4.

8.

15.

3.

6.

11.

13.

5.

9.

10.

Using Optimistic Locking the user is responsible for managing the version of an item using an attribute

How can the data of a DynamoDB Table be encrypted at rest with the least amount of work

Which type of database should be used to query normalized highly structured data

True or false On demand backups should only be taken when there is a lower amount