databases and Analytics

Question 1

Relational database

Answer 1

SQL

Just like an excel spreadsheet like between them!, have relationship

Question 2

NOSQl Databases

Answer 2

non relational database

Question 3

Amazon EMR: Elastic Map Reduce

Answer 3

you create Hadoop clusters to analyze and process a vast amount of data

How can you create Hadoop clusters to analyse and process a vast amount of data?

EMR is a web service that enables businesses, researchers, data analysts, and developers to easily and cost-effectively process vast amounts of data.

Question 4

AWS Glue

Answer 4

a fully managed ETL (extract, transform, and load) service. serverless to prepare data so it can be loaded for analytics.

You would like to use a serverless service to prepare data so it can be loaded for analytics. Which service would you use?

Question 5

Glue data catalog:

Answer 5

(a central repository to store structural and operational metadata for data assets in AWS Glue)

What is the name of a central repository to store structural and operational metadata for data assets in AWS Glue?

Question 6

DMS:database migration

Answer 6

migration of a database : to migrate databases to AWS while still being able to use the database during the migration.

You would like to migrate databases to AWS while still being able to use the database during the migration. What service allows you to do this?

Question 7

Amazon Managed Blockchain

Answer 7

easily create and manage scalable blockchain network . Ethereum, and Hyperledger fabric. Do Not need for a trusted, central authority it is decentralized

Question 8

Amazon QLDB- Amazon Quantum Ledger Database (Amazon QLDB

Answer 8

AWS service is an immutable ledger database

recording financial transactions: Review history of all the changes made to your application data over time

Question 9

Amazon Neptune

Answer 9

Graph database: create complex graphs for fraud detection

Question 10

Amazon DocumentDB

Answer 10

Fully-managed Aurora MongoDB-compatible database service. (Json-nosql database

Question 11

Amazon Athena

Answer 11

always serverless and has SQL capabilities Query Data in S3

Which AWS database is fully serverless and has SQL capabilities?

Question 12

Redshift

Answer 12

for OLAP : online analytical processing analytics and data warehouse

Which AWS database is a data warehouse?

Question 13

DynamoDB

Answer 13

You would like to set up a NoSQL database that can scale with no downtime and can handle millions of requests per second.

Single-digit millisecond latency – low latency retrieval

You would like to set up a NoSQL database that can scale with no downtime and can handle millions of requests per second. Which AWS database is best suited for this work?

Question 14

Key/value database

Answer 14

DynamoDB (serverless).

DAX (cache for DynamoDB

Question 15

Elasticache

Answer 15

In memory database
Which in-memory AWS database can you use to reduce the load off databases and has high performance, low latency)
- Elastcheche can be used for other database

Which in-memory AWS database can you use to reduce the load off databases and has high performance, low latency?

Question 16

RDS Deployment: read replicas

Answer 16

→ scale the read workload of your DB
→ can create up to read replicas
→ data only written on the main DB

Question 17

RDS Deployment: Multi-AZ

Answer 17

→ Fall Over in case of AZ outage (high availability)
→ Data is only read/ written to the main database
→ Can only have I other AZ as failover

Question 18

RDS Deployment: Multi-region

Answer 18

• Fall Over in case of AZ outage (high availability)
• Data is only read/ written to the main database
• Can only have I other AZ as failover

Question 19

Amazon Aurora

Answer 19

Which relational database is a proprietary technology from AWS and is cloud-optimized?

Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud, that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases.

Question 20

Databased & Shared responsibility on AWS

Answer 20

Aws offers use to manage different database:

• quick provisioning high availability, vertical and horizontal scaling
• Monitoring, alerting
• operating system patching is handled by AWS
• automated backup / Restore, operations , upgrades
• many database could run on EC2

Question 21

AWS RDS; Relational Database Service

Answer 21

following databases is a managed service with SQL capability suited for Online Transaction Processing:

Which of the following databases is a managed service with SQL capability suited for Online Transaction Processing (OLTP)?

Question 22

DynamoDB accelerator

Answer 22

DAX: Which exclusive DynamoDB feature is an in-memory cache that can improve your performance up to 10x?

• Fully managed in memory cache for DYnamBD
• DAX only used for and is interheated with DynamoDB

Question 23

Amazon Quicksight

Answer 23

(WS serverless service can use machine learning-powered business intelligence to create interactive dashboards such as business analytics)

allows everyone in your organization to understand your data by asking questions in natural language, exploring through interactive dashboards, or automatically looking for patterns and outliers powered by machine learning.

Use case:

• Business analytics
• Building visualization
• Perform ad-hoc analysis
• Get business insight using data