Exam AWS Certified Solutions Architect - Professional topic 1 question 932 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Professional

Question #: 932
Topic #: 1

[All AWS Certified Solutions Architect - Professional Questions]

A company deploys a new web application. As part of the setup, the company configures AWS WAF to log to Amazon S3 through Amazon Kinesis Data Firehose.
The company develops an Amazon Athena query that runs once daily to return AWS WAF log data from the previous 24 hours. The volume of daily logs is constant. However, over time, the same query is taking more time to run.
A solutions architect needs to design a solution to prevent the query time from continuing to increase. The solution must minimize operational overhead.
Which solution will meet these requirements?

A. Create an AWS Lambda function that consolidates each days AWS WAF logs into one log file.
B. Reduce the amount of data scanned by configuring AWS WAF to send logs to a different S3 bucket each day.
C. Update the Kinesis Data Firehose configuration to partition the data in Amazon S3 by date and time. Create external tables for Amazon Redshift. Configure Amazon Redshift Spectrum to query the data source.
D. Modify the Kinesis Data Firehose configuration and Athena table definition to partition the data by date and time. Change the Athena query to view the relevant partitions.

Show Suggested Answer

Suggested Answer: D 🗳️

by SGES at Sept. 3, 2022, 11:54 a.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

masetromain

2 years, 5 months ago

Selected Answer: D

D. Modify the Kinesis Data Firehose configuration and Athena table definition to partition the data by date and time. Change the Athena query to view the relevant partitions. To prevent the query time from continuing to increase and minimize operational overhead, a solutions architect should modify the Kinesis Data Firehose configuration and the Athena table definition to partition the data by date and time. This will allow Athena to only scan the relevant partitions, reducing the amount of data that needs to be scanned and improving query performance. Additionally, the architect should change the Athena query to view the relevant partitions, ensuring that the query is only scanning the necessary data.

upvoted 1 times

masetromain

2 years, 5 months ago

Option A: Create an AWS Lambda function that consolidates each day's AWS WAF logs into one log file, this would reduce the number of files that Athena needs to scan, but it does not address the issue of the increasing query time. Option B: Reduce the amount of data scanned by configuring AWS WAF to send logs to a different S3 bucket each day, this would reduce the number of files that Athena needs to scan, but it does not address the issue of the increasing query time. Option C: Update the Kinesis Data Firehose configuration to partition the data in Amazon S3 by date and time. Create external tables for Amazon Redshift. Configure Amazon Redshift Spectrum to query the data source. This option is more complex and requires additional resources and maintenance,

upvoted 1 times

...