DEA-C01 Question 194
Select 3Your organization uses Amazon S3 to store large volumes of data and Amazon Athena for querying the data. To streamline querying and ensure data discoverability, you decide to use AWS Glue Data Catalog. Which of the following actions are necessary to set up and utilize the AWS Glue Data Catalog effectively?
- A
Enable the AWS Glue Data Catalog as the metadata store in Athena settings.
- B
Manually assign IAM roles to each individual user querying the data.
- C
Run an AWS Glue crawler to populate the Data Catalog with table metadata.
- D
Store the raw data schema files in a separate S3 bucket for manual updates.
- E
Define and manage table schemas directly in the AWS Glue Data Catalog.
Show answer and explanation
Correct answers: A, C, E
Explanation
To effectively utilize the AWS Glue Data Catalog, you need to integrate it with Athena by enabling it as the metadata store, populate the catalog by running crawlers to automatically detect table metadata, and manage table schemas directly in the Glue Data Catalog. This ensures seamless data discoverability and querying across services.
- A. Correct.
Correct: To integrate Athena with the AWS Glue Data Catalog, you must enable the Glue Data Catalog as the metadata store in Athena settings.
- B. Incorrect.
Incorrect: IAM roles should be assigned to services or groups of users, not manually to individual users, to follow AWS best practices for security and scalability.
- C. Correct.
Correct: AWS Glue crawlers are used to automatically scan data in S3 and populate the Data Catalog with table metadata, making it easier to query.
- D. Incorrect.
Incorrect: Storing raw schema files in S3 for manual updates is unnecessary as the AWS Glue Data Catalog manages schemas automatically using crawlers or manual definitions.
- E. Correct.
Correct: You can define and manage table schemas directly within the AWS Glue Data Catalog for use by services like Athena or EMR.