Brainscape's Knowledge GenomeTM

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


See full index

Amazon AWS Certified Solutions Architect Associate remix > Databases > Flashcards

Databases Flashcards

1
Q

What database services are available on AWS?

A

RDS-OLTP DynamoDB (NoSQL) RedShift (OLAP) Elasticache (in memory caching) DMS

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

What OLTP databases are available in RDS?

A

SQL

MySQL

Postgre

Oracle

MariaDB

Aurora

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

What cache services are available in RDS Elasticache?

A

Memcached Redis

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

What is Elasticache?

A

Amazon ElastiCache is a web service that makes it easy to deploy, operate, and scale an in-memory data store or cache in the cloud.

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

What is DMS?

A

AWS Database Migration Service is a web service you can use to migrate data from your database that is on-premises, on an Amazon Relational Database Service (Amazon RDS) DB instance, or in a database on an Amazon Elastic Compute Cloud (Amazon EC2) instance to a database on an AWS service.

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

What are the types of backups supported on RDS?

A

Automated Backups and Database Snapshots

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

How does Automated Backups work?

A

Automated Backups allow you to recover your DB to any point in time within a “retention period”. Retention Period can be between 1 and 35 days. Automated Backups will take a full daily snapshot and will also store the transaction logs throughout the day.

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

Where is stored the Automated Backup data? How much does it cost?

A

The backup data is stored in S3 and you get free storage space equal to the size of your database.

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

How does RDS Snapshots work?

A

DB Snapshots are done manually. They are stored even after the original RDS instance is deleted, unlike Automated Backups.

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

What happens when you restore a backup?

A

When ever you restore either an Automated Backup or a manual Snapshot, the restored version of the database will be a new RDS instance with a new endpoint.

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

Can an existing RDS DB be encrypted?

A

Encrypting an existing DB instance is not supported. To use RDS encryption for an existing database: - Create a new DB instance with encryption enabled and migrate your data into it. Or, - 1) Create a snapshot of the unencrypted database instance. 2) Copy the snapshot to a new, encrypted snapshot. Enable encryption and specify the desired KMS key as you do so. 3) Restore the encrypted snapshot to a new database instance.

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

What is Multi-AZ RDS?

A

Multi-AZ allows to have an exact copy of your production database in another AZ. In the event of planned DB maintenance, BD instance failure, or an Availability Zone failure, Amazon RDS will automatically failover to the standby.

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

What is the use case for Multi-AZ RDS

A

Multi-AZ is for disaster recovery. It is not used for improving performance. For performance improvement, Read Replicas are needed.

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

Can Multi-AZ be used to performance improvement?

A

No. Multi-AZ is for disaster recovery. It is not used for improving performance. For performance improvement, Read Replicas are needed.

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

What is a Read Replica?

A

Read Replica uses asynchronous synchronization to create an exact copy of the DB that can be actually read.

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

For which RDS databases Multi-AZ is supported?

A

SQL Sever Oracle MySQL Server PostgreSQL MariaDB (Aurora has its own replica mechanism)

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

For which RDS databases “Read Replicas” is supported?

A

MySQL MariaDB PostgreSQL Amazon Aurora

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

What is the use case for Read Replicas?

A

Read Replicas are used for scaling, not for disaster recovering.

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

How many Read Replicas can be added to a RDS BD?

A

Amazon RDS allow you to add up to 5 read replicas to each DB Instance.

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

Can you have Read Replicas of Read Replicas?

A

Yes, but watch out for latency.

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

How applications can use Read Replicas?

A

The read replica operates as a DB instance that allows only read-only connections; applications can connect to a read replica just as they would to any DB instance.

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

Can Read Replicas be Multi-AZ?

A

Yes. You can have read replicas that have Multi-AZ.

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

Can Multi-AZ databases have Read Replicas?

A

Yes. You can create Read Replicas of Multi-AZ source databases.

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

Can Read Replicas be promoted, so that they become standalone DB Instances?

A

Yes. This breaks the replication.

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

Can you have cross-region Read Replicas?

A

Yes. You can have a read replica in a second region.

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

What is one of the main advantages of DynamoDB over RDS?

A

DynamoDB offers Push Button scaling, meaning that you can scale your database on the fly, without any down time. For RDS, scaling is not so easy and you usually have to use a bigger instance size or to add a read replica.

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

How can you scale up in RDS?

A

It’s a manual process. - Snapshot, Restore changing instance size. - Read replica with bigger size.

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

Can you scale out in RDS?

A

In RDS, you can only scale up. You can scale out, but only in terms of reads, not writes.

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

What is DynamoDB?

A

Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability. DynamoDB lets you offload the administrative burdens of operating and scaling a distributed database, so that you don’t have to worry about hardware provisioning, setup and configuration, replication, software patching, or cluster scaling.

30
Q

What NoSQL data models support DynamoDB?

A

Document and key-value data models.

31
Q

What kind of storage does DynamoDB uses?

A

Stored on SSD storage.

32
Q

How is DynamoDB spread?

A

Spread across 3 geographically distinct data centers.

33
Q

What Read Consistency models does DynamoDB supports?

A

Eventual Consistent Reads (default) Strongly Consistent Reads.

34
Q

What is “Eventual Consistent Reads”?

A

Consistency across all copies of data is usually reached within a second.

35
Q

What is “Strongly Consistent Reads”?

A

A Strongly Consistent Read returns a result that reflects all writes that received a successful response prior to the read.

36
Q

DynamoDB pricing

A

Provisioned Throughput Reserved capacity (if applicable) Data storage Data transfer (only across AWS Regions)

37
Q

What is RedShift?

A

Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse that makes it simple and cost-effective to analyze all your data using your existing business intelligence tools. Start small for $0.25 per hour with no commitments and scale to petabytes for $1,000 per terabyte per year, less than a tenth the cost of traditional solutions.

38
Q

What configurations does RedShift support?

A

Single node (160GB) Multi-node: - Leader node (manage client connections and receives queries) - Compute node (store data and perform queries and computations). Up to 128 Compute Nodes.

39
Q

What are the advantages of RedShift (“10 times faster”)

A

Columnar Data Storage Advanced Compression Massively Parallel Processing

40
Q

RedShift pricing

A

Compute node hours Backup Data transfer (only within a VPC)

41
Q

What AWS platform is most suitable for OLTP?

A

RDS/DynamoDB

42
Q

When replicating data from your primary RDS instance to your secondary RDS instance, what is the charge?

A

You are not charged for the data transfer incurred in replicating data between your source DB instance and Read Replica.

43
Q

What is the maximum size RDS volume can you have by default for Provisioned IOPS and General Purpose SSD storage types?

A

Amazon RDS supports database storage size up to 16TB for MySQL, MariaDB, Oracle, SQL Server, and PostgreSQL engines, for Provisioned IOPS and General Purpose SSD storage types (since 2017).

44
Q

In RDS, when using Multi-AZ, can you use the secondary database as an independent read node?

A

No.

45
Q

Which types of Aurora Replicas are available?

A

Aurora Replicas (currently 15) MySQL Read Replicas (currently 5)

46
Q

Aurora Scaling

A
  • 6 copies of data: 2 in each of a minimum of 3 AZs. - Designed to handled transparently the loss of up to 2 copies of data without affecting write availability and 3 without affecting read availability. - Self-healing (data blocks and disks continuously scanned)
47
Q

Are automated backups enabled by default in RDS databases?

A

Yes

48
Q

Can you select the AZ in which to deploy an RDS database at creation time?

A

Yes

49
Q

What is the maximum size RDS volume you can have by default when using Amazon RDS Provisioned IOPS storage with MySQL or Oracle?

A

16TB

50
Q

Must you specify a port number or protocol when adding a rule to an RDS Security Group?

A

No

51
Q

Are RDS reserved instances available for Multi-AZ deployment?

A

Yes

52
Q

What happens to the I/O operations of a single-AZ RDS instance during a database snapshot or backup?

A

I/O may be briely suspended while the backup process intializes (typically under a few seconds), and you may experience a brief period of elevated latency.

53
Q

In RDS what’s the maximum value I can set for my backup retention period?

A

35 days

54
Q

Which node in the response from the Amazon RDS API do I need to check if I want my application to check RDS for an error?

A

Error node

55
Q

When do changes to the RDS backup window take effect?

A

Immediately

56
Q

When you have deployed an RDS database into multiple AZs, can you use the secondary DB as an independent read node?

A

No

57
Q

Is there a charge associated with data transfering when replicating data from the primary RDS instance to the secondary RDS instance?

A

No

58
Q

Can you “force” a failover for any RDS instance that has Multi-AZ configured?

A

Yes, rebooting the instance.

59
Q

RDS runs on virtual machines. Can you login to the OS?

A

No

60
Q

As the user, are you responsible to patch your AWS DB and OS?

A

Not for any AWS RDS services

61
Q

Is RDS serverless?

A

Yes except for Aurora

62
Q

Describe red shift backups?

A

1 day enabled by default

maximum 35 days

maintains 3 copies

can asynchronously replicate your snapshots to S3 in another region

63
Q

you have an aurora snapshot. Can you share it with another account?

A

yes

64
Q

What types of aurora replicas are available?

A

Aurora and MySQL replicas

65
Q

How is aurora backed up?

A

automated backups turned on by default

snapshots

66
Q

What DB perfomance enhancer also provides multi az?

A

elasticache Reddis

67
Q

Which of the following DynamoDB features are chargeable, when using a single region?

A

Read and Write Capacity

Storage of Data

68
Q

Which of the following data formats does Amazon Athena support? (Choose 3)

A

JSON

Apache ORC

Apache Parquet

69
Q

MySQL installations default to port number ________.

A

3306

70
Q

Which of the following AWS services is a non-relational database?

A

DynamoDB

71
Q

If you want your application to check RDS for an error, have it look for an ______ node in the response from the Amazon RDS API.

A

Error

72
Q

Which AWS DB platform is most suitable for OLTP?

A

RDS

Amazon AWS Certified Solutions Architect Associate remix (11 decks)

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