CPC Prep Database Flashcards
Which database type is organized by tables, rows and columns, has a rigid schema (SQL), is typically scaled vertically, and supports complex queries?
Relational Database
Which type of database has varied storage models, flexible schema (NoSQL), scales horizontally, and supports unstructured data?
Non-Relational
Which type of database is used for online transaction processing (OLTP)?
Operational/Transactional Database
Which type of database has source data coming from OLTP databases?
Online Analytics Processing (OLAP)
When would you use a database on an EC2 instance?
When you need full control over the instance and database.
Which Amazon database service makes it easy to set up, operate, and scale a relational database in the cloud?
Amazon RDS
Which Amazon database service is Online Transaction Processing type of data base that can be used for online stores and banking systems?
Amazon RDS
How can you encrypt Amazon RDS instances and snapshots at rest?
Enabling encryption options for your Amazon RDS DB instance
Which service does Amazon RDS use for encryption services?
Key Management System (KMS)
Which AWS database services supports SQL server, Oracle, MySQL Server, PostgreSQL, Aurora, and Maria DB?
Amazon RDS
How does Amazon RDS scale?
Vertically by increasing the instance size
How does Amazon RDS achieve fault tolerance, disaster recovery, and automatic failover?
By using Multi-Availability Zone option
When should you use Amazon RDS read replica options and is used for scaling read performance?
For read heavy workloads
Which AWS database offering is in the RDS family?
Aurora
Which AWS database operates using MySQL and PostreSQL for a compatible relational database built for the cloud?
Aurora
Which AWS database features a distributed, fault-tolerant, self-healing storage system that auto-scales up to 64TB per database instance?
Aurora
Which AWS database service is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability?
DynamoDB
Which AWS database service offers push button scaling that enables you to scale at any time without incurring downtime?
DynamoDB
Which AWS database service synchronously replicates data across 3 Availability Zones in a region?
Dynamo DB
Which service is a fully managed, highly available, in-memory cache for DynamoDB that delivers up to 10X performance improvement?
DynamoDB Accelerator (DAX)
How does DynamoDB scale?
Horizontally
How does DynamoDB backup?
Point-in-time recovery down to the second in the last 35-days
- on-demand backup and restore
Which AWS service acts as a data warehouse for large volumes of aggregated data to perform analytics?
Amazon RedShift
Which AWS database service is a fast, fully managed data warehouse that makes it simple and cost-effective to analyze all you data using standard SQL and Business Intelligence Tools?
Amazon RedShift
