Database and Analytics

Question 1

These databases suits for Relational Databases that have OLTP (Online Transactional Processing)

Answer 1

RDS and Aurora (SQL)

Question 2

This database suits for in-memory database (cache)

Answer 2

ElasticCache

Question 3

Key/value Database

Answer 3

DynamoDB (serverless)

Question 4

This database suits for warehouse and data analytics

Answer 4

Redshift (SQL)

Question 5

This database is used for big data, Hadoop Cluster

Answer 5

EMR (Elastic MapReduce)

Question 6

The Database used for querying data from Amazon S3

Answer 6

Athena (serverless and SQL)

Question 7

Managed ETL (Extract Transform Load) and Data Catalog service

Answer 7

Glue

The Data Catalog service provides metadata to Athena, Redshift, and EMR

Question 8

Service used for database migration

Answer 8

DMS (Database Migration Service)

Question 9

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

a) Redshift
b) ElasticCache
c) RDS
d) DynamoDB

Answer 9

b) ElasticCache

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.

Question 10

Which AWS database is a data warehouse?

a) DynamoDB
b) ElasticCache
c) Redshift
d) RDS

Answer 10

c) Redshift

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

Question 11

Which AWS database is fully serverless and has SQL capabilities?

a) RDS
b) Aurora
c) DynamoDB
d) Athena

Answer 11

d) Athena

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.

Question 12

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

a) Athena
b) RDS
c) Glue
d) ElasticCache

Answer 12

c) Glue

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.

Question 13

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

a) DynamoDB
b) Oracle
c) Athena
d) Aurora

Answer 13

d) 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.

Question 14

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?

a) Elastic MapReduce (EMR)
b) Database Migration Service (DMS)
c) AWS Storage Gateway
d) Snowball

Answer 14

b) 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.

Question 15

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

a) EMR
b) Athena
c) EC2 Instances
d) Redshift

Answer 15

a) EMR

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 to create Hadoop clusters (Big Data) to analyze and process a vast amount of data

Question 16

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

a) Glue Data Table
b) Glue Data Dictionary
c) Glue Data Catalog

Answer 16

c) 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.

Question 17

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

a) DynamoDB
b) Redshift
c) RDS
d) MySQL on EC2

Answer 17

c) 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

Question 18

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?

a) DynamoDB
b) RDS
c) Redshift
d) Athena

Answer 18

a) DynamoDB

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.