CPC Prep Database Flashcards

1
Q

Which database type is organized by tables, rows and columns, has a rigid schema (SQL), is typically scaled vertically, and supports complex queries?

A

Relational Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which type of database has varied storage models, flexible schema (NoSQL), scales horizontally, and supports unstructured data?

A

Non-Relational

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Which type of database is used for online transaction processing (OLTP)?

A

Operational/Transactional Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Which type of database has source data coming from OLTP databases?

A

Online Analytics Processing (OLAP)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

When would you use a database on an EC2 instance?

A

When you need full control over the instance and database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Which Amazon database service makes it easy to set up, operate, and scale a relational database in the cloud?

A

Amazon RDS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Which Amazon database service is Online Transaction Processing type of data base that can be used for online stores and banking systems?

A

Amazon RDS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

How can you encrypt Amazon RDS instances and snapshots at rest?

A

Enabling encryption options for your Amazon RDS DB instance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Which service does Amazon RDS use for encryption services?

A

Key Management System (KMS)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Which AWS database services supports SQL server, Oracle, MySQL Server, PostgreSQL, Aurora, and Maria DB?

A

Amazon RDS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

How does Amazon RDS scale?

A

Vertically by increasing the instance size

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

How does Amazon RDS achieve fault tolerance, disaster recovery, and automatic failover?

A

By using Multi-Availability Zone option

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

When should you use Amazon RDS read replica options and is used for scaling read performance?

A

For read heavy workloads

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Which AWS database offering is in the RDS family?

A

Aurora

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Which AWS database operates using MySQL and PostreSQL for a compatible relational database built for the cloud?

A

Aurora

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Which AWS database features a distributed, fault-tolerant, self-healing storage system that auto-scales up to 64TB per database instance?

A

Aurora

17
Q

Which AWS database service is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability?

A

DynamoDB

18
Q

Which AWS database service offers push button scaling that enables you to scale at any time without incurring downtime?

A

DynamoDB

19
Q

Which AWS database service synchronously replicates data across 3 Availability Zones in a region?

A

Dynamo DB

20
Q

Which service is a fully managed, highly available, in-memory cache for DynamoDB that delivers up to 10X performance improvement?

A

DynamoDB Accelerator (DAX)

21
Q

How does DynamoDB scale?

A

Horizontally

22
Q

How does DynamoDB backup?

A

Point-in-time recovery down to the second in the last 35-days
- on-demand backup and restore

23
Q

Which AWS service acts as a data warehouse for large volumes of aggregated data to perform analytics?

A

Amazon RedShift

24
Q

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?

A

Amazon RedShift

25
Q

Which Amazon database service is used for relational databases that is used for Online Analytics Processing (OLAP) use cases, always keep three copies of your data, and provides continuous/incremental backup?

A

Amazon RedShift

26
Q

Which AWS database service offers in-memory caching that can be used to improve latency and throughput for many read-heavy application workloads or compute-intensive workloads?

A

Amazon ElastiCache

27
Q

Which Amazon database service is good for fast temporary storage of small amounts of data?

A

Amazon ElastiCache

28
Q

Which AWS database service can be used for a web session store, database caching, leaderboards, or streaming data dashboards?

A

Amazon ElastiCache

29
Q

What are the two types of ElastiCache engines?

A
  1. Memcached

2. Redis