ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Solutions Architect - Professional SAP-C02 All Questions

View all questions & answers for the AWS Certified Solutions Architect - Professional SAP-C02 exam
Go to Exam

Exam AWS Certified Solutions Architect - Professional SAP-C02 topic 1 question 468 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Professional SAP-C02
Question #: 468
Topic #: 1
[All AWS Certified Solutions Architect - Professional SAP-C02 Questions]

A company deploys workloads in multiple AWS accounts. Each account has a VPC with VPC flow logs published in text log format to a centralized Amazon S3 bucket. Each log file is compressed with gzip compression. The company must retain the log files indefinitely.

A security engineer occasionally analyzes the logs by using Amazon Athena to query the VPC flow logs. The query performance is degrading over time as the number of ingested logs is growing. A solutions architect must improve the performance of the log analysis and reduce the storage space that the VPC flow logs use.

Which solution will meet these requirements with the LARGEST performance improvement?

  • A. Create an AWS Lambda function to decompress the gzip files and to compress the files with bzip2 compression. Subscribe the Lambda function to an s3:ObjectCreated:Put S3 event notification for the S3 bucket.
  • B. Enable S3 Transfer Acceleration for the S3 bucket. Create an S3 Lifecycle configuration to move files to the S3 Intelligent-Tiering storage class as soon as the files are uploaded.
  • C. Update the VPC flow log configuration to store the files in Apache Parquet format. Specify hourly partitions for the log files.
  • D. Create a new Athena workgroup without data usage control limits. Use Athena engine version 2.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by CMMC at March 19, 2024, 3:31 p.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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
AzureDP900
5 months, 3 weeks ago
C is correct -- The Parquet format is designed for efficient querying, and hourly partitions allow Athena to quickly scan through the logs. This combination will result in the largest performance improvement for log analysis compared to other options.
upvoted 2 times
...
TonytheTiger
1 year ago
Selected Answer: C
Option C : https://aws.amazon.com/about-aws/whats-new/2021/10/amazon-vpc-flow-logs-parquet-hive-prefixes-partitioned-files/ New features to make it faster, easier and more cost efficient to store and run analytics on your Amazon VPC Flow Logs
upvoted 4 times
...
pangchn
1 year, 1 month ago
Selected Answer: C
C Using AWS Athena with parquet files is faster and cheaper than using other formats like CSV and JSON based file structures, according to AWS Athena pricing "compressing your data allows Athena to scan less data, and converting your data to columnar formats allows Athena to selectively read only required columns to process the data, which leads to cost savings and improved performance https://www.linkedin.com/pulse/aws-athena-parquet-vs-csv-ahmed-fayed/
upvoted 4 times
...
lasithasilva709
1 year, 1 month ago
Selected Answer: C
Apache Parquet is compressed, efficient columnar data representation https://parquet.apache.org/docs/overview/motivation/
upvoted 2 times
...
Dgix
1 year, 1 month ago
Selected Answer: C
C is correct.
upvoted 1 times
...
CMMC
1 year, 1 month ago
Selected Answer: C
Apache Parquet format to enable a highly optimized columnar storage format and partitioning by hour for improving the Athena query performance
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago