SAA-C03 Question #37: Real Exam Question with Answer & Explanation

Question

A weather forecasting company collects temperature readings from various sensors on a continuous basis. An existing data ingestion process collects the readings and aggregates the readings into larger Apache Parquet files. Then the process encrypts the files by using client-side encryption with KMS managed keys (CSE-KMS). Finally, the process writes the files to an Amazon S3 bucket with separate prefixes for each calendar day. The company wants to run occasional SQL queries on the data to take sample moving averages for a specific calendar day. Which solution will meet these requirements MOST cost-effectively?

Options

• AConfigure Amazon Athena to read the encrypted files. Run SQL queries on the data directly in
• BUse Amazon S3 Select to run SQL queries on the data directly in Amazon S3.
• CConfigure Amazon Redshift to read the encrypted files Use Redshift Spectrum and Redshift query
• DConfigure Amazon EMR Serverless to read the encrypted files. Use Apache SparkSQL to run

Explanation

Amazon Athenais a serverless query service that allows you to run SQL queries directly on data stored in Amazon S3 without the need for a data warehouse. It is cost-effective because you only pay for the queries you run, and it can handleApache Parquetfiles efficiently. Additionally, Athena integrates with KMS, making it suitable for querying encrypted data. Key AWS features: Cost-Effective: Athena charges only for the data scanned by the queries, making it a more cost- effective solution compared to Redshift or EMR for occasional queries. Direct S3 Querying: Athena supports querying data directly in S3, including Parquet files, without needing to move the data. AWS Documentation: Athena's compatibility with encrypted Parquet files in S3 makes it the ideal choice for this scenario, reducing both cost and complexity.

No community discussion yet for this question.