Databases & Analytics Quiz Flashcards

1
Q

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

1 - RedShift
2 - ElastiCache
3 - RDS
4 - DynamoDB

A

ElastiCache = in-memory

Amazon ElastiCache is a web service that makes it easy to deploy and run Memcached or Redis protocol-compliant server nodes in the cloud. ElastiCache caches are in-memory databases with high performance, low latency. They help reduce load off databases for read intensive workloads.

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

Which AWS database is a data warehouse?

1 - RedShift
2 - ElastiCache
3 - RDS
4 - DynamoDB

A

Redshift = Warehouse

Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud.

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

Which AWS database is fully serverless and has SQL capabilities?

1 - RDS
2 - Aurora
3 - Athena
4 - DynamoDB

A

Athena = serverless & SQL

Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run.

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

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

1 - Athena
2 - Glue
3 - RDS
4 - ElastiCache

A

Glue = serverless, good for ETL Data

AWS Glue is a fully managed extract, transform, and load (ETL) service that makes it easy for customers to prepare and load their data for analytics.

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

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

1 - Athena
2 - DynamoDB
3 - Oracle
4 - Aurora

A

Amazon Aurora

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. It is a proprietary technology from AWS.

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

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?

1 - ElasticMapReduce (EMR)
2 - Database Migration Service (DMS)
3 - AWS Storage Gateway
4 - Snowball

A

Database Migration Service (DMS)

AWS Database Migration Service helps you migrate databases to AWS quickly and securely. The source database remains fully operational during the migration, minimizing downtime to applications that rely on the database.

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

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

1 - ElasticMapReduce (EMR)
2 - Athena
3 - EC2 Instances
4 - Redshift

A

ElasticMapReduce (EMR) = Hadoop & Big Data

Amazon EMR is a web service that enables businesses, researchers, data analysts, and developers to easily and cost-effectively process vast amounts of data. EMR helps creating Hadoop clusters (Big Data) to analyze and process vast amount of data

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

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

1 - Glue Data Table
2 - Glue Data Dictionary
3 - Glue Data Catalog

A

Glue Data Catalog

The AWS Glue Data Catalog is a central repository to store structural and operational metadata for all your data assets. For a given data set, you can store its table definition, physical location, add business relevant attributes, as well as track how this data has changed over time.

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

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

1 - RedShift
2 - MySQL on EC2
3 - RDS
4 - DynamoDB

A

RDS

Amazon Relational Database Service (Amazon RDS) 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

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

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?

1 - RedShift
2 - Athena
3 - RDS
4 - DynamoDB

A

DynamoDB = NoSQL

DynamoDB is a fast and flexible non-relational database service for any scale. It can scale with no downtime, it can process millions of requests per second, and is fast and consistent in performance.

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

Amazon Relational Database Service (RDS) is an example of what type of database?

  1. Online Transaction Processing (OLTP)
  2. Online Analytics Processing (OLAP)
  3. No SQL
  4. data warehouse
A

1.Online Transaction Processing (OLTP)

Amazon RDS is an example of a relational database used for online transaction processing (OLTP) workloads. This means its typically used for production databases that process transactions

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

Which AWS database service offers seamless horizontal scaling?

  1. Amazon RDS
  2. Redshift
  3. DynamoDB
  4. Database on Amazon EC2
A

Amazon DynamoDB offers seamless “push-button” horizontal scaling

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

How can fault tolerance be added to an Amazon RDS database?

  1. Using read replicas
  2. Using Multi-AZ
  3. Using Global replicas
  4. Using EBS Snapshots
A

Multi-AZ creates a standby copy of the master DB in a separate availability zone

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

How can an organization enable microsecond latency for a DynamoDB database?

  1. Use Elasticache
  2. dynamoDB AutoScaling
  3. Use read replicas
  4. Use DynamoDB Accelerator (DAX)
A

DynamoDB Accelerator (DAX) is an in-memory cache that increases performance of DynamoDB databases

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

Which AWS database service is a relational, data warehouse?

  1. Redshift
  2. Aurora
  3. DynamoDB
  4. Elasticache
A

RedShift is a relational, SQL database that is well suited for data warehouse use

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

Why might an organization decide to move an on-premises database to Amazon RDS?

  1. To reduce Operational Overhead
  2. To increase flexibility
  3. To eliminate the need to patch management
  4. To benefit from seamless scalability
A
  1. To reduce Operational Overhead

You can reduce operational overhead by moving to AWS managed services. With RDS this means you no longer need to manage the operating system

NOT:
4.To benefit from seamless scalability

You do not get seamless scalability with RDS. To scale you need to change the instance type which incurs some downtime

17
Q

How do you increase the capacity of an Amazon RDS database?

  1. Scaling horizontally, by adding instances
  2. Scaling horizontally, by adding RCUs/WCU
  3. Scaling vertically, by changing instance type
  4. Scaling vertically, by adding CPUs
A

3.Scaling vertically, by changing instance type

You can scale Amazon RDS by changing to a larger instance type. This is an example of vertical scaling

18
Q

Amazon DynamoDB is good for which use case?

  1. Structured data, rigid schema
  2. Unstructured data, flexible schema
A

DynamoDB is a No-SQL database which has a flexible schema and is good for unstructured data