BuboFlash - helps with learning

Edited, memorised or added to reading queue

Do you want BuboFlash to help you learning these things? Click here to log in or create user.

Annotation 4518825823500

The attraction to the new and the fear of the new will always be present. In optimization of education, we need to focus on the attraction part, and eliminate the fear part. The learn drive is part of the attractive force in novelty seeking.

status	not read	reprioritisations
last reprioritisation on		suggested re-reading day
started reading on		finished reading on

Learn drive - supermemo.guru
the behavior without changing the instinct. You may scare an animal into novelty seeking (increase in behavior) while actually suppressing the instinct in the long term (instinct suppression). <span>The attraction to the new and the fear of the new will always be present. In optimization of education, we need to focus on the attraction part, and eliminate the fear part. The learn drive is part of the attractive force in novelty seeking. Anxiety may suppress or enhance exploration. If a child fears dark woods, its explorations will depend on whether it is in the woods (enhanced exploration), on its edge (inhibited explo

Flashcard 4518833687820

Question

In databases, [...] is a design technique which organizes tables in a manner that reduces redundancy and dependency of data (i.e. by dividing larger tables to smaller tables and linking them using relationships, via primary/secondary keys).

Answer

Normalization

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Flashcard 4518835784972

Question

In databases, an [...] is a data structure (usually another table) that improves the speed of data retrieval operations on a regular database table, at the cost of additional writes and storage space to maintain the [...] data structure <-- SAME WORD FOR BOTH OCULSIONS

Answer

Index

^^ in both SQL and NoSQL databases (like DynamoDB), you create indexes to allow fast search of fields (in fact for DynamoDB, creating index is only way to search for a particular field that is not part of the primary key).

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Flashcard 4518838668556

Question

In AWS, you use [...] when you want a relational database solution for OLTP (On-Line Transactional Processing)

Answer

RDS

^^ OLTP is the kind of DB you use for storing your main data to run your customer-facing site (i.e. you run simple/smaller queries against it for example to get information about an order, by order number)

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Flashcard 4518840765708

Question

In AWS, there are 6 DB engines supported for RDS: [...] , MariaDB, Oracle, Postgres SQL, MS SQL Server and Aurora

Answer

MySQL

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Flashcard 4518842862860

Question

In AWS, there are 6 DB engines supported for RDS: MySQL, [...] , Oracle, Postgres SQL, MS SQL Server and Aurora

Answer

MariaDB

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Flashcard 4518844960012

Question

In AWS, there are 6 DB engines supported for RDS: MySQL, MariaDB, [...] , Postgres SQL, MS SQL Server and Aurora

Answer

Oracle

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Flashcard 4518847057164

Question

In AWS, there are 6 DB engines supported for RDS: MySQL, MariaDB, Oracle, [...], MS SQL Server and Aurora

Answer

PostgreSQL

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Flashcard 4518849154316

Question

In AWS, there are 6 DB engines supported for RDS: MySQL, MariaDB, Oracle, PostgresSQL, [...] [...] [...] and Aurora

Answer

MS SQL Server

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Flashcard 4518851251468

Question

In AWS, there are 6 DB engines supported for RDS: MySQL, MariaDB, Oracle, PostgresSQL, MS SQL Server and [...]

Answer

Aurora

^^ Aurora is Amazon's own DB engine based on MySQL so it is cheap (similar to MySQL being free) but commercial grade (like MS SQL Server, Oracle, etc).

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Flashcard 4518853348620

Question

In AWS, you use [...] when you want a relational database for OLAP (On-Line Analytical Processing), where are you are running large, complex queries on petabyte scale data.

Answer

Redshift

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Flashcard 4518855445772

Question

In AWS, you use [...] when you want a key-value based NoSQL database.

Answer

DynamoDB

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Flashcard 4518857542924

Question

In databases, one major advantage of NoSQL over traditional SQL is the lack of a DB [...] <-- thing what this means

Answer

Schema

^^ no schema means you can add fields on the fly to a single db row/object in a table (via adding extra fields to the object's JSON, e.g. adding a "gender" property to a JSON-defined "Person" item/row.

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Flashcard 4518859640076

Question

In AWS, you use [...] if you want a fast in-memory database used to take load off of your main OLTP db for repeat queries.

Answer

ElastiCache

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Flashcard 4518861737228

Question

In AWS, Elasticache (AWS's in-memory caching service) has two caching engines/flavors: [...] and Memcached.

Answer

Redis

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Flashcard 4518862261516

Question

In AWS, Elasticache (AWS's in-memory caching service) has two caching engines/flavors: Redis and [...] .

Answer

Memcached

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Annotation 4518866980108

Hierarchical Clustering

status	not read	reprioritisations
last reprioritisation on		suggested re-reading day
started reading on		finished reading on

pdf

cannot see any pdfs

Flashcard 4518868815116

Question

In AWS, for RDS, you can enable automated backups to restore the db to any point in time (down to the second) within a retention period of between 0 and [...] days (configurable)

Answer

^^ RDS achieves automated backups by taking a daily snapshot (stored on S3), then using up-to-the second transaction logs to restore the midday delta
^^^ you get equal amounts of free backup storage on S3 as you have DB storage (so if you have 10G of storage for your RDS instance, you get 10G free of backup space on S3)

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Flashcard 4518870912268

Question

In AWS, for RDS, if you don't turn on Automated backups (configurable for down to second point in time recovery for retention period of 0 to 35 days), you can still take manual backups through taking [...] [...]

Answer

Database Snapshots

^^ note that when you restore an RDS instance from a snapshot, a whole new instance (with differnt DNS) is created

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Flashcard 4518873009420

Question

In AWS, for RDS, you can take care of DR (disaster recovery) by enabling [...]-[...] support for your DB instance (a one-click configuration)

Answer

Multi-AZ

^^ when you turn on Multi-AZ, a synchronous backup of your DB is created in another Availability Zone (within same region) with same DNS (but differnt IP obviously), so if your main instance goes down for any reason (including for maintenacne) AWS does the DNS switching for you automatically.

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Flashcard 4518875106572

Question

In AWS, for RDS, you can force a failover from one AZ to another (if you have multi-AZ enabled) by [...] the RDS instance.

Answer

rebooting

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Flashcard 4518877203724

Question

In AWS, for RDS, if you want to alleviate the load on your DB instance, you can especially improve read performance by enableing [...] [...]

Answer

Read Replicas

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Flashcard 4518879300876

Question

In AWS, for RDS, when you create a Read Replica of your RDS instance, the [...] of the replica is different than that of the master.

Answer

DNS

^^ so you need to manage this by pointing your EC2 application instances to the right master/replica(s) by the correct DNS

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Flashcard 4518881398028

Question

In AWS, for RDS, when you create a Read Replica of your RDS instance, to allivate DB load and improve Read performance, you can create the replica in a totally different [...] , which is not the case for Multi-AZ (used for disaster recovery).

Answer

Region

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Flashcard 4518883495180

Question

In AWS, for RDS, a prerequisite of creating a Read Replica of your RDS instance (to allivate DB load and improve Read performance), is to first have [...] [...] enabled.

Answer

Automated Backups

^^ this is because the asynchronous process of creating/maintaining the Read Replica, uses the daily snapshot and continuos transaction log mechanism used by automated backups.

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Flashcard 4518885592332

Question

In AWS, for RDS, Read Replicas are supported for all DB engines except [...] <-- could be multiword answer

Answer

MS SQL Server

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Flashcard 4518887689484

Question

In AWS, for RDS, Read Replicas can be promoted from replica to master but this will break the [...]

Answer

Replication

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Flashcard 4518889786636

Question

In AWS, for RDS, when you enable Encryptoin (at rest) which is supported for all RDS db engines (using KMS), it will encrypt not just the db but also the the automated backups, snapshots, multi-AZ copy and [...] [...]

Answer

Read Replicas

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Edited, memorised or added to reading queue

on 05-Nov-2019 (Tue)

pdf