MCQs on Advanced RDS Configurations | AWS RDS Questions
Dive into this comprehensive set of AWS RDS MCQ questions and answers focused on advanced configurations. Master topics like Multi-AZ deployments, custom parameter groups, cost optimization using reserved instances, and cross-region replication. These questions will help you solidify your knowledge of Amazon RDS and its advanced functionalities for high availability and performance.
Chapter 6: Advanced RDS Configurations
1. Multi-AZ Deployments and High Availability
Q1. What is the primary purpose of Multi-AZ deployments in Amazon RDS?
a) Performance optimization
b) High availability and failover support
c) Cost reduction
d) Data encryption
Q2. In a Multi-AZ deployment, the standby instance is located in:
a) The same availability zone as the primary instance
b) A different region
c) A different availability zone
d) An on-premises data center
Q3. What happens during a failover in a Multi-AZ deployment?
a) The standby instance becomes read-only
b) The primary and standby instances merge
c) The standby instance takes over as the primary instance
d) Data is synced to a new database
Q4. Which of the following database engines support Multi-AZ deployments in Amazon RDS?
a) Oracle, MySQL, PostgreSQL
b) MongoDB, Cassandra, Aurora
c) Redis, DynamoDB, Neo4j
d) Elasticsearch, CouchDB, Firestore
Q5. Multi-AZ deployments are designed to improve:
a) Read performance
b) Write performance
c) High availability
d) Scalability
2. Custom Parameter Groups and Option Groups
Q6. What is a parameter group in Amazon RDS?
a) A set of configurations for instance hardware
b) A set of database engine configurations
c) A collection of user accounts
d) A security group for database access
Q7. Which of the following can be configured using a parameter group?
a) Database instance type
b) Backup retention period
c) Database engine settings like time zone and logging
d) Network access control
Q8. What is the purpose of an option group in RDS?
a) To define access policies
b) To enable additional database features like Oracle Enterprise Manager
c) To configure security settings
d) To manage backups
Q9. How can you apply a custom parameter group to an RDS instance?
a) It is done automatically
b) By selecting it during instance creation or modifying an existing instance
c) By editing the default group directly
d) By restarting the instance manually
Q10. When should you use option groups in RDS?
a) To enable high availability
b) To add optional features specific to a database engine
c) To configure storage options
d) To enhance read/write performance
3. Configuring Reserved Instances for Cost Optimization
Q11. What is a reserved instance in Amazon RDS?
a) A temporary database instance
b) A database instance reserved for disaster recovery
c) A prepaid capacity for long-term cost savings
d) A multi-AZ deployment instance
Q12. What is the minimum commitment period for RDS reserved instances?
a) 1 month
b) 6 months
c) 1 year
d) 5 years
Q13. Reserved instances offer cost savings compared to:
a) On-demand instances
b) Spot instances
c) Multi-AZ deployments
d) Free-tier instances
Q14. Which of the following payment options is available for reserved instances?
a) Hourly payment only
b) All upfront, partial upfront, and no upfront
c) Weekly payment plans
d) Monthly billing without upfront
Q15. Reserved instances are best suited for:
a) Applications with unpredictable workloads
b) Short-term testing environments
c) Applications with steady and predictable workloads
d) Intermittent batch processing
4. Cross-Region Replication
Q16. What is the purpose of cross-region replication in RDS?
a) To improve read performance within a single region
b) To enable disaster recovery and improve global availability
c) To reduce storage costs
d) To scale write operations
Q17. Cross-region replication in RDS requires:
a) A Multi-AZ deployment
b) A read replica in a different region
c) A reserved instance
d) A custom parameter group
Q18. Which of the following engines support cross-region replication in RDS?
a) Oracle, DynamoDB, Aurora
b) MySQL, PostgreSQL, MariaDB
c) MongoDB, Redis, Cassandra
d) Elasticsearch, Couchbase, Neo4j
Q19. How is cross-region replication initiated in Amazon RDS?
a) By enabling Multi-AZ
b) By creating a read replica in the target region
c) By exporting snapshots
d) By modifying the parameter group
Q20. Cross-region replication is useful for:
a) Increasing write performance
b) Load balancing
c) Global read access and disaster recovery
d) Reducing storage latency
Answer Key
| QNo | Answer |
|---|---|
| 1 | b) High availability and failover support |
| 2 | c) A different availability zone |
| 3 | c) The standby instance takes over as the primary instance |
| 4 | a) Oracle, MySQL, PostgreSQL |
| 5 | c) High availability |
| 6 | b) A set of database engine configurations |
| 7 | c) Database engine settings like time zone and logging |
| 8 | b) To enable additional database features like Oracle Enterprise Manager |
| 9 | b) By selecting it during instance creation or modifying an existing instance |
| 10 | b) To add optional features specific to a database engine |
| 11 | c) A prepaid capacity for long-term cost savings |
| 12 | c) 1 year |
| 13 | a) On-demand instances |
| 14 | b) All upfront, partial upfront, and no upfront |
| 15 | c) Applications with steady and predictable workloads |
| 16 | b) To enable disaster recovery and improve global availability |
| 17 | b) A read replica in a different region |
| 18 | b) MySQL, PostgreSQL, MariaDB |
| 19 | b) By creating a read replica in the target region |
| 20 | c) Global read access and disaster recovery |