dynamoDB Overview Flashcards

1
Q

What are the key features of DynamoDB?

A
  • serverless
  • non-relational database service
  • key-value data model
  • managed service - requiring no patching or upgrading
  • high throughput and single-digit latency at any scale
  • suitable for high-traffic web applications or gaming applications
  • scales automatically
  • replicates across multiple availability zones (AZs) in a region by default
  • built-in fault tolerance that adjusts capacity based on the number of requests
  • can be accessed using SQL queries like PartiQL
  • permissions are handled via IAM (Identity and Access Management).**
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What are the core components of DynamoDB?

A
  • tables, items, and attributes
  • an item is analogous to a row in a traditional database,
  • an attribute is analogous to a column.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What are primary keys in DynamoDB?

A
  • used to uniquely identify each item
  • can be a partition key or partition key + sort key (optional)
  • The partition key identifies an item’s location
  • sort key used for querying data and sorting the order of items that share the same partition key.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are the considerations when performing scans in DynamoDB?

A
  • slow and less efficient, especially as the table grows larger.
  • Each iteration of a scan operation consumes read capacity units
  • avoid scans on large tables whenever possible.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is a secondary index in DynamoDB?

A
  • contains a subset of attributes from a table, along with an alternate key to support query operations.
  • It allows using non-key attributes as primary keys in query operations is different from the original table.
  • When creating a secondary index, you can specify attribute projection, which determines which attributes are copied from the base table to the secondary index.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What are the options for attribute projection

A

There are three options for attribute projection:
* Only Keys
* Include
* All.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly