Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

AWS Cloud Practitioner (CLF-C02) > Databases and Analytics > Flashcards

Databases and Analytics Flashcards

1
Q

Relational Database

A

Relations between tables in a database

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

Language for relational databases

A

SQL

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

NoSQL DB Benefits

A

Flexible
Scalable
High-performance
Highly functional

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

RDS acronym

A

Relational Database Service

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

What are key-value, Document, graph, in-memory, and search databases examples of?

A

NoSQL Databases

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

NoSQL DB’s purpose built for…

A

Specific data models with flexible schemas for modern apps

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

NoSQL data type

A

JSON

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

What database type can be nested?

A

NoSQL (JSON)

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

AWS managed DB benefits

A

Provisioning, HA, Scaling, Backup, restore, OS patching, monitoring, alerting

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

AWS service for Oracle

A

RDS

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

RDS

A

Managed DB service using SQL

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

AWS service for Postgres

A

RDS

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

AWS service for MariaDB

A

RDS

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

AWS service for Aurora

A

RDS

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

Can you SSH into RDS instances

A

no

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

DB types supported by Aurora (2)

A

PostgreSQL
MySQL

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

Aurora DB max size

A

128TB

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

How much more does Aurora cost over RDS (percent)

A

20%

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

Which DB type is more cloud native (RDS or Aurora)?

A

Aurora

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

RDS Read Replica

A

Scale read workload

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

Max RDS read replicas

A

15

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

RDS Multi-AZ

A

Failover in case of AZ outage

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

How many failover AZ’s in RDS multi-AZ?

A

1

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

RDS Multi-Region

A

Read replicas in different regions

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

In-Memory Database service

A

ElastiCache

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

AWS service for Redis

A

ElastiCache

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

AWS service for Memcached

A

Elasticache

20
Q

Benefit of ElastiCache

A

Relieve load from RDS

21
Q

DynamoDB benefits

A

Fully managed HA with replication in 3 AZ

22
Q

Which DB type is “serverless?”

A

DynamoDB

23
Q

Low latency DB type

A

Dynamo DB

24
Q

Dynamo DB Relational or NoSQL?

A

NoSQL

25
Q

DynamoDB Accelorator (DAX)

A

In-memory cache for DynamoDB

26
Q

DynamoDB Global Tables

A

Make DynamoDB accessible with low latency in multiple regions

27
Q

Which DB type has Active-Active Replication

A

DynamoDB

28
Q

Which table allows writing in Dynamo DB?

A

All of them

29
Q

Redshift OLTP or OLAP

A

OLAP

30
Q

DB with hourly load interval

A

Redshift

31
Q

Database with columnar storage

A

Redshift

32
Q

Database that has a data warehouse to do computation/analytics/visualization on datasets?

A

Redshift

33
Q

BI Tools for Redshift (2)

A

Quicksight
Tableau

34
Q

Amazon EMR acronym

A

Elastic MapReduce

35
Q

EMU helps provision…

A

Hadoop clusters

36
Q

DB for machine learning, web indexing, big data

A

EMR

37
Q

Serverless query service for S3 analytics

A

Amazon Athena

38
Q

Amazon Athena (SQL or NoSQL)

A

SQL

39
Q

Database for BI for VPN flow logs, ELB logs, Cloudtrail Trails, etc…

A

Amazon Athena

40
Q

Amazon Quicksight purpose

A

BI
Dashboards
Visualizations

41
Q

DocumentDB (SQL or NoSQL)

A

NoSQL

42
Q

DocumentDB is AWS version of…

A

MongoDB

43
Q

DocumentDB max size

A

64TB

44
Q

DocumentDB is similar to what other Amazon service?

A

Aurora

45
Q

DocumentDB number of AZ’s

A

3

46
Q

Neptune is

A

Graph DB

47
Q

Neptune Graph DB use cases…

A

Social networking
Fraud detection
Recommendation engines

48
Q

Amazon QLDB purpose

A

Review history of all changes to app data

49
Q

Which DB type is similar to blockchain

A

QLDB

50
Q

Immutable DB service

A

QLDB

51
Q

QLDB central or decentralized

A

Central DB

52
Q

Managed Blockchain central or decentralized

A

Decentralized

53
Q

DB product for financial transactions

A

QLDB

54
Q

Hyperledger Fabric or Ethereum Product…

A

Amazon Managed Blockchain

55
Q

AWS Glue

A

Managed ETL service

56
Q

ETL used for…

A

Prepare and transform data for analytics

57
Q

DMS Acronym

A

Database Migration Service

58
Q

Can DMS support migrating from one database type to another?

A

Yes (ex. Microsoft SQL to Oracle)

59
Q

Key/Value Database product…

A

DynamoDB & DAX

AWS Cloud Practitioner (CLF-C02) (21 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions