NEW
Font size
WorksheetsAWS Databases
Total questions: 20
Worksheet time: 8mins
AWS's NoSQL product offering is known as ____.
RDS
MongoDB
DynamoDB
MySQL
RDS Reserved instances are available for multi-AZ deployments.
False
True
Amazon's ElastiCache uses which two engines?
Reddit & Memcrush
Redis & Memory
MyISAM & InnoDB
Redis & Memcached
How many copies of my data does RDS - Aurora store by default?
3
2
6
4
Which of the following is most suitable for OLAP (Online Analytical Processing)?
ElastiCache
Redshift
RDS
DynamoDB
In RDS, what is the maximum value you can set for backup retention period?
30 Days
45 Days
35 Days
15 Days
You can SSH into and control the operating system where your Amazon RDS MySQL instance is running.
True
False
Under what circumstances would you choose provisioned IOPS over standard storage when creating an RDS instance?
If this was a test Database.
If you use online transaction processing in your production environment.
If your business was trying to save money.
If you have workloads that are not sensitive to latency/lag.
With new RDS DB instances, automated backups are enabled by default?
False
True
DB security groups are used with DB instances that are not in a VPC and on the EC2-Classic platform. When you create a DB security group, you need to specify a destination port number.
False
True
MySQL installations default to port number ____.
3306
1433
80
3389
If I wanted to run a database on an EC2 instance, which of the following storage options would Amazon recommend?
S3
EBS
Glacier
RDS
What data transfer charge is incurred when replicating data between Availability Zones for your Amazon RDS MySQL in a Multi-AZ deployment?
The charge is double the standard data transfer charge.
The charge is half of the standard data transfer charge.
There is no charge associated with this action.
The charge is the same as the standard data transfer charge.
Which set of RDS database engines is currently available?
Amazon Aurora, MySQL, MariaDB, Oracle, SQL Server, and PostgreSQL
PostgreSQL, MariaDB, MongoDB, Amazon Aurora
MariaDB, SQL Server, MySQL, Cassandra
Aurora, MySQL, SQL Server, Cassandra
You are hosting a MySQL database on the root volume of an EC2 instance. The database is using a large number of IOPS, and you need to increase the number of IOPS available to it. What should you do?
Migrate the database to Glacier.
Migrate the database to an S3 bucket.
Use CloudFront to cache the database.
Add 2 additional EBS SSD volumes and create a RAID 0 volume to host the database.
What happens to the I/O operations of a single-AZ RDS instance during a database snapshot or backup?
Nothing.
I/O operations will function normally.
I/O operations to the database are sent to a Secondary instance of a Multi-AZ installation (for the duration of the snapshot.)
I/O may be briefly suspended while the backup process initializes (typically under a few seconds), and you may experience a brief period of elevated latency.
Which AWS service is ideal for Business Intelligence Tools/Data Warehousing?
Elastic Beanstalk
ElastiCache
Redshift
DynamoDB
Which AWS Database service is the most suitable for OLTP (Online Transactional Processing) workloads?
DynamoDB
ElastiCache
RDS
Redshift
Your business is building a new application that will store its entire customer database that data for different purposes. Large analytics jobs on the database are likely to cause other applications to not be able to get the query results they need to, before time out. Also, as your data grows, these analytics jobs will start to take more time, increasing the negative effect on the other applications. How do you solve the contention issues between these different workloads on the same data?
Enable Multi-AZ mode on the RDS instance.
Use ElastiCache to offload the analytics job data.
Create RDS Read-Replicas for the analytics work.
Run the RDS instance on the largest size possible.
You have launched an RDS instance with MySQL database with default configuration for your file sharing application to store all the transactional information. Due to security compliance, your organization wants to encrypt all the databases and storage on the cloud. They approached you to perform this activity on your MySQL RDS database. How can you achieve this?
Stop the RDS instance, modify and select encryption option. Start the RDS instance, it may take a while to start RDS instance as existing data is getting encrypted.
Create a case with AWS support to enable encryption for your RDS instance.
Copy snapshot from latest snapshot of your RDS instance, select encryption during copy and restore a new DB instance from the newly encrypted snapshot.
AWS RDS is a managed service and the data at rest in all RDS instances are encrypted by default.
