SAA-C03 · Question #12
A marketing company receives a large amount of new clickstream data in Amazon S3 from a marketing campaign The company needs to analyze the clickstream data in Amazon S3 quickly. Then the company…
The correct answer is B. Configure an AWS Glue crawler to crawl the data. Configure Amazon Athena to query the data. AWS Glue Crawler: AWS Glue is a fully managed ETL (Extract, Transform, Load) service that makes it easy to prepare and load data for analytics. A Glue crawler can automatically discover new data and schema in Amazon S3, making it easy to keep the data catalog up-to-date…
Question
A marketing company receives a large amount of new clickstream data in Amazon S3 from a marketing campaign The company needs to analyze the clickstream data in Amazon S3 quickly. Then the company needs to determine whether to process the data further in the data pipeline. Which solution will meet these requirements with the LEAST operational overhead?
Options
- ACreate external tables in a Spark catalog Configure jobs in AWS Glue to query the data
- BConfigure an AWS Glue crawler to crawl the data. Configure Amazon Athena to query the data.
- CCreate external tables in a Hive metastore. Configure Spark jobs in Amazon EMR to query the
- DConfigure an AWS Glue crawler to crawl the data. Configure Amazon Kinesis Data Analytics to
How the community answered
(50 responses)- A4% (2)
- B76% (38)
- C8% (4)
- D12% (6)
Explanation
AWS Glue Crawler: AWS Glue is a fully managed ETL (Extract, Transform, Load) service that makes it easy to prepare and load data for analytics. A Glue crawler can automatically discover new data and schema in Amazon S3, making it easy to keep the data catalog up-to-date. Crawling the Data: Set up an AWS Glue crawler to scan the S3 bucket containing the clickstream data. The crawler will automatically detect the schema and create/update the tables in the AWS Glue Data Catalog. Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using Once the data catalog is updated by the Glue crawler, use Athena to query the clickstream data Operational Efficiency: This solution leverages fully managed services, reducing operational overhead. Glue crawlers automate data cataloging, and Athena provides a serverless, pay-per- query model for quick data analysis without the need to set up or manage infrastructure.
Community Discussion
No community discussion yet for this question.