Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Cantril > Relational Database Service (RDS) > Flashcards

Relational Database Service (RDS) Flashcards

1
Q

type of nonrelational database that uses a simple key-value method to store data. A key-value database stores data as a collection of key-value pairs in which a key serves as a unique identifier

A

Key Value Database

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

type of nonrelational database that is designed to store and query data as JSON-like documents.These DB make it easier for developers to store and query data in a database by using the same document-model format they use in their application code

A

Document Database

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

database purpose-built to store and navigate relationships. Relationships are first-class citizens and most of the value is derived from these relationships

A

Graph Database

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

purpose-built databases that rely primarily on memory for data storage, in contrast to databases that store data on disk or SSDs. Are designed to enable minimal response times by eliminating the need to access disks

A

In-Memory Database

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

NoSQL database that organizes data storage into flexible columns that can be spread across multiple servers or database nodes

A

Wide Column Database

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

Transaction model ensures that a performed transaction is always consistent. This makes it a good fit for businesses which deal with online transaction processing, or online analytical processing. Used for systems which can handle many small simultaneous transactions. used for relational DB

A

ACID

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

The rise of NoSQL databases provided a flexible and fluid way to manipulate data used by MongoDB, Cassandra and Redis are among the most popular NoSQL solutions, together with Amazon DynamoDB and Couchbase

A

BASE

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

ensure availability of data by spreading and replicating it across the nodes of the database cluster

A

Basically Available

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

Use EC2 for databases if you need access to the DB instance operating system

A

True

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

Use EC2 for databases if you need advanced database tuning which can only be done on the root

A

True

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

Use EC2 for databases or database version which aws dont provide

A

True

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

MySQL, MariaDB, PostgreSQL, Oracle, Microsoft SQL Server are all

A

Database engines for RDS

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

Can RDS be access from the VPC or any connected private networks?

A

Yes

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

Allows access to the database from the public internet

A

Public Addressing

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

Does every RDS instance have its own EBS storage?

A

Yes

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

Data is replicated from primary to standby immediately

A

Synchronous Replication

17
Q

Data is replicated from Standby to Read replicas, data is not replicated immediately

A

Asynchronous Replication

18
Q

cluster deployment in Amazon RDS provides a high availability deployment mode of Amazon RDS with two readable standby DB instances

A

Multi-AZ DB cluster

19
Q

has a writer DB instance and two usable reader DB instances in three separate Availability Zones in the same AWS Region

A

Multi-AZ DB cluster

20
Q

provides high availability and failover support for DB instances using a single standby DB instance. Amazon RDS automatically provisions and maintains a synchronous standby replica in a different Availability Zone

A

Multi-AZ DB instance deployment

21
Q

Points at the writer and is used for read, writes and administration

A

Cluster Endpoint

22
Q

Directs and reads at an available reader instance

A

Reader Endpoint

23
Q

Points at a specific instance generally used for testing/fault finding

A

Instance Endpoints

24
Q

contained in AWS managed s3 buckets that are unable to be viewed from S3

A

RDS Backups

25
Q

Do snapshots live on after the deletions of an RDS instance

A

Yes

26
Q

RDS can be configured to replicate backups to another region for extra charges for replication and storage

A

True

27
Q

When restoring RDS a new instance is created with a new address, applications must be configured to the new RDS instance address

A

True

28
Q

Provide enhanced performance and durability for Amazon RDS database (DB) instances. They make it easy to elastically scale out beyond the capacity constraints of a single DB instance for read-heavy database workloads

A

Read Replicas

29
Q

Amazon RDS creates a second DB instance using a snapshot of the source DB instance. It then uses the engines’ native asynchronous replication to update the read replica whenever there is a change to the source DB instance

A

Read Replicas

30
Q

Read Replicas offer near 0 RPO and very low RTO from failure, data corruption means the Read Replica likely has corrupted data

A

True

31
Q

Encryption in RDS

A

SSL/TLS in transit

32
Q

EBS volume encryption in RDS

A

Thru KMS

33
Q

SQL Server (SQL Server Enterprise Edition) and Oracle security in RDS, which is handled within the DB engine

A

TDE

34
Q

Does RDS oracle support integration with CloudHSM

A

Yes

35
Q

can you map database users to IAM roles for federated access.

A

Yes

36
Q

managed database service for applications that require customization of the underlying operating system and database environment, used/needed for legacy, packaged, and custom applications

A

RDS Custom

37
Q

instead of connecting to the database everytime, users connect to a proxy which has a pool of connections to the database

A

rds proxy

Cantril (38 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions