Relational Database Service (RDS) Flashcards
type of nonrelational database that uses a simple key-value method to store data. A key-value database stores data as a collection of key-value pairs in which a key serves as a unique identifier
Key Value Database
type of nonrelational database that is designed to store and query data as JSON-like documents.These DB make it easier for developers to store and query data in a database by using the same document-model format they use in their application code
Document Database
database purpose-built to store and navigate relationships. Relationships are first-class citizens and most of the value is derived from these relationships
Graph Database
purpose-built databases that rely primarily on memory for data storage, in contrast to databases that store data on disk or SSDs. Are designed to enable minimal response times by eliminating the need to access disks
In-Memory Database
NoSQL database that organizes data storage into flexible columns that can be spread across multiple servers or database nodes
Wide Column Database
Transaction model ensures that a performed transaction is always consistent. This makes it a good fit for businesses which deal with online transaction processing, or online analytical processing. Used for systems which can handle many small simultaneous transactions. used for relational DB
ACID
The rise of NoSQL databases provided a flexible and fluid way to manipulate data used by MongoDB, Cassandra and Redis are among the most popular NoSQL solutions, together with Amazon DynamoDB and Couchbase
BASE
ensure availability of data by spreading and replicating it across the nodes of the database cluster
Basically Available
Use EC2 for databases if you need access to the DB instance operating system
True
Use EC2 for databases if you need advanced database tuning which can only be done on the root
True
Use EC2 for databases or database version which aws dont provide
True
MySQL, MariaDB, PostgreSQL, Oracle, Microsoft SQL Server are all
Database engines for RDS
Can RDS be access from the VPC or any connected private networks?
Yes
Allows access to the database from the public internet
Public Addressing
Does every RDS instance have its own EBS storage?
Yes
Data is replicated from primary to standby immediately
Synchronous Replication
Data is replicated from Standby to Read replicas, data is not replicated immediately
Asynchronous Replication
cluster deployment in Amazon RDS provides a high availability deployment mode of Amazon RDS with two readable standby DB instances
Multi-AZ DB cluster
has a writer DB instance and two usable reader DB instances in three separate Availability Zones in the same AWS Region
Multi-AZ DB cluster
provides high availability and failover support for DB instances using a single standby DB instance. Amazon RDS automatically provisions and maintains a synchronous standby replica in a different Availability Zone
Multi-AZ DB instance deployment
Points at the writer and is used for read, writes and administration
Cluster Endpoint
Directs and reads at an available reader instance
Reader Endpoint
Points at a specific instance generally used for testing/fault finding
Instance Endpoints
contained in AWS managed s3 buckets that are unable to be viewed from S3
RDS Backups
Do snapshots live on after the deletions of an RDS instance
Yes
RDS can be configured to replicate backups to another region for extra charges for replication and storage
True
When restoring RDS a new instance is created with a new address, applications must be configured to the new RDS instance address
True
Provide enhanced performance and durability for Amazon RDS database (DB) instances. They make it easy to elastically scale out beyond the capacity constraints of a single DB instance for read-heavy database workloads
Read Replicas
Amazon RDS creates a second DB instance using a snapshot of the source DB instance. It then uses the engines’ native asynchronous replication to update the read replica whenever there is a change to the source DB instance
Read Replicas
Read Replicas offer near 0 RPO and very low RTO from failure, data corruption means the Read Replica likely has corrupted data
True
Encryption in RDS
SSL/TLS in transit
EBS volume encryption in RDS
Thru KMS
SQL Server (SQL Server Enterprise Edition) and Oracle security in RDS, which is handled within the DB engine
TDE
Does RDS oracle support integration with CloudHSM
Yes
can you map database users to IAM roles for federated access.
Yes
managed database service for applications that require customization of the underlying operating system and database environment, used/needed for legacy, packaged, and custom applications
RDS Custom
instead of connecting to the database everytime, users connect to a proxy which has a pool of connections to the database
rds proxy