NoSQL Databases & DynamoDB

Question 1

NoSQL fully managed Database-as-a-Service (DBaaS) product available within AWS. It is highly resilient across multiple AZ in a region or globally

Answer 1

DynamoDB

Question 2

Does DynamoDB have self-managed servers or infrastructure?

Answer 2

No

Question 3

database with Manual / Automatic provisioned performance IN/OUT that is SSD based with single-digit millisecond access to data

Answer 3

DynamoDB

Question 4

True As-A-Service performance model for DynamoDB

Answer 4

On-Demand

Question 5

Is data replicated over multiple nodes in DynamoDB?

Answer 5

Yes

Question 6

Does DynamoDB support encryption at rest?

Answer 6

Yes

Question 7

Grouping of items in DynamoDB which all share the same Primary Key

Answer 7

Table

Question 8

in DynamoDB the Simple (partition) key or Composite (partition & Sort) key are part of the

Answer 8

Primary Key

Question 9

The speed of writes and reads on a table within DynamoDB

Answer 9

Capacity

Question 10

in DynamoDB 1 WCU (Writes) = _____KB per second

Answer 10

1

Question 11

in DynamoDB 1 RCU (Read) = _____KB per second

Answer 11

4

Question 12

Two types of backups in DynamoDB

Answer 12

On-Demand & Point-In-Time Recovery

Question 13

Full backup of a table in DynamoDB similar to RDS Snapshots

Answer 13

On-Demand

Question 14

A continuous stream of backups of a DynamoDB Table over 35 days that needs to be enabled on a per-table basis

Answer 14

Point-In-Time Recovery

Question 15

The capacity mode used with an unknown, unpredictable load or low admin overhead on a DynamoDB table

Answer 15

On-Demand

Question 16

The capacity mode in DynamoDB where the RCU and WCU are set on a per-table basis

Answer 16

Provisioned mode

Question 17

Operation to retrieve data from a product within a DynamoDB table which accepts a single PK value or optionally an SK

Answer 17

Query

Question 18

Most flexible way to get data from a DynamoDB table but the least efficient by moving through the table and consuming the capacity of every item

Answer 18

Scan

Question 19

Reading DynamoDB data which is directed at a random node across the AZs. Possible to return with stale data if a node is checked before replication completes

Answer 19

Eventually Consistent reads

Question 20

Reading DynamoDB data that is directly connected to the leader node which always returns the most up-to-date copy of data

Answer 20

Strongly Consistent reads

Question 21

WCU per item (Item size / 1kb) rounding up then multiplying the average number of items per second

Answer 21

WCU calculation

Question 22

RCU per item (Item size / 4kb) rounding up then multiplying by the average read ops per second

Answer 22

RCU calculation

Question 23

allow for an alternative presentation of data stored in a base table within DynamoDB

Answer 23

Local Secondary Indexes (LSI) and Global Secondary Indexes (GSI)

Question 24

Alternative querying using the same primary key but a different sort key within a table in DynamoDB

Answer 24

Local Secondary Indexes (LSI)

Question 25

Alternative querying using a different primary key and different sort key within a table in DynamoDB

Answer 25

Global Secondary Indexes (GSI)

Question 26

Are GSI always eventually consistent?

Answer 26

Yes

Question 27

24 hour rolling window of time ordered changes to ITEMS in a DynamoDB table

Answer 27

DynamoDB Streams

Question 28

Event driven architecture that can respond to any data changes in a table using Streams + Lambda

Answer 28

Database Triggers

Question 29

Provides multi-master global replication of DynamoDB tables which can be used for performance, HA or DR/BC reasons. Tables are replication in multiple regions and added to a single table

Answer 29

DynamoDB Global Tables

Question 30

Speed of replication between table replicas for DynamoDB Global Tables

Answer 30

Sub-Second

Question 31

in-memory cache designed specifically for DynamoDB designed for fast response times for accessing Eventually Consistent Data. There is a primary Node which writes and replica nodes that read spread across AZs

Answer 31

DynamoDB Accelerator (DAX)

Question 32

is DAX a public service or must it be deployed within a VPC?

Answer 32

Within a VPC

Question 33

Is DAX a good choice for strongly consistent data?

Answer 33

No

Question 34

Allows you to define a per-item timestamp to determine when an item is no longer needed. DynamoDB deletes the item from your table without consuming any write throughput

Answer 34

Amazon DynamoDB Time to Live (TTL)

Question 35

Serverless querying service which allows for ad-hoc questions where billing is based on the amount of data consumed.

Answer 35

Amazon Athena

Question 36

Tables are defined in advance in a data catalog and data is projected through when read, it allows SQL-Like queries on data without transforming source data

Answer 36

Amazon Athena

Question 37

Used for ad-hoc, sporadic and cost-effective queries which don't require transforming or loading of data. Great to use for querying AWS Service Logs due to it's native support of them.

Answer 37

Amazon Athena

Question 38

Query for Athena which supports non-S3 data source querying that is run on Lambda

Answer 38

Athena Federated Query

Question 39

a High performance, cost-effective managed in-memory cache of temporary data which provides a managed implementation of the redis or memcached engines

Answer 39

Elasticache

Question 40

Used to cache data for read-heavy workloads with low latency requirements or storing session data for users

Answer 40

Elasticache

Question 41

Do you need to make application changes when using Elasticache?

Answer 41

Yes

Question 42

Allows cost effective scaling of read-heavy workloads with the ability to improve performance at scale

Answer 42

In-Memory Cache

Question 43

Elasticache supported engine that supports simple data structures with no replication but supports multiple nodes without backups. Supports multithreading

Answer 43

Memcached

Question 44

Elasticache supported engine that supports advanced data structures, with Multi-AZ capability and replication. Allows for backup and restore with support for Transactions

Answer 44

Redis

Question 45

A server using, column-based, petabyte-scale, data warehousing product within AWS that lets you access and analyze data without the usual configurations of a provisioned data warehouse

Answer 45

Amazon Redshift

Question 46

Designed for OLAP products within AWS/on-premises to add data to for long term processing, aggregation and trending

Answer 46

Amazon Redshift

Question 47

Directly querying S3 in Redshift without loading data into redshift itself

Answer 47

Redshift Spectrum

Question 48

Directly querying other DB in redshift

Answer 48

Redshift Federated Query

Question 49

Is Redshift highly available or tied to a cluster in one AZ in a VPC?

Answer 49

Tied to a cluster in one AZ

Question 50

Routing of Redshift traffic that allows traffic to be routed based on the VPC network configuration or traffic that requires customized networking requirements

Answer 50

Enhanced VPC Routing