AWS Certified Data Analytics – Specialty — Question 98

An ecommerce company is migrating its business intelligence environment from on premises to the AWS Cloud. The company will use Amazon Redshift in a public subnet and Amazon QuickSight. The tables already are loaded into Amazon Redshift and can be accessed by a SQL tool.
The company starts QuickSight for the first time. During the creation of the data source, a data analytics specialist enters all the information and tries to validate the connection. An error with the following message occurs: `Creating a connection to your data source timed out.`
How should the data analytics specialist resolve this error?

Answer options

• A. Grant the SELECT permission on Amazon Redshift tables.
• B. Add the QuickSight IP address range into the Amazon Redshift security group.
• C. Create an IAM role for QuickSight to access Amazon Redshift.
• D. Use a QuickSight admin user for creating the dataset.

Correct answer: B

Explanation

The correct answer is B because Amazon QuickSight needs to be allowed through the Amazon Redshift security group to establish a connection, which is achieved by adding its IP address range. Option A is incorrect as permissions alone won't resolve connectivity issues. Option C is also not the right solution since IAM roles pertain more to permissions than to network access. Option D does not address the underlying connection timeout issue.