Brainscape's Knowledge GenomeTM

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


See full index

AWS > AWS Certified Database - Specialty (Aurora) > Flashcards

AWS Certified Database - Specialty (Aurora) Flashcards

1
Q

Amazon Aurora supports __ and __

A

MySQL and PostgreSQL

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

How is PostgreSQL on Aurora better than standard PostgreSQL databases?

A

3x faster

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

How is MySQL on Aurora better than standard MySQL databases?

A

5x faster

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

What is the maximum number of read replicas for Aurora?

A

15 replicas (can be Multi AZ and autoscaling)

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

Aurora Global DB

A

Supports Multi AZ read replication (local reads with under 1 second latency)

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

Can Aurora be hosted on EC2?

A

No, it is only available via the RDS platform.

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

Aurora keywords

A

high performance, Multi AZ, self-healing, auto expanding, shared storage volume, replicas

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

Aurora keywords

A

high performance, Multi AZ, self-healing, auto expanding, shared storage volume, replicas,

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

How do backups affect performance?

A

Data is conitnuously backed up to S3 in real time, using storage nodes (compute node performance is unaffected)

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

How do backups affect performance?

A

Data is continuously backed up to S3 in real time, using storage nodes (compute node performance is unaffected)

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

Do the read replicas share the same endpoint?

A

All the read replicas have the same endpoint (read endpoint) and AWS handles the load balancing.

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

What is the maximum number of custom endpoints?

A

5

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

Replicas double up as failover targets. What does this mean?

A

Standby instances are not needed

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

ZDP

A

zero downtime patching: preserves client connections through an engine patch on a best-effort basis

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

ElastiCache or other external caching can be used on top of Aurora. True or False?

A

true

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

Aurora Parallel Query

A

Data intensive queries can be split and run in parallel on multiple nodes. I can get data faster.

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

Aurora Parallel Query is only available for __

A

MySQL

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

Aurora Serverless is available for __ and __

A

MySQL and PostgreSQL

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

Is Aurora a fully managed service?

A

Amazon Aurora being a fully managed service helps you save time by automating time consuming tasks such as provisioning, patching, backup, recovery, failure detection, and repair.

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

How long does it take for Aurora Serverless to “wake up”?

A

about 30 seconds

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

What can kind of workloads does Aurora Serverless support?

A

infrequent, intermittent or unpredictable workloads (e.g. DEV/TEST envs which are typically used only during business hours)

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

What does Aurora Serverless cost in comparison to RDS?

A

40% less

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

Tell me more about the availability of Aurora Serverless

A

Aurora Serverless operates in single-AZ with multi-AZ failover mode. The compute layer consists of a single instance. In case of an outage, Aurora Serverless will spin up a new instance in another availability zone. As the storage layer is replicated among multiple availability zones, data is not at risk. But it will take some time until the new instance can serve requests.

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

How does the failover time of Aurora Serverless compare to standard Aurora?

A

failover time is longer

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

How can I run SQL queries using an API instead of a database connection?

A

use the Data API of Aurora Serverless

26
Q

Where are the database credentials for Aurora Serverless stored?

A

AWS Secrets Manager

27
Q

What is better than high availability and how is it achieved?

A

continuous availability and it is achieved with multiple master instances (multiple writers)

28
Q

What is the maximum number of instance in a multi-master cluster?

A

2

29
Q

How many regions does Global Aurora use?

A

1 primary region to read and write and up to 5 secondary (read only regions) and up to 16 read replicas per secondary region

30
Q

3 advantages of Aurora

A

reliable, durable, fault-tolerant

31
Q

Storage auto repair

A

Notes 12

32
Q

Survivable cache warming

A

Notes 12

33
Q

Crash recovery

A

Notes 12

34
Q

RDS vs Aurora cost

A

Aurora costs about 20% more than RDS but is more efficient

35
Q

Which instance classes are available for Aurora?

A

Memory-optimized and burstable performance

36
Q

How is Aurora Serverless priced?

A

Per second pricing for actual ACUs used and no charge when database instance is not running

37
Q

ACU (Aurora Serverless)

A

Aurora Capacity Unit: database capacity is measured in ACU (about 2GB of memory with corresponding CPU and networking)

38
Q

How can I use SSL for Aurora Serverless?

A

The same procedure as RDS/Aurora provisioned but also certificates from ACM (AWS Certificate Manager) can be used.

39
Q

How can I enforce SSL for Aurora Serverless?

A

Notes 13

40
Q

Changing the parameter group associated with a database instance requires a manual reboot. T/F?

A

True

41
Q

Changing the parameter group associated with a database cluster requires a manual reboot. T/F?

A

False

42
Q

parameter group precedence

A

Notes 14

43
Q

What type of parameter groups does Aurora Serverless have?

A

only DB cluster parameter groups and no DB parameter groups

44
Q

For Aurora Serverless, all parameter changes are applied immediately. T/F?

A

True (irrespective of the Apply Immediately setting)

45
Q

Backtrack

A

in-place restore, no new instance is created

46
Q

What is the difference between Backtrack and PITR?

A

With Backtrack we have in-place restore and no new instance is created.

47
Q

Can I have AWS Aurora Global and Serverless?

A

No

48
Q

Data API

A

talk SQL to Aurora Serverless

49
Q

How does Aurora (provisioned) storage scale?

A

Storage scaling is built-in and automatic. 10GB increments up to 64TB.

50
Q

How does compute scaling work (provisioned)?

A
  • larger instance
  • more replicas (up to 15)
  • higher value for max_connections parameter in the instance level parameter group
  • replica auto scaling (min max replicas)
51
Q

Advanced Auditing in Aurora is available only for ___

A

MySQL

52
Q

How does Enhanced Monitoring compare to Cloudwatch metrics?

A

Enhanced monitoring offers higher granularity

53
Q

How and why are Aurora and Kinesis integrated?

A

Notes 16

monitor database activity in real time

54
Q

How can I export database table data into S3?

A

Create IAM role with policy that allows Aurora to write to given S3 and attach the role to the Aurora cluster. Using a SELECT query the data can be exported.

55
Q

Difference between Aurora and RDS in backups and backtracking.

A

only that automatic backups cannot be disabled (min 1 day retention)

56
Q

The Backtrack feature is only supported for Aurora and MySQL.

A

rewind DB cluster to a specific point in time up to 72 hours ago

57
Q

Backtrack is not supported with Aurora ___ clusters and __ __ must be disabled.

A

multi-master, cross-region replication

58
Q

PITR is always to a new database instance. T/F?

A

True

59
Q

How does Aurora failover in case of no replicas and single AZ?

A

spins up a new master

60
Q

How does Aurora failover in case there are replicas and single AZ?

A

replica is promoted to master

61
Q

How does Aurora Serverless failover in case of a single AZ?

A

it spins up a new master in different AZ

62
Q

CCM

A

Cluster Cache Management

AWS (3 decks)

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