Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Cantril > NoSQL Databases & DynamoDB > Flashcards

NoSQL Databases & DynamoDB Flashcards

1
Q

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

A

DynamoDB

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

Does DynamoDB have self-managed servers or infrastructure?

A

No

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

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

A

DynamoDB

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

True As-A-Service performance model for DynamoDB

A

On-Demand

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

Is data replicated over multiple nodes in DynamoDB?

A

Yes

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

Does DynamoDB support encryption at rest?

A

Yes

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

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

A

Table

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

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

A

Primary Key

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

The speed of writes and reads on a table within DynamoDB

A

Capacity

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

in DynamoDB 1 WCU (Writes) = _____KB per second

A

1

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

in DynamoDB 1 RCU (Read) = _____KB per second

A

4

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

Two types of backups in DynamoDB

A

On-Demand & Point-In-Time Recovery

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

Full backup of a table in DynamoDB similar to RDS Snapshots

A

On-Demand

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

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

A

Point-In-Time Recovery

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

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

A

On-Demand

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

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

A

Provisioned mode

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

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

A

Query

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

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

A

Scan

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

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

A

Eventually Consistent reads

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

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

A

Strongly Consistent reads

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

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

A

WCU calculation

22
Q

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

A

RCU calculation

23
Q

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

A

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

24
Q

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

A

Local Secondary Indexes (LSI)

25
Q

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

A

Global Secondary Indexes (GSI)

26
Q

Are GSI always eventually consistent?

A

Yes

27
Q

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

A

DynamoDB Streams

28
Q

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

A

Database Triggers

29
Q

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

A

DynamoDB Global Tables

30
Q

Speed of replication between table replicas for DynamoDB Global Tables

A

Sub-Second

31
Q

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

A

DynamoDB Accelerator (DAX)

32
Q

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

A

Within a VPC

33
Q

Is DAX a good choice for strongly consistent data?

A

No

34
Q

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

A

Amazon DynamoDB Time to Live (TTL)

35
Q

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

A

Amazon Athena

36
Q

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

A

Amazon Athena

37
Q

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.

A

Amazon Athena

38
Q

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

A

Athena Federated Query

39
Q

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

A

Elasticache

40
Q

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

A

Elasticache

41
Q

Do you need to make application changes when using Elasticache?

A

Yes

42
Q

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

A

In-Memory Cache

43
Q

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

A

Memcached

44
Q

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

A

Redis

45
Q

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

A

Amazon Redshift

46
Q

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

A

Amazon Redshift

47
Q

Directly querying S3 in Redshift without loading data into redshift itself

A

Redshift Spectrum

48
Q

Directly querying other DB in redshift

A

Redshift Federated Query

49
Q

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

A

Tied to a cluster in one AZ

50
Q

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

A

Enhanced VPC Routing

Cantril (38 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions