A Company Wants to Run Analytics on Its Elastic Load

question 64

Multiple Choice

A company wants to run analytics on its Elastic Load Balancing logs stored in Amazon S3. A data analyst needs to be able to query all data from a desired year, month, or day. The data analyst should also be able to query a subset of the columns. The company requires minimal operational overhead and the most cost-effective solution. Which approach meets these requirements for optimizing and querying the log data?

• A) Use an AWS Glue job nightly to transform new log files into .csv format and partition by year, month, and day. Use AWS Glue crawlers to detect new partitions. Use Amazon Athena to query data.
• B) Launch a long-running Amazon EMR cluster that continuously transforms new log files from Amazon S3 into its Hadoop Distributed File System (HDFS) storage and partitions by year, month, and day. Use Apache Presto to query the optimized format.
• C) Launch a transient Amazon EMR cluster nightly to transform new log files into Apache ORC format and partition by year, month, and day. Use Amazon Redshift Spectrum to query the data.
• D) Use an AWS Glue job nightly to transform new log files into Apache Parquet format and partition by year, month, and day. Use AWS Glue crawlers to detect new partitions. Use Amazon Athena to query data.

---

Definitions:

Serum Glucose Levels

The concentration of glucose in the serum part of the blood, an important indicator of metabolic health and diabetes management.

Catheter Care

The maintenance and hygiene practices involved in managing a catheter, a tube inserted in the body to drain and collect urine from the bladder.

Parenteral Nutrition

A method of feeding that bypasses the gastrointestinal tract, delivering nutrients directly into the bloodstream through an intravenous solution.

Parenteral Nutrition

A method of feeding that bypasses the gastrointestinal tract, delivering nutrients directly into the bloodstream through an intravenous line.