Brainscape's Knowledge GenomeTM

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


See full index

AWS Certified Database > Amazon RDS & Aurora > Flashcards

Amazon RDS & Aurora Flashcards

1
Q

What does RDS stand for?

A

Relational database service

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

What language does RDS use?

A

SQL

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

Which databases are offered in RDS?

A

Postgres SQL, MySQL, MariaDB, Oracle, Microsoft SQL, Aurora

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

True or False: RDS is a managed service?

A

True

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

True or False: RDS performs backups automatically and keeps them forever.

A

RDS does perform automated backups, but they are not kept indefinitely.

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

Can you make copies of snapshots cross-region?

A

Yes

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

Where can you perform monitoring of your RDS instance?

A

CloudWatch

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

True or False: RDS does not support multi-AZ deployments

A

False

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

When you deploy an RDS instance, which items are you responsible for?
A. Manage Hardware
B. Manage Operating System
C. Manage DB Application

A

Amazon takes care of each one of these items for you when hosted on RDS.

If you host your database on an EC2 instance, then you would be responsible for all of these items.

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

What are some of the advantages using RDS over hosting your database on an EC2 instance?
Hint: What is AWS looking for here?

A
  1. Automated provisioning, OS patching
  2. Continuous backups
  3. Restore to specific timestamp
  4. Monitoring Dashboards
  5. Read replicas for improved read performance
  6. Multi-AZ for disaster recovery
  7. Maintenance windows, chosen by you, where AWS does the maintenance automatically.
  8. Scaling, both vertical and horizontal
  9. Storage backed by EBS (gp2 or io 1)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

True or False: You can SSH into your underlying DB instance?

A

False

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

When you create an RDS instance, what selections can you make to reduce the cost?

A
  1. Instance Type
  2. Database Engine type
  3. DB instance class (how much CPU, memory, IO)
  4. Reserved instance, deep discounts for 1 or 3 year contracts.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is the difference between on-demand and reserved pay models?

A

On-Demand is a pay for compute capacity per hour, paying at the standard or contract rate.

Reserved offers deep discounts if you sign a 1 or 3 year contract for your database instance

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

How does RDS use storage?

A

EBS storage for OS, backups, snapshots exported to S3

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

True or False: When using RDS, you are billed per 1000 requests?

A

False, it is billed per million requests

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

What are the three class types you can choose from when creating an RDS instance.

A

Standard
Memory-optimized
Burstable performance

17
Q

When using the burstable instance class, how do you obtain CPU credits?

A

You get credits when you underutilize the CPU.

18
Q

When using the Burstable instance class, how long can does one credit allow you to remain at 100% CPU core utilization?

A

1 minute

19
Q

What types of storage can you choose for RDS?

A

General Purpose Storage

Provisioned IOPS

20
Q

General Purpose SSD storage for RDS is best for production heavy workloads

A

False
General Purpose SSD provides you with these specs:
1. Baseline 3 IOPS/GB
2. Volumes below 1TB can burst to 3,000 IOPS
3. Best for variable workloads
4. Best used for small or medium sized DB’s in Dev and Test environments

21
Q

When you need high-performance, high IOPS workloads, which storage is best suited for your RDS needs?

A

Provisioned IOPS

22
Q

Which RDS storage types support Auto Scaling?

A

Both General Purpose (GP2) and Provisioned IOPS (IO1)

23
Q

What events trigger an auto-scaling event in RDS?

A

Workload and utilization nears provisioned capacity

24
Q

True or False: You can use a single parameter group for different RDS instances.

A

False.
You must have a different Parameter group based on each type of database engine (this includes different versions of the same database type (MS Sql server 2013 vs 2019)

25
Q

How do you creat a custom parameter group for your RDs instance?

A

You must create a new parameter group, which will copy the settings of the base group for that version, then you can make changes based on your needs

26
Q

True or False: When you create an RDS parameter group, you can use this throughout your entire account, including different AWS regions?

A

False, you can only use the parameter group in the region it was created.

27
Q

When you update a parameter group, what option always requires that the settings are applied immediately?

A

Dynamic parameters always trigger an immediate update to the database.

28
Q

What status is shown when you change a static parameter on an RDS instance before it is rebooted?

A

Pending-Reboot.

Static changes require a DB reboot before the settings are applied.

29
Q

When an RDS instance is in the state of pending-reboot, does the instance get restarted during the next maintenance window?

A

No, not automatically. You must reboot manually to change the status.

30
Q

What are option groups used for?

A

Configuring optional features offered by the DB engine

31
Q

What is the default setting for backup retention days in RDS?

A

7 days

32
Q

When setting up your RDS instance, if you choose the option for Log Exports, where do those logs get exported to?

A

Cloudwatch

AWS Certified Database (2 decks)

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