MCQs on Amazon RDS Automation | AWS RDS Questions

Dive into this collection of AWS RDS MCQ questions and answers focused on Amazon RDS automation. These questions cover critical concepts such as using AWS CLI and SDK for RDS operations, automating with AWS Lambda, leveraging RDS APIs for workflows, and managing automated backups and snapshots. Perfect for AWS certification prep and skill enhancement!

---

Amazon RDS Automation MCQs

Using AWS CLI and SDK for RDS Operations

1. Which AWS CLI command is used to describe all RDS instances in an account?
   a) aws rds describe-db-instances
   b) aws rds list-db-instances
   c) aws rds get-db-details
   d) aws rds query-db
2. What is the purpose of the aws-sdk in RDS operations?
   a) To configure VPCs
   b) To automate RDS workflows in programming languages
   c) To manage IAM roles
   d) To create EC2 instances
3. Which programming language is NOT supported by the AWS SDK?
   a) Python
   b) Ruby
   c) Swift
   d) COBOL
4. How can you tag an RDS instance using the AWS CLI?
   a) aws rds add-tags-to-resource
   b) aws rds create-tags
   c) aws rds attach-tags
   d) aws rds set-resource-tags
5. Which AWS CLI command is used to restore an RDS instance from a snapshot?
   a) aws rds create-db-snapshot
   b) aws rds restore-db-instance-from-snapshot
   c) aws rds clone-db-instance
   d) aws rds replicate-snapshot

Automation with AWS Lambda

6. Which AWS service is required to trigger Lambda functions for automated RDS tasks?
   a) S3
   b) EventBridge
   c) CloudFormation
   d) Route 53
7. A common use case for AWS Lambda in RDS automation is:
   a) Managing database schemas
   b) Creating custom reports
   c) Automatically starting and stopping instances based on schedules
   d) Enabling Multi-AZ deployments
8. How can you secure Lambda’s access to RDS?
   a) Assign an IAM role to the Lambda function
   b) Add the Lambda function to the RDS security group
   c) Use an API Gateway
   d) Enable Public Access
9. Which language is commonly used to write AWS Lambda functions for RDS?
   a) PHP
   b) Python
   c) C++
   d) JavaScript
10. What is the maximum runtime for an AWS Lambda function?
    a) 1 minute
    b) 5 minutes
    c) 15 minutes
    d) 60 minutes

Leveraging Amazon RDS APIs for Custom Workflows

11. Which API operation can be used to list all snapshots of an RDS instance?
    a) DescribeSnapshots
    b) ListSnapshots
    c) GetDBSnapshots
    d) DescribeDBSnapshots
12. To terminate an RDS instance via API, you would call:
    a) DeleteDBInstance
    b) RemoveDBInstance
    c) TerminateRDSInstance
    d) DestroyInstance
13. How does the Amazon RDS API authenticate requests?
    a) Using API Gateway keys
    b) Through VPC endpoints
    c) With access keys and secret keys
    d) Using S3 bucket policies
14. Which API call is used to scale storage for an RDS instance?
    a) ModifyDBInstance
    b) ScaleStorageInstance
    c) UpdateInstanceSize
    d) ChangeInstanceCapacity
15. What is the format of Amazon RDS API requests?
    a) JSON over HTTPS
    b) XML over HTTP
    c) SOAP
    d) YAML over SFTP

Automated Backups and Snapshots

16. How often are automated backups taken in RDS by default?
    a) Once per day
    b) Every 6 hours
    c) Every hour
    d) Every 15 minutes
17. What happens when the backup retention period is set to 0 days?
    a) Backups are taken but not stored
    b) Automated backups are disabled
    c) Snapshots are deleted immediately
    d) Retention defaults to 7 days
18. What type of snapshot must be used for creating a copy in another AWS region?
    a) Manual Snapshot
    b) Automated Snapshot
    c) System Snapshot
    d) Backup Snapshot
19. Which AWS CLI command creates a manual snapshot of an RDS instance?
    a) aws rds backup-db-instance
    b) aws rds create-db-snapshot
    c) aws rds save-db-backup
    d) aws rds snapshot-instance
20. What is a common use case for point-in-time recovery?
    a) Restoring a database to a specific version
    b) Scaling up database storage
    c) Undoing data loss caused by accidental deletion
    d) Migrating databases across regions

Mixed Questions

21. How can you automate the deletion of outdated RDS snapshots?
    a) Use EventBridge rules
    b) Use an AWS Lambda function with a cron job
    c) Schedule deletion in the AWS Console
    d) Enable lifecycle policies
22. Which AWS service is commonly used to schedule automated RDS operations?
    a) EventBridge
    b) CloudFormation
    c) CodePipeline
    d) Elastic Beanstalk
23. Which RDS API operation can trigger a manual failover?
    a) InitiateFailover
    b) RebootDBInstance
    c) PromoteReadReplica
    d) FailoverRDSInstance
24. What happens when automated backups are disabled in RDS?
    a) Multi-AZ replication stops
    b) Manual snapshots are also disabled
    c) Point-in-time recovery is unavailable
    d) All existing snapshots are deleted
25. Which AWS SDK package is used for RDS operations in Node.js?
    a) aws-sdk-rds
    b) aws-sdk
    c) node-aws-rds
    d) rds-api-sdk
26. How can you monitor the status of automated backups?
    a) Use CloudTrail logs
    b) Check the “Backup Status” field in the AWS Console
    c) Enable CloudWatch metrics
    d) Use Lambda triggers
27. What is the maximum retention period for automated backups?
    a) 7 days
    b) 35 days
    c) 90 days
    d) Unlimited
28. What action is required to share an RDS snapshot with another AWS account?
    a) Use the share-snapshot CLI command
    b) Modify snapshot permissions to allow access
    c) Copy the snapshot to the target account
    d) Enable cross-account IAM roles
29. Which AWS CLI command can you use to schedule a snapshot?
    a) aws rds schedule-db-snapshot
    b) aws rds create-db-snapshot
    c) aws rds set-snapshot-policy
    d) aws rds snapshot-schedule
30. How can you ensure an RDS instance is compliant with backup policies?
    a) Use Config Rules
    b) Enable Enhanced Monitoring
    c) Modify the instance type
    d) Use CloudFormation templates

---

Answers

QNo	Answer (Option with Text)
1	a) aws rds describe-db-instances
2	b) To automate RDS workflows in programming languages
3	d) COBOL
4	a) aws rds add-tags-to-resource
5	b) aws rds restore-db-instance-from-snapshot
6	b) EventBridge
7	c) Automatically starting and stopping instances based on schedules
8	a) Assign an IAM role to the Lambda function
9	b) Python
10	c) 15 minutes
11	d) DescribeDBSnapshots
12	a) DeleteDBInstance
13	c) With access keys and secret keys
14	a) ModifyDBInstance
15	a) JSON over HTTPS
16	a) Once per day
17	b) Automated backups are disabled
18	a) Manual Snapshot
19	b) aws rds create-db-snapshot
20	c) Undoing data loss caused by accidental deletion
21	b) Use an AWS Lambda function with a cron job
22	a) EventBridge
23	c) PromoteReadReplica
24	c) Point-in-time recovery is unavailable
25	b) aws-sdk

Last 6 answers

QNo	Answer (Option with Text)
25	b) aws-sdk
26	c) Enable CloudWatch metrics
27	b) 35 days
28	b) Modify snapshot permissions to allow access
29	b) aws rds create-db-snapshot
30	a) Use Config Rules