1. An ecommerce company has noticed performance degradation of its Amazon RDS based web application. The performance degradation is attributed to an increase in the number of read-only SQL queries triggered by business analysts. A solution architect needs to solve the problem with minimal changes to the existing web application.What should the solution architect recommend?
A) Load the data into Amazon ElastiCache and have the business analysts run their queries. B) Export the data to Amazon DynamoDB and have the business analysts run their queries. C) Create a read replica of the primary database and have the business analysts run their queries. D) Copy the data into an Amazon Redshift cluster and have the business analysts run their queries.
2. A company is planning to build a new web application on AWS. The company expects predictable traffic most of the year and very high traffic on occasion. The web application needs to be highly available and fault tolerant with minimal latency.What should a solutions architect recommend to meet these requirements?
A) Use Amazon EC2 instances in an Auto Scaling group with an Application Load Balancer across multiple Availability Zones. B) Use an Amazon Route 53 routing policy to distribute requests to two AWS Regions, each with one Amazon EC2 instance. C) Use Amazon EC2 instances in a cluster placement group and include the cluster placement group within a new Auto Scaling group. D) Use Amazon EC2 instances in a cluster placement group with an Application Load Balancer across multiple Availability Zones.
3. A company running an on-premises application is migrating the application to AWS to increase its elasticity and availability. The current architecture uses a Microsoft SQL Server database with heavy read activity. The company wants to explore alternate database options and migrate database engines, if needed.Every 4 hours, the development team does a full copy of the production database to populate a test database. During this period, users experience latency.What should a solution architect recommend as replacement database?
A) Use Amazon RDS for MySQL with a Multi-AZ deployment and read replicas, and use the standby instance for the test database. B) Use Amazon Aurora with Multi-AZ Aurora Replicas and restore snapshots from Amazon RDS for the test database. C) Use Amazon Aurora with Multi-AZ Aurora Replicas and restore from mysqldump for the test database. D) Use Amazon RDS for SQL Server with a Multi-AZ deployment and read replicas, and restore snapshots from RDS for the test database.
4. A leasing company generates and emails PDF statements every month for all its customers. Each statement is about 400 KB in size. Customers can download their statements from the website for up to 30 days from when the statements were generated. At the end of their 3-year lease, the customers are emailed a ZIP file that contains all the statements.What is the MOST cost-effective storage solution for this situation?
A) Store the statements using the Amazon S3 Standard storage class. Create a lifecycle policy to move the statements to Amazon S3 One Zone-Infrequent Access (S3 One Zone-IA) storage after 30 days. B) Store the statements using the Amazon S3 Standard-Infrequent Access (S3 Standard-IA) storage class. Create a lifecycle policy to move the statements to Amazon S3 Glacier storage after 30 days. C) Store the statements using the Amazon S3 Standard storage class. Create a lifecycle policy to move the statements to Amazon S3 Glacier storage after 1 day. D) Store the statements using the Amazon S3 Glacier storage class. Create a lifecycle policy to move the statements to Amazon S3 Glacier Deep Archive storage after 30 days.
5. A company is running a highly sensitive application on Amazon EC2 backed by an Amazon RDS database. Compliance regulations mandate that all personally identifiable information (PII) be encrypted at rest.Which solution should a solutions architect recommend to meet this requirement with the LEAST amount of changes to the infrastructure?
A) Configure SSL encryption using AWS Key Management Service customer master keys (AWS KMS CMKs) to encrypt database volumes. B) Deploy AWS CloudHSM, generate encryption keys, and use the customer master key (CMK) to encrypt database volumes. C) Configure Amazon Elastic Block Store (Amazon EBS) encryption and Amazon RDS encryption with AWS Key Management Service (AWS KMS) keys to encrypt instance and database volumes. D) Deploy AWS Certificate Manager to generate certificates. Use the certificates to encrypt the database volume.
1. Right Answer: C Explanation:
2. Right Answer: A Explanation:
3. Right Answer: D Explanation: https://aws.amazon.com/getting-started/hands-on/create-microsoft-sql-db/
Leave a comment