Amazon DynamoDB: Building NoSQL Database-Driven Applications Quiz Answers

All Weeks Amazon DynamoDB: Building NoSQL Database-Driven Applications Quiz Answers

Amazon DynamoDB: Building NoSQL Database-Driven Applications Week 02 Quiz Answers

Week 2: Amazon DynamoDB: Building NoSQL Database-Driven Applications

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

• Relational database
• Key-value store
• Document store
• Graph store

Q2. What does the CAP Theorem stands for?

• Conformity, Availability and Persistence
• Conformity, Atomicity and Partition Tolerance
• Consistency, Availability and Partition Tolerance
• Consistency, Atomicity and Persistence

Q3. Which type of database should be used to store user session data with the highest scalability and effective way?

• Relational database
• Key-value store
• Wide-column store
• Graph store

Q4. Which of the following is the fastest way to get an item from DynamoDB?

• Scan
• Filter
• Query
• ItemQuery

Week 3: Amazon DynamoDB: Building NoSQL Database-Driven Applications

Q1. True or false: On-demand backups should only be taken when there is a lower amount of reads sent to the DynamoDB table as taking a backup can affect the latency of those reads.

• True
• False

Q2. Which of the following API calls will be captured in CloudTrail?

• Scan
• GetItem
• UpdateTable
• PutItem

Q3. Where can a backup from a DynamoDB Table be restored?

• In the same table in the same AWS Region.
• In the same table in a different AWS Region.
• A new table in the same AWS Region.
• A new table in a different AWS Region.

Q4. Which of the following service will help determine if the amount of Read Capacity Units and Write Capacity Units on a table is set appropriately?

• AWS Trusted Advisor
• Amazon CloudWatch Logs
• AWS CloudTrail
• Amazon CloudWatch Metrics

Week 4: Amazon DynamoDB: Building NoSQL Database-Driven Applications

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

• Use AWS Key Management Service to encrypt the data before storing it in DynamoDB.
• Use a library to encrypt the data before storing it in DynamoDB.
• Do nothing, it’s encrypted by default.
• Use the Amazon DynamoDB Encryption Client to encrypt the data before storing it in DynamoDB.

Q2. How can a user be authenticated with the DynamoDB service via the SDK?

• Using a Username and a Password.
• Using a Certificate.
• Using a API Keys.
• Using an Access Key and a Secret Access Key.

Q3. How can DynamoDB be accessed from within a VPC without going through an Internet Gateway?

• Use a NAT Gateway instead.
• Use a Virtual Private Gateway.
• Use a VPC Gateway Endpoint.
• Use the Private IP of DynamoDB.

Q4. How does DynamoDB know when to expire the items from a table using the Time To Live feature?

• When using the PutItem API call, a TTL parameter is specified in seconds at which to expire this particular item.
• An attribute in the item contains the time at which to expire the item.
• When enabling the TTL feature, an amount of time in seconds is specified as the amount of time each item can stay in the table.
• DynamoDB looks for an attribute named ExpirationTime as part of the item to know when to expire the item.

Week 5: Amazon DynamoDB: Building NoSQL Database-Driven Applications

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

• True
• False

Q2. When querying a DynamoDB Local Secondary Index that doesn’t have a required attribute specified in the query, what is the most optimal way to get the data if that attribute is rarely needed?

• After retrieving the data from the index, query the main table for the missing attribute.
• Modify the Projected attributes field to All.
• DynamoDB will return the attribute from the main table if it can’t find it in the index.
• Modify the Projected attributes field to Include and specify that specific attribute.

Q3. Where should large attribute values should be stored in relation to DynamoDB?

• Amazon Simple Storage Service
• Amazon Elasticsearch Service
• Amazon DynamoDB Streams
• In DynamoDB as there is no limit to the storage

Q4. Which of the following statement is TRUE concerning Amazon DynamoDB Accelerator (DAX)?

• DAX requires an entire rewrite of the application so that reads go to DAX and writes go to DynamoDB.
• DAX should be used for an application reading from the same partition key very often.
• DAX should be used to speed up an application doing a lot of writes to DynamoDB.
• DAX should be used for single digit millisecond latency reads.

End of Course Assessment

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

Graphical store

• Key-value store
• Document database
• Short-column database
• Relational database

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

• Local Secondary Index
• Global Secondary Index
• Partition Key
• Sort Key

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

• Partition Key name
• Sort Key name
• Read Capacity Unit and Write Capacity Unit
• Table name
• Attribute Definitions

Q4. 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?

• The BatchGetItem operation exceeds the maximum request of 100 items.
• The throughput exceeds the current throughput limit of the account.
• The queries aren’t uniformly distributed across all logical partition keys in the table.
• The amount of Write Capacity Unit consumed is higher than normal and uses Read Capacity Units instead.

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

• Amazon CloudWatch Logs
• AWS CloudTrail
• AWS X-Ray
• AWS Config

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

• Provisioned
• Reserved
• Dynamic
• On-demand
• Auto-Scale

Q7. 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
• 2
• 5
• 10

Q8. 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?

• Query the table and issue a sort on the Score attribute with a limit of 5 every minute.
• 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.
• Use DynamoDB Stream and AWS Lambda to update the dashboard each time a higher score is added.

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

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

Q10. Which statement is FALSE about DynamoDB Global Tables?

• DynamoDB Streams is used to replicate the data between tables.
• ll DynamoDB tables that are part of the DynamoDB Global Table can be written to.
• The data is synchronous replicated between tables.
• The tables must have the same write capacity management settings.

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

• Configure an Identity and Access Management Policy and apply it to the User.
• Create a Global Secondary Index (GSI) with only those specific attributes projected and only allow the GSI to be queried by the user.
• It’s not possible.
• Use the Amazon DynamoDB Encryption Client to encrypt the data and don’t allow that user to access the key to decrypt it.

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

• A table can have more Global Secondary Index than Local Secondary Index.
• Local and Global Secondary Indexes are synchronously updated when the main table is updated.
• A Local Secondary Index can only be created at the time of creation of a table.
• A Global Secondary Index can have a different Partition Key than the main table.

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

• Datasets with Time-Series Data.
• Datasets with Many-to-One Relationships.
• Datasets with similar access patterns.
• Datasets with Many-to-Many Relationships.

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

• Versioning of items
• Conditional writes
• Locking of items
• Transaction support

Q15. 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)?

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

Amazon DynamoDB: Building NoSQL Database-Driven Applications Coursera Course Review:

Get All Course Quiz Answers of Modern Application Development with Python on AWS Specialization

AWS Cloud Technical Essentials Coursera Quiz Answers

Building Modern Python Applications on AWS Coursera Quiz Answers

Amazon DynamoDB: Building NoSQL Database-Driven Applications Quiz Answers

Improve Your Python Code Using Amazon CodeGuru Coursera Quiz Answers