Edited, memorised or added to reading list

on 05-Nov-2019 (Tue)

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

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.
statusnot read reprioritisations
last reprioritisation on reading queue position [%]
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

statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised 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).


statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised 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)


statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised 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

statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised 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

statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised 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

statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised 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

statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised 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

statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised 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).


statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised 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

statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised 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

statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised 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.


statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised 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

statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised 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

statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised 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

statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised on               scheduled repetition               
scheduled repetition interval               last repetition or drill






Hierarchical Clustering
statusnot read reprioritisations
last reprioritisation on reading queue position [%]
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

35

^^ 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)


statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised 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


statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised 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.


statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised 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


statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised 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


statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised 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


statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised 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

statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised 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.


statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised 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

statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised 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

statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised 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

statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised on               scheduled repetition               
scheduled repetition interval               last repetition or drill