Database Services Flashcards
Ideal for databases that frequently read and write data, this system is optimized for faster query performance.
Online Transaction Processing (OLTP)
Optimized for handling complex queries on large datasets, data warehousing consolidates multiple transaction records into a single database.
Online Analytic Processing (OLAP)
This database engine offers an S3 Integration
Oracle
These databases offer Transparent Data Encryption (TDE), which encrypts data before it is stored.
Microsoft SQL Server and Oracle
These Databases provide an audit plug-in for logging user logins and queries executed on the databases.
MySQL and MariaDB
Database instance storage class that offers faster query times and improved performance.
Memory Optimized
Database instance class that is best for nonproduction environments and testing.
Burstable Performance
A low latency cost effective storage value
General-Purpose SSD
Both of these databases are supported by Aurora DB.
Postgres and MYSQL
RDS supports x amount of read replicas
5
A database instance designed to support applications that require intensive querying.
Read Replica
Aurora supports x amount of read replicas
15
The instance remains responsible for writing data to the database.
master database instance
Data from the master database is replicated to the read replicas?
Asynchronously replicated (Not instant)
A domain name that the application uses when a query is needed to be performed on the database.
Reader Endpoint
Deploying multiple database instances in different availability zones.
Multi-AZ deployment.
Within a Multi-AZ DB deployment, all instances should
Be in the same region
In a Multi-AZ deployment, your application uses a __ for the primary and the secondary is __
Endpoint domain
Not a read replica
Database instance that provides 6 copies of your data across 3 AZs
Aurora
Instances rely on a cluster volume that is synchronized across three availability zones, allowing for an instance to take over if the primary fails.
Aurora Single-Master
All instances are capable of writing to the database. Therefore, when one instance fails, there is no failover because all instances can continue writing to the shared cluster volume that stores the database.
Aurora Multi-Master
The maximum acceptable time to recover data.
Recovery Time Objective (RTO)
The maximum acceptable data loss.
Recovery Point Objective (RPO)
Point-in-time recovery is enabled, allowing the archiving of database change logs to S3 every five minutes.
Automated Snapshots
RDS automates snapshots for a set duration, allowing you to choose between 1 to 35 days. Setting the retention period to 0 deletes existing snapshots, while setting it to 1 creates a new snapshot.
Retention period
Frequent opening and closing of database connections can drain resources and degrade performance. Proper management of idle connections and scaling with demand.
Amazon RDS Proxy
Using AWS Secrets Manager with Amazon RDS allows for an encrypted connection to provide authentication credentials.
Amazon RDS Proxy
A database warehouse service for computationally intensive queries, it enables faster data retrieval by utilizing compression to encode and reduce the size of the data or columns.
Amazon Redshift (SQL)
This node in a Redshift cluster coordinates communication among compute nodes and clients without incurring any additional charges. What is it?
Leader Node
Components of an Amazon Redshift cluster can be categorized into three types, each with varying storage capacities and types of storage media. What are these types?
Dense Compute Nodes: Store up to 326 TB on fast SSDs.
Dense Storage Nodes: Store up to 2 PB on magnetic hard disk drives.
RA3 Nodes: Store up to 16,384 TB on fast SSDs (faster alternative to dense storage nodes).
With data in the same region, you can query data from files stored in AWS S3 without having to import the data into your clusters.
Redshift Spectrum
A secure way to migrate databases from on-premises to AWS, using an instance and replication if the database engines differ.
AWS Database Migration Service (DMS)
Converts your database from one engine to another.
AWS Schema Conversion Tool (SCT)
Aside from querying with the primary key, these databases are unsuitable for complex or arbitrary queries.
Nonrelational (NoSQL) Databases
A NoSQL database that offers millisecond latency and multi-AZ by default, with authorization through IAM and rapidly evolving schemas.
DynamoDB
DynamoDB offers a point-in-time recovery for backups for up to…
35 days
This database feature allows the information in the table to be updated as records contain details about data modifications.
DynamoDB Stream
This NoSQL feature enables replication of your database across different regions.
DynamoDB Global
