Databases Flashcards

1
Q

Amazon Aurora is compatible with? (DB)

A

MySQL and PostgreSQL

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

Minimum and maximum size of Aurora

A

min 10GB max 128 TB

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

Is Aurora a fully managed service?

A

Yes

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

Aurora resiliency

A

fault-tolerant and self-healing

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

Aurora replication is on … level

A

disk level

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

Aurora is based on? (medium)

A

ssd

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

Aurora cluster volume

A

virtual database storage volume that spans multiple AZs, with each AZ having a copy of the DB cluster data

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

Aurora cluster structure

A

Primary DB instance ( supports R/W, 1 in cluster), Aurora Replica ( read-only replicas, connected to the same storage volume, up to 15)

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

Aurora Endpoints

A

Cluster(primary db), Reader(lb for read replicas), Custom, Instance(specific isntance)

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

Aurora Backup

A

automatic, 1 to 35 days

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

Aurora cross-region replicas

A

supported by MySQL

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

How many copies aurora maintains and where?

A

6 copies across 3 AZ

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

Aurora Global Database

A

spans across multiple regions, 1 region read-write, up to 5 read only

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

Aurora Global Database RTO/RPO

A

RTO less than minute, RPO 5 seconds

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

DocumentDB is

A

Fully managed document database service

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

use cases for DocumentDB

A

content management, user profiles, and real-time big data.

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

DocumentDB performance

A

milions of requests per second with miliseconds latency

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

DocumentDB storage size?

A

min 10GB max 64 TB

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

DocumentDB scaling

A

up to 15 replcas

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

How many copies DocumentDB maintains and where?

A

6 copies across 3 AZ

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

DocumentDB backup/restore

A

automatic backups, RPO 5 minutes, restore from snapshot local and cross region

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

DynamoDB is

A

nosql database, key/value

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

DynamoDB keep data on..? (medium)

A

ssd

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

DynamoDB resilency

A

higly resilient across AZs and optionally globaly

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
DynamoDB TTL
Timestamps for automatic delete of items
26
DynamoDB LSI
alternative view on a table, Local Secondary Indexes, switch secondary key on table
27
DynamoDB GSI
alternative view on a table, global secondary indexes, switch primary and secondary keys
28
DynamoDB and DAX
write-through cache fo dynamoDB
29
DynamoDB Billing
RCU 4KB read, WCU 1 kb read
30
DynamoDB consistency model
eventually (possibility to read stale data) or strongly consistent (harder to scale)
31
DynamoDB Stream
captures data modification events in DynamoDB tables
32
Aurora Serverless
on-demand, autoscaling configuration for Amazon Aurora, scales aurora capacity units from 0 to max
33
DynamoDB Queries
finds items using PK or SK
34
DynamoDB Scans
reads every item in a table
35
DynamoDB Global tables
multi-region, multi-master database, eventually consistent,
36
ElastiCache
distributed in-memory cache
37
ElastiCache work with ..?
redis and memcached
38
ElastiCache use cases
ready heavy workload with low latency requirements, store session data, reduce database workloads
39
MemoryDB for Redis
in-memory database service for microservices-based applications
40
MemoryDB for Redis resiliency
data stored across multiple AZ using transactional log
41
Neptune supports query languages like
Apache TinkerPop Gremlin and W3C’s SPARQL
42
Neptune use cases
social networking, recommendation engines, Knowledge Graphs, Identity Graphs
43
Neptune reliability
6 copies across 3 AZ, self healing, asynchronous replication to read replicas
44
Neptune Streams
complete sequence of change-log entries that record every change made to your graph data
45
QLDB transactions are?
ACID
46
Is QLDB serveless?
yes
47
RDS supported dbs
Aurora, MySQL, MariaDB, PostgreSQL, Oracle, Microsoft SQL Server.
48
what is managed by RDS?
backups, software patching, automatic failure detection and recovery
49
RDS HA
Multi-AZ option with synchronous replication
50
RDS use cases
app requrie relational dm, data is welformed and structured,
51
RDS storage backend
EBS (gp2 or io1)
52
What’s the difference between OLAP and OLTP?
OLAP analyze aggregated data OLTP process database transactions
53
RDS encryption
RDS at rest using kms, ssl in transit
54
RDS cross region
not possible with RDS
55
RDS proxy
sits between app and databases, fully managed, highly available database proxy for rds
56
Redshift
Petabyte-scale data warehouse, OLAP
57
Redshift resiliency
single AZ
58
Redshift Backup
automatic to s3 1to 35 days
59
Redshift Encryption
always encrypted AES-256
60
how redshift improve performance?
build in caching
61
Amazon Redshift Enhanced VPC Routing
Force traffic to run via VPC
62
Redshift Spectrum vs Athena
serverless engines to query data stored in s3, but if you use redshift use spectrum, spectrum require redis cluster, while athena only s3
63
RTO vs RPO
Recovery Time Objective (time to recover ) vs Recovery Point Objective( time to last backup)
64
Redshift Serverless use cases
unpredictable usage patterns, s3 integration for spectrum, ETL integration with quickSight(powerBI)
65
Redshift Serverless scaling
Redshift Serverless can scale automatically for unpredictable workload
66
How DynamobDB can handle increased loads
using application auto Scaling, to increase capacity in response to traffic patterns
67
Are DynamoDB Streams enabled by default?
No
68
IAM database authentication
manage database user credential via iam
69