Brainscape's Knowledge GenomeTM

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


See full index

AWS CCP > 7. Databases > Flashcards

7. Databases Flashcards

1
Q

What is the primary purpose of using databases instead of disk storage?

A

To structure data, build indexes, and define relationships between datasets.

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

True or False: A relational database is like a collection of Excel spreadsheets with links between them.

A

True

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

What language is commonly used to perform queries on relational databases?

A

SQL

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

Fill in the blank: NoSQL databases are known for their _____ and _____ capabilities, allowing them to handle distributed clusters and specific data models.

A

flexibility, scalability

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

What is JSON commonly used for in NoSQL databases?

A

To represent data that can be nested and evolve over time.

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

Which Amazon service provides managed relational databases like PostgreSQL and MySQL?

A

Amazon RDS

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

How does Amazon RDS improve disaster recovery for relational databases?

A

It offers Multi-AZ setups to provide failover in case of an AZ outage.

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

Name one advantage of using Amazon Aurora over standard MySQL or PostgreSQL on RDS.

A

Aurora is optimized for the cloud and offers up to 5x performance improvement over MySQL on RDS.

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

What is Amazon Aurora Serverless used for?

A

Automated database scaling based on actual usage, ideal for unpredictable workloads.

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

True or False: You can SSH into RDS instances.

A

False

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

Fill in the blank: Amazon ElastiCache provides a managed service for in-memory databases like _____ and _____.

A

Redis, Memcached

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

What is the purpose of Amazon DynamoDB?

A

To provide a fully managed, serverless NoSQL database optimized for high availability and scalability.

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

Which AWS service enhances DynamoDB performance with in-memory caching?

A

DynamoDB Accelerator (DAX)

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

What type of database is Amazon Redshift?

A

An OLAP database designed for analytics and data warehousing.

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

How does Amazon Redshift Serverless benefit users?

A

By automatically provisioning and scaling data warehouse capacity, users only pay for what they use.

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

What is Amazon EMR used for?

A

Creating and managing Hadoop clusters for big data processing.

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

Fill in the blank: Amazon Athena is a _____ service for querying data stored in Amazon S3 using _____ language.

A

serverless, SQL

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

What are the primary use cases for Amazon QuickSight?

A

Business analytics, creating dashboards, and visualizing data.

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

True or False: Amazon DocumentDB is a managed MongoDB-compatible database.

A

True

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

Which AWS database service is designed for graph data, such as social networks?

A

Amazon Neptune

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

Fill in the blank: Amazon Timestream is a serverless database designed for _____ data.

A

time-series

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

How is data in Amazon QLDB different from traditional databases?

A

It is immutable, cryptographically verifiable, and ideal for tracking data changes over time.

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

True or False: Amazon Managed Blockchain supports Hyperledger Fabric and Ethereum.

A

True

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

What does AWS Glue provide for data management?

A

A managed ETL service for data preparation and transformation.

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

Which AWS service helps in migrating databases to AWS with minimal downtime?

A

AWS Database Migration Service (DMS)

26
Q

Fill in the blank: Amazon Neptune is a _____ database that supports _____ relationships between data entities.

A

graph, complex

27
Q

What is the main benefit of using Amazon Timestream for IoT data?

A

It allows fast and scalable analysis of time-series data.

28
Q

How does Amazon QLDB ensure data integrity?

A

By making all entries immutable and cryptographically verifiable.

29
Q

True or False: Amazon Redshift is designed for online transactional processing (OLTP).

A

False

30
Q

What are the two types of migrations supported by AWS Database Migration Service?

A

Homogeneous (e.g., Oracle to Oracle) and Heterogeneous (e.g., SQL Server to Aurora).

31
Q

Name one advantage of using Amazon Managed Blockchain for applications.

A

It removes the need for a central authority by allowing decentralized transactions.

32
Q

Fill in the blank: Amazon _____ enables SQL querying of data stored on Amazon S3 in a serverless manner.

A

Athena

33
Q

Describe a key advantage of Amazon EMR for big data processing.

A

It simplifies cluster setup, provisioning, and auto-scaling, reducing management overhead.

34
Q

True or False: Amazon QuickSight uses machine learning to enhance data visualization.

A

True

35
Q

What type of data structure does DynamoDB use?

A

Key-value

36
Q

How does DynamoDB achieve high availability?

A

By replicating data across three Availability Zones.

37
Q

Fill in the blank: Amazon DocumentDB is compatible with _____ for managing JSON data.

A

MongoDB

38
Q

What database solution on AWS is recommended for storing immutable financial transaction records?

A

Amazon QLDB

39
Q

Describe a key benefit of Amazon RDS Multi-AZ deployment.

A

Provides high availability by automatically failing over to a standby instance in a different AZ.

40
Q

What is Amazon Redshift optimized for?

A

Online analytical processing (OLAP) for data warehousing and large-scale analytics.

41
Q

Which service is a good choice for caching to reduce database load?

A

Amazon ElastiCache

42
Q

What AWS database is suitable for applications with complex relationships, such as social networking?

A

Amazon Neptune

43
Q

Fill in the blank: Amazon _____ is a time-series database that scales based on demand and is cost-effective for IoT data.

A

Timestream

44
Q

Which AWS database can perform cryptographic verification of all transactions?

A

Amazon QLDB

45
Q

True or False: AWS Glue only supports data transformation and not cataloging.

A

False

46
Q

What is a major benefit of using Amazon Managed Blockchain over traditional centralized databases?

A

It allows multiple parties to participate in transactions without a central authority.

47
Q

What type of data is ideal for storage in DynamoDB?

A

Highly available, scalable, key-value data with single-digit millisecond latency.

48
Q

Which AWS service is specifically for querying large datasets on Amazon S3?

A

Amazon Athena

49
Q

How does Amazon ElastiCache help improve application performance?

A

By providing in-memory caching to reduce load on the primary database.

50
Q

What is the difference between Amazon RDS and DynamoDB?

A

RDS is a relational database service, while DynamoDB is a fully managed NoSQL service.

51
Q

True or False: Amazon Redshift supports real-time analytics.

A

False; Redshift is designed for batch loading and processing.

52
Q

Which database is optimized for graph-based data and relationships?

A

Amazon Neptune

53
Q

Fill in the blank: Amazon QLDB provides a managed, _____ database for applications that require a history of changes over time.

A

ledger

54
Q

Describe a use case for Amazon Timestream.

A

Ideal for IoT applications that require real-time analysis of time-series data.

55
Q

True or False: Amazon QuickSight can be used to create interactive dashboards directly on data stored in RDS.

A

True

56
Q

What database model does DocumentDB follow?

A

NoSQL document model, similar to MongoDB.

57
Q

What AWS service should you choose for high-performance key-value data?

A

Amazon DynamoDB

58
Q

Name one advantage of using Amazon Managed Blockchain for creating a private network.

A

Scalable and compatible with Hyperledger Fabric.

59
Q

True or False: Amazon EMR can only process structured data.

A

False; it can process large datasets, both structured and unstructured.

60
Q

Describe one scenario where Amazon Athena is particularly useful.

A

Analyzing and querying log data stored in Amazon S3.

61
Q

What feature makes AWS Glue valuable for data scientists?

A

Automated ETL processes and the Data Catalog for organized datasets.

62
Q

Fill in the blank: Amazon _____ provides a managed, serverless business intelligence service for creating data dashboards.

A

QuickSight

AWS CCP (19 decks)

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