Answer-first summary for fast verification
Answer: Host the visualization tool in the same AWS Region as the data warehouse and access it over a Direct Connect connection at a location in the same Region.
## Explanation This question focuses on minimizing data transfer egress costs for a data warehouse scenario. Let's analyze each option: **Key Factors to Consider:** 1. **Data transfer from AWS to internet**: Typically charged per GB 2. **Data transfer over Direct Connect**: Usually has lower costs than internet egress 3. **Location of visualization tool**: Affects where data needs to be transferred 4. **Data volumes**: Query results = 50 MB, webpages = 500 KB **Analysis of Each Option:** **A. Host the visualization tool on premises and query the data warehouse directly over the internet.** - Data warehouse (AWS) → Internet → On-premises visualization tool - All 50 MB query results transferred over internet (charged for egress) - **High cost**: Paying for internet egress for all query results **B. Host the visualization tool in the same AWS Region as the data warehouse. Access it over the internet.** - Data warehouse and visualization tool both in same AWS Region - Query results transferred within same Region (no egress charges) - Only 500 KB webpages sent over internet to users - **Lower cost**: Only small webpages use internet egress **C. Host the visualization tool on premises and query the data warehouse directly over a Direct Connect connection at a location in the same AWS Region.** - Data warehouse (AWS) → Direct Connect → On-premises visualization tool - All 50 MB query results transferred over Direct Connect - **Moderate cost**: Direct Connect typically cheaper than internet egress **D. Host the visualization tool in the same AWS Region as the data warehouse and access it over a Direct Connect connection at a location in the same Region.** - Data warehouse and visualization tool both in same AWS Region - Query results transferred within same Region (no egress charges) - Only 500 KB webpages sent over Direct Connect to users - **Lowest cost**: No egress charges for query results, minimal data over Direct Connect **Why Option D is the BEST:** 1. **No data transfer charges for query results**: Since both data warehouse and visualization tool are in the same AWS Region, the 50 MB query results stay within the Region (no egress charges) 2. **Minimal data over Direct Connect**: Only the 500 KB webpages need to go over Direct Connect to reach corporate users 3. **Direct Connect vs Internet**: Even if webpages went over internet (Option B), Option D is still better because: - Direct Connect typically has lower data transfer costs than internet egress - More predictable pricing with Direct Connect - Better performance and reliability **Cost Comparison:** - **Option D**: ~500 KB per webpage over Direct Connect (lowest cost) - **Option B**: ~500 KB per webpage over internet (higher cost than Direct Connect) - **Option C**: 50 MB per query over Direct Connect (higher than D) - **Option A**: 50 MB per query over internet (highest cost) Therefore, **Option D provides the LOWEST data transfer egress cost** by keeping the large query results within the same AWS Region and only transferring small webpages over the cost-effective Direct Connect connection.
Ultimate access to all questions.
No comments yet.
Author: LeetQuiz Editorial Team
A company previously migrated its data warehouse solution to AWS. The company also has an AWS Direct Connect connection. Corporate office users query the data warehouse using a visualization tool. The average size of a query returned by the data warehouse is 50 MB and each webpage sent by the visualization tool is approximately 500 KB. Result sets returned by the data warehouse are not cached.
Which solution provides the LOWEST data transfer egress cost for the company?
A
Host the visualization tool on premises and query the data warehouse directly over the internet.
B
Host the visualization tool in the same AWS Region as the data warehouse. Access it over the internet.
C
Host the visualization tool on premises and query the data warehouse directly over a Direct Connect connection at a location in the same AWS Region.
D
Host the visualization tool in the same AWS Region as the data warehouse and access it over a Direct Connect connection at a location in the same Region.