Aurora Flashcards

1
Q

What is aurora?

A

Cloud native database. AWS fork of SQL.

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

Aurora replicates data over how many AZ’s as default?

A

3

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

If you change the default settings in Aurora. So that it only uses one availability zone, how long will recovery take in event of a fault?

A

10 mins.

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

Aurora will automatically promote a read replica in the event of an outage on the main database?

A

True

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

The four end point types in Aurora are

A

Cluster
Reader
Custom
Instance

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

In aurora. What is a cluster endpoint?

A

It points to the current master database instance. Allows for read and writes.

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

In aurora. What is a reader endpoint?

A

It load balances data across all read replicas.

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

In aurora. What is a custom endpoint?

A

Groups instances by a particular parameter.

You could for example have one particular chunk of code, then only use your custom end point.

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

In aurora. What is a instance endpoint?

A

The end point of a specific cluster.

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

If you stop an aurora cluster. It will automatically restart after how many days?

A

7

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

True or false. In aurora read replicas can be prioritised for promotion in the event of a failover?

A

True

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

What does aurora multi master clusters do?

A

Creates multiple masters for increased resilience.

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

When using aurora multi master clusters. Which does load balancing occur?

A

Client side

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

Can you have read replicas with multi master aurora clusters?

A

No

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

Give a description of aurora serverlesss

A

It auto scales compute level based on demand. And only charges you for when in use.

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

Aurora Serverless feature the web service data api. What does this do?

A

Allows you to run HTTP queries against the database.

17
Q

What is aurora parallel query?

A

It allows for faster analytical queries of Aurora data, without having to copy the data to another service like redshift.