A business need a data warehouse system that stores data consistently and in a highly organized fashion. The organization demands rapid response times for end-user inquiries including current-year data, and users must have access to the whole 15-year dataset when necessary. Additionally, this solution must be able to manage a variable volume of incoming inquiries. Costs associated with storing the 100 TB of data must be maintained to a minimum.
Which solution satisfies these criteria?

1. A. Leverage an Amazon Redshift data warehouse solution using a dense storage instance type while keeping all the data on local Amazon Redshift storag
2. B. Provision enough instances to support high demand.
3. C. Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent dat
4. D. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum laye
5. E. Provision enough instances to support high demand.
6. F. Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent dat
7. G. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum laye
8. H. Enable Amazon Redshift Concurrency Scaling.
9. I. Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent dat
10. J. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum laye
11. K. Leverage Amazon Redshift elastic resize.

Correct Answer: C
https://docs.aws.amazon.com/redshift/latest/dg/concurrency-scaling.html
"With the Concurrency Scaling feature, you can support virtually unlimited concurrent users and concurrent queries, with consistently fast query performance. When concurrency scaling is enabled, Amazon Redshift automatically adds additional cluster capacity when you need it to process an increase in concurrent read
queries. Write operations continue as normal on your main cluster. Users always see the most current data, whether the queries run on the main cluster or on a concurrency scaling cluster. You're charged for concurrency scaling clusters only for the time they're in use. For more information about pricing, see Amazon Redshift pricing. You manage which queries are sent to the concurrency scaling cluster by configuring WLM queues. When you enable concurrency scaling for a queue, eligible queries are sent to the concurrency scaling cluster instead of waiting in line."

A company wants to migrate its on-premises MySQL databases to Amazon RDS for MySQL. To comply with the company’s security policy, all databases must be encrypted at rest. RDS DB instance snapshots must also be shared across various accounts to provision testing and staging environments.
Which solution meets these requirements?

1. A. Create an RDS for MySQL DB instance with an AWS Key Management Service (AWS KMS) customer managed CM
2. B. Update the key policy to include the Amazon Resource Name (ARN) of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.
3. C. Create an RDS for MySQL DB instance with an AWS managed CM
4. D. Create a new key policy to include the Amazon Resource Name (ARN) of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.
5. E. Create an RDS for MySQL DB instance with an AWS owned CM
6. F. Create a new key policy to include the administrator user name of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.
7. G. Create an RDS for MySQL DB instance with an AWS CloudHSM ke
8. H. Update the key policy to include the Amazon Resource Name (ARN) of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.

Correct Answer: A
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ShareSnapshot.html

A database specialist has been entrusted by an ecommerce firm with designing a reporting dashboard that visualizes crucial business KPIs derived from the company's primary production database running on Amazon Aurora. The dashboard should be able to read data within 100 milliseconds after an update.
The Database Specialist must conduct an audit of the Aurora DB cluster's present setup and provide a
cost-effective alternative. The solution must support the unexpected read demand generated by the reporting dashboard without impairing the DB cluster's write availability and performance.
Which solution satisfies these criteria?

1. A. Turn on the serverless option in the DB cluster so it can automatically scale based on demand.
2. B. Provision a clone of the existing DB cluster for the new Application team.
3. C. Create a separate DB cluster for the new workload, refresh from the source DB cluster, and set up ongoing replication using AWS DMS change data capture (CDC).
4. D. Add an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on CPU consumption.

Correct Answer: D

A company is using 5 TB Amazon RDS DB instances and needs to maintain 5 years of monthly database backups for compliance purposes. A Database Administrator must provide Auditors with data within 24 hours. Which solution will meet these requirements and is the MOST operationally efficient?

1. A. Create an AWS Lambda function to run on the first day of every month to take a manual RDS snapshot.Move the snapshot to the company’s Amazon S3 bucket.
2. B. Create an AWS Lambda function to run on the first day of every month to take a manual RDS snapshot.
3. C. Create an RDS snapshot schedule from the AWS Management Console to take a snapshot every 30days.
4. D. Create an AWS Lambda function to run on the first day of every month to create an automated RDS snapshot.

Correct Answer: A
Unlike automated backups, manual snapshots aren't subject to the backup retention period. Snapshots don't expire. For very long-term backups of MariaDB, MySQL, and PostgreSQL data, we recommend exporting snapshot data to Amazon S3. If the major version of your DB engine is no longer supported, you can't restore to that version from a snapshot. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CreateSnapshot.html

A gaming company wants to deploy a game in multiple Regions. The company plans to save local high scores in Amazon DynamoDB tables in each Region. A Database Specialist needs to design a solution to automate the deployment of the database with identical configurations in additional Regions, as needed. The solution should also automate configuration changes across all Regions.
Which solution would meet these requirements and deploy the DynamoDB tables?

1. A. Create an AWS CLI command to deploy the DynamoDB table to all the Regions and save it for future deployments.
2. B. Create an AWS CloudFormation template and deploy the template to all the Regions.
3. C. Create an AWS CloudFormation template and use a stack set to deploy the template to all the Regions.
4. D. Create DynamoDB tables using the AWS Management Console in all the Regions and create a step-by- step guide for future deployments.

Correct Answer: C
https://aws.amazon.com/blogs/aws/use-cloudformation-stacksets-to-provision-resources-across-multiple-aws-ac https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/stacksets-concepts.html