Databases and Analytics Flashcards

1
Q

Scale workload of database by making up to five read-only copies; data only writes to main database

A

Read replicas

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

Deployment configuration where a failover database is created in a different AZ; if main db fails, failover database takes over

A

Multi-AZ

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

Deployment configuration that creates a read replica in a separate region; writes only to main database; high availability and better for regional users

A

Multi-Region

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

Managed in-memory database used typically for caching read-intensive workloads

A

Elasticache

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

Distributed key/value serverless database; can be replicated across three AZs for low latency retrieval

A

DynamoDB

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

An in memory database for DynamoDB used to cache frequently read objects

A

DynamoDB Accelerator

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

Table that can be accessed from multiple regions that has low latency

A

DynamoDB Global Tables

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

AWS Postgres-based database useful for OLAP (analytics and data warehousing); integrates with Quicksight and Tableau

A

Redshift

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

AWS service used to create Hadoop clusters to handle big data

A

ElasticMap Reduce

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

Serverless query service to query structures S3 objects (JSON, csv, parquet, etc)

A

Athena

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

Serverless ML-powered business intelligence service to create interactive dashboards

A

Quicksight

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

AWS implementation of MongoDB that allows you to store, query, and index JSON data

A

DocumentDB

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

Fully managed graph database used for highly connected datasets (e.g. social networks, recommendation engines)

A

Neptune

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

Immutable blockchain ledger used for financial transactions

A

Quantum Ledger Database (QLDB)

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

AWS blockchain service compatible with Hyperledger and Ethereum frameworks

A

Managed Blockchain

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

Managed ETL service

A

Glue

17
Q

Service used to migrate databases to AWS; source database remains available during migration

A

Database Migration Service (DMS)

18
Q

AWS hosted database service

A

Relational Database Service (RDS)

19
Q

Proprietary AWS relational database service optimized for cloud usage

A

Aurora

20
Q

True or False: The main purpose of a Read Replica RDS design is for enhanced availability

A

False - it is for improved scalability

21
Q

True or False: The main purpose of a Multi-AZ RDS deployment is for high availability

A

True

22
Q

What are the two main purposes of a Multi-Region RDS deployment?

A

Disaster Recovery
Local Performance