AWS Database Definitions Flashcards

Become very familiar with AWS database terms

1
Q

Amazon RDS (Relational Database Service)

A

_____________ is a fully managed relational database service offered by AWS. It supports several popular database engines, including MySQL, PostgreSQL, MariaDB, Oracle, and SQL Server. With _____________, users can easily deploy, operate, and scale relational databases in the cloud without worrying about infrastructure management tasks such as hardware provisioning, software installation, patching, backups, and monitoring.

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

Amazon DynamoDB

A

_____________ is a fully managed NoSQL database service provided by AWS. It offers seamless scalability and low-latency performance for applications requiring fast and predictable data access. _____________ is designed to handle large-scale, high-traffic workloads with automatic scaling, built-in fault tolerance, and single-digit millisecond response times. It supports both document and key-value data models and provides features like encryption at rest, in-transit, and fine-grained access control.

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

Amazon Redshift

A

_____________ is a fully managed data warehousing service offered by AWS. It is designed for analyzing large datasets using SQL queries and business intelligence tools. _____________ is built for high-performance, scalable data analytics with petabyte-scale data storage, columnar storage, parallel processing, and automatic optimization features. It allows users to run complex analytical queries across structured and semi-structured data stored in Amazon S3, Amazon DynamoDB, and other data sources.

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

Amazon DocumentDB (with MongoDB compatibility)

A

_____________ is a fully managed document database service compatible with MongoDB. It offers a scalable, highly available, and performant solution for storing, querying, and indexing JSON-like documents. _____________ is designed to provide the flexibility and ease of use of MongoDB along with the reliability, scalability, and security of AWS infrastructure. It supports features like ACID transactions, encryption at rest, and point-in-time recovery.

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

Amazon Neptune

A

_____________ is a fully managed graph database service provided by AWS. It is optimized for storing and querying highly connected data with complex relationships, such as social networks, recommendation engines, and fraud detection systems. _____________ supports both property graph and RDF graph models and provides features like multi-tenancy, high availability, and encryption at rest. It is compatible with popular graph query languages like Gremlin and SPARQL.

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

Amazon ElastiCache

A

_____________ is a fully managed in-memory caching service provided by AWS. It supports popular open-source in-memory data stores like Redis and Memcached, offering high-performance, low-latency data access for applications requiring fast read and write operations. _____________ helps improve application performance and scalability by offloading database and application servers, reducing database load, and improving response times.

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

Amazon Keyspaces (for Apache Cassandra)

A

_____________ is a fully managed Apache Cassandra-compatible database service provided by AWS. It offers the scalability, availability, and performance of Apache Cassandra with the ease of use and reliability of AWS infrastructure. _____________ supports automatic scaling, built-in encryption, and point-in-time recovery, making it suitable for applications requiring high throughput, low latency, and continuous availability.

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

Amazon Timestream

A

_____________ is a fully managed time-series database service provided by AWS. It is designed for storing and analyzing time-series data at scale, such as IoT telemetry, application logs, and operational metrics. _____________ offers features like automatic data retention, tiered storage, and built-in analytics functions for analyzing time-series data efficiently. It supports SQL-like queries and integrates seamlessly with other AWS services for data ingestion and visualization.

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

Amazon Quantum Ledger Database (QLDB)

A

_____________ is a fully managed ledger database service provided by AWS. It provides a transparent, immutable, and cryptographically verifiable transaction log for tracking changes to application data over time. _____________ is designed to provide a centralized, trusted source of truth for applications requiring an auditable record of all transactions. It supports SQL-like querying and integrates with AWS services like AWS Key Management Service (KMS) for data encryption.

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

Amazon Managed Apache Cassandra Service

A

_____________ is a fully managed Apache Cassandra-compatible database service provided by AWS. It offers the scalability, availability, and performance of Apache Cassandra with the ease of use and reliability of AWS infrastructure. _____________ handles routine tasks like hardware provisioning, software installation, patching, backups, and monitoring, allowing developers to focus on building applications.

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

Amazon Aurora Serverless

A

_____________ is an on-demand, auto-scaling version of Amazon Aurora, a high-performance relational database service provided by AWS. _____________ automatically scales compute capacity up or down based on actual application usage, allowing users to pay only for the resources consumed. It is well-suited for unpredictable or intermittent workloads, reducing costs and management overhead.

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

Amazon Aurora Multi-Master

A

_____________ is a feature of Amazon Aurora that allows users to create multiple read/write master instances in a cluster, enabling high availability and scalability for write-intensive workloads. _____________ provides synchronous replication and automatic failover capabilities, ensuring continuous availability and data consistency across multiple database instances.

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

Amazon Aurora Global Database

A

_____________ is a feature of Amazon Aurora that enables global replication and deployment of Aurora database clusters across multiple AWS regions. It allows users to create read replicas in different regions for low-latency access to data and disaster recovery purposes. _____________ provides fast, synchronous replication and automatic failover, ensuring data consistency and high availability across regions.

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

Amazon Aurora Parallel Query

A

_____________ is a feature of Amazon Aurora that accelerates analytical queries by pushing processing down to the Aurora storage layer. It enables faster query performance and better utilization of resources by parallelizing query execution across multiple storage nodes. _____________ is particularly beneficial for analytics and reporting workloads with large datasets, reducing query response times and improving overall system efficiency.

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

Apache Cassandra

A

_____________ is an open-source, distributed NoSQL database management system designed to handle large volumes of structured data across multiple commodity servers, providing high availability, fault tolerance, and linear scalability.

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

_____________ is a fully managed relational database service offered by AWS. It supports several popular database engines, including MySQL, PostgreSQL, MariaDB, Oracle, and SQL Server. With _____________, users can easily deploy, operate, and scale relational databases in the cloud without worrying about infrastructure management tasks such as hardware provisioning, software installation, patching, backups, and monitoring.

A

Amazon RDS (Relational Database Service)

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

_____________ is a fully managed NoSQL database service provided by AWS. It offers seamless scalability and low-latency performance for applications requiring fast and predictable data access. _____________ is designed to handle large-scale, high-traffic workloads with automatic scaling, built-in fault tolerance, and single-digit millisecond response times. It supports both document and key-value data models and provides features like encryption at rest, in-transit, and fine-grained access control.

A

Amazon DynamoDB

18
Q

_____________ is a fully managed data warehousing service offered by AWS. It is designed for analyzing large datasets using SQL queries and business intelligence tools. _____________ is built for high-performance, scalable data analytics with petabyte-scale data storage, columnar storage, parallel processing, and automatic optimization features. It allows users to run complex analytical queries across structured and semi-structured data stored in Amazon S3, Amazon DynamoDB, and other data sources.

A

Amazon Redshift

19
Q

_____________ is a fully managed document database service compatible with MongoDB. It offers a scalable, highly available, and performant solution for storing, querying, and indexing JSON-like documents. _____________ is designed to provide the flexibility and ease of use of MongoDB along with the reliability, scalability, and security of AWS infrastructure. It supports features like ACID transactions, encryption at rest, and point-in-time recovery.

A

Amazon DocumentDB (with MongoDB compatibility)

20
Q

_____________ is a fully managed graph database service provided by AWS. It is optimized for storing and querying highly connected data with complex relationships, such as social networks, recommendation engines, and fraud detection systems. _____________ supports both property graph and RDF graph models and provides features like multi-tenancy, high availability, and encryption at rest. It is compatible with popular graph query languages like Gremlin and SPARQL.

A

Amazon Neptune

21
Q

_____________ is a fully managed in-memory caching service provided by AWS. It supports popular open-source in-memory data stores like Redis and Memcached, offering high-performance, low-latency data access for applications requiring fast read and write operations. _____________ helps improve application performance and scalability by offloading database and application servers, reducing database load, and improving response times.

A

Amazon ElastiCache

22
Q

_____________ is a fully managed Apache Cassandra-compatible database service provided by AWS. It offers the scalability, availability, and performance of Apache Cassandra with the ease of use and reliability of AWS infrastructure. _____________ supports automatic scaling, built-in encryption, and point-in-time recovery, making it suitable for applications requiring high throughput, low latency, and continuous availability.

A

Amazon Keyspaces (for Apache Cassandra)

23
Q

_____________ is a fully managed time-series database service provided by AWS. It is designed for storing and analyzing time-series data at scale, such as IoT telemetry, application logs, and operational metrics. _____________ offers features like automatic data retention, tiered storage, and built-in analytics functions for analyzing time-series data efficiently. It supports SQL-like queries and integrates seamlessly with other AWS services for data ingestion and visualization.

A

Amazon Timestream

24
Q

_____________ is a fully managed ledger database service provided by AWS. It provides a transparent, immutable, and cryptographically verifiable transaction log for tracking changes to application data over time. _____________ is designed to provide a centralized, trusted source of truth for applications requiring an auditable record of all transactions. It supports SQL-like querying and integrates with AWS services like AWS Key Management Service (KMS) for data encryption.

A

Amazon Quantum Ledger Database (QLDB)

25
Q

_____________ is a fully managed Apache Cassandra-compatible database service provided by AWS. It offers the scalability, availability, and performance of Apache Cassandra with the ease of use and reliability of AWS infrastructure. _____________ handles routine tasks like hardware provisioning, software installation, patching, backups, and monitoring, allowing developers to focus on building applications.

A

Amazon Managed Apache Cassandra Service

26
Q

_____________ is an on-demand, auto-scaling version of Amazon Aurora, a high-performance relational database service provided by AWS. _____________ automatically scales compute capacity up or down based on actual application usage, allowing users to pay only for the resources consumed. It is well-suited for unpredictable or intermittent workloads, reducing costs and management overhead.

A

Amazon Aurora Serverless

27
Q

_____________ is a feature of Amazon Aurora that allows users to create multiple read/write master instances in a cluster, enabling high availability and scalability for write-intensive workloads. _____________ provides synchronous replication and automatic failover capabilities, ensuring continuous availability and data consistency across multiple database instances.

A

Amazon Aurora Multi-Master

28
Q

_____________ is a feature of Amazon Aurora that enables global replication and deployment of Aurora database clusters across multiple AWS regions. It allows users to create read replicas in different regions for low-latency access to data and disaster recovery purposes. _____________ provides fast, synchronous replication and automatic failover, ensuring data consistency and high availability across regions.

A

Amazon Aurora Global Database

29
Q

_____________ is a feature of Amazon Aurora that accelerates analytical queries by pushing processing down to the Aurora storage layer. It enables faster query performance and better utilization of resources by parallelizing query execution across multiple storage nodes. _____________ is particularly beneficial for analytics and reporting workloads with large datasets, reducing query response times and improving overall system efficiency.

A

Amazon Aurora Parallel Query

30
Q

_____________ is an open-source, distributed NoSQL database management system designed to handle large volumes of structured data across multiple commodity servers, providing high availability, fault tolerance, and linear scalability.

A

Apache Cassandra

31
Q

MySQL

A

_____________ is an open-source relational database management system (RDBMS) developed by Oracle Corporation. It is one of the most popular database systems in the world, known for its reliability, performance, and ease of use. _____________ uses a client-server architecture and supports SQL (Structured Query Language) for querying and managing data. It is commonly used for web applications, e-commerce platforms, content management systems, and other data-driven applications.

32
Q

PostgreSQL

A

_____________ is an open-source object-relational database management system (ORDBMS) known for its robustness, extensibility, and SQL compliance. It provides advanced features such as complex queries, indexing, and data integrity constraints, making it suitable for a wide range of applications from simple web applications to large-scale enterprise systems. _____________ supports various data types, including JSON, XML, and arrays, and offers features like table inheritance, partitioning, and full-text search.

33
Q

MariaDB

A

_____________ is an open-source relational database management system (RDBMS) and a fork of MySQL, developed by the original creators of MySQL. It aims to be fully compatible with MySQL while providing additional features, performance improvements, and security enhancements. _____________ offers features such as storage engines, replication, and clustering, making it a popular choice for web hosting, cloud computing, and enterprise applications.

34
Q

Oracle

A

_____________ is a proprietary relational database management system (RDBMS) developed by Oracle Corporation. It is one of the most widely used database systems in the world, known for its scalability, security, and comprehensive feature set. _____________ Database supports advanced features such as partitioning, clustering, and advanced analytics, making it suitable for large-scale enterprise applications in various industries like finance, telecommunications, and government.

35
Q

SQL Server

A

_____________ is a proprietary relational database management system (RDBMS) developed by Microsoft Corporation. It is designed to run on Windows-based systems and is tightly integrated with other Microsoft products and platforms. _____________ offers features such as high availability, advanced security, and business intelligence tools, making it a popular choice for enterprise applications, data warehousing, and business analytics.

36
Q

Amazon Aurora

A

_____________ is a fully managed relational database service provided by Amazon Web Services (AWS). It is compatible with MySQL and PostgreSQL, offering enhanced performance, scalability, and availability compared to traditional database systems. _____________ is built for the cloud with features like automated backups, automatic scaling, and read replicas, making it a popular choice for cloud-native applications, microservices, and serverless architectures.

37
Q

_____________ is an open-source relational database management system (RDBMS) developed by Oracle Corporation. It is one of the most popular database systems in the world, known for its reliability, performance, and ease of use. _____________ uses a client-server architecture and supports SQL (Structured Query Language) for querying and managing data. It is commonly used for web applications, e-commerce platforms, content management systems, and other data-driven applications.

A

MySQL

38
Q

_____________ is an open-source object-relational database management system (ORDBMS) known for its robustness, extensibility, and SQL compliance. It provides advanced features such as complex queries, indexing, and data integrity constraints, making it suitable for a wide range of applications from simple web applications to large-scale enterprise systems. _____________ supports various data types, including JSON, XML, and arrays, and offers features like table inheritance, partitioning, and full-text search.

A

PostgreSQL

39
Q

_____________ is an open-source relational database management system (RDBMS) and a fork of MySQL, developed by the original creators of MySQL. It aims to be fully compatible with MySQL while providing additional features, performance improvements, and security enhancements. _____________ offers features such as storage engines, replication, and clustering, making it a popular choice for web hosting, cloud computing, and enterprise applications.

A

MariaDB

40
Q

_____________ is a proprietary relational database management system (RDBMS) developed by Oracle Corporation. It is one of the most widely used database systems in the world, known for its scalability, security, and comprehensive feature set. _____________ Database supports advanced features such as partitioning, clustering, and advanced analytics, making it suitable for large-scale enterprise applications in various industries like finance, telecommunications, and government.

A

Oracle

41
Q

_____________ is a proprietary relational database management system (RDBMS) developed by Microsoft Corporation. It is designed to run on Windows-based systems and is tightly integrated with other Microsoft products and platforms. _____________ offers features such as high availability, advanced security, and business intelligence tools, making it a popular choice for enterprise applications, data warehousing, and business analytics.

A

SQL Server

42
Q

_____________ is a fully managed relational database service provided by Amazon Web Services (AWS). It is compatible with MySQL and PostgreSQL, offering enhanced performance, scalability, and availability compared to traditional database systems. _____________ is built for the cloud with features like automated backups, automatic scaling, and read replicas, making it a popular choice for cloud-native applications, microservices, and serverless architectures.

A

Amazon Aurora