AWS Databases Quiz
Which AWS service is ideal for business intelligence tools/data warehousing? A.) ElastiCache B.) DynamoDB C.) Redshift D.) Elastic Beanstalk
C
RDS Reserved Instances are available for Multi-AZ deployments. A.) True B.) False
A
Under what circumstances would I choose provisioned IOPS over standard storage when creating an RDS instance? A.) If you use online transaction processing in your production environment B.) If your business is trying to save money C.) If you're using it for your development environment D.) If you have workloads that are not sensitive to latency/lag
A
What are the various ways of securing a database running in RDS? 1. Create the database in a private subnet 2. Encrypt the entire database 3. Create the database in multiple AZs 4. Change the IP address of the database every week A.) 1, 2 B.) 1, 3 C.) 3, 4 D.) 2, 4
A
What data transfer charge is incurred when replicating data from your primary RDS instance to your secondary RDS instance? A.) There is no charge associated with this action B.) The charge is double the standard data transfer charge C.) The charge is half of the standard data transfer charge D.) The charge is the same as the standard data transfer charge
A
When creating an RDS instance you can select which availability zone in which to deploy your instance. A.) True B.) False
A
Which AWS DB platform is most suitable for OLTP? A.) RDS B.) Redshift C.) DynamoDB D.) ElastiCache
A
Which set of RDS database engines is currently available? A.) Oracle, SQL Server, MySQL, PostgreSQL B.) MariaDB, SQL Server, MySQL, Cassandra C.) Aurora, MySQL, SQL Server, Cassandra D.) PostgreSQL, MariaDB, MongoDB, Aurora
A
With new RDS DB instances, automated backups are enabled by default? A.) True B.) False
A
What happens to the I/O operations of a single-AZ RDS instance during a database snapshot or backup? A.) I/O operations will function normally B.) I/O operations to the database are sent to a secondary instance of a Multi-AZ installation (for the duration of the snapshot) C.) I/O may be briefly suspended while the backup process initializes and you may experience a brief period of elevated latency D.) Nothing
C
Which of the following AWS services is a non-relational database? A.) RDS B.) ElastiCache C.) DynamoDB D.) Redshift
C
Which of the following statements are true for Amazon Aurora? 1. The storage is replicated in three different AZs 2. The data is copied at six different places 3. It uses a quorum-based system for reads and writes 4. Aurora supports all the commercial databases A.) 1, 2, 4 B.) 1, 2 C.) 1, 2, 3 D.) 2, 3, 4
C
You're running a mission-critical application, and you are hosting the database for that application in RDS. Your IT team needs to access all the critical OS metrics every 5 seconds. What approach would you choose? A.) Write a script to capture all the key metrics and schedule the script to run every 5 seconds using a cron job B.) Schedule a job every 5 seconds to capture the OS metrics C.) Use standard monitoring D.) Use advanced monitoring
D
If you want your application to check RDS for an error, have it look for an ____________ node in the response from the Amazon RDS API A.) Error B.) Exit C.) Incorrect D.) Abort
A
In RDS, change to the backup window take effect ____________ A.) Immediately B.) After 30 minutes C.) The next day D.) You cannot backup in RDS
A
Amazon's Elasticache uses which two engines? A.) MyISAM & InnoDB B.) Redis & Memcached C.) Redis & Memory D.) Reddit & Memcrush
B
MySQL installations default to port number ____________ A.) 80 B.) 3306 C.) 1433 D.) 3389
B
When you add a rule to an RDS DB security group, you must specify a port number or protocol A.) True B.) False
B
Which of the following is most suitable for OLAP? A.) ElastiCache B.) Redshift C.) DynamoDB D.) RDS
B
You a running your MySQL database in RDS. The database is critical for you, and you can't afford to lose any data in the case of any kind of failure. What kind of architecture will you go for with RDS? A.) Create the RDS across multiple regions using a cross-regional read replica B.) Create the RDS across multiple AZs in master standby mode C.) Create the RDS and create multiple read replicas in multiple AZs with the same region D.) Create a multimaster RDS database across multiple AZs
B
You can RDS or SSH into an RDS instance to see what is going on with the OS A.) True B.) False
B
You have a legacy application that needs a file system in the database server to write application files. Where should you install the database? A.) You can achieve this using RDS because RDS has a file system in the database server B.) Install the database on an EC2 instance to get full control C.) Install the database in RDS, mount an EFS from the RDS server, and give the EFS mount point to the application for writing the application files D.) Create the database using a multi-AZ architecture in RDS
B
You have to run analytics, and to optimize I want to store all the data in columnar format. Which database serves my need? A.) Amazon Aurora for MySQL B.) Amazon Redshift C.) Amazon DynamoDB D.) Amazon Aurora for PostegreSQL
B
Your company has just acquired a new company, and the number of users who are going to use the database will double. The database is running on Aurora. What things can you do to handle the additional users? 1. Scale up the database vertically by choosing a bigger box 2. Use a combination of Aurora and EC2 to host the database 3. Create a few read replicas to handle the additional read-only traffic 4. Create the Aurora instance across multiple regions with a multi-master mode A.) 1, 2 B.) 1, 3 C.) 2, 4 D.) 3, 4
B
If you are using Amazon RDS Provisioned IOPS storage with a Microsoft SQL Server database engine, what is the maximum size RDS volume you can have by default? A.) 1TB B.) 6TB C.) 16TB D.) 32TB
C
In RDS, what is the maximum value you can set for the backup retention period? A.) 15 days B.) 30 days C.) 35 days D.) 45 days
C
What are the 2 in-memory key-value engines that Amazon ElastiCache supports? 1. Memcached 2. MySQL 3. Redis 4. SQL Server A.) 1, 2 B.) 2, 4 C.) 1, 3 D.) 3, 4
C
You want to launch a copy of a Redshift cluster to a different region. What is the easiest way to do this? A.) Create a cluster manually in a different region and load all the data B.) Extend the existing cluster to a different region C.) Use third-party software like Golden Gate to replicate the data D.) Enable cross-region snapshot and restore the database from the snapshot to a different region
D
You application is I/O bound, and your application needs around 36,000 IOPS. The application you are running is critical for the business. How can you make sure the application always gets all the IOPS it requests and the database is highly available? A.) Install the database in EC2 using an EBS-optimized instance and choose an I/O optimized instance class with an SSD-based hard drive B.) Install the database in RDS using SSD C.) Install the database in RDS in multi-AZs using Provisioned IOPS and select 36,000 D.) Install multiple copies of read replicas in RDS so all the workload gets distributed across multiple read replicas and you can cater to the I/O requirement
C
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 IOPS available to it. What should you do? A.) Migrate the database to an S3 bucket. B.) Migrate the database to Glacier. C.) Add 4 additional EBS SSD volumes and create a RAID 10 using these volumes. D.) Use Cloud Front to cache the database.
C
AWS's NoSQL product offering is known as ____________ A.) RDS B.) MongoDB C.) MySQL D.) DynamoDB
D
How many copies of your data does RDS-Aurora store by default? A.) 1 B.) 2 C.) 3 D.) 6
D
If you encrypt a database running in RDS, what objects are going to be encrypted? A.) The entire database B.) The database backups and snapshots C.) The database log files D.) All of the above
D
If you wanted to run a database on an EC2 instance, which of the following storage options would Amazon recommend? A.) S3 B.) RDS C.) EFS D.) EBS
D
Which RDS engine does not support read replicas? A.) MySQL B.) Aurora MySQL C.) PostgreSQL D.) Oracle
D
Which of the following DynamoDB features are chargeable when using a single region? 1. The number of tables created 2. Storage of data 3. Read and write capacity 4. Incoming data transfer A.) 1, 4 B.) 1, 2 C.) 3, 4 D.) 2, 3
D
Which of the following data formats does Amazon Athena support? 1. JSON 2. Apache Parquet 3. Apache ORC 4. XML A.) 1, 2 B.) 1, 4 C.) 2, 3, 4 D.) 1, 2, 3
D
Which of the following does Amazon DynamoDB support? 1. Graph database 2. Key-value database 3. Document database 4. Relational database A.) 1, 4 B.) 1, 2 C.) 3, 4 D.) 2, 3
D
Which of the following is not a feature of DynamoDB? A.) The primary key can either be a single-attribute or a composite B.) Data reads that are either eventually consistent or strongly consistent C.) The ability to perform operations by using a user-defined primary key D.) The ability to store relational based data
D
You are running a MySQL database in RDS, and you have been tasked with creating a disaster recovery architecture. What approach is easiest for creating the DR instance in a different region? A.) Create an EC2 server in a different region and constantly replicate the database over there B.) Create an RDS database in the other region and use third-party software to replicate the data across the database C.) While installing the database, use multiple regions. This way, your database gets installed into multiple regions directly D.) Use the cross-regional replication functionality of RDS. This will quickly spin off a read replica in a different region that can be used for disaster recovery
D
You want to store JSON objects. Which database should you choose? A.) Amazon Aurora for MySQL B.) Oracle hosted on EC2 C.) RDS Instance of PostgreSQL D.) DynamoDB
D
