DAS-C01 · Question #51
A company currently uses Amazon Athena to query its global datasets. The regional data is stored in Amazon S3 in the us-east-1 and us-west-2 Regions. The data is not encrypted. To simplify the query…
The correct answer is B. Run the AWS Glue crawler in us-west-2 to catalog datasets in all Regions. Athena in us-west-2 resolves table locations from the Glue Data Catalog and reads directly from S3 URIs, even across regions. By running a Glue crawler in us-west-2 that catalogs the S3 data from both us-east-1 and us-west-2 buckets, all table metadata is centralized in a…
Question
A company currently uses Amazon Athena to query its global datasets. The regional data is stored in Amazon S3 in the us-east-1 and us-west-2 Regions. The data is not encrypted. To simplify the query process and manage it centrally, the company wants to use Athena in us-west- 2 to query data from Amazon S3 in both Regions. The solution should be as low-cost as possible. What should the company do to achieve this goal?
Options
- AUse AWS DMS to migrate the AWS Glue Data Catalog from us-east-1 to us-west-2.
- BRun the AWS Glue crawler in us-west-2 to catalog datasets in all Regions.
- CEnable cross-Region replication for the S3 buckets in us-east-1 to replicate data in us-west-2.
- DUpdate AWS Glue resource policies to provide us-east-1 AWS Glue Data Catalog access to us-
How the community answered
(34 responses)- A3% (1)
- B85% (29)
- C3% (1)
- D9% (3)
Explanation
Athena in us-west-2 resolves table locations from the Glue Data Catalog and reads directly from S3 URIs, even across regions. By running a Glue crawler in us-west-2 that catalogs the S3 data from both us-east-1 and us-west-2 buckets, all table metadata is centralized in a single Glue catalog. Athena in us-west-2 can then query both. This avoids the ongoing storage cost of cross-region S3 replication (Option C), which would double storage costs, and avoids the complexity of DMS or cross-catalog federation (Options A/D). Cross-region S3 data transfer costs from Athena queries are lower than continuous replication costs.
Topics
Community Discussion
No community discussion yet for this question.