Databases Flashcards
In a relational database, what language is used to perform queries or lookups?
SQL
What type of database does NoSQL reflect?
Non relational database
In regards to database, what is meant by “schema”?
Basically, the shape of the data
What type of database offers a flexible schema?
non relational
The following are examples of what type of database?
Key-value, document, graph, in-memory, search databases
non relational
the following is an example of what type of database?
flexible (easy to evolve data model)
scalable - designed to scale out by using distributed clusters
high-performance - optimized for a specific data model
highly-functional - optimized for the data model
non relational
what does JSON stand for?
java script object notation
In the Shared Responsibility model, who is responsible for patching OS and database patching?
AWS
In the Shared Responsibility model, who is responsible for automated backup and restore, operations, and upgrades?
AWS
In the Shared Responsibility model, who is responsible for monitoring and alerts?
AWS
For RDS services, how is the storage managed?
EBS (gp2 or ioL)
Can you SSH into an RDS instance?
No
What are the two services you can utilize to create relational databases in AWS?
RDS or Aurora
This type of database is OLAP (analytics & data warehousing)
Redshift
What type of database is based on PostgreSQL but doesn’t use OLTP
Redshift
How often does Redshift load data?
every hour
Is RDS a single or multi-AZ service, and why?
multi-AZ, for data reliability (disaster recovery)
What type of replicas are provided for RDS, “read/write” or “read”?
read
what two types of query languages are supported by Amazon Aurora?
PostgreSQL and and MySQL
Aurora is ____ optimized
cloud
Aurora claims _x performance in PostgreSQL over RDS and _x performance in MySQL over RDS
3x and 5x
Aurora storage is adjusted
a. automatically
b. manually
a. automatically
Aurora storage is automatically incremented by __ GB up to a maximum of __ TB
10GB, 128TB
Which is more expensive, Aurora or Amazon RDS?
Aurora
How much more expensive is Aurora over Amazon RDS?
20%
Aurora storage (Is/Is Not) in the free tier?
Is not
Amazon RDS can have a maximum of how many “read” replicas?
5
With Amazon RDS, data is only written to where?
the main DB
Amazon RDS, how many AZs can be utilized as a fail-over?
1
Which type of managed relational database is going to be more cloud native? which one will work more with the technologies you’re probably already familiar with?
Aurora / RDS
When starting a new database from the RDS service, which database options are available to choose from?
PostgreSQL (Aurora)
PostgreSQL
MySQL (Aurora)
MySQL
MariaDB
Oracle
SQL Server
In a failover DB (multi-AZ) where is the data written to and read from?
the main DB only
The failover database is considered to be (passive/active)?
passive
When is the failover DB accessible?
only after a failure to the main DB
If you want to copy your database to another region, what is a method you can use?
Create a snapshot into another region
What would be two reasons to setup a multi-region DB deployment, where data is written to and read from one main DB but replicas are created in other regions?
one - disaster recovery if there’s an issue with a given region
less latency - the application is reading data from a “read replica” that’s in a region closer to where the application is located
Anytime you hear “in-memory databases with high performance and low latency” what should you think of?
ElastiCache
This is an example of what “helps reduce load off databases for read intensive workloads”
ElastiCache
DynamoDB replicates across how many AZs?
three
What type of database is this referring to:
“scales to massive workloads, distributed “serverless” database, millions of requests per seconds, trillions of rows, 100s of TB storage, single digit millisecond latency, low latency retrieval
Dynamo DB
If the certification exam refers to “single digit millisecond latency” and/or “low latency retrieval” - what type of database is it likely referring to?
Dynamo DB
True or False:
Dynamo DB has low cost and auto scaling capabilities?
True
What type of S3 storage class is offered by Dynamo DB?
standard and IA
the name for a fully managed, in-memory cache for DynamoDB
DynamoDB Accelerator - DAX
DynamoDB Accelerator DAX offers a __x performance improvement
10x
Theoretically, can ElastiCache be used as an in-memory DB for DynamoDB?
It could, but it’s recommended to use Dynamo Accelerator DAX instead as that is formulated for use with Dynamo
DynamoDB replication is an (active/passive) replication?
active
DynamoDB region replication is referring to as G_____ T_____.
global tables