{ "@context": "https://schema.org", "@type": "Organization", "name": "Brainscape", "url": "https://www.brainscape.com/", "logo": "https://www.brainscape.com/pks/images/cms/public-views/shared/Brainscape-logo-c4e172b280b4616f7fda.svg", "sameAs": [ "https://www.facebook.com/Brainscape", "https://x.com/brainscape", "https://www.linkedin.com/company/brainscape", "https://www.instagram.com/brainscape/", "https://www.tiktok.com/@brainscapeu", "https://www.pinterest.com/brainscape/", "https://www.youtube.com/@BrainscapeNY" ], "contactPoint": { "@type": "ContactPoint", "telephone": "(929) 334-4005", "contactType": "customer service", "availableLanguage": ["English"] }, "founder": { "@type": "Person", "name": "Andrew Cohen" }, "description": "Brainscape’s spaced repetition system is proven to DOUBLE learning results! Find, make, and study flashcards online or in our mobile app. Serious learners only.", "address": { "@type": "PostalAddress", "streetAddress": "159 W 25th St, Ste 517", "addressLocality": "New York", "addressRegion": "NY", "postalCode": "10001", "addressCountry": "USA" } }

Databases Flashcards

(11 cards)

1
Q

RDS

A

Use for OLTP. SQL Server, MySQL, PostgreSQL, Oracle, Aurora, MariaDB

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

DynamoDB

A

NoSQL

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

Redshift

A

OLAP

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

Elasticache

A

In-memory caching. Memcached and Redis

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

Multi-AZ

A

Used for failover, data synchronously replicated

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

Read Replica

A

Used for frequent reads, up to 5 read replicas

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

Aurora scaling

A

2 copies of your data in minimum 3 AZs, so 6 copies of your data. Designed to handle the loss of up to 2 copies of data w/o affecting writes, 3 copies w/o affecting reads. Self healing. Aurora replicas and MySQL read replicas

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

DynamoDB vs RDS

A

DynamoDB has push button scaling, so scale your database on the fly. RDS - need to use bigger instance or add read replica

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

DynamoDB properties

A

stored on SSD storage, spread across 3 geographically distinct data centers, eventual consistent reads (default), strongly consistent reads

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

Redshift configuration

A

Single node (160 Gb), Multi-Node

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

Multi-Node

A
Leader node (manages client connections and receives queries)
Compute node (store data and perform queries and computations). Up to 128 compute nodes
How well did you know this?
1
Not at all
2
3
4
5
Perfectly