Brainscape's Knowledge GenomeTM

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


See full index

aws - certified solutions architect - associate (saa-c03) > Databases > Flashcards

Databases Flashcards

1
Q

What are the RDS Database types?

A

1) SQL Server
2) Oracle
3) MySQL
4) PostgreSQL
5) MariaDB
6) Amazon Aurora

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

What workloads is RDS used for?

A

OLTP (Online Transaction Processing)

A transactional or OLTP (online transaction processing) workload is a workload typically identified by a database receiving both requests for data and multiple changes to this data from a number of users over time where these modifications are called transactions.

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

What workloads is Redshift best for?

A

OLAP (Online Analytical Processing)

OLAP systems retrieve and manipulate data through complex queries and scans, organizing the data into different multidimensional views or reports for in-depth analysis.

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

What is a Read Replica?

A

Is a read only copy of your database

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

Can a read replica be in a separate AZ or region?

A

Yes

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

Can you use a Read Replica for disaster recovery?

A

No

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

Can you upgrade a Read Replica do be its own database?

A

Yes

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

When you upgrade a Read Replica database to its own database does it still get replication from the original database?

A

No

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

Do Read replicas require automatic backup?

A

Yes

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

What is the max number of read replicas you can have per Database instance?

A

5

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

Can you use a Multi-AZ backup DB as a read replica?

A

No, the database is only a copy of the main one and on standby if there is a failure from the first one.

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

What is Amazon Aurora?

A

A MySQL and Postgres compatible relational database engine

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

How much better performance does Aurora have over MySQL

A

5x

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

How much better performance does Aurora have over Postgres?

A

3x

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

Whats the starting size of an Aurora DB?

A

10gb

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

What size increments does aurora scale in?

A

10gb

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

What is the max size of Aurora storage autoscaling?

A

128TB

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

What is the max scale of compute resources for Aurora?

A

96vCPUs and 768 GB of memory

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

How many copies of your data are there in total with Aurora by default?

A

6
2 in every availability zone with a minimum of 3 availability zones

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

Can you share Aurora snapshots across accounts?

A

Yes

21
Q

What are the three types of replicas available to Aurora?

A

Aurora, Mysql, Postgress

22
Q

Is automatic failover available for all Aurora replica types?

A

No, only Aurora Replicas and not Mysql and Postgres

23
Q

Does Aurora have automated snapshots?

A

Yes

24
Q

Is Dynomo DB Data stored on HDD or SSD?

A

SSD

25
Q

How many geographically distinct data centers is Dynamo DB data spread across?

A

3

26
Q

By default what read type does Dynamo DB have?

A

Eventually consistent reads

27
Q

Can you have strongly consistent reads configured in Dynamo DB?

A

Yes

28
Q

What is eventually consistent reads?

A

Consistency across all copies of data is usually reached within a second. Repeating a read after a short time should return the updated data.

best for read performance

29
Q

What is strongly consistent reads?

A

A strongly consistent read returns a result that reflects all writes that received a successful response prior to the read

30
Q

What does ACID stand for?

A

Atomicity, Consistency, Isolation, and Durability

31
Q

If Dynamo DB has ACID Requirements what do you need to configure?

A

DynamoDB Transactions

32
Q

What does ACID basically mean?

A

All-or-Nothing transactions.

33
Q

Is Point-in-time-recover (PITR) Enabled by default for Dynamo DB?

A

No

34
Q

What is the latest restorable time for a PITR in DynamoDB?

A

5 minutes

35
Q

How far back can you go in a PITR for DynamoDB?

A

35 days

36
Q

What does PITR protect from?

A

Accidental writes or deletes

37
Q

What do DynamoDB Global tables do?

A

It gives multi master multi region replication.

38
Q

Do you need to enable dynamoDB streams for global tables to work?

A

Yes

39
Q

How long is Replication latency for DynamoDB Global Tables?

A

Under 1 second

40
Q

What is Amazon DocumentDB?

A

A way of running MongoDB workloads on an AWS environment.

41
Q

What is Cassandra?

A

A distributed database that uses noSQL

42
Q

What is Amazon Keyspaces?

A

Allows you to run your Cassandra services on AWS that managed by AWS

43
Q

What is a Graph Database?

A

A database that stores nodes and relationships instead of tables or documents

44
Q

What is Amazon Neptune?

A

AWS’s Graph database offering

45
Q

What is Amazon Neptune?

A

AWS’s Graph database offering

46
Q

What is a Ledger DB?

A

NoSQL Database that is immutable, transparent, and a cryptographically verified transaction log that is owned by one authority.

You can not update a record in a ledger database. instead, an update adds a new record to the database.

47
Q

What is QLDB?

A

Quantum Ledger Database

Amazons way of doing a ledger database.

48
Q

What is time-series data?

A

Datapoints logged over time

49
Q

What is Amazon TImestream?

A

AWS’s timeseries DB solution

aws - certified solutions architect - associate (saa-c03) (17 decks)

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