Databases & Analytics Flashcards

1
Q

Aurora

A

Relational Databases

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

In-memory Database

A

ElastiCache

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

ElastiCache

A

In-memory Database

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

Relational Database

A

Aurora

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

Key/Value Database

A

DynamoDB

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

Dynamo DB

A

Key/Value Database

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

DynamoDB Accelerator

A

Amazon DynamoDB Accelerator (DAX) is a fully managed, highly available, in-memory cache for Amazon DynamoDB that delivers up to a 10 times performance improvement-from milliseconds to microseconds-even at millions of requests per second.

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

Warehouse

A

Redshift

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

Redshift

A

Warehouse

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

Hadoop Cluster

A

EMR service

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

Athena

A

Query data on Amazon S3 (severless & SQL)

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

Quicksight

A

Dashboards or visuals that can be interactive on your data (serverless). Also used for business intelligence.

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

DocumentDB

A

NoSQL database which stores JSON objects. Called the “Aurora for MongoDB”

Amazon DocumentDB (with MongoDB compatibility) is a database service that is purpose-built for JSON data management at scale, fully managed and integrated with AWS, and enterprise-ready with high durability.
Amazon DocumentDB is designed to give you the scalability and durability you need when operating mission-critical MongoDB workloads. Storage scales automatically up to 64TiB without any impact to your application. It supports millions of requests per second with up to 15 low latency read replicas in minutes, without any application downtime, regardless of the size of your data.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Amazon QLDB

A

Summary: Centralized database used for financial transactions. Choose when you read immutable, and cryptographically verifiable transaction log.

Amazon Quantum Ledger Database (QLDB) is a fully managed ledger database that provides a transparent, immutable (unchanging over time or unable to be changed), and cryptographically verifiable transaction log.

Use Cases

1) Store financial transactions: Create a complete and accurate record of all financial transactions, such as credit and debit transactions.
2) Reconcile supply chain systems: Record the history of each transaction and provide details of every batch manufactured, shipped, stored, and sold from facility to store.
3) Maintain claims history: Track a claim over its lifetime, and cryptographically verify data integrity to make the application resilient against data entry errors and manipulation.
4) Centralize digital records: Implement a system-of-record application to create a complete, centralized record of employee details such as payroll, bonus, and benefits.

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

Amazon Managed Blockchain

A

Decentralized database. Manage Hyperledger Fabric & Ethereum blockchain on AWS.

Amazon Managed Blockchain is a fully managed service that makes it easy to join public networks or create and manage scalable private networks using the popular open-source frameworks Hyperledger Fabric and Ethereum.

Blockchain makes it possible to build applications where multiple parties can execute transactions without the need for a trusted, central authority. Today, building a scalable blockchain network with existing technologies is complex to set up and hard to manage. To create a blockchain network, each network member needs to manually provision hardware, install software, create, and manage certificates for access control, and configure networking components. Once the blockchain network is running, you need to continuously monitor the infrastructure and adapt to changes, such as an increase in transaction requests, or new members joining or leaving the network.

Amazon Managed Blockchain is a fully managed service that allows you to join public networks or set up and manage scalable private networks with just a few clicks. Amazon Managed Blockchain eliminates the overhead required to create the network or join a public network, and automatically scales to meet the demands of thousands of applications running millions of transactions. Once your network is up and running, Managed Blockchain makes it easy to manage and maintain your blockchain network. It manages your certificates and lets you easily invite new members to join the network.

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

Glue

A

AWS Glue is a serverless data-preparation service for extract, transform, and load (ETL) operations.

It makes it easy for data engineers, data analysts, data scientists, and ETL developers to extract, clean, enrich, normalize, and load data. AWS Glue reduces the time it takes to start analyzing your data from months to minutes. It provides you with both visual and code-based interfaces to make data preparation easy. Data engineers and ETL developers can use AWS Glue Studio to create, run, and monitor ETL jobs with a few clicks. Data analysts and data scientists can use AWS Glue DataBrew to visually clean up and normalize data without writing code.

17
Q

DMS

A

Database Migration Service. Use to move data between databases.

18
Q

Neptune

A

Amazon Neptune is a fast, reliable, fully-managed graph database service that makes it easy to build and run applications that work with highly connected datasets. It can be used for knowledge graphs, fraud detection, recommendations engines, social networking, etc.

19
Q

Amazon Relational Database Service

A

Amazon Relational Database Service is a SQL managed service that makes it easy to set up, operate, and scale a relational database in the cloud. It is suited for OLTP workloads.

On-Line-Transaction-Processing (OLTP) Workloads bestehen generell aus einer großen Anzahl schneller, kleiner Transaktionen, die Reaktionszeiten in Bruchteilen von Sekunden erfordern.