MCQs on RDS Instance Management | Amazon RDS Questions
This set of AWS RDS MCQ questions and answers is designed to help you understand and evaluate your knowledge of RDS instance management concepts. The questions cover key topics such as connecting to RDS databases, managing instances (start, stop, reboot, modify), backups and restores, and database monitoring tools like CloudWatch and Performance Insights. Perfect for AWS learners and professionals preparing for certifications!
AWS RDS Instance Management MCQs
Connecting to Your RDS Database
- What must be configured for an EC2 instance to connect to an RDS database?
a) Security Group
b) IAM Role
c) VPC Peering
d) S3 Bucket - Which of the following tools can be used to connect to an RDS database?
a) AWS Console
b) SQL Client
c) RDP Client
d) AWS CLI - In RDS, the endpoint for database connections includes:
a) IP address only
b) Database name only
c) Endpoint DNS and port
d) Only port number - What is the default port used by MySQL databases on RDS?
a) 5432
b) 3306
c) 1521
d) 1433 - What is required to allow an RDS instance to be accessible from the internet?
a) Enable Public Access and modify the Security Group
b) Assign an Elastic IP
c) Configure Route 53
d) Enable Data Encryption
Managing Instances (Start, Stop, Reboot, Modify)
- Which AWS CLI command is used to start an RDS instance?
a)aws rds reboot-db-instance
b)aws rds start-db-instance
c)aws rds create-db-instance
d)aws rds modify-db-instance - What happens when you reboot an RDS instance?
a) All connections are retained
b) A failover is initiated
c) The database engine restarts
d) Data is wiped - Which modification to an RDS instance does NOT require downtime?
a) Changing instance class
b) Changing storage type
c) Updating parameter groups
d) Enabling encryption - What is the maximum storage size for an RDS instance?
a) 64 TB
b) 32 TB
c) 16 TB
d) 8 TB - How can you scale read capacity for an RDS instance?
a) Add Read Replicas
b) Increase instance size
c) Enable Multi-AZ
d) Upgrade to Aurora
Backup and Restore (Automatic Backups, Manual Snapshots)
- What is the retention period for automated backups in RDS?
a) 7 days
b) 35 days
c) 14 days
d) 60 days - Which AWS feature allows restoring a database to a specific point in time?
a) Manual Snapshot
b) Automated Backup
c) Point-in-Time Recovery
d) Multi-AZ Failover - What must be enabled to use automated backups in RDS?
a) IAM Role
b) Multi-AZ Deployment
c) Backup Retention Period
d) Enhanced Monitoring - A manual snapshot of an RDS instance can be:
a) Shared across AWS accounts
b) Automatically deleted after 30 days
c) Used for automated backups
d) Restored only to the same region - When restoring an RDS snapshot, what can be modified?
a) Engine version
b) Instance size
c) Region
d) All of the above
Database Monitoring Tools (CloudWatch, Performance Insights)
- Which service provides detailed metrics for monitoring RDS instances?
a) AWS Inspector
b) AWS CloudTrail
c) Amazon CloudWatch
d) AWS Lambda - Performance Insights helps monitor:
a) CPU Utilization
b) Storage Metrics
c) Query Performance
d) VPC Connectivity - Which of the following is NOT a metric available in CloudWatch for RDS?
a) Freeable Memory
b) Read IOPS
c) Cache Hits
d) Network Throughput - How can you enable enhanced monitoring for RDS?
a) Update parameter groups
b) Enable it during instance creation or modification
c) Install a monitoring agent
d) Create a Lambda function - What metric does Performance Insights primarily visualize?
a) Disk Utilization
b) Query Load
c) Free Storage Space
d) Network Latency
Mixed Questions
- Which type of RDS instance supports Multi-AZ deployments?
a) Aurora Serverless
b) Standard MySQL
c) T3 Micro instances
d) All of the above - IAM policies can be used to:
a) Control access to RDS resources
b) Modify database instances
c) Manage database connections
d) Disable backups - Which action is required to enable cross-region RDS snapshots?
a) Create a new instance
b) Configure snapshot replication
c) Enable VPC peering
d) Add a CloudWatch alarm - What is the default storage type for RDS?
a) SSD
b) Magnetic
c) GP2
d) Provisioned IOPS - Which database engine does NOT support Performance Insights?
a) PostgreSQL
b) Oracle
c) MariaDB
d) SQL Server - CloudWatch Alarms for RDS can be triggered by:
a) Parameter changes
b) Metrics exceeding thresholds
c) Storage migrations
d) Snapshot creation - How many read replicas can you create for a MySQL RDS instance?
a) 1
b) 5
c) 10
d) Unlimited - What is the primary purpose of the Multi-AZ feature in RDS?
a) Scale database storage
b) Enhance security
c) Improve availability
d) Reduce costs - How often does RDS update CloudWatch metrics?
a) Every second
b) Every minute
c) Every 5 minutes
d) Every hour - To modify an existing RDS instance, you must:
a) Stop the instance
b) Use the AWS CLI
c) Have modify permissions
d) Reboot the database
Answers
| QNo | Answer (Option with Text) |
|---|---|
| 1 | a) Security Group |
| 2 | b) SQL Client |
| 3 | c) Endpoint DNS and port |
| 4 | b) 3306 |
| 5 | a) Enable Public Access and modify the Security Group |
| 6 | b) aws rds start-db-instance |
| 7 | c) The database engine restarts |
| 8 | c) Updating parameter groups |
| 9 | a) 64 TB |
| 10 | a) Add Read Replicas |
| 11 | b) 35 days |
| 12 | c) Point-in-Time Recovery |
| 13 | c) Backup Retention Period |
| 14 | a) Shared across AWS accounts |
| 15 | d) All of the above |
| 16 | c) Amazon CloudWatch |
| 17 | c) Query Performance |
| 18 | c) Cache Hits |
| 19 | b) Enable it during instance creation or modification |
| 20 | b) Query Load |
| 21 | b) Standard MySQL |
| 22 | a) Control access to RDS resources |
| 23 | b) Configure snapshot replication |
| 24 | c) GP2 |
| 25 | c) MariaDB |
| 26 | b) Metrics exceeding thresholds |
| 27 | b) 5 |
| 28 | c) Improve availability |
| 29 | b) Every minute |
| 30 | c) Have modify permissions |