AWS RDS/Dynamo DB

You are working for a small organization that does not have a database administrator and the organization needs to install a database on the cloud quickly to support an accounting application used by thousands of users. The application will act as a backend and will perform (CRUD) operations such as create, read, update and delete as well as inner joins.

Which database is best suited for this scenario?

• Redshift

• 
  

  DynamoDB

• 
  

  ElastiCache

• RDS

As a Senior Developer, you manage 10 Amazon EC2 instances that make read-heavy database requests to the Amazon RDS for PostgreSQL. You need to make this architecture resilient for disaster recovery.

Which of the following features will help you prepare for database disaster recovery? (Select two)

• Use RDS Provisioned IOPS (SSD) Storage in place of General Purpose (SSD) Storage

• Use cross-Region Read Replicas

• Use database cloning feature of the RDS DB cluster

• Enable the automated backup feature of Amazon RDS in a multi-AZ deployment that creates backups across multiple Regions

• Enable the automated backup feature of Amazon RDS in a multi-AZ deployment that creates backups in a single AWS Region

A company has recently launched a new gaming application that the users are adopting rapidly. The company uses RDS MySQL as the database. The development team wants an urgent solution to this issue where the rapidly increasing workload might exceed the available database storage.

As a developer associate, which of the following solutions would you recommend so that it requires minimum development effort to address this requirement?

• Enable storage auto-scaling for RDS MySQL

• Migrate RDS MySQL database to Aurora which offers storage auto-scaling

• Create read replica for RDS MySQL

• Migrate RDS MySQL database to DynamoDB which automatically allocates storage space when required

An application has a database in an AWS RDS Instance. When the traffic is high, the application’s response time grows as there are many read queries to the RDS database. Which of the following can be used to decrease the response time for the application?

• 
  Enable Read Replicas for the database.

• Place a CloudFront distribution in front of the database.

• Enable Multi-AZ for the database.

• Change the database from RDS to DynamoDB.

A Developer is migrating an on-premises application to the AWS Cloud. The application currently uses Microsoft SQL, encrypting some of the data using Transparent Data Encryption. Which service should the Developer use to minimize code changes?

• Amazon DynamoDB

• 
  

  Amazon Redshift

• Amazon Aurora

• Amazon RDS

A popular mobile game uses CloudFront, Lambda, and DynamoDB for its backend services. The player data is persisted on a DynamoDB table and the static assets are distributed by CloudFront. However, there are a lot of complaints that saving and retrieving player information is taking a lot of time.  To improve the game’s performance, which AWS service can you use to reduce DynamoDB response times from milliseconds to microseconds?

• DynamoDB Auto Scaling

• Amazon ElastiCache

• AWS Device Farm

• Amazon DynamoDB Accelerator (DAX)

A company currently has an Augment Reality (AR) mobile game that has a serverless backend. It is using a DynamoDB table which was launched using the AWS CLI to store all the user data and information gathered from the players and a Lambda function to pull the data from DynamoDB. The game is being used by millions of users each day to read and store data. How would you design the application to improve its overall performance and make it more scalable while keeping the costs low? (Select TWO.)

• Use AWS SSO and Cognito to authenticate users and have them directly access DynamoDB using single-sign on. Manually set the provisioned read and write capacity to a higher RCU and WCU

• Configure CloudFront with DynamoDB as the origin; cache frequently accessed data on the client device using ElastiCache.

• Since Auto Scaling is enabled by default, the provisioned read and write capacity will adjust automatically. Also enable DynamoDB Accelerator (DAX) to improve the performance from milliseconds to microseconds.

• Enable DynamoDB Accelerator (DAX) and ensure that the Auto Scaling is enabled and increase the maximum provisioned read and write capacity.

• Use API Gateway in conjunction with Lambda and turn on the caching on frequently accessed data and enable DynamoDB global replication.

A Solutions Architect created a brand new IAM User with a default setting using AWS CLI. This is intended to be used to send API requests to Amazon S3, DynamoDB, Lambda, and other AWS resources of the company’s cloud infrastructure. Which of the following must be done to allow the user to make API calls to the AWS resources?

• Do nothing as the IAM User is already capable of sending API calls to your AWS resources.

• Enable Multi-Factor Authentication for the user.

• Assign an IAM Policy to the user to allow it to send API calls.

• Create a set of Access Keys for the user and attach the necessary permissions.