Q47 — AWS SAA-C03 Ch.12

Question 47 of 100 | ← Chapter 12

Q847. A company uses Salesforce. The company needs to load existing data and ongoing data changes from Salesforce to Amazon Redshift for analysis. The company does not want the data to travel over the public internet.Which solution will meet these requirements with the LEAST development effort?

Correct Answer: C. Create an AWS PrivateLink connection in the VPC to Salesforce. Use Amazon AppFlow to transfer data.

Explanation

To meet the requirements of loading existing data and ongoing data changes from Salesforce to Amazon Redshift without data traveling over the public internet, the solution with the least development effort is:C. Create an AWS PrivateLink connection in the VPC to Salesforce. Use Amazon AppFlow to transfer data.Here's why:Option C suggests creating an AWS PrivateLink connection in the VPC to Salesforce and using Amazon AppFlow to transfer data.AWS PrivateLink enables private and secure communication between VPCs and supported AWS services. By establishing a PrivateLink connection to Salesforce, you can ensure that the data transfer occurs securely within the AWS network without traversing the public internet.Amazon AppFlow is a fully managed integration service that simplifies the transfer of data between different applications. AppFlow supports Salesforce as a source and Amazon Redshift as a destination, allowing you to easily configure and automate the movement of data from Salesforce to Redshift.Using AWS PrivateLink and Amazon AppFlow requires minimal development effort compared to other options. PrivateLink provides a straightforward and secure network connection, while AppFlow abstracts the complexity of data transfer and provides an intuitive user interface for configuration.Option A suggests establishing a VPN connection from the VPC to Salesforce and using AWS Glue DataBrew for data transfer. While this option may work, it requires more development effort to set up and manage the VPN connection, and AWS Glue DataBrew may introduce additional complexity for data transfer.Option B suggests establishing an AWS Direct Connect connection from the VPC to Salesforce and using AWS Glue DataBrew for data transfer. Similar to Option A, this option requires more development effort to set up and manage Direct Connect, and AWS Glue DataBrew may introduce additional complexity.Option D suggests creating a VPC peering connection to Salesforce and using Amazon AppFlow for data transfer. VPC peering requires additional configuration and coordination with Salesforce, and AppFlow simplifies data transfer but may still require some development effort.Therefore, the recommended solution with the least development effort is to create an AWS PrivateLink connection in the VPC to Salesforce and use Amazon AppFlow to transfer data. This approach ensures secure and private communication while simplifying the data transfer process.