You have enabled logs for a classic load balancer.
There is a need to perform SQL queries on the log files.
Which of the below actions would you perform.
Choose 2 answers from the options given below.
Click on the arrows to vote for the correct answer
A. B. C. D.Answer - A and C.
Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL.
So first ensure the logs are copied to S3.
For more information on ELB access log collection, please refer to the below URL:
http://docs.aws.amazon.com/elasticloadbalancing/latest/classic/access-log-collection.htmlWhen logs are enabled for a classic load balancer, the log files are stored in Amazon S3 bucket or Amazon CloudWatch Logs. In order to perform SQL queries on the log files, you need to copy the log files to a service that allows you to perform SQL queries.
There are two options to perform SQL queries on the log files:
A. Configure the logs to be copied to S3 B. Configure the logs to be copied to Athena
Option A: Configure the logs to be copied to S3 You can configure the logs to be copied to Amazon S3, which is a highly durable and scalable object storage service provided by AWS. S3 provides a cost-effective way to store log files for long-term retention and easy access. Once the logs are copied to S3, you can use a third-party tool or Amazon Athena to perform SQL queries on the log files.
Option B: Configure the logs to be copied to Athena Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. You can configure the logs to be copied to Athena, which automatically stores the log data in an optimized format for query performance. Once the logs are stored in Athena, you can use SQL to query the data and perform various analysis.
Option C: Use the Athena service to query the logs If you choose to copy the logs to Amazon S3 or Athena, you can use the Athena service to query the logs using standard SQL. Athena allows you to query large datasets stored in S3 without having to worry about infrastructure management or scaling. You can use Athena to create tables, run queries, and generate reports based on the log data.
Option D: Use the EMR service to query the logs. Amazon EMR is a managed Hadoop framework that allows you to process large amounts of data using distributed computing. EMR can be used to process log data stored in S3 or other data sources. However, EMR requires more setup and management overhead than other options, such as Athena or a third-party tool.
In summary, to perform SQL queries on log files from a classic load balancer, you can either copy the logs to S3 or Athena, and then use Athena to query the logs. These options are cost-effective and do not require additional infrastructure management. Alternatively, you can use EMR, which provides more flexibility and processing power but requires more setup and management.