AWS Database Specialty 练习

RDS manages relational databases. NoSQL, object storage, and CDNs are different.

Aurora is compatible with MySQL and PostgreSQL. Graph databases, caches, and warehouses are different.

DynamoDB is a NoSQL key-value and document database. Relational databases, caches, and warehouses are different.

Redshift is a data warehouse. NoSQL, caches, and graph databases are different.

ElastiCache provides in-memory caching. Relational databases, warehouses, and graph databases are different.

Neptune is a graph database. Relational databases, caches, and warehouses are different.

DocumentDB is MongoDB compatible. Graph, cache, and warehouse services are different.

Multi-AZ provides failover across availability zones. Read replicas, caches, and backups are different.

Aurora Serverless scales capacity on demand. Fixed-size databases, caches, and warehouses are different.

RDS is managed relational, Aurora is MySQL/Postgres compatible, DynamoDB is NoSQL, and Redshift is a warehouse.

Primary keys uniquely identify rows. Foreign keys link tables, indexes speed lookups, and backups protect data.

Foreign keys reference primary keys in other tables. Unique row IDs, caches, and snapshots are different.

Indexes improve query performance. Tables, backups, and caches are different.

Partitioning splits data for manageability and performance. Deletion, encryption, and reports are different.

Normalization reduces redundancy. Duplication, deletion, and caching are different.

Denormalization adds redundancy for faster reads. Reducing redundancy, deleting indexes, and encryption are different.

Partition keys control data distribution in DynamoDB. Foreign keys, indexes, and backups are different.

Sort keys order items in a partition. Primary keys, caches, and snapshots are different.

Schema design defines the data structure. Backups, deletion, and CDNs are different.

Primary keys identify rows, indexes speed lookups, partitioning splits data, and normalization reduces redundancy.

Automated backups enable point-in-time recovery. Manual snapshots, caches, and read replicas are different.

Snapshots are manual backups. Automated backups, caches, and queries are different.

Maintenance windows schedule changes. Backups, read replicas, and security groups are different.

Multi-AZ failover uses a standby for availability. Read replicas, caches, and deletion are different.

Read replicas serve read traffic. Standby instances, backups, and caches are different.

PITR restores to a chosen time. Deletion, caching, and encryption are different.

Retention controls backup duration. Caches, indexes, and security groups are different.

Parameter groups configure database settings. Backups, snapshots, and caches are different.

Option groups enable database features. Backups, caches, and indexes are different.

Backups provide recovery, snapshots restore manually, read replicas scale reads, and maintenance windows schedule changes.

At-rest encryption protects stored data. Transit encryption, caches, and backups are different.

Transit encryption protects moving data. Stored-file encryption, snapshots, and indexes are different.

IAM database authentication uses IAM credentials. Engines, caches, and backups are different.

KMS manages keys. File storage, traffic filtering, and reports are different.

Security groups filter traffic. Databases, caches, and backups are resources or features.

VPC isolation protects network access. Storage, disabled encryption, and reports are different.

Secrets Manager stores and rotates secrets. Databases, caches, and firewalls are different.

TLS/SSL encrypts connections. Faster queries, storage, and indexes are not encryption features.

Audit logs record activity. Backups, caches, and indexes are different.

IAM grants permissions, KMS manages keys, security groups filter traffic, and Secrets Manager stores secrets.

Query tuning improves execution. Deletion, backups, and DNS are different.

Index optimization improves lookups. Deletion, caching, and backups are different.

Read replicas offload reads. Encryption, deletion, and reports are different.

Caching speeds access to hot data. Deletion, encryption, and backups are different.

DAX is an in-memory cache for DynamoDB. Relational databases, warehouses, and backups are different.

Auto scaling adjusts capacity. Deletion, encryption, and reports are different.

Provisioned IOPS guarantees storage performance. Caches, backups, and security groups are different.

Query plans show execution steps. Backups, caches, and reports are different.

Connection pooling reuses connections. Deleting, encrypting, and backing up are different.

Read replicas scale reads, DAX caches, Provisioned IOPS guarantees IOPS, and query plans show execution.

DMS migrates databases. Engines, caches, and backups are different.

SCT converts schemas between engines. Backups, caches, and firewalls are different.

CDC captures changes for replication. Deletion, encryption, and reports are different.

Replication instances run DMS tasks. Source/target databases and caches are different.

DataSync transfers data between storage systems. Engines, caches, and backups are different.

Schema conversion adapts objects. Deletion, backups, and encryption are different.

Homogeneous migrations use the same engine. Heterogeneous migrations differ, and caches or backups are different.

Heterogeneous migrations change engines. Same-engine, caches, and snapshots are different.

Cutover switches production to the new system. Start, backups, and caches are different.

DMS migrates data, SCT converts schemas, CDC captures changes, and DataSync transfers files.