Which solution provides the LOWEST data transfer egress cost for the company?
Host the visualization tool on premises and query the data warehouse directly over the internet.
Host the visualization tool in the same AWS Region as the data warehouse. Access it over the internet.
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.
Host the visualization tool in the same AWS Region as the data warehouse and access it over a DirectConnect connection at a location in the same Region.
Explanations:
Hosting the visualization tool on premises and querying the data warehouse over the internet incurs standard internet egress charges, which can be costly, especially with large query sizes (50 MB).
Hosting the visualization tool in the same AWS Region as the data warehouse and accessing it over the internet still results in internet egress costs for transferring data out of AWS, which does not optimize costs compared to other options.
While hosting the visualization tool on premises and using Direct Connect to query the data warehouse may reduce some costs, it still involves egress charges for transferring data from AWS to on-premises over the Direct Connect connection, making it less cost-effective than other options.
Hosting the visualization tool in the same AWS Region as the data warehouse and accessing it over Direct Connect eliminates egress charges since both services are within AWS. This setup minimizes data transfer costs while maintaining performance.
I structure that the answer is:
Host the visualization tool in the same AWS Region as the data warehouse and access it over a DirectConnect connection at a location in the same Region.