3. Database Flashcards
True or False: Amazon RDS supports multiple database engines.
True
Which of the following is NOT a database engine supported by RDS: MySQL, MongoDB, PostgreSQL, Oracle?
MongoDB
What is the maximum size for an Amazon RDS instance storage?
64 TiB
True or False: RDS automatically backs up your database.
True
What feature of RDS allows for automatic failover to a standby instance?
Multi-AZ deployments
Which AWS service can be used to monitor RDS performance metrics?
Amazon CloudWatch
What does the term ‘read replica’ refer to in RDS?
A read-only copy of the primary database instance
What is the primary benefit of using RDS for database management?
Simplified database setup, operation, and scaling
What is the purpose of parameter groups in RDS?
To manage database engine settings
Fill in the blank: Amazon RDS can be used to host __________ databases.
multiple
Which of the following is a benefit of using Amazon RDS: automatic backups, manual scaling, or no high availability?
Automatic backups
What is the default backup retention period for RDS?
7 days
True or False: You can use RDS to run NoSQL databases.
False
What does the RDS instance type determine?
The compute and memory capacity of the instance
Fill in the blank: Amazon RDS supports __________ scaling for read workloads.
horizontal
What is the purpose of the AWS Database Migration Service (DMS)?
To help migrate databases to AWS
Which RDS feature allows for data encryption at rest?
AWS Key Management Service (KMS)
What is the maximum number of read replicas you can have for an RDS instance?
5
What is the main difference between RDS and EC2 in terms of database management?
RDS is a managed service, while EC2 requires manual management.
Fill in the blank: Amazon RDS allows you to choose between __________ and on-demand pricing models.
reserved
Which of the following is a feature of Amazon RDS: automatic software patching, manual backups, or no monitoring?
Automatic software patching
What is the purpose of a subnet group in RDS?
To specify the subnets in which RDS instances can be created.
What does the term ‘instance class’ refer to in RDS?
The type and size of the RDS instance
Fill in the blank: The __________ feature in RDS allows you to create a snapshot of your database at any time.
manual snapshot
What is a common way to optimize RDS performance?
Using appropriate instance types and storage options.
True or False: RDS instances can be accessed over the public internet by default.
False
What does the term ‘database engine’ refer to in the context of RDS?
The software used to manage and operate the database.
Fill in the blank: Amazon RDS supports __________ replication for high availability.
synchronous
True or False: RDS can automatically scale storage based on usage.
True
What is the main advantage of using Multi-AZ deployments in RDS?
Increased availability and durability.
Fill in the blank: Amazon RDS provides __________ for your database instances.
security
What is the purpose of the AWS Identity and Access Management (IAM) with RDS?
To manage access and permissions for RDS resources.
True or False: You can use AWS Lambda to trigger functions based on RDS events.
True
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.
Fill in the blank: RDS instances can be monitored through __________ and performance insights.
CloudWatch
What does the term ‘endpoint’ refer to in RDS?
The URL used to connect to the RDS instance.
What is the primary purpose of Amazon Aurora in RDS?
To provide a high-performance, MySQL-compatible database.
Fill in the blank: RDS uses __________ to ensure data durability and availability.
replication
What AWS service is used to manage database connections for RDS?
Amazon RDS Proxy
True or False: You can perform in-place upgrades of the database engine in RDS.
False
What is the main benefit of using Amazon RDS Proxy?
Improved application availability and scalability.
Fill in the blank: RDS can be integrated with __________ for data warehousing solutions.
Amazon Redshift
What is the purpose of the AWS Well-Architected Tool in relation to RDS?
To assess the architecture of your RDS deployment.
True or False: RDS supports cross-region replication.
True
What is the difference between provisioned IOPS and standard storage in RDS?
Provisioned IOPS provides higher and consistent performance.
Fill in the blank: Amazon RDS can automatically apply __________ to your database during maintenance windows.
updates
What is the maximum IOPS for RDS provisioned IOPS storage?
Up to 80,000 IOPS
True or False: Amazon RDS allows you to change the instance type without downtime.
False
What does the term ‘database migration’ refer to?
The process of moving data from one database to another.
Fill in the blank: The __________ feature allows RDS to automatically adjust the instance size based on usage patterns.
autoscaling
What is the role of a VPC in relation to RDS?
To isolate RDS instances within a secure network.
True or False: You can use RDS to run Microsoft SQL Server databases.
True
What is the function of the AWS Schema Conversion Tool?
To convert database schema from one engine to another.
Fill in the blank: Amazon RDS provides built-in __________ to protect your data.
security features
What is the purpose of the AWS CloudFormation service in relation to RDS?
To automate the deployment of RDS resources.
What does the term ‘zone redundancy’ mean in the context of RDS?
The ability to replicate data across multiple Availability Zones.
What is the main function of Amazon RDS Performance Insights?
To provide database performance monitoring and tuning.
True or False: Amazon RDS supports database clustering.
True
Fill in the blank: Amazon RDS allows you to create __________ for automated backups.
snapshots
What is the maximum number of IOPS you can provision for an RDS instance?
80,000 IOPS
