- (Exam Topic 3)
A company has an application that places hundreds of .csv files into an Amazon S3 bucket every hour. The files are 1 GB in size. Each time a file is uploaded, the company needs to convert the file to Apache Parquet format and place the output file into an S3 bucket.
Which solution will meet these requirements with the LEAST operational overhead?

1. A. Create an AWS Lambda function to download the .csv files, convert the files to Parquet format, and place the output files in an S3 bucke
2. B. Invoke the Lambda function for each S3 PUT event.
3. C. Create an Apache Spark job to read the .csv files, convert the files to Parquet format, and place the output files in an S3 bucke
4. D. Create an AWS Lambda function for each S3 PUT event to invoke the Spark job.
5. E. Create an AWS Glue table and an AWS Glue crawler for the S3 bucket where the application places the.csv file
6. F. Schedule an AWS Lambda function to periodically use Amazon Athena to query the AWS Glue table, convert the query results into Parquet format, and place the output files into an S3 bucket.
7. G. Create an AWS Glue extract, transform, and load (ETL) job to convert the .csv files to Parquet format and place the output files into an S3 bucke
8. H. Create an AWS Lambda function for each S3 PUT event to invoke the ETL job.

Correct Answer: D
https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/three-aws-glue-etl-job-types-for-converting-d

- (Exam Topic 3)
A company wants to implement a disaster recovery plan for its primary on-premises file storage volume. The file storage volume is mounted from an Internet Small Computer Systems Interface (iSCSI) device on a local storage server. The file storage volume holds hundreds of terabytes (TB) of data.
The company wants to ensure that end users retain immediate access to all file types from the on-premises systems without experiencing latency.
Which solution will meet these requirements with the LEAST amount of change to the company's existing infrastructure?

1. A. Provision an Amazon S3 File Gateway as a virtual machine (VM) that is hosted on premise
2. B. Set thelocal cache to 10 T
3. C. Modify existing applications to access the files through the NFS protoco
4. D. To recover from a disaster, provision an Amazon EC2 instance and mount the S3 bucket that contains the files.
5. E. Provision an AWS Storage Gateway tape gatewa
6. F. Use a data backup solution to back up all existing data to a virtual tape librar
7. G. Configure the data backup solution to run nightly after the initial backup is complet
8. H. To recover from a disaster, provision an Amazon EC2 instance and restore the data to an Amazon Elastic Block Store (Amazon EBS) volume from the volumes in the virtual tape library.
9. I. Provision an AWS Storage Gateway Volume Gateway cached volum
10. J. Set the local cache to 10 T
11. K. Mount the Volume Gateway cached volume to the existing file server by using iSCS
12. L. and copy all files to the storage volum
13. M. Configure scheduled snapshots of the storage volum
14. N. To recover from a disaster, restore a snapshot to an Amazon Elastic Block Store (Amazon EBS) volume and attach the EBS volume to an Amazon EC2 instance.
15. O. Provision an AWS Storage Gateway Volume Gateway stored volume with the same amount of disk space as the existing file storage volum
16. P. Mount the Volume Gateway stored volume to the existing file server by using iSCSI, and copy all files to the storage volum
17. Q. Configure scheduled snapshots of the storage volum
18. R. To recover from a disaster, restore a snapshot to an Amazon Elastic Block Store (Amazon EBS) volume and attach the EBS volume to an Amazon EC2 instance.

Correct Answer: C

- (Exam Topic 3)
A company is building a data analysis platform on AWS by using AWS Lake Formation. The platform will ingest data from different sources such as Amazon S3 and Amazon RDS. The company needs a secure solution to prevent access to portions of the data that contain sensitive information.

1. A. Create an IAM role that includes permissions to access Lake Formation tables.
2. B. Create data filters to implement row-level security and cell-level security.
3. C. Create an AWS Lambda function that removes sensitive information before Lake Formation ingests re data.
4. D. Create an AWS Lambda function that perodically Queries and removes sensitive information from Lake Formation tables.

Correct Answer: A

- (Exam Topic 3)
At part of budget planning. management wants a report of AWS billed dams listed by user. The data will be used to create department budgets. A solution architect needs to determine the most efficient way to obtain this report Information
Which solution meets these requirement?

1. A. Run a query with Amazon Athena to generate the report.
2. B. Create a report in Cost Explorer and download the report
3. C. Access the bill details from the runing dashboard and download Via bill.
4. D. Modify a cost budget in AWS Budgets to alert with Amazon Simple Email Service (Amazon SES).

Correct Answer: B

- (Exam Topic 3)
A company has a multi-tier application deployed on several Amazon EC2 instances in an Auto Scaling group. An Amazon RDS for Oracle instance is the application’s data layer that uses Oracle-specific
PL/SQL functions. Traffic to the application has been steadily increasing. This is causing the EC2 instances to become overloaded and the RDS instance to run out of storage. The Auto Scaling group does not have any scaling metrics and defines the minimum healthy instance count only. The company predicts that traffic will continue to increase at a steady but unpredictable rate before levelling off.
What should a solutions architect do to ensure the system can automatically scale for the increased traffic? (Select TWO.)

1. A. Configure storage Auto Scaling on the RDS for Oracle Instance.
2. B. Migrate the database to Amazon Aurora to use Auto Scaling storage.
3. C. Configure an alarm on the RDS for Oracle Instance for low free storage space
4. D. Configure the Auto Scaling group to use the average CPU as the scaling metric
5. E. Configure the Auto Scaling group to use the average free memory as the seeing metric

Correct Answer: AC