A company needs a data warehouse solution that keeps data in a consistent, highly structured format. The company requires fast responses for end-user queries when looking at data from the current year, and users must have access to the full 15-year dataset, when needed. This solution also needs to handle a fluctuating number incoming queries. Storage costs for the 100 TB of data must be kept low.
Which solution meets these requirements?

• A.Leverage an Amazon Redshift data warehouse solution using a dense storage instance type while keeping all the data on local Amazon Redshift storage. Provision enough instances to support high demand.
• B.Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum layer. Provision enough instances to support high demand.
• C.Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum layer. Enable Amazon Redshift Concurrency Scaling.
• D.Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum layer. Leverage Amazon Redshift elastic resize.

Comment: *

Name: *

Email: *

Verification: *

A company is building a new web platform where user requests trigger an AWS Lambda function that performs an insert into an Amazon Aurora MySQL DB cluster. Initial tests with less than 10 users on the new platform yielded successful execution and fast response times. However, upon more extensive tests with the actual target of 3,000 concurrent users, Lambda functions are unable to connect to the DB cluster and receive too many connections errors.
Which of the following will resolve this issue?

• A.Edit the my.cnf file for the DB cluster to increase max_connections
• B.Increase the instance size of the DB cluster
• C.Change the DB cluster to Multi-AZ
• D.Increase the number of Aurora Replicas

Comment: *

Name: *

Email: *

Verification: *

An ecommerce company is using Amazon DynamoDB as the backend for its order-processing application.
The steady increase in the number of orders is resulting in increased DynamoDB costs. Order verification and reporting perform many repeated GetItem functions that pull similar datasets, and this read activity is contributing to the increased costs. The company wants to control these costs without significant development efforts.
How should a Database Specialist address these requirements?

• A.Use an Amazon ElastiCache for Redis in front of DynamoDB to boost read performance
• B.Use DynamoDB Accelerator to offload the reads
• C.Use AWS DMS to migrate data from DynamoDB to Amazon DocumentDB
• D.Use Amazon DynamoDB Streams and Amazon Kinesis Data Firehose to push the data into AmazonRedshift

Comment: *

Name: *

Email: *

Verification: *

A Database Specialist modified an existing parameter group currently associated with a production Amazon RDS for SQL Server Multi-AZ DB instance. The change is associated with a static parameter type, which controls the number of user connections allowed on the most critical RDS SQL Server DB instance for the company. This change has been approved for a specific maintenance window to help minimize the impact on users.
How should the Database Specialist apply the parameter group change for the DB instance?

• A.Select the option to apply the change immediately
• B.Allow the preconfigured RDS maintenance window for the given DB instance to control when the change is applied
• C.Apply the change manually by rebooting the DB instance during the approved maintenance window
• D.Reboot the secondary Multi-AZ DB instance

Comment: *

Name: *

Email: *

Verification: *

A gaming company is developing a new mobile game and decides to store the data for each user in Amazon DynamoDB. To make the registration process as easy as possible, users can log in with their existing Facebook or Amazon accounts. The company expects more than 10,000 users.
How should a database specialist implement access control with the LEAST operational effort?

• A.Use web identity federation on the mobile app and create individual IAM users with credentials to access DynamoDB.
• B.Use web identity federation on the mobile app and AWS STS with an attached IAM role to get temporary credentials to access DynamoDB.
• C.Use a self-developed user management system on the mobile app that lets users access the data from DynamoDB through an API.
• D.Use a single IAM user on the mobile app to access DynamoDB.

Comment: *

Name: *

Email: *

Verification: *