Database Flashcards
What is OLAP
Online Analytical Processing Redshift
Which of the following data formats does Amazon Athena support?
Apache ORC Apache Parquet JSON
If you want your application to check RDS for an error, have it look for an __ code in the response from the Amazon RDS API.
Error
MySQL installations default to port number ____.
3306
RDS Reserved instances are available for multi-AZ deployments.
True
In RDS, changes to the backup window take effect ____.
Immediately
what is the maximum size RDS volume you can have by default
16TB
With new RDS DB instances, automated backups are enabled by default?
True
Which set of RDS database engines is currently available?
Oracle, SQL Server, MySQL, PostgreSQL
OLTP
(Online Transactional Processing) RDS
Which AWS DB platform is most suitable for OLTP?
RDS
How many copies of my data does RDS - Aurora store by default?
6
In RDS, what is the maximum value I can set for my backup retention period?
35 Days
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?
Add 2 additional EBS SSD volumes and create a RAID 0 volume to host the database. Why is this incorrect? CloudFront does not increase IOPS, CloudFront is a Content Delivery Network that helps deliver content closer to the consumers of the content. Correct Answer: B Why is this correct? RAID 0 provides performance improvements compared with a single volume as data can be read and written to multiple disks simultaneously. 2 disks, each with a bandwidth of 4,000 IOPS will provide a combined bandwidth of 8,000 IOPS.
Which of the following DynamoDB features are chargeable, when using a single region?
Read and Write Capacity Storage of Data
RDS and Elasticache
You should consider; using ElastiCache, using RDS Read Replicas Scaling up may also resolve the contention, however it may be more expensive than offloading the read activities to cache or Read-Replicas. RDS Multi-AZ is for resilience only.
Boosting MySQL database performance with Amazon ElastiCache for Redis
Relational databases are a cornerstone of most applications. When it comes to scalability and low latency though, there’s only so much you can do to improve performance. Even if you add replicas to scale reads, there’s a physical limit imposed by disk based storage. The most effective strategy for coping with that limit is to supplement disk-based databases with in-memory caching.
https://aws.amazon.com/getting-started/hands-on/boosting-mysql-database-performance-with-amazon-elasticache-for-redis/
Which of the following strategies does AWS use to deliver the promised levels of DynamoDB performance?
Data is stored on Solid State Disks.
The Database is partitioned across a number of nodes.
DynamoDB makes use of parallel processing to achieve predictable performance. You visualise each partition as an independent DB server of fixed size. Each responsible for a defined block of data. In SQL terminology it is called sharding. The documentation is specific about the SSDs, but makes no mention of read-replicas or EBS-Optimised. Caching in-front of DDB is an option (DAX), but it is not inherent to DDB.
You have a database-style application that frequently has multiple reads and writes across the data set. Which of the following AWS storage services are capable of hosting this application?
thumb_upthumb_down
Elastic File Service (EFS)
EBS
NOT S3
