Solutions Architect Associate (Page 39)

A company has an Amazon S3 data lake that is governed by AWS Lake Formation.The company wants to create a visualization in Amazon QuickSight by joining the data in the data lake with operational data that is stored in an Amazon Aurora MySQL database.The company wants to enforce column-level authorization so that the company’s marketing team can access only a subset of columns in the database.Which solution will meet these requirements with the LEAST operational overhead?Read More →

A company has launched an Amazon RDS for MySQL DB instance.Most of the connections to the database come from serverless applications.Application traffic to the database changes significantly at random intervals.At times of high demand, users report that their applications experience database connection rejection errors.Which solution will resolve this issue with the LEAST operational overhead?Read More →

A company is migrating an old application to AWS.The application runs a batch job every hour and is CPU intensive.The batch job takes 15 minutes on average with an on-premises server.The server has 64 virtual CPU (vCPU) and 512 GiB of memory.Which solution will run the batch job within 15 minutes with the LEAST operational overhead?Read More →

A company recently deployed a new auditing system to centralize information about operating system versions, patching, and installed software for Amazon EC2 instances.A solutions architect must ensure all instances provisioned through EC2 Auto Scaling groups successfully send reports to the auditing system as soon as they are launched and terminated.Which solution achieves these goals MOST efficiently?Read More →

A company uses Amazon API Gateway to run a private gateway with two REST APIs in the same VPC.The BuyStock RESTful web service calls the CheckFunds RESTful web service to ensure that enough funds are available before a stock can be purchased.The company has noticed in the VPC flow logs that the BuyStock RESTful web service calls the CheckFunds RESTful web service over the internet instead of through the VPC.A solutions architect must implement a solution so that the APIs communicate through the VPC.Which solution will meet these requirements with the FEWEST changes to the code?Read More →

A company hosts a frontend application that uses an Amazon API Gateway API backend that is integrated with AWS Lambda.When the API receives requests, the Lambda function loads many libraries.Then the Lambda function connects to an Amazon RDS database, processes the data, and returns the data to the frontend application.The company wants to ensure that response latency is as low as possible for all its users with the fewest number of changes to the company’s operations.Which solution will meet these requirements?Read More →

A company has implemented a self-managed DNS service on AWS.The solution consists of the following:• Amazon EC2 instances in different AWS Regions• Endpoints of a standard accelerator in AWS Global AcceleratorThe company wants to protect the solution against DDoS attacks.What should a solutions architect do to meet this requirement?Read More →

A company has a three-tier application on AWS that ingests sensor data from its users’ devices.The traffic flows through a Network Load Balancer (NLB), then to Amazon EC2 instances for the web tier, and finally to EC2 instances for the application tier.The application tier makes calls to a database.What should a solutions architect do to improve the security of the data in transit?Read More →

A manufacturing company has machine sensors that upload .csv files to an Amazon S3 bucket.These .csv files must be converted into images and must be made available as soon as possible for the automatic generation of graphical reports.The images become irrelevant after 1 month, but the .csv files must be kept to train machine learning (ML) models twice a year.The ML trainings and audits are planned weeks in advance.Which combination of steps will meet these requirements MOST cost-effectively? (Choose two.)Read More →

A company’s applications run on Amazon EC2 instances in Auto Scaling groups.The company notices that its applications experience sudden traffic increases on random days of the week.The company wants to maintain application performance during sudden traffic increases.Which solution will meet these requirements MOST cost-effectively?Read More →