ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Data Analytics - Specialty All Questions

View all questions & answers for the AWS Certified Data Analytics - Specialty exam
Go to Exam

Exam AWS Certified Data Analytics - Specialty topic 1 question 14 discussion

Exam question from Amazon's AWS Certified Data Analytics - Specialty
Question #: 14
Topic #: 1
[All AWS Certified Data Analytics - Specialty Questions]

A US-based sneaker retail company launched its global website. All the transaction data is stored in Amazon RDS and curated historic transaction data is stored in Amazon Redshift in the us-east-1 Region. The business intelligence (BI) team wants to enhance the user experience by providing a dashboard for sneaker trends.
The BI team decides to use Amazon QuickSight to render the website dashboards. During development, a team in Japan provisioned Amazon QuickSight in ap- northeast-1. The team is having difficulty connecting Amazon QuickSight from ap-northeast-1 to Amazon Redshift in us-east-1.
Which solution will solve this issue and meet the requirements?

  • A. In the Amazon Redshift console, choose to configure cross-Region snapshots and set the destination Region as ap-northeast-1. Restore the Amazon Redshift Cluster from the snapshot and connect to Amazon QuickSight launched in ap-northeast-1.
  • B. Create a VPC endpoint from the Amazon QuickSight VPC to the Amazon Redshift VPC so Amazon QuickSight can access data from Amazon Redshift.
  • C. Create an Amazon Redshift endpoint connection string with Region information in the string and use this connection string in Amazon QuickSight to connect to Amazon Redshift.
  • D. Create a new security group for Amazon Redshift in us-east-1 with an inbound rule authorizing access from the appropriate IP address range for the Amazon QuickSight servers in ap-northeast-1.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by Priyanka_01 at Aug. 10, 2020, 12:59 a.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Priyanka_01
Highly Voted 3 years, 9 months ago
D any thoughts? https://docs.aws.amazon.com/quicksight/latest/user/enabling-access-redshift.html Not B: https://docs.aws.amazon.com/quicksight/latest/user/working-with-aws-vpc.html
upvoted 44 times
awssp12345
3 years, 9 months ago
Agreed
upvoted 1 times
...
Monika14Sharma
3 years, 8 months ago
D is the right answer!
upvoted 4 times
...
lakediver
3 years, 6 months ago
Agree Remember cross region ingestion is also supported ( https://aws.amazon.com/about-aws/whats-new/2014/06/29/amazon-redshift-announces-cross-region-ingestion-and-improved-query-functionality/) As of 23 Nov 21, there's a preview capability to have cross region data sharing as well https://aws.amazon.com/about-aws/whats-new/2014/06/29/amazon-redshift-announces-cross-region-ingestion-and-improved-query-functionality/
upvoted 3 times
lakediver
3 years, 6 months ago
Changing my answer to B https://aws.amazon.com/blogs/big-data/amazon-quicksight-deployment-models-for-cross-account-and-cross-region-access-to-amazon-redshift-and-amazon-rds/
upvoted 2 times
CHRIS12722222
3 years, 3 months ago
"Set up an Amazon Redshift-managed VPC endpoint between the Amazon Redshift cluster VPC and QuickSight VPC. For instructions, see Connecting to Amazon Redshift using an interface VPC endpoint." https://aws.amazon.com/blogs/big-data/amazon-quicksight-deployment-models-for-cross-account-and-cross-region-access-to-amazon-redshift-and-amazon-rds/ Option B says something very different
upvoted 1 times
...
CHRIS12722222
3 years, 3 months ago
Quicksight has no vpc. What is mentioned in the post is connection from quicksight to a vpc using vpcid subnet id and security grp id. Answer=D
upvoted 2 times
...
Load full discussion...
...
...
...
singh100
Highly Voted 3 years, 9 months ago
D. As mentioned in the link shared by Priyanka, B is not the answer. "QuickSight connects only to data located in the same AWS Region where you're currently using QuickSight. You can't connect QuickSight to data in another AWS Region, even if your VPC is configured to work across AWS Regions."
upvoted 11 times
...
teo2157
Most Recent 1 year, 6 months ago
Selected Answer: B
Hi guys, there's a new amazing IA feature in the AWS documentation called Amazon Q, if you type this question there, the answer is or "Create an Amazon Redshift cluster in the ap-northeast-1 region and copy the required data from us-east-1 Redshift" or "they can configure cross-region connectivity between QuickSight and Redshift. This involves setting up a VPC endpoint for Redshift in ap-northeast-1 region that connects to the us-east-1 Redshift cluster.", so chosing the option B as it's cheaper than the A.
upvoted 1 times
...
debasishg
1 year, 9 months ago
Selected Answer: D
D. NOT A - "cross-Region snapshots .." - expensive NOT B - "VPC endpoint.." - cross region connectivity not possible from Quicksight NOT C - "Redshift endpoint connection string .." - needs address to be added through Security Group to allow connetivity
upvoted 1 times
...
nroopa
1 year, 10 months ago
Option D
upvoted 1 times
...
NikkyDicky
1 year, 11 months ago
Selected Answer: D
Going with D
upvoted 1 times
...
Espa
2 years, 1 month ago
Selected Answer: D
D is the correct option
upvoted 1 times
...
pk349
2 years, 1 month ago
D: I passed the test
upvoted 1 times
...
Aina
2 years, 2 months ago
Definitely D. This scenario is explored in Stephane Maarek's and Abhishek Singh's Udemy practice exam set.
upvoted 1 times
...
rich_knp
2 years, 3 months ago
Selected Answer: D
D is correct
upvoted 2 times
...
flanfranco
2 years, 3 months ago
D: https://docs.aws.amazon.com/quicksight/latest/user/enabling-access-redshift.html "If you activated Amazon QuickSight in multiple AWS Regions, you can create inbound rules for each Amazon QuickSight endpoint CIDR. Doing this allows Amazon QuickSight to have access to the Amazon RDS DB instance from any AWS Region defined in the inbound rules. An Amazon QuickSight user or administrator who uses Amazon QuickSight in multiple AWS Regions is treated as a single user. In other words, even if you are using Amazon QuickSight in every AWS Region, both your Amazon QuickSight account and your users are global"
upvoted 3 times
...
[Removed]
2 years, 4 months ago
Selected Answer: D
Answer is D!
upvoted 1 times
...
cloudlearnerhere
2 years, 7 months ago
Selected Answer: D
Correct answer is D as the Redshift security group should be updated to allow inbound access from QuickSight IP addresses. Option B is wrong as QuickSight does not support cross-region access within the VPC. Option A is wrong as it leads to data duplication and is not the most efficient solution. Option C is wrong as changing the endpoint would not allow connectivity. The access needs to be enabled using security groups.
upvoted 2 times
...
Bansel
2 years, 8 months ago
D per AWS DA Course on Udemy!
upvoted 1 times
...
thirukudil
2 years, 8 months ago
Ans is D https://docs.aws.amazon.com/quicksight/latest/user/enabling-access-redshift.html
upvoted 1 times
...
pgf909
2 years, 8 months ago
B is not correct as this: https://docs.aws.amazon.com/quicksight/latest/user/vpc-finding-setup-information.html Make sure also that you use Amazon QuickSight in the same AWS Region with the VPC. You can't use QuickSight in one AWS Region and expect to connect to a VPC in a different AWS Region.
upvoted 1 times
...
LukeTran3206
2 years, 8 months ago
Selected Answer: B
https://docs.aws.amazon.com/quicksight/latest/user/vpc-creating-a-connection-in-quicksight.html AWS Region – The AWS Region where you plan to create a connection to your data source. VPC ID – The ID of the VPC that contains the data, the subnets, and the security groups that you plan to use. Subnet ID – The ID of the subnet that the QuickSight network interface is using. Security group ID – The ID of the security group. Quicksight can access using VPC ID and region so B is correct
upvoted 1 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel