SP-15 QUIZ (Databases)

You configured Multi-Availability Zone to your RDS instance. There is a spike in incoming requests in the past few hours, and the performance of the primary database is starting to go down. What would happen to the database if primary DB instance fails?

• The IP address of the primary DB instance is switched to the standby DB instance.

• The RDS DB instance will automatically reboot.

• The canonical name record is changed from the primary database to the standby database.

Your company has got a client whose data is stored in AWS for a 3 tier application. The relational database should be highly durable and support schema changes. Changes to the database should not result in downtime. As a Cloud Architect of the company. Which of the following would be the best data storage option for the client?

• AWS S3

• AWS Redshift

• AWS Aurora

You can SSH into and control the operating system where your Amazon RDS MySQL instance is running.

• True

• False

When creating a single-AZ Amazon RDS instance, you can select the Availability Zone into which you deploy it.

• True

• False

Which of the following AWS services is a non-relational database?

• Amazon RDS

• Amazon DynamoDB

• Amazon Redshift

Under what circumstances would I choose provisioned IOPS over standard storage when creating an RDS instance?

• If you need to run an I/O-intensive relational database for a mission-critical application in production.

• If your business was trying to save money.

• If you have workloads that are not sensitive to latency/lag.

• For test/development environments.

If I wanted to run a database on an EC2 instance, which of the following storage options would Amazon recommend?

• EBS

• S3

• EFS

• RDS

MySQL installations default to port number ____.

• 443

• 3306

• 80

• 5432

What data transfer charge is incurred when replicating data between Availability Zones for your Amazon RDS MySQL in a Multi-AZ deployment?

• There is no charge

• Standard data transfer charge

• Discounted data transfer charge

Which SQL-based relational database is suitable for high-performance OLTP (Online Transactional Processing) workloads?

• Amazon Redshift

• RDS with Provisioned IOPS

• Amazon DynamoDB