Database Flashcards

(19 cards)

1
Q

In which 3 categories AWS shared responsibility model divider based on the ownership of administrative tasks

A

1.Fully Managed services (handle all operational tasks and in this fully man6db services only require customer to be responsible for designing data structures and managing access control)
2.Managed services(AWS handle like backup,patching, hardware provisioning tasks and customer take care of db configuration,query optimization and performance tuning decision)
3.Unmanaged service (customer responsible for config, patching, maintenance tasks,database security,backup,high availability setup n performance optimization e.g. MySQL installed on ec2 instance)

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

Which managed service support multi-AZ deployment and automated backups and multiple db instance types ,also using manually backup creationusing db snapshot

A

Amazon relational database service( RDS)

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

Which service provides security features like network isolation, encryption at rest and encryption in transit

A

Amazon RDS

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

Which db engines supported by Amazon RDS

A

Amazon aurora
MySQL
Postgresql
Microsoft SQL server
Mariadb
Oracledb

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

Select 4 benefit of Amazon RDS :
1.Scalability
2.Cost optimization
3.Multi-AZ Deployment
4.Performance optimization.
5 Security controls

A

2,3,4,5

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

Which process reduce pressure on your primary db by storing frequently accessed data in high speed ,easily accessible location

A

Caching :- data in caching layer stored in system’s memory instead of disk and reduce strain on backend databases by decreasing query volume

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

Which managed db service help to reduce unnecessary I/O operations and it’s benefits

A

Amazon aurora and benefits are:
1. High performance and availability(deliver 5 times throughout of std mysql and 3 times of postgresql ,used distributed storage system accross multiple nodes )
2. Automated storage and backup management (automatically storage grows from 10gb to 128tb based on actual data usage and provide continually backup ur db to S3 to provide point-in-time recovery
3. Advanced replication (replicate data across 3 AZ WITH 6 copies of data , provide 99.99percent availability) and fault tolerance

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

Which service provides automatically scaling with provisioned capacity and data encryption

A

Amazon Dynamodb

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

Which service is fully managed No sql db service for both document and key-vakue data structures and fast db option which use flexible schema

A

Amazon DYNAMODB (give scalability with provisioned capacity, consistent high performance and high availability and durability

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

Which AWS services support VPC gateway endpoint for a private connection from a VPC

A

Amazon Dynamodb and Amazon S3(S3 support interface gateway endpoint too)

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

Which service is fully managed in-memory caching service which used to reduce complexity of administrating in-memory caching systems and automatically detect n replaced failed nodes

A

Elastic Cache(benefits : high performance for reduce,valkey or Memcached instances
High availability
Replication across multiple availability zones
Data encryption)

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

Give practical usecases for Elasticcache

A

Session data management
Database query enhancement
Gaming leather board

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

Which db with full managed service design to handle semi structured data and compatible with Mongo-DB compatible database and perfect for application requiring frequent schema changes n document oriented data

A

Amazon DocumentDB(benefits:
MongoDB compatibility
Performance and scalability
Increased read throughput)

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

Which db service manager json like document with dynamic schemas

A

Amazon DocumentDB

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

Which service streamline data protection across AWS resources and on-premises deployments by providing single dashboard for monitoring and managing backups and eliminate complexity of managing multiple backup strategies by supporting multiple storage types including Amazon EBS volume, EFS

A

AWS backup(benefits:
Centralized backup management
Cross region backup redundancy
Streamlined regulatory compliance)

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

Which service is fully managed purpose built graph db service which managed highly connected data sets with millisecond latency and excel in understanding complex relationships

A

Amazon Neptune(benefits:
Purpose built for complex relationships
High performance and scalability)

17
Q

What are the common tools for caching and while service support all those tools

A

Redis OSS
Valkey
Memcached

Elasticcache ( improve application performance by delivering microsecond latenctmy for data reads and offloading database queries

18
Q

Which service used to handled semi structured data like product catalog

A

Amazon documentdb

19
Q

Which db service provides enterprise level performance and reliability with cost effective solution by replacing high cost commerce db engines

A

Amazon Aurora