Section 21: Databases in AWS Flashcards
A web service that makes it easier to set up, operate, and scale a relational database in the AWS Cloud. It provides cost-efficient, resizable capacity for an industry-standard relational database and manages common database administration tasks.
Amazon RDS
This service is a fully managed relational database engine that’s compatible with MySQL and PostgreSQL
Amazon Aurora
How long does storage replication take across regions when using Aurora Global?
Less than one second
Service that can be described as a fully managed, in-memory caching service supporting flexible, real-time use cases. (i.e. fully managed Redis or Memcached)
ElastiCache
True/False - Using ElastiCache requires changes to your application code
True
A fully managed, serverless, key-value NoSQL database designed to run high-performance applications at any scale
Amazon DynamoDB
What are the two backup options available for DynamoDB?
Automated backups with PITR
On-Demand backups
What is the maximum object size for an object in Amazon S3?
5 TB
A fully managed native JSON document database that makes it easy and cost effective to operate critical document workloads at virtually any scale without managing infrastructure (i.e. managed MongoDB)
DocumentDB
A fully managed database service built for the cloud that makes it easier to build and run graph applications
Neptune
A scalable, highly available, and managed Apache Cassandra–compatible database service
Amazon Keyspaces
A fully managed ledger database that provides a transparent, immutable, and cryptographically verifiable transaction log owned by a central trusted authority
Amazon Quantum Ledger Database
A fast, scalable, and serverless time-series database service that makes it easier to store and analyze trillions of events per day up to 1,000 times faster
Amazon Timestream
What RDS service can you use if you want to operate an Oracle database on the cloud and have access to customize the database server host and operating system?
RDS Custom for Oracle
True/False: ElastiCache supports IAM Authorization
False - You have to use the cache’s authorization methods
True/False: ElastiCache for Redis is not HIPAA eligible
False - ElastiCache for Redis features Online Cluster Resizing, supports encryption, and is HIPAA eligible, and PCI DSS compliant
True/False: DynamoDB Accelerator (DAX) supports SQL query caching
False
What are the two purposes for using Aurora replicas?
Scale read operations
Increase availability in case a cluster becomes unavailable
This feature of RDS detects that you are running out of free database space and automatically scales up your storage
Storage autoscaling
ElasticCache can be used to significantly improve latency and through put for ____-heavy application workloads as well as _____-intensive workloads
read; compute
True/False: All DynamoDB tables are encrypted by default
True - all DynamoDB tables are encrypted under an AWS owned customer master key (CMK)
What is the main feature of Elasticache for Memcached that Elasticache for Redis does not offer?
Multithreaded architecture
What Aurora database feature can you use if you need to create copies of the database?
Cloning
Which is the only AWS database type that supports database cloning?
Aurora
True/False: Running a database level upgrade for an RDS DB instance with Multi-AZ deployment causes downtime because both the primary and standby database instances are upgraded at the same time.
True
