SAA-C03 · Question #37
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
Sign in or unlock SAA-C03 to reveal the answer and full explanation for question #37. The question stem and answer options stay visible for context.
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
Unlock SAA-C03 to see the answer
You've previewed enough free SAA-C03 questions. Unlock SAA-C03 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.