Brainscape's Knowledge GenomeTM

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


See full index

AWS SAA-C03 list of services > Databases > Flashcards

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
Q

DynamoDB TTL

A

Timestamps for automatic delete of items

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

DynamoDB LSI

A

alternative view on a table, Local Secondary Indexes, switch secondary key on table

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

DynamoDB GSI

A

alternative view on a table, global secondary indexes, switch primary and secondary keys

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

DynamoDB and DAX

A

write-through cache fo dynamoDB

29
Q

DynamoDB Billing

A

RCU 4KB read, WCU 1 kb read

30
Q

DynamoDB consistency model

A

eventually (possibility to read stale data) or strongly consistent (harder to scale)

31
Q

DynamoDB Stream

A

captures data modification events in DynamoDB tables

32
Q

Aurora Serverless

A

on-demand, autoscaling configuration for Amazon Aurora, scales aurora capacity units from 0 to max

33
Q

DynamoDB Queries

A

finds items using PK or SK

34
Q

DynamoDB Scans

A

reads every item in a table

35
Q

DynamoDB Global tables

A

multi-region, multi-master database, eventually consistent,

36
Q

ElastiCache

A

distributed in-memory cache

37
Q

ElastiCache work with ..?

A

redis and memcached

38
Q

ElastiCache use cases

A

ready heavy workload with low latency requirements, store session data, reduce database workloads

39
Q

MemoryDB for Redis

A

in-memory database service for microservices-based applications

40
Q

MemoryDB for Redis resiliency

A

data stored across multiple AZ using transactional log

41
Q

Neptune supports query languages like

A

Apache TinkerPop Gremlin and W3C’s SPARQL

42
Q

Neptune use cases

A

social networking, recommendation engines, Knowledge Graphs, Identity Graphs

43
Q

Neptune reliability

A

6 copies across 3 AZ, self healing, asynchronous replication to read replicas

44
Q

Neptune Streams

A

complete sequence of change-log entries that record every change made to your graph data

45
Q

QLDB transactions are?

A

ACID

46
Q

Is QLDB serveless?

A

yes

47
Q

RDS supported dbs

A

Aurora, MySQL, MariaDB, PostgreSQL, Oracle, Microsoft SQL Server.

48
Q

what is managed by RDS?

A

backups, software patching, automatic failure detection and recovery

49
Q

RDS HA

A

Multi-AZ option with synchronous replication

50
Q

RDS use cases

A

app requrie relational dm, data is welformed and structured,

51
Q

RDS storage backend

A

EBS (gp2 or io1)

52
Q

What’s the difference between OLAP and OLTP?

A

OLAP analyze aggregated data
OLTP process database transactions

53
Q

RDS encryption

A

RDS at rest using kms, ssl in transit

54
Q

RDS cross region

A

not possible with RDS

55
Q

RDS proxy

A

sits between app and databases, fully managed, highly available database proxy for rds

56
Q

Redshift

A

Petabyte-scale data warehouse, OLAP

57
Q

Redshift resiliency

A

single AZ

58
Q

Redshift Backup

A

automatic to s3 1to 35 days

59
Q

Redshift Encryption

A

always encrypted AES-256

60
Q

how redshift improve performance?

A

build in caching

61
Q

Amazon Redshift Enhanced VPC Routing

A

Force traffic to run via VPC

62
Q

Redshift Spectrum vs Athena

A

serverless engines to query data stored in s3, but if you use redshift use spectrum, spectrum require redis cluster, while athena only s3

63
Q

RTO vs RPO

A

Recovery Time Objective (time to recover ) vs Recovery Point Objective( time to last backup)

64
Q

Redshift Serverless use cases

A

unpredictable usage patterns, s3 integration for spectrum, ETL
integration with quickSight(powerBI)

65
Q

Redshift Serverless scaling

A

Redshift Serverless can scale automatically for unpredictable workload

66
Q

How DynamobDB can handle increased loads

A

using application auto Scaling, to increase capacity in response to traffic patterns

67
Q

Are DynamoDB Streams enabled by default?

A

No

68
Q

IAM database authentication

A

manage database user credential via iam

69
Q
A

AWS SAA-C03 list of services (3 decks)

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