Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

AWS Data Engineering > 3. Database > Flashcards

3. Database Flashcards

1
Q

True or False: Amazon RDS supports multiple database engines.

A

True

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

Which of the following is NOT a database engine supported by RDS: MySQL, MongoDB, PostgreSQL, Oracle?

A

MongoDB

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

What is the maximum size for an Amazon RDS instance storage?

A

64 TiB

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

True or False: RDS automatically backs up your database.

A

True

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

What feature of RDS allows for automatic failover to a standby instance?

A

Multi-AZ deployments

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

Which AWS service can be used to monitor RDS performance metrics?

A

Amazon CloudWatch

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

What does the term ‘read replica’ refer to in RDS?

A

A read-only copy of the primary database instance

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

What is the primary benefit of using RDS for database management?

A

Simplified database setup, operation, and scaling

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

What is the purpose of parameter groups in RDS?

A

To manage database engine settings

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

Fill in the blank: Amazon RDS can be used to host __________ databases.

A

multiple

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

Which of the following is a benefit of using Amazon RDS: automatic backups, manual scaling, or no high availability?

A

Automatic backups

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

What is the default backup retention period for RDS?

A

7 days

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

True or False: You can use RDS to run NoSQL databases.

A

False

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

What does the RDS instance type determine?

A

The compute and memory capacity of the instance

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

Fill in the blank: Amazon RDS supports __________ scaling for read workloads.

A

horizontal

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

What is the purpose of the AWS Database Migration Service (DMS)?

A

To help migrate databases to AWS

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

Which RDS feature allows for data encryption at rest?

A

AWS Key Management Service (KMS)

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

What is the maximum number of read replicas you can have for an RDS instance?

A

5

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

What is the main difference between RDS and EC2 in terms of database management?

A

RDS is a managed service, while EC2 requires manual management.

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

Fill in the blank: Amazon RDS allows you to choose between __________ and on-demand pricing models.

A

reserved

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

Which of the following is a feature of Amazon RDS: automatic software patching, manual backups, or no monitoring?

A

Automatic software patching

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

What is the purpose of a subnet group in RDS?

A

To specify the subnets in which RDS instances can be created.

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

What does the term ‘instance class’ refer to in RDS?

A

The type and size of the RDS instance

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

Fill in the blank: The __________ feature in RDS allows you to create a snapshot of your database at any time.

A

manual snapshot

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
What is a common way to optimize RDS performance?
Using appropriate instance types and storage options.
26
True or False: RDS instances can be accessed over the public internet by default.
False
27
What does the term 'database engine' refer to in the context of RDS?
The software used to manage and operate the database.
28
Fill in the blank: Amazon RDS supports __________ replication for high availability.
synchronous
29
True or False: RDS can automatically scale storage based on usage.
True
30
What is the main advantage of using Multi-AZ deployments in RDS?
Increased availability and durability.
31
Fill in the blank: Amazon RDS provides __________ for your database instances.
security
32
What is the purpose of the AWS Identity and Access Management (IAM) with RDS?
To manage access and permissions for RDS resources.
33
True or False: You can use AWS Lambda to trigger functions based on RDS events.
True
34
What is the maximum number of databases you can create in a single RDS instance?
The limit depends on the database engine but can be up to 100.
35
Fill in the blank: RDS instances can be monitored through __________ and performance insights.
CloudWatch
36
What does the term 'endpoint' refer to in RDS?
The URL used to connect to the RDS instance.
37
What is the primary purpose of Amazon Aurora in RDS?
To provide a high-performance, MySQL-compatible database.
38
Fill in the blank: RDS uses __________ to ensure data durability and availability.
replication
39
What AWS service is used to manage database connections for RDS?
Amazon RDS Proxy
40
True or False: You can perform in-place upgrades of the database engine in RDS.
False
41
What is the main benefit of using Amazon RDS Proxy?
Improved application availability and scalability.
42
Fill in the blank: RDS can be integrated with __________ for data warehousing solutions.
Amazon Redshift
43
What is the purpose of the AWS Well-Architected Tool in relation to RDS?
To assess the architecture of your RDS deployment.
44
True or False: RDS supports cross-region replication.
True
45
What is the difference between provisioned IOPS and standard storage in RDS?
Provisioned IOPS provides higher and consistent performance.
46
Fill in the blank: Amazon RDS can automatically apply __________ to your database during maintenance windows.
updates
47
What is the maximum IOPS for RDS provisioned IOPS storage?
Up to 80,000 IOPS
48
True or False: Amazon RDS allows you to change the instance type without downtime.
False
49
What does the term 'database migration' refer to?
The process of moving data from one database to another.
50
Fill in the blank: The __________ feature allows RDS to automatically adjust the instance size based on usage patterns.
autoscaling
51
What is the role of a VPC in relation to RDS?
To isolate RDS instances within a secure network.
52
True or False: You can use RDS to run Microsoft SQL Server databases.
True
53
What is the function of the AWS Schema Conversion Tool?
To convert database schema from one engine to another.
54
Fill in the blank: Amazon RDS provides built-in __________ to protect your data.
security features
55
What is the purpose of the AWS CloudFormation service in relation to RDS?
To automate the deployment of RDS resources.
56
What does the term 'zone redundancy' mean in the context of RDS?
The ability to replicate data across multiple Availability Zones.
57
What is the main function of Amazon RDS Performance Insights?
To provide database performance monitoring and tuning.
58
True or False: Amazon RDS supports database clustering.
True
59
Fill in the blank: Amazon RDS allows you to create __________ for automated backups.
snapshots
60
What is the maximum number of IOPS you can provision for an RDS instance?
80,000 IOPS

AWS Data Engineering (14 decks)

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