data-engineer video for an e-commerce company stores all transaction data in Amazon RDS in the us-east-1 Region. The transformed transaction data is also kept
An e-commerce company stores all transaction data in Amazon RDS in the us-east-1 Region. The transformed transaction data is also kept in the us-east-1 Region in Amazon Redshift. The data engineering team wants to improve the user experience by developing a business intelligence (BI) dashboard that highlights the sales trends over the last year. A team in India configured Amazon QuickSight in ap-south-1 Region during development. The team is experiencing connectivity issues between Amazon QuickSight in ap-south-1 Region and Amazon Redshift in us-east-1 Region. Which of the following solutions would you recommend to address this requirement?