Question 1

A company decided to change its third-party data analytics tool to a cheaper solution. They sent a full data export on a CSV file which contains all of their analytics information. You then save the CSV file to an S3 bucket for storage. Your manager asked you to do some validation on the provided data export.

In this scenario, what is the most cost-effective and easiest way to analyze export data using standard SQL?

Options :

A : Use mysqldump client utility to load the CSV export file from S3 to a MySQL RDS instance. Run some SQL queries once the data has been loaded to complete your validation.

B : To be able to run SQL queries, use AWS Athena to analyze the export data file in S3.

C : Use a migration tool to load the CSV export file from S3 to a database that is designed for online analytic processing (OLAP) such as AWS RedShift. Run some queries once the data has been loaded to complete your validation.

D : Create a migration tool to load the CSV export file from S3 to a DynamoDB instance. Once the data has been loaded, run queries using DynamoDB.

Answer: B

Question 2

A company has an application that processes customer orders. The company hosts the application on an Amazon EC2 instance that saves the orders to an Amazon Aurora database. Occasionally when traffic is high: the workload does not process orders fast enough.

What should a solutions architect do to write the orders reliably to the database as quickly as possible?

Options :

A : Increase the instance size of the EC2 instance when traffic is high. Write orders to Amazon Simple Notification Service (Amazon SNS). Subscribe the database endpoint to the SNS topic.

B : Write orders to an Amazon Simple Queue Service (Amazon SQS) queue. Use EC2 instances in an Auto Scaling group behind an Application Load Balancer to read from the SQS queue and process orders into the database.

C : Write orders to Amazon Simple Notification Service (Amazon SNS) Subscribe the database endpoint to the SNS topic Use EC2 instances in an Auto Scaling group behind an Application Load Balancer to read from the SNS topic

D : Write orders to an Amazon Simple Queue Service (Amazon SQS) queue when the EC2 instance reaches CPU threshold limits. Use scheduled scaling of EC2 instances in an Auto Scaling group behind an Application Load Balancer to read from the SQS queue and process orders into the database

Answer: B

Question 3

A company’s web application consists of an Amazon API Gateway API in front of an AWS Lambda function and an Amazon DynamoDB database. The Lambda function handles the business logic, and the DynamoDB table hosts the data. The application uses Amazon Cognito user pools to identify the individual users of the application. A solutions architect needs to update the application so that only users who have a subscription can access premium content.

Which solution will meet this requirement with the LEAST operational overhead?

Options :

A : Enable API caching and throttling on the API Gateway API

B : Set up AWS WAF on the API Gateway API Create a rule to filter users who have a subscription

C : Apply fine-grained IAM permissions to the premium content in the DynamoDB table

D : Implement API usage plans and API keys to limit the access of users who do not have a subscription

Answer: D

Question 4

An ecommerce company runs a PostgreSQL database on premises. The database stores data by using high IOPS Amazon Elastic Block Store (Amazon EBS) block storage. The daily peak I/O transactions per second do not exceed 15,000 IOPS. The company wants to migrate the database to Amazon RDS for PostgreSQL and provision disk IOPS performance independent of disk storage capacity.

Which solution will meet these requirements MOST cost-effectively?

Options :

A : Configure the General Purpose SSD (gp2) EBS volume storage type and provision 15,000 IOPS.

B : Configure the Provisioned IOPS SSD (io1) EBS volume storage type and provision 15,000 IOPS.

C : Configure the General Purpose SSD (gp3) EBS volume storage type and provision 15,000 IOPS.

D : Configure the EBS magnetic volume type to achieve maximum IOPS.

Answer: C

Question 5

A retail company uses AWS Cloud to manage its technology infrastructure. The company has deployed its consumer-focused web application on Amazon EC2-based web servers and uses Amazon RDS PostgreSQL database as the data store. The PostgreSQL database is set up in a private subnet that allows inbound traffic from selected Amazon EC2 instances. The database also uses AWS Key Management Service (AWS KMS) for encrypting data at rest.

Which of the following steps would you recommend to facilitate secure access to the database?

Options :

A : Create a new network access control list (network ACL) that blocks SSH from the entire Amazon EC2 subnet into the database

B : Configure Amazon RDS to use SSL for data in transit

C : Use IAM authentication to access the database instead of the database user-s access credentials

D : Create a new security group that blocks SSH from the selected Amazon EC2 instances into the database

Answer: B

Higher Test Marks with Free Online SAA-C03 Exam Practice

Buying Options: