Which Aws Database Service Is Best Suited For Traditional Online Transaction Processing (Oltp)?

Know what a relational database is.
A relational database consists of one or more tables, Communication to and from relational databases usually involves simple SQL queries, such every bit "Add a new record," or "What is the cost of product x?" These simple queries are often referred to equally OLTP.

Understand which databases are supported by Amazon RDS.

Amazon RDS currently supports half dozen relational database engines:

Microsoft SQL Server
MySQL Server
Oracle
PostgreSQL
MariaDB
Amazon Aurora

Understand the operational benefits of using Amazon RDS.
Amazon RDS is a managed service provided by AWS. AWS is responsible for patching, antivirus, and direction of the underlying guest Os for Amazon RDS. Amazon RDS profoundly simplifies the procedure of setting a secondary slave with replication for failover and setting up read replicas to offload queries.

Think that you cannot access the underlying OS for Amazon RDS DB instances.
You cannot use Remote Desktop Protocol (RDP) or SSH to connect to the underlying OS. If y'all demand to admission the Bone, install custom software or agents, or want to use a database engine non supported by Amazon RDS, consider running your database on Amazon EC2 instead.

Know that you can increase availability using Amazon RDS Multi- AZ deployment.
Add error tolerance to your Amazon RDS database using Multi-AZ deployment. You tin can quickly set a secondary DB Instance in some other Availability Zone with Multi-AZ for rapid failover.

Sympathise the importance of RPO and RTO.

Each awarding should set RPO and RTO targets to define the corporeality of acceptable data loss and also the amount of time required to recover from an incident. Amazon RDS can be used to meet a wide range of RPO and RTO requirements.

Understand that Amazon RDS handles Multi-AZ failover for you.
If yous principal Amazon RDS Example becomes unavailable, AWS fails over to your secondary instance in another Availability Zone automatically. This failover is done by pointing your existing database endpoint to a new IP address. Y'all do not have to change the connexion string manually; AWS handles the DNS alter automatically.

Remember that Amazon RDS read replicas are used for scaling out and increased performance.

This replication feature makes information technology like shooting fish in a barrel to scale out your read-intensive databases. Read replicas are currently supported in Amazon RDS for MySQL, PostgreSQL, and Amazon Aurora. You lot tin can create i or more replicas of a database within a single AWS Region or beyond multiple AWS Regions. Amazon RDS uses native replication to propagate changes made to a source DB Example to whatsoever associated read replicas. Amazon RDS also supports cross-region read replicas to replicate changes asynchronously to another geography or AWS Region.

Know what a NoSQL database is.

NoSQL databases are non-relational databases, meaning that you exercise non have to accept an existing table created in which to store your information. NoSQL databases come in the post-obit formats:

Document databases
Graph stores
Primal/value stores
Wide-cavalcade stores

Retrieve that Amazon DynamoDB is AWS NoSQL service.
You should remember that for NoSQL databases, AWS provides a fully managed service called Amazon DynamoDB. Amazon DynamoDB is an extremely fast NoSQL database with predictable performance and high scalability. You can utilise Amazon DynamoDB to create a tabular array that tin store and recall whatsoever amount of data and serve any level of asking traffic. Amazon DynamoDB automatically spreads the data and traffic for the table over a sufficient number of partitions to handle the request capacity specified by the customer and the amount of information stored, while maintaining consistent and fast performance.

Know what a information warehouse is.
A information warehouse is a central repository for data that tin come up from one or more sources. This data repository would be used for query and assay using OLAP. An organization's direction typically uses a information warehouse to compile reports on specific data. Data warehouses are usually queried with highly complex queries.

Remember that Amazon Redshift is AWS information warehouse service.
You should remember that Amazon Redshift is Amazon'due south data warehouse service. Amazon Redshift organizes the data past column instead of storing data as a series of rows. Considering only the columns Involved in the queries are candy and columnar information is storage sequentially on the storage media, cavalcade-based systems crave far fewer I/Os, which greatly improves query performance. Another advantage of columnar data storage is the increased compression, which tin can further reduce overall I/O.

Exercises
In society to pass the exam, you lot should practice deploying databases and creating tables using Amazon RDS, Amazon DynamoDB, and Amazon Redshift. Remember to delete whatever resources you provision to minimize any charges.

EXERCISE 7.1
Create a MySQL Amazon RDS Instance

Log in to the AWS Management Console, and navigate to the Amazon RDS Console.
Launch a new Amazon RDS DB Case, and select MySQL Community Edition example as the database engine.
Configure the DB Instance to use Multi-AZ and General Purpose (SSD) storage.
Alert: This is not eligible for AWS Free Tier; you volition incur a small accuse by provisioning this example.
Set the DB Instance identifier and database name to MySQL123, and configure the master username and password.
Validate the configuration settings, and launch the DB Example.
Render to the list of the Amazon RDS instances. You will see the condition of your
Amazon RDS database equally Creating. It may take up to 20 minutes to create your new
Amazon RDS instance.
Y'all have provisioned your first Amazon RDS instance using Multi-AZ.

EXERCISE 7.2
Simulate a Failover from 1 AZ to Some other
in this exercise, you lot will utilize Multi-AZ failover to simulate a failover from one Availability
Zone to some other.

ln the Amazon RDS Panel, view the list of DB Instances.
Find your DB Case chosen MySQL123, and cheque its status. When its status is Bachelor, proceed to the next step.
Select the instance, and result a Reboot command from the deportment carte.
Ostend the reboot.
You lot have now simulated a failover from one Availability Zone to some other using Multi-AZ failover. The failover should have approximately two or iii minutes.

Do 7.3
Create a Read Replica
In this exercise, you will create a read replica of you existing MySQL123 DB server.

In the Amazon RDS Console, view the list of DB Instances.
Find your DB Instance called MySQL123, and Check its condition. When its condition is Available, continue to the side by side pace.
Select the instance, and outcome a Create Read Replica command from the list of deportment.
Configure the proper name of the read replica and any other settings. Create the replica.
Await for the replica to be created, which can typically take several minutes. When it is complete, delete both the MySQL123 and MYSQLReadReplica databases past clicking the checkboxes next to them, clicking the Example Actions drop-down box, and and then clicking Delete.

In the preceding exercises, you created a new Amazon RDS MySQL example with Multi-AZ enabled. You then simulated a failover from i Availability Zone to some other by rebooting the primary instance. After that, you scaled your Amazon RDS instance out by creating a read replica of the primary database. Delete the DB Instance.

EXERCISE 7.4
Read and Write from a DynamoDB Table
In this do, you will create an Amazon DynamoDB table and then read and write to it using the AWS Direction Console.

Log in to the AWS Management Console, and view the Amazon DynamoDB console.
Create a new table named UserProfile with a division key of userlD of blazon String.
Subsequently the tabular array has been created, view the list of items in the table.
Using the Amazon DynamoDB console, create and save a new item in the tabular array. Set the userlD to U01, and append another Cord attribute called name with a value of Joe.
Perform a scan on the table to retrieve the new item.
You take now created a elementary Amazon DynamoDB table, put a new item, and retrieved it using Scan. Delete the DynamoDB tabular array.

EXERCISE 7.v
Launch a Redshift Cluster
In this practice, y'all will create a data warehouse using Amazon Redshift and so read and write to it using the AWS Management Console.

Log in to the AWS Management Console, and view the Amazon Redshift Console.
Create a new cluster, configuring the database proper noun, username, and password.
Configure the cluster to be single node using i SSD-backed storage node.
Launch the cluster into an Amazon VPC using the advisable security group.
Install and configure SQL Workbench on your local computer, and connect to the new cluster.
Create a new table and load data using the Re-create command.
You accept now created an Amazon Redshift cluster and connected to it using a standard SQL customer. Delete the cluster when you have completed the practise.

Review Questions
Which AWS database service is best suited for traditional Online Transaction Processing (OLTP)?
Amazon Redshift
Amazon Relational Database Service (Amazon RDS)
Amazon Glacier
Elastic Database

Which AWS database service is best suited for non-relational database?

Amazon Redshift
Amazon Relational Database Service (Amazon RDS)
Amazon Glacier
Amazon DynamoDB

You are a solutions architect working for a media company that hosts its website on AWS. Currently, there is a single Amazon Rubberband Compute Cloud (Amazon EC2) Instance on AWS with MySQL installed locally to that Amazon EC2 Instance. Yous have been asked to make the visitor'due south production surround more resilient and to increase performance. You advise that the company divide out the MySQL database onto an Amazon RDS instance with Multi-AZ enabled. This addresses the company's increased resiliency requirements. Now you need to suggest how you tin increase performance. Ninety-nine percent of the company's end users are magazine subscribers who will be reading additional articles on the website, then only one percent of stop users will need to write information to the site. What should yous suggest to increase performance?

Alter the connection cord so that if a user is going to write information, it is written to the secondary copy of the Multi—AZ database.
Alter the connection string so that if a user is going to write data, it is written to the primary copy of the Multi-AZ database.
Recommend that the company use read replicas, and distribute the traffic across multiple read replicas.
Migrate the MySQL database to Amazon Redshift to accept advantage of columnar storage and maximize performance.

Which AWS Deject service is best suited for Online Analytics Processing (OLAP)?

Amazon Redshift
Amazon Relational Database Service (Amazon RDS)
Amazon Glacier
Amazon DynamoDB
Yous have been using Amazon Relational Database Service (Amazon RDS) for the last yr to run an important application with automatic backups enabled. I of your team members is performing routine maintenance and accidentally drops an important table, causing an outage. How can you recover the missing information while minimizing the duration of the outage?
Perform an undo performance and recover the table.
Restore the database from a recent automated DB snapshot.
Restore only the dropped tabular array from the DB snapshot.
The data cannot be recovered.

Which Amazon Relational Database Service (Amazon RDS) database engines support Multi-AZ?

All of them
Microsoft SQL Server, MySQL, and Oracle
Oracle, Amazon Aurora, and PostgreSQL
MySQL

Which Amazon Relational Database Service (Amazon RDS) database engines support read replicas?

Microsoft SQL Server Oracle
MySQL, MariaDB, PostgreSQL, and Aurora
Aurora, Microsoft SQL Server, and Oracle
MySQL and PostgreSQL

Your team is edifice an order processing organization that will span multiple Availability Zones. During testing, the squad wanted to test how the awarding will react to a database failover. How can you enable this type of test?

Force a Multi-AZ failover from one Availability Zone to some other past rebooting the primary instance using the Amazon RDS console.
End the DB instance, and create a new one. Update the connexion string.
Create a support case asking for a failover.
It is non possible to test a failover.

You are a system ambassador whose company has moved its production database to AWS. Your visitor monitors its estate using Amazon CloudWatch, which sends alarms using Amazon Unproblematic Notification Service (Amazon SNS) to your mobile phone. One night, you go an alert that your principal Amazon Relational Database Service (Amazon RDS) Instance has gone down. You have Multi-AZ enabled on this instance. What should y'all do to ensure the failover happens apace?

Update your Domain Name System (DNS) to point to the secondary example's new IP address, forcing your application to fail over to the secondary example.
Connect to your server using Secure Trounce (SSH) and update your connexion strings so that your application tin can communicate to the secondary case instead of the failed primary case.
Take a snapshot of the secondary instance and create a new instance then using this snapshot, then update your connection string to point to the new instance.
No activity is necessary. Your connection cord points to the database endpoint, and AWS automatically updates this endpoint to point to your secondary instance.

You are working for a small organisation without a dedicated database ambassador on staff. You lot need to install Microsoft SQL Server Enterprise edition chop-chop to back up an bookkeeping back function application on Amazon Relational Database Service (Amazon RDS). What should you do?

Launch an Amazon RDS DB Case, and select Microsoft SQL Server Enterprise Edition under the Bring Your Own License (BYOL) model.
Provision SQL Server Enterprise Edition using the License Included option from the Amazon RDS Panel.
SQL Server Enterprise edition is simply available via the Command Line Interface (CLI). Install the command-line tools on your laptop, and then provision your new Amazon RDS Instance using the CLI.
Y'all cannot utilize SQL Server Enterprise edition on Amazon RDS. Yous should install this on to a dedicated Amazon Rubberband Compute Cloud (Amazon EC2) Instance.

You are edifice the database tier for an enterprise application that gets occasional activity throughout the day. Which storage blazon should yous select as your default selection?

Magnetic storage
General Purpose Solid State Drive (SSD)
Provisioned IOPS (SSD)
Storage Area Network (SAN)-attached

You are designing an eastward-commerce web awarding that will scale to potentially hundreds of thousands of concurrent users. Which database applied science is best suited to hold the session country for large numbers of concurrent users?

Relational database using Amazon Relational Database Service (Amazon RDS)
NoSQL database table using Amazon DynamoDB
Data warehouse using Amazon Redshift
Amazon Uncomplicated Storage Service (Amazon S3)

Which of the following techniques can you use to help y'all meet Recovery Point Objective and (RPO) requirements? (Choose three answers)

DB snapshots
DB option groups
Read replica
Multi—AZ deployment

When using Amazon Relational Database Service (Amazon RDS) Multi-AZ, how can you lot offload read requests from the primary? (Choose 2 answers)

Configure the connection string of the clients to connect to the secondary node and perform reads while the primary is used for writes.
Amazon RDS automatically sends writes to the primary and sends reads to the secondary.
Add together a read replica DB example, and configure the client'due south application logic to use a read-replica.
Create a caching environment using ElastiCache to cache frequently used data. Update the application logic to read/write from the cache.

You are building a large club processing system and are responsible for securing the database. Which actions will you take to protect the data? (Choose 3 answers)

Adjust AWS Identity and Access Management (IAM) permissions for administrators.
Configure security groups and network Access Control Lists (ACLs) to limit network admission.
Configure database users, and grant permissions to database objects.
Install anti-virus software on the Amazon RDS DB Instance.

Your squad manages a popular website running Amazon Relational Database Service (Amazon RDS) MySQL back end. The Marketing department has just informed you about an upcoming telly commercial that volition drive thousands of new visitors to the website. How can y'all set up your database to handle the load? (Choose 3 answers)

Vertically scale the DB Instance by selecting a more than powerful instance class.
Create read replicas to offload read requests and update your application.
Upgrade the storage from Magnetic volumes to General Purpose Solid State Drive (SSD) volumes.
Upgrade to Amazon Redshift for faster columnar storage.
You are building a photo direction awarding that maintains metadata on millions of images in an
Amazon DynamoDB tabular array. When a photo is retrieved, you lot want to display the metadata next to the image. Which Amazon DynamoDB operation will you use to recollect the metadata attributes from the table?
Scan performance
Search functioning
Query operation
Find operation

Y'all are creating an Amazon DynamoDB table that will contain letters for a social chat awarding. This table will have the following attributes: Username (Cord), Timestamp (Number), Message (String). Which aspect should you utilise equally the sectionalization cardinal? The sort key?

Username, Timestamp
Username, Bulletin
Timestamp, Message
Bulletin, Timestamp

Which of the following statements about Amazon DynamoDB tables are truthful (Choose 2 answers)?

Global secondary indexes can only be created when the table is being created.
Local secondary indexes tin but exist created when the table is being created.
Yous can only have one global secondary index.
You lot can only have ane local secondary index.

Which of the following workloads are a good fit for running on Amazon Redshift? (Choose 2 answers)

Transactional database supporting a busy e-commerce order processing Website
Reporting database supporting back-function analytics
Data warehouse used to amass multiple disparate data sources
Manage session state and user contour data for thousands of concurrent users

AWS Certified Solutions Builder Associate Tutorials – IAM – 2019 – Part-1

AWS Certified Solutions Builder Associate Tutorials – IAM – 2019 – Part-two

AWS Certified Solutions Architect Acquaintance Tutorials – S3 – 2019 – Part-3

AWS Certified Solutions Architect Acquaintance Tutorials – S3 – 2019 – Office-four

AWS Certified Solutions Architect Associate Tutorials – SQS-SNS – 2019 – Part-5

AWS Certified Solutions Builder Acquaintance Tutorials – SNS-WATCH-TRAIL-LAMBDA – 2019 – Office-half dozen

AWS Certified Solutions Architect Acquaintance Tutorials – CloudFormation – 2019 – Part-7

AWS Certified Solutions Architect Associate Tutorials – DynamoDB – 2019 – Part-8

AWS Certified Solutions Architect Associate Tutorials – Redshift – 2019 – Function-9

AWS Certified Solutions Architect Associate Tutorials – Route53 – 2019 – Part-10

AWS Certified Solutions Architect Associate Tutorials – RDS-SNOWBALL – 2019 – Part-xi

AWS Certified Solutions Architect Acquaintance Tutorials – VPC – 2019 – Part-12

AWS Certified Solutions Architect Associate Tutorials – VPC – 2019 – Part-13

AWS Certified Solutions Architect Associate Tutorials – VPC – 2019 – Role-14

Author
Contempo Posts

Mentor for DevOps - DevSecOps - SRE - Cloud - Container & Micorservices at Cotocus

Website - www.RajeshKumar.xyz
Electronic mail - Contact@DevOpsSchool.com

I tin can help in the following:
- DevOps - DevSecOps - SRE
- Continuous Integration & Commitment
- Continuous Deployment & Inspection
- Technical Debt Reduction
- Containerization/Micro Services Using Kubernetes & Docker
- Deject Migration using AWS-Azure-GoogleCloud
- Enterprise observability