Q31 — AWS SAA-C03 Ch.16

Question 31 of 100 | ← Chapter 16

Q1231. A company recently migrated a data warehouse to AWS. The company has an AWS Direct Connect connection to AWS Company users query the data warehouse by using a visualization tool.The average size of the queries that the data warehouse returns is 50 MB. The average visualization that the visualization tool produces is 500 KB in size.The result sets that the data warehouse returns are not cached.The company wants to optimize costs for data transfers between the data warehouse and the company.Which solution will meet this requirement?

Correct Answer: C. Host the visualization tool on premises. Connect to the data warehouse through the Direct Connect connection.

Explanation

To optimize costs for data transfers between the data warehouse and the visualization tool, let's analyze the options based on the given scenario:Key Requirements:Optimize Costs: The solution should minimize data transfer costs.Data Transfer Characteristics:The average query result size is 50 MB (data warehouse visualization tool). The average visualization size is 500 KB (visualization tool user). The result sets are not cached, so every query generates 50 MB of data transfer.Solution Analysis:Data Transfer Costs:AWS Data Transfer Pricing:Data transferred out of AWS (e.g., from a data warehouse to an on-premises tool via the internet) is charged at a higher rate than data transferred within the same AWS Region or via Direct Connect. Direct Connect provides a dedicated, private connection between on-premises and AWS, which can reduce or eliminate data transfer costs for data moving between on-premises and AWS (depending on the contract and usage).Internet Egress: Data transferred out of AWS over the internet is charged at a higher rate.Visualization Tool Location:Hosting the visualization tool on-premises means all query results (50 MB each) must be transferred out of AWS, incurring high egress costs.Hosting the visualization tool in the same AWS Region as the data warehouse means the 50 MB query results are transferred within the same region (no egress cost), and only the 500 KB visualizations are transferred out (much cheaper).Evaluating the Options:Option A: Host the visualization tool on premises. Connect to the data warehouse directly through the internet.Incorrect: This incurs high egress costs for the 50 MB query results (transferred out of AWS over the internet).Option B: Host the visualization tool in the same AWS Region as the data warehouse. Access the visualization tool through the internet.Partially Correct (But Not Optimal): The 50 MB query results are transferred within the same region (no egress cost), but the 500 KB visualizations are still transferred out over the internet (though this is cheaper, it is not the main cost driver here). However, the question asks for optimizing costs for data transfers between the data warehouse and the company, and the primary cost is the 50 MB egress if the tool is on- premises. This option avoids that, but it is not the most efficient if the tool is accessed via the internet (though the 500 KB is negligible). The main issue is that the tool is not accessed via Direct Connect, but the question is about data transfer costs between the warehouse and the tool, not the user. Option C: Host the visualization tool on premises. Connect to the data warehouse through the Direct Connect connection.Correct (for data transfer between warehouse and tool): The 50 MB query results are transferred over Direct Connect, which can significantly reduce or eliminate egress costs (depending on the contract). This is the most cost-effective way to transfer the 50 MB results between the data warehouse and the visualization tool.Option D: Host the visualization tool in the same AWS Region as the data warehouse. Access the visualization tool through the Direct Connect connection.Incorrect (for the given requirement): While this avoids egress costs for the 50 MB query results (they stay within AWS), the 500 KB visualizations would still need to be transferred out to the users (likely over the internet, unless the users are also connected via Direct Connect, which is not mentioned). The question is about optimizing costs for data transfers between the data warehouse and the company (i.e., the visualization tool), not the end users. However, the main cost driver is the 50 MB egress if the tool is on- premises, and this option avoids that, but it is not the most efficient for the tool-to-user transfer (though that is not the focus of the question). The main issue is that the tool is not on-premises, so the 50 MB transfer is within AWS (no egress), but the question implies the company wants to optimize the transfer between the warehouse and the tool, which is cheaper if the tool is on-premises and connected via Direct Connect.Clarifying the Best Option:The question is about optimizing costs for data transfers between the data warehouse and the company (i.e., the visualization tool). The primary cost is the 50 MB query results being transferred out of AWS if the tool is on-premises (via internet) or within AWS (no egress) if the tool is in the same region. However, if the tool is on-premises and connected via Direct Connect, the 50 MB transfer is not charged as egress (it is part of the Direct Connect contract).Thus, the most cost-effective solution is:Host the visualization tool on-premises.Connect to the data warehouse via Direct Connect to avoid egress costs for the 50 MB query results.Final Answer:C. Host the visualization tool on premises. Connect to the data warehouse through the Direct Connect connection.This minimizes data transfer costs by avoiding egress charges for the 50 MB query results (they are transferred over Direct Connect instead of the internet).