Database & Analytics Flashcards
What type of Database is DynamoDB and what does it support
DynamoDB is a NoSQL database that supports both key-value and document data models. This enables DynamoDB to have a flexible schema. Dynamo Db supports high availability by default
What is a read replica configuration used for
Read replica improves Database Scalability
What is Amazon Redshift used for
Amazon Redshift is a fast fully-managed petabyte-scale cloud-based data warehouse product designed for large scale data set storage and analysis. it simple and cost-effective to analyze all your data across your data warehouse and data lake.
What does the Aws Glue service provide
Aws glue primary points - used to prepare and load data for analytics and meant to be used for batch etl data processing:
AWS 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. AWS Glue job is meant to be used for batch ETL data processing.
What is EMR service and how does it deliver and process data
Amazon EMR - Amazon EMR provides a managed Hadoop framework that makes it easy, fast, and cost-effective to process vast amounts of data across dynamically scalable Amazon EC2 instances.
What type of service is Amazon Athena and what does it provide
Amazon 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
What does the database migration service provide
AWS Database Migration Service helps you migrate databases to AWS quickly and securely. The AWS Database Migration Service can migrate your data to and from the most widely used commercial and open-source databases.
What type of Database is Amazon Neptune
Amazon Neptune is a fully-managed graph database service and it’s also considered as a type of NoSQL database. Its purpose purpose is to make it easy to build and run applications that work with highly connected datasets.
What is amazon DocumentDB
Amazon DocumentDB (with MongoDB compatibility) and MongoDB are popular document databases that provide powerful and intuitive APIs for flexible and iterative development. Amazon DocumentDB is a non-relational database service designed from the ground-up to give you the performance, scalability, and availability you need when operating mission-critical MongoDB workloads at scale.
How does DynamoDB Accelerator work
DAX is a DynamoDB-compatible caching service that enables you to benefit from fast in-memory performance for demanding applications. DAX addresses three core scenarios:
As an in-memory cache, DAX reduces the response times of eventually consistent read workloads by an order of magnitude from single-digit milliseconds to microseconds.
DAX reduces operational and application complexity by providing a managed service that is API-compatible with DynamoDB. Therefore, it requires only minimal functional changes to use with an existing application.
For read-heavy or bursty workloads, DAX provides increased throughput and potential operational cost savings by reducing the need to overprovision read capacity units. This is especially beneficial for applications that require repeated reads for individual keys.
What is Amazon RDS
Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. Amazon RDS is available on several database instance types - optimized for memory, performance, or I/O - and provides you with six familiar database engines to choose from, including Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle Database, and SQL Serve
What is 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. You cannot use Aurora for SQL analysis on S3 based data.
