AWS: Databases and Analytics

AWS: Databases and Analytics

September 26, 2020

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

ElastiCache (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.)

Which AWS database is a data warehouse?

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

Which AWS database is fully serverless and has SQL capabilities?

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

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

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

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

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

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?

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 can you create Hadoop clusters to analyze and process a vast amount of data?

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

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

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

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

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)

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?

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

One Comment

  1. iHerb Code October 19, 2022 at 9:14 pm - Reply

    Yes, really. So happens.

Leave A Comment