AWS Certified Data Engineer Associate · Free Practice Question Medium
Question 19
A multinational corporation wants to aggregate, analyze, and visualize logs from various AWS services and on-premises resources for business intelligence. The solution must provide capabilities for log aggregation, analysis, and building interactive visualizations for reporting and decision-making purposes.
Which combination of AWS services should the corporation use to meet these requirements for log aggregation, analysis, and visualization?
-
A
Use AWS CloudTrail for log aggregation, Amazon EMR for analysis, and Amazon S3 for visualization.
-
B
Use Amazon CloudWatch for log aggregation, Amazon Athena for analysis, and Amazon QuickSight for visualization.
-
C
Use Amazon Kinesis Data Firehose for log aggregation, Amazon RDS for analysis, and Amazon EC2 for visualization.
-
D
Use AWS Glue for log aggregation, Amazon Redshift for analysis, and AWS Lambda for visualization.
Reveal correct answer
Correct answer: B
Explanation
This combination offers a comprehensive solution for the corporation's needs. Amazon CloudWatch effectively aggregates logs from various AWS services and on-premises resources.
Amazon Athena can then be used to analyze these logs with SQL queries. It is serverless, making it easy to query large amounts of log data without the need for infrastructure management.
Finally, Amazon QuickSight can be used to create interactive visualizations and business intelligence reports from the analyzed data. QuickSight's integration with Athena allows for easy visualization of query results, providing insights for decision-making
CORRECT: "Use Amazon CloudWatch for log aggregation, Amazon Athena for analysis, and Amazon QuickSight for visualization" is the correct answer (as explained above.)
INCORRECT: "Use AWS Glue for log aggregation, Amazon Redshift for analysis, and AWS Lambda for visualization" is incorrect.
AWS Glue is primarily an ETL service and not specifically used for log aggregation. Amazon Redshift is a powerful data warehouse service suitable for analysis, but it's more complex and resource-intensive than needed for log analysis. AWS Lambda is a serverless computing service and is not specialized in data visualization.
INCORRECT: "Use AWS CloudTrail for log aggregation, Amazon EMR for analysis, and Amazon S3 for visualization" is incorrect.
AWS CloudTrail is used for auditing AWS account activity and is not a log aggregation tool for business intelligence purposes. Amazon EMR is used for big data processing but is a more complex solution than needed for log analysis in this context. Amazon S3 is a storage service and does not provide visualization capabilities.
INCORRECT: "Use Amazon Kinesis Data Firehose for log aggregation, Amazon RDS for analysis, and Amazon EC2 for visualization" is incorrect.
Amazon Kinesis Data Firehose is used for real-time streaming data, but it's not the best fit for log aggregation in this scenario. Amazon RDS is a relational database service and might not be the optimal choice for log analysis. Amazon EC2 provides compute capacity and does not specialize in data visualization.
References:
https://docs.aws.amazon.com/quicksight/latest/user/create-a-data-set-athena.html
Save time with our AWS cheat sheets:
https://digitalcloud.training/aws-certified-data-engineer-associate-cheat-sheet/
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
