ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 421 - SAP-C02 discussion

Report
Export

A company deploys a new web application. As pari 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 day's AWS WAF logs into one log file.
Answers
A.
Create an AWS Lambda function that consolidates each day's 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.
Answers
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.
Answers
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.
Answers
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.
Suggested answer: D

Explanation:

The best solution is to modify the Kinesis Data Firehose configuration and Athena table definition to partition the data by date and time. This will reduce the amount of data scanned by Athena and improve the query performance. Changing the Athena query to view the relevant partitions will also help to filter out unnecessary data. This solution requires minimal operational overhead as it does not involve creating additional resources or changing the log format.Reference:[AWS WAF Developer Guide], [Amazon Kinesis Data Firehose User Guide], [Amazon Athena User Guide]

asked 16/09/2024
DMITRY Yunov
33 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first