Q38 — AWS SAA-C03 Ch.14

Question 38 of 100 | ← Chapter 14

Q1038. 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?

Correct Answer: A. Configure Amazon Athena to read the encrypted files. Run SQL queries on the data directly in Amazon S3.

Explanation

To meet the requirements for running occasional SQL queries on encrypted Apache Parquet files stored in Amazon S3, the most cost-effective solution is:A. Configure Amazon Athena to read the encrypted files. Run SQL queries on the data directly in Amazon S3.Explanation:\1. Amazon Athena: - Athena is a serverless interactive query service that allows you to run SQL queries directly on data stored in Amazon S3. It natively supports reading Apache Parquet files and can handle various data formats, making it ideal for querying large datasets without needing to move or transform the data.\2. Support for Client-Side Encryption: - Athena can read files that are encrypted using client-side encryption with KMS-managed keys (CSE-KMS). This means you can query your encrypted Parquet files without needing to decrypt them manually or manage additional infrastructure.\3. Cost-Effectiveness: - Since Athena is serverless, you only pay for the queries you run based on the amount of data scanned. This is typically more cost-effective than provisioning and managing infrastructure, as would be required with other options like Amazon Redshift or EMR.Evaluation of Other Options:B. Use Amazon S3 Select to run SQL queries on the data directly in Amazon S3. - While S3 Select allows you to retrieve a subset of data from S3 objects using SQL, it is more limited in functionality compared to Athena, especially for complex queries involving multiple files or aggregations over large datasets.C. Configure Amazon Redshift to read the encrypted files. Use Redshift Spectrum and Redshift query editor v2 to run SQL queries on the data directly in Amazon S3. - Redshift Spectrum allows querying data in S3, but it typically involves higher costs for storage and compute resources than using Athena, particularly for occasional querying.D. Configure Amazon EMR Serverless to read the encrypted files. Use Apache SparkSQL to run SQL queries on the data directly in Amazon S3. - While EMR Serverless is a flexible option for processing data, it also introduces additional complexity and cost compared to using Athena, especially for the occasional querying needs of the company.Conclusion:Option A is the best choice for running occasional SQL queries on the data in a cost-effective manner while leveraging existing data formats and encryption methods.