DynamoDB

Question 1

What is Amazon DynamoDB?

Answer 1

Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability.

Question 2

DynamoDB also offers encryption at rest, why is this a benefit to AWS Customers?

Answer 2

Encryption at rest eliminates the operational burden and complexity of protecting sensitive data.

Question 3

DynamoDB provides on-demand backup capability.
Which creates full backups of your tables for which two purposes?

Answer 3

DynamoDB allows you to create full backups of your tables for long-term retention and archival for regulatory compliance needs

Question 4

How does DynamoDB provide built-in high availability and data durability?

Answer 4

All of your data is stored on solid-state disks (SSDs) and is automatically replicated across multiple Availability Zones in an AWS Region,

Question 5

Describe global tables purpose in relation to DynamoDB?

Answer 5

You can use global tables to keep DynamoDB tables in sync across AWS Regions.

Question 6

What are the three Core components of Amazon DynamoDB?

Answer 6

In DynamoDB, tables, items, and attributes are the core components that you work with.

Question 7

How do tables, items, and attributes work together?

Answer 7

A table is a collection of items, and each item is a collection of attributes.

Question 8

Describe how DynamoDB uses primary keys.

What features does the addition of secondary indexes provide you in DynamoDB

Answer 8

DynamoDB uses primary keys to uniquely identify each item in a table.
DynamoDB uses secondary indexes to provide more querying flexibility.

Question 9

DynamoDB: What is a table?

Answer 9

A table is a collection of data.

For example, a table called People that you could use to store personal contact information about friends, family, or anyone else of interest.

Question 10

DynamoDB: What is an item?

Answer 10

An item is a group of attributes that is uniquely identifiable among all of the other items.

In a People table, each item represents a person.

Question 11

Items in DynamoDB are similar to ____ in other database systems.

Answer 11

Items in DynamoDB are similar to rows in other database systems.

Question 12

DynamoDB: What are attributes?

Answer 12

Each item within a table is composed of one or more attributes.

For example, an item in a People table contains attributes like PersonID, LastName, FirstName, and so on.

Question 13

Attributes in DynamoDB are similar in many ways to ______ or _________ in other database systems.

Answer 13

Attributes in DynamoDB are similar in many ways to fields or columns in other database systems.

Question 14

What does it mean when someone says your table is schemaless?

Answer 14

Schemaless means that neither the attributes nor their data types must be defined beforehand. Each item can have its own distinct attributes.

Question 15

What is an example of a nested attribute?

Answer 15

Some of the items have a nested attribute (Address). DynamoDB supports nested attributes up to 32 levels deep.

Take a look at the address in this example.

Question 16

When you create a table, in addition to the table name, you must specify the

Answer 16

primary key of the table

Question 17

What is the function of the primary key?

Answer 17

The primary key uniquely identifies each item in the table so that no two items can have the same key.

Question 18

DynamoDB supports two different kinds of primary keys:

Answer 18

Simple Primary Key aka Partition Primary Key
and a Composite Primary Key

Question 19

What are the components of a Simple Primary key?

Answer 19

A Simple primary key is made up of one attribute known as the partition key.

Question 20

What happens if you try to add two items with the same partition key value in a table with a Simple Primary key setup?

Answer 20

No two items can have the same partition key value in a table with only a partition key. You will get an error.

Question 21

What are the components of a Composite Primary key?

Answer 21

A Composite Primary Key is composed of two attributes:
Partition key and Sort key

Question 22

Explain how Composite Primary Key differs from a Partition Primary Key.

Answer 22

In a table that has a (Partition key and a Sort key = Composite Primary Key) it’s possible for multiple items to have the same partition key value. However, those items must have different sort key values.

Question 23

How are items in a table sorted when using a Composite Primary Key?

Answer 23

All items with the same partition key value are stored together, in ascending order by sort key value.

Question 24

What type of flexibility does Composite Primary Key give you when querying data?

Answer 24

For example, if you provide only the value for Artist, DynamoDB retrieves all of the songs by that artist. To retrieve only a subset of songs by a particular artist, you can provide a value for the Artist and a range of values for SongTitle.

Question 25

The partition key of an item is also known as its

Answer 25

hash attribute.
A partition key notes where the data will be stored in the data base

Question 26

The sort key of an item is also known as its range attribute. Where is the term range derived from?

Answer 26

The term range attribute derives from how DynamoDB stores items with the same partition key physically close together, in sorted order by the sort key value.

Question 27

A sort key is a way to represent what type of relationship?

Answer 27

A sort key is a way to represent a 1:many relationship

Question 28

What is the purpose of a secondary index?

Answer 28

A secondary index lets you query the data in the table using an alternate key

Question 29

DynamoDB supports two kinds of indexes:

Answer 29

Global secondary index
Local secondary index

Question 30

What are the features of a Global secondary index

Answer 30

An index with a partition key and sort key that can be different from those on the table.

Question 31

What are the features of a Local secondary index

Answer 31

An index that has the same partition key as the table, but a different sort key.

Question 32

DynamoDB Streams is an optional feature that captures what?

Answer 32

DynamoDB Streams is an optional feature that captures data modification events in DynamoDB tables.

Question 33

DynamoDB Streams data about events that appear in the stream in near-real time and in the

Answer 33

the order that the events occurred

Question 34

If you enable a stream on a table, DynamoDB Streams writes a stream record whenever one of the following events occurs: (3)

Answer 34

A new item is added to the table:

An item is updated:

An item is deleted from the table:

Question 35

What does a DB stream capture when A new item is added to the table:

Answer 35

The stream captures an image of the entire item, including all of its attributes.

Question 36

What does a DB stream capture when An item is updated:

Answer 36

The stream captures the “before” and “after” images of any attributes modified in the item.

Question 37

What does a DB stream capture when an item is deleted?

Answer 37

The stream captures an image of the entire item before it was deleted.

Question 38

Stream records have a lifetime of __ hours; after that, period of time what happens to them?

Answer 38

Stream records have a lifetime of 24 hours; after that, they are automatically removed from the stream.

Question 39

Control plane operations let you ______ and ______ DynamoDB tables.

Answer 39

Control plane operations let you create and manage DynamoDB tables.

Question 40

What are 5 Control Pane operations aka API calls?

Answer 40

-CreateTable – Creates a new table.
-DescribeTable– Returns information about a table
-ListTables – Names of all of your tables in a list.
-UpdateTable – Modifies the settings of a table or its indexes, creates or removes new indexes on a table, or modifies DynamoDB Streams settings for a table.
-DeleteTable – Removes a table and all of its dependent objects

Question 41

Classic API for Creating data
What does ‘PutItem’ command execute?

Answer 41

Writes a single item to a table. You must specify the primary key attributes, but you don’t have to specify other attributes.

Question 42

Classic API for Creating data
What does ‘BatchWriteItem’ command execute?

Answer 42

BatchWriteItem – Writes up to 25 items to a table. Can also be used for deleting multiple items from one or more tables.

Question 43

What are Amazon DynamoDB two read/write capacity modes for processing reads and writes on your tables:

Answer 43

On-demand
Provisioned (default, free-tier eligible)

Question 44

What does the read/write capacity mode control? (2)

Answer 44

The read/write capacity mode controls how you are charged for read and write throughput and how you manage capacity.

Question 45

When can you set the read/write capacity mode on a table? (2)

Answer 45

You can set the read/write capacity mode when creating a table or you can change it later.

Question 46

When should you use on-demand pricing with DynamoDB? (3)

Answer 46

New tables with unknown workloads.
Unpredictable application traffic.
You prefer the ease of paying for only what you use.

Question 47

In a DynamoDB table, what is the upper limit on the number of distinct sort key values per partition key value?

Answer 47

There is no upper limit on the number of distinct sort key values per partition key value.

If you need to store billions of Dog names to a partition key for Dogs with a sort key names in a Pets table. Then DynamoDB would allocate enough storage to handle this requirement automatically.

Question 48

1 read capacity unit represents how many strongly consistent & eventually consistent reads per second for up to how many kbs?

Answer 48

1 read capacity unit (RCU) = 1 strongly consistent read of up to 4 KB/s or 2 eventually consistent reads of up to 4 KB/s per read.

Question 49

Transactional read requests require how many read capacity units to perform one read per second for items up to 4 KB?

Answer 49

Transactional read requests require two read capacity units to perform one read per second for items up to 4 KB.

2 RCUs = 1 transactional read request (one read per second) for items up to 4 KB.

Question 50

What happens to reads on items greater than 4kbs?

Answer 50

For reads on items greater than 4 KB, the total number of reads required = (total item size / 4 KB) rounded up.

Question 51

Write Capacity Unit: On-Demand Mode DynamoDB charges you for the writes that your application performs on your tables in terms of

Answer 51

write request units.

Question 52

2 WRUs = how many transactional write requests (one write per second) for items up to 1 KB?
For writes greater than 1 KB, total number of writes required = ?

Answer 52

2 WRUs = 1 transactional write request (one write per second) for items up to 1 KB.
For writes greater than 1 KB, total number of writes required = (total item size / 1 KB) rounded up
1 write request unit (WRU) = 1 write of up to 1 KB/s.