AWS Cloud Practitioner Exam - Databases

Amazon Relational Database Service (RDS)

AWS provides a service that sets up, operates, and scales the relational database without any ongoing administration. It makes it easy to run a relational database in the cloud. _______ is a managed service for relational databases including support for MySQL, PostgreSQL, MariaDB, Oracle, Microsoft SQL Server, and Amazon Aurora. With it your focus is on optimizing your application.

Managed Services

AWS solutions typically fall into one of two categories. In this type of service Amazon does most of the work in managing changes in load, errors, and situations where resources become unavailable. Features such as scaling, fault-tolerance, and availability are handled automatically and internally by Amazon

Unmanaged Services

AWS solutions typically fall into one of two categories. In this type of service the user does most of the work in managing changes in load, errors, and situations where resources become unavailable. Features such as scaling, fault tolerance, and availability are handled by you.

Compound Key

Alternatively, to a partition key or composite primary key, you can specify a _______ which is composed of a partition key and a secondary key

Read Replicas

Amazon RDS also supports the creation of ______ for MySQL, MariaDB, PostgreSQL, and Amazon Aurora. Updates that are made to the source database instance are asynchronously copied to them. This can reduce the load on your main database for read-heavy database workloads. They can even be deployed in other regions to improve disaster recovery or reduce latency by moving reads closer to the user.

Amazon Redshift

This is a fast, fully managed data warehouse that makes it simple and cost-effective to analyze all your data by using standard SQL and your existing business intelligence (BI) tools. It enables you to run complex analytic queries against petabytes of structured data by using sophisticated query optimization, columnar storage on high-performance local disks, and massively parallel data processing.

Tables

This is a primary component of DynamoDB. It is simply a collection of data.

Attributes

This is a primary component of DynamoDB. They are a fundamental data element, something that does not need to be broken down any further.

Amazon Aurora

This managed database service is a MySQL and PostgreSQL compatible relational database that is built for the cloud. It combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases.

Non-Relational Databases

This type of database is any database that does not follow the relational model that is provided by traditional relational database management systems (RDBMS)

Relational Databases

This type of database works with structured data that is organized by tables, records, and columns.

True

True or False, Amazon Redshift automatically and continuously monitors clusters

True

True or False. Amazon Aurora is designed for instant crash recovery, and can restart after a database crash in less than 60 seconds in most cases.

False

True or False. Amazon Redshift does not have encryption built in.

True

True or False. DynamoDB automatically replicates your tables across your choice of AWS Regions.

False

True or False. DynamoDB does not work well for mobile, web, gaming, adtech, and IoT applications.

True

True or False. DynamoDB provides consistent, single-digit millisecond latency at scale, with no limits on table size or throughput.

Multi-AZ

Usually, the database instance is isolated in a private subnet and is only made directly accessible to indicated application instances. Subnets in a VPC are associated with a single Availability Zone, so when you select the subnet, you are also choosing the Availability Zone for your database instance. You can improve availability by configuring a _______ deployment, where Amazon RDS automatically generates a standby copy of your database in another Availability Zone. The standby copy is synchronously replicated with your main database instance.

Amazon DynamoDB

What is the name of AWS's NoSQL Database?

You

When using Amazon RDS, who is responsible for application optimization You or Amazon

Amazon

When using Amazon RDS, who is responsible for ensuring high system availability by scaling resource, managing power and cooling, and performing maintenance? You or Amazon

Amazon

When using Amazon RDS, who performs OS and Database software installation and patching? You or Amazon

Amazon

When using Amazon RDS, who performs backups? You or Amazon

MySQL, Amazon Aurora, Microsoft SQL Server, PostgreSQL, MariaDB, and Oracle

When you choose to create a database instance, you must first specify which database engine to run. Amazon RDS supports six of the most popular database engines. Name some of them.

D. Amazon Aurora

Which of the four managed database services can use up to 15 read replicas and is designed for instant crash recovery? A. Amazon RDS B. Amazon DynamoDB C. Amazon Redshift D. Amazon Aurora

B. Amazon DynamoDB

Which of the four managed database services is a Fast and flexible NoSQL database service for any scale? A. Amazon RDS B. Amazon DynamoDB C. Amazon Redshift D. Amazon Aurora

C. Amazon Redshift

Which of the four managed database services is a data warehouse? A. Amazon RDS B. Amazon DynamoDB C. Amazon Redshift D. Amazon Aurora

A. Amazon RDS

Which of the four managed database services provides an enterprise-class relational database? A. Amazon RDS B. Amazon DynamoDB C. Amazon Redshift D. Amazon Aurora

SSD

Which storage type does DynamoDB exclusively run on? SSD or HDD

Yes

Yes or No. Should you use Amazon RDS if your application requires: Complex transactions or complex queries A medium to high query or write rate up to 30,000 IOPS No more than a single worker node or shard High durability

No

Yes or No. Should you use Amazon RDS if your application requires: Massive read/write rates (for example 150,000 writes per second) Sharding due to high data size or throughput demands Simple GET or PUT requests and queries that a NoSQL database can handle Or, relational database management system (RDBMS) customization

Items

This is a primary component of DynamoDB. They are a group of attributes that is uniquely identifiable among all the other items

Performance and Price

Database instances and storage differ in ______ characteristics and ______.

Partition Key and Composite Primary Key

DynamoDB supports two different kinds of primary keys. They are _____ and ______.

Database Instance

Much like an EC2 instance is the basic building block of computing. This is the basic building block of Amazon RDS. It is an isolated database environment that can contain multiple user-created databases.

Partition Key

The ________ is a simple primary key, which is composed of ONE attribute called the sort key.

Composite Primary Key

The partition key and sort key are also known as the composite primary key, which is composed of TWO attributes.

Tables, Items, and Attributes

There are three primary components of DynamoDB

Query

You can retrieve data from a DynamoDB table in two different ways: In the first method, the ______ operation takes advantage of partitioning to effectively locate items by using the primary key. You _______ by key.

Scan

You can retrieve data from a DynamoDB table in two different ways: The second method is via a ______, which enables you to locate items in the table by matching conditions on non-key attributes. This second method gives you the flexibility to locate items by other attributes. However, the operation is less efficient because DynamoDB will comb through all the items in the table to find the ones that match your criteria