Free Practice Quiz Question List

2 Amazon RDS in Practice Online Quiz Questions

Use this free practice quiz with 20 questions to review 2 Amazon RDS in Practice, test your knowledge, and prepare for your next test or exam.

20 questions

Choose one

1 point

A team needs a service for analytical warehousing and large-scale reporting. Which option best fits that purpose?

A
DynamoDB
B
Redshift
C
Amazon RDS for a relational application
D
A read replica

Choose one

1 point

An application is moving to RDS and depends on particular database features. What should the team prioritize when selecting its engine version?

A
Choose the newest engine version without checking application compatibility.
B
Choose an engine version compatible with the application and its required features.
C
Choose the engine based only on the instance class.
D
Choose an engine based only on the amount of storage.

Choose one

1 point

Which statement best describes the purpose of a Multi-AZ DB instance deployment?

A
It provides an additional reader that serves application reads.
B
It uses asynchronous replication for read scaling.
C
It maintains a standby in another Availability Zone for high availability and failover.
D
It stores manual snapshots in another Region.

Choose all

1 point

Select all statements that accurately describe RDS backups and restores.

A
Automated backups support point-in-time recovery within the configured retention period.
B
A retention value of zero enables automated backups without a retention limit.
C
A manual snapshot can serve as a longer-lived restore point.
D
Restoring a manual snapshot overwrites the existing DB instance in place.
E
Restoring a manual snapshot creates a new DB instance.

Choose all

1 point

Select all controls that directly support secure production connectivity or database access.

A
Normally keep the production DB instance private in its VPC.
B
Use IAM policies as the sole control for which database users can access data.
C
Permit database traffic only from the application or approved administrative sources.
D
Use database users and privileges to control access to data.
E
Open the database port broadly to the internet so clients can connect.
F
Configure clients to use TLS for connections in transit.

True or false

1 point

True or false: Adding an index can speed up reads while also increasing storage use and the cost of writes.

A
True
B
False

True or false

1 point

True or false: An application using Multi-AZ failover can assume that failover will be invisible, so it does not need to reconnect or account for its endpoint.

A
True
B
False

Written response

1 point

What is the maximum automated backup retention period allowed for an RDS DB instance? Enter the number of days.

Written response

1 point

Which RDS tool can help investigate database load, top SQL, and wait events where supported?

Fill in the blank

1 point

RDS read replicas use replication, so they can lag behind the source.

Fill in the blank

1 point

Use Enhanced Monitoring when operating- detail is useful.

Open ended

1 point

A production query is slow, and the team is considering adding an index or upgrading the DB instance. Describe how the team should investigate and decide what to change.

True or false

1 point

True or false: An application can send read queries to the standby of a Multi-AZ DB instance to increase its read capacity.

A
True
B
False

Choose one

1 point

What is the maximum automated-backup retention period for an RDS DB instance?

A
35
B
30
C
14
D
7

Written response

1 point

A team wants to store database credentials securely and rotate them. Which AWS service is recommended in the material as an example for this purpose?

Choose one

1 point

An application requires relational tables, SQL transactions, joins, and compatibility with a supported database engine. Which service best fits this workload?

A
DynamoDB, because it is designed for arbitrary relational joins
B
RDS, because the application needs SQL, transactions, joins, and a supported relational engine
C
Redshift, because it is the standard transactional database for application workloads
D
A read replica, because it replaces the need to choose a database engine

Choose one

1 point

A production application runs in a VPC and needs to connect to its RDS database. Which configuration best follows the recommended network-security approach?

A
Expose the database port to the internet so application hosts can connect from any network
B
Use a public database endpoint and rely only on database passwords to restrict access
C
Keep the database private and allow database traffic only from the application or approved administrative sources
D
Allow all traffic from the VPC because private networks do not need security-group restrictions

Choose one

1 point

A workload needs high availability and additional read capacity, and its engine and configuration support the option. Which RDS deployment matches that requirement?

A
A writer and one standby in a second Availability Zone; the standby handles application reads
B
A writer and two reader instances across three Availability Zones
C
Three independent writers in one Availability Zone
D
One writer and asynchronous read replicas in any number of Regions

Choose one

1 point

An application uses an RDS read replica to scale reads. Some reports can use slightly delayed data, but the application must handle replica lag correctly. Which approach is appropriate?

A
Use the replica as a synchronous standby because it cannot lag behind the primary
B
Send every read to the replica without checking whether the data must be current
C
Use the replica for failover and assume the application will not need to reconnect
D
Send suitable read traffic to the replica and design for possible replication lag

Written response

1 point

A team plans to change an RDS engine parameter before deploying the change to its live database. In what type of environment should the team test the change first?

2 Amazon RDS in Practice Online Quiz Questions

Related study packs and tools