A Company Has Collected More Than 100 TB of Log

question 20

Multiple Choice

A company has collected more than 100 TB of log files in the last 24 months. The files are stored as raw text in a dedicated Amazon S3 bucket. Each object has a key of the form year-month-day_log_HHmmss.txt where HHmmss represents the time the log file was initially created. A table was created in Amazon Athena that points to the S3 bucket. One-time queries are run against a subset of columns in the table several times an hour. A data analyst must make changes to reduce the cost of running these queries. Management wants a solution with minimal maintenance overhead. Which combination of steps should the data analyst take to meet these requirements? (Choose three.)

• A) Convert the log files to Apace Avro format.
• B) Add a key prefix of the form date=year-month-day/ to the S3 objects to partition the data.
• C) Convert the log files to Apache Parquet format.
• D) Add a key prefix of the form year-month-day/ to the S3 objects to partition the data.
• E) Drop and recreate the table with the PARTITIONED BY clause. Run the ALTER TABLE ADD PARTITION statement.
• F) Drop and recreate the table with the PARTITIONED BY clause. Run the MSCK REPAIR TABLE statement.

---

Definitions:

Strategy of Litigation

The methodical and tactical use of the legal system and lawsuits to achieve a specific objective, such as civil rights, policy changes, or personal compensation.

Congressional Committee

A legislative sub-organization in the United States Congress that handles specific duties and responsibilities, aiding in the legislative process.

Iron Triangle

The policy-making relationship among the congressional committees, the bureaucracy, and interest groups.

Amicus Curiae Briefs

Amicus Curiae Briefs are legal documents filed in court cases by non-litigants with a strong interest in the subject matter, offering additional information or perspectives for the court's consideration.