Frank Lloyd Wright
An analytics application is currently performing its queries against your main production RDS database. These queries run at any time of the day and slow down the RDS database which impacts your users' experience. What should you do to improve the users' experience?
Setup a Read Replica – This will be a dedicated connection string for your analytics application, and now it won’t impact the main production RDS database
What is the maximum number of read replicas you can have on an RDS database?
5
Name 4 out of the 6 of the database types that RDS supports
MySQL, PostgreSQL, MariaDB, Oracle, MS SQL Server, Amazon Aurora
Which database type helps you store relational datasets, with SQL language compatibility and the capability of processing transactions such as insert, update, and delete?
Amazon RDS
Amazon Aurora supports what two types of databases?
MySQL and PostgresSQL
You would like to create a disaster recovery strategy for your RDS PostgreSQL database so that in case of a regional outage the database can be quickly made available for both read and write workloads in another AWS Region. The DR database must be highly available. What do you recommend?
Create a Read Replica in a different region and enable Multi-AZ on the Read Replica
What is the maximum size of an item in a DynamoDB Table?
400KB
Select the True statement
Read Replica uses Asynchronous Replication and Multi-AZ uses Synchronous Replication
You are looking to perform Online Transaction Processing (OLTP). You would like to use a database that has built-in auto-scaling capabilities and provides you with the maximum number of replicas for its underlying storage. What AWS Service do you use?
Amazon Aurora
You have a lot of log files stored in an S3 bucket that you want to perform a quick analysis of to filter the logs and find users that attempted to make an unauthorized action. Which AWS service allows you to do so (without managed servers if possible…)?
Amazon Athena
As a solutions Architect a startup company asked you for help as they are working on an architecture for a social media website where users can be friends with each other, and like each other’s posts. The company plan on performing some complicated queries such as “What are the number of likes on the posts that have been posted by the friends of Mike?”. Which database do you recommend?
Amazon Neptune
How many Aurora Read Replicas can you have in a single Aurora DB Cluster?
15
Which RDS Database Technology does NOT support IAM Database Authentication?
Oracle
You want to migrate an on-premise MongoDB NSQL database to AWS. You don’t want to manage any database servers, so you want to use a managed NoSQL database, preferably Serverless, that provides you with high availability, durability, and reliability. Which database should you choose?
Amazon DynamoDB
Your application running on a fleet of EC2 instances managed by an Auto Scaling Group behind an Application Load Balancer. Users have to constantly log back in and you don't want to enable Sticky Sessions on your ALB as you fear it will overload some EC2 instances. What should you do?
Store Session data in ElastiCache
You have developed a mobile application that uses DynamoDB as its datastore. You currently automate sending welcome emails to new users after they sign up by scheduling a Lambda function to run every minute using CloudWatch Events that scans the entire table looking for new users, what’s a better way of doing this?
Enable DynamoDB Streams and configure it to invoke a Lambda function to send emails out.
What is the maximum size of an Aurora db?
128TB
An application running in production is using an Aurora Cluster as its database. Your development team would like to run a version of the application in a scaled-down application with the ability to perform some heavy workload on a need-basis. Most of the time, the application will be unused. Your CIO has tasked you with helping the team to achieve this while minimizing costs. What do you suggest?
Use Aurora Serverless
DAILY DOUBLE!
Which AWS service allows you to create, run and monitor ETL (extract, transform, and load) jobs in just a few clicks?
You are running an application in production that is leveraging DynamoDB as its datastore and is experiencing smooth sustained usage. There is a need to make the application run in development mode as well, where it will experience the unpredictable volume of requests. What is the most cost-effective solution that you recommend?
Use Provisioned Capacity Mode with Auto Scaling enabled for production and use On-Demand Capacity Mode for development
You have an e-commerce website where you are using DynamoDB as your database. You are about to enter the Christmas sale and you have a few items which are very popular and you expect that they will be read often. Unfortunately, last year due to the huge traffic you had the ProvisionedThroughputExceededException exception. What feature of DynamoDB could you use to prevent this error from happening again?
Create a DAX Cluster
What is the maximum default retention for an automated RDS backup?
7 Days, but manual snapshots can be triggered and saved indefinitely
Your RDS database is struggling to keep up with the demand of requests from your website. Your millions of users mostly read news, and you don’t post new news very often. Name two solutions that could help remedy this problem.
Implement an ElastiCache cluster, Add RDS Read Replicas
You would like to have a database that is efficient at performing analytical queries on large sets of columnar data. You would like to connect to this Data Warehouse using a reporting and dashboard tool such as Amazon Quicksight or some other BI tool. Which AWS Technology do you recommend?
Amazon Redshift
You have set up read replicas on your RDS database, but users are complaining that upon updating their social media posts, they do not see their updated posts right away… What is a possible cause for this?
Read Replicas have Asynchronous Replication, therefore it’s likely your users will only read Eventual Consistency.