Databases Flashcards
How many types of Relational Databases in AWS there is?
6. SQL Server, Oracle, MariaDB, PostgreSQL, Aurora, MySQL Server
What are the benefits of AWS databases?
You can have copies in Multiple AZ for disaster recovery
How to improve AWS databases READ?
By allowing database replica, which is basically a copy of the DB you’re implementing.
What’s the name of Amazon NonSQL DB?
DynamoDB
Whats the difference between Online Transactions Processing vs Online Analytics Processing?
OLTP returns a row of data already filtered from the DB. The sort/filter is made in data side, and only the result is returned.
OLAP on the other hand returns a large amount of data and the sorting/filtered needs to be done after the query.
What is Data Warehousing?
I’ts used for Business Inteligence to retrieve large amount of data in a most performatic way. It uses a different type of architecture both from a Database perspective and infrastructure layer.
What’s Redshift
It’s Amazon’s Data Warehousing
What’s Elastic Cache?
It’s a service that facilitate the deployment, and operation of in-memory cache. You can configure to cache the most recurrent queries in your database to boost performance and latency, like Amazons departament categories for example
What are the two types of Elastic Cache supported by AWS?
MemCached
Redis
What is Amazon’s Graph Database?
Amazon Neptune
What is Data Lake?
Is an architectural approach that allows you to store data from different origins in a central location as is. since data can be stored as-is you don’t have to convert it as a predefined schema and you no longer need to know what questions to ask about your data beforehand.
How does Amazon recommend removing single points of failure?
- Introducing Redundancy
- Detect Failure
- Durable data Storage
- Automate Multi-Data center Resilience
- Fault Isolation and Traditional Horizontal Scaling
- Sharding => Split across multiple shards
How does Amazon recommend the cost optimization for DBs?
- Right sizing
- Elasticity => Expands and shrinks based on demand of traffic
- Take advantage of the variety of purchasing options
(Reserved capacity and Spot Instances)
What’s the 2 types of caching in DBs?
Application Caching
Edge Caching
How to improve security in AWS?
Use AWS Features for defense in depth Share Security Responsibility with AWS Reduce Privileged access Security as code Real-time auditing => AWS inspector (CloudTrail)
