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