Database Services

Question 1

Ideal for databases that frequently read and write data, this system is optimized for faster query performance.

Answer 1

Online Transaction Processing (OLTP)

Question 2

Optimized for handling complex queries on large datasets, data warehousing consolidates multiple transaction records into a single database.

Answer 2

Online Analytic Processing (OLAP)

Question 3

This database engine offers an S3 Integration

Answer 3

Oracle

Question 4

These databases offer Transparent Data Encryption (TDE), which encrypts data before it is stored.

Answer 4

Microsoft SQL Server and Oracle

Question 5

These Databases provide an audit plug-in for logging user logins and queries executed on the databases.

Answer 5

MySQL and MariaDB

Question 6

Database instance storage class that offers faster query times and improved performance.

Answer 6

Memory Optimized

Question 7

Database instance class that is best for nonproduction environments and testing.

Answer 7

Burstable Performance

Question 8

A low latency cost effective storage value

Answer 8

General-Purpose SSD

Question 9

Both of these databases are supported by Aurora DB.

Answer 9

Postgres and MYSQL

Question 10

RDS supports x amount of read replicas

Answer 10

5

Question 11

A database instance designed to support applications that require intensive querying.

Answer 11

Read Replica

Question 12

Aurora supports x amount of read replicas

Answer 12

15

Question 13

The instance remains responsible for writing data to the database.

Answer 13

master database instance

Question 14

Data from the master database is replicated to the read replicas?

Answer 14

Asynchronously replicated (Not instant)

Question 15

A domain name that the application uses when a query is needed to be performed on the database.

Answer 15

Reader Endpoint

Question 16

Deploying multiple database instances in different availability zones.

Answer 16

Multi-AZ deployment.

Question 17

Within a Multi-AZ DB deployment, all instances should

Answer 17

Be in the same region

Question 18

In a Multi-AZ deployment, your application uses a __ for the primary and the secondary is __

Answer 18

Endpoint domain
Not a read replica

Question 19

Database instance that provides 6 copies of your data across 3 AZs

Answer 19

Aurora

Question 20

Instances rely on a cluster volume that is synchronized across three availability zones, allowing for an instance to take over if the primary fails.

Answer 20

Aurora Single-Master

Question 21

All instances are capable of writing to the database. Therefore, when one instance fails, there is no failover because all instances can continue writing to the shared cluster volume that stores the database.

Answer 21

Aurora Multi-Master

Question 22

The maximum acceptable time to recover data.

Answer 22

Recovery Time Objective (RTO)

Question 23

The maximum acceptable data loss.

Answer 23

Recovery Point Objective (RPO)

Question 24

Point-in-time recovery is enabled, allowing the archiving of database change logs to S3 every five minutes.

Answer 24

Automated Snapshots

Question 25

RDS automates snapshots for a set duration, allowing you to choose between 1 to 35 days. Setting the retention period to 0 deletes existing snapshots, while setting it to 1 creates a new snapshot.

Answer 25

Retention period

Question 26

Frequent opening and closing of database connections can drain resources and degrade performance. Proper management of idle connections and scaling with demand.

Answer 26

Amazon RDS Proxy

Question 27

Using AWS Secrets Manager with Amazon RDS allows for an encrypted connection to provide authentication credentials.

Answer 27

Amazon RDS Proxy

Question 28

A database warehouse service for computationally intensive queries, it enables faster data retrieval by utilizing compression to encode and reduce the size of the data or columns.

Answer 28

Amazon Redshift (SQL)

Question 29

This node in a Redshift cluster coordinates communication among compute nodes and clients without incurring any additional charges. What is it?

Answer 29

Leader Node

Question 30

Components of an Amazon Redshift cluster can be categorized into three types, each with varying storage capacities and types of storage media. What are these types?

Answer 30

Dense Compute Nodes: Store up to 326 TB on fast SSDs.
Dense Storage Nodes: Store up to 2 PB on magnetic hard disk drives.
RA3 Nodes: Store up to 16,384 TB on fast SSDs (faster alternative to dense storage nodes).

Question 31

With data in the same region, you can query data from files stored in AWS S3 without having to import the data into your clusters.

Answer 31

Redshift Spectrum

Question 32

A secure way to migrate databases from on-premises to AWS, using an instance and replication if the database engines differ.

Answer 32

AWS Database Migration Service (DMS)

Question 33

Converts your database from one engine to another.

Answer 33

AWS Schema Conversion Tool (SCT)

Question 34

Aside from querying with the primary key, these databases are unsuitable for complex or arbitrary queries.

Answer 34

Nonrelational (NoSQL) Databases

Question 35

A NoSQL database that offers millisecond latency and multi-AZ by default, with authorization through IAM and rapidly evolving schemas.

Answer 35

DynamoDB

Question 36

DynamoDB offers a point-in-time recovery for backups for up to…

Answer 36

35 days

Question 37

This database feature allows the information in the table to be updated as records contain details about data modifications.

Answer 37

DynamoDB Stream

Question 38

This NoSQL feature enables replication of your database across different regions.

Answer 38

DynamoDB Global