AdView Inc. wants to build a single SageMaker Data Wrangler flow that joins an S3 CSV of campaign logs with a Redshift table of customer profiles and then exports the cleaned, joined dataset to Parquet. The Redshift cluster is in a private subnet. What is the correct sequence of actions to implement this in Data Wrangler while ensuring connectivity and correctness?
Choose an answer
Tap an option to check your answer.
Correct answer: Upload the S3 CSV as a Data Wrangler dataset and add Redshift as another dataset in the flow using the Redshift JDBC credentials. Add a Join transform in the flow specifying join keys. Configure the Data Wrangler flow processing/export to run in a VPC with subnets and security groups that allow access to the Redshift cluster, and ensure the IAM role used by Data Wrangler has permission to access S3 and the Redshift credentials..
Why this is the answer
The correct option outlines the necessary steps for Data Wrangler to access a private Redshift cluster and perform the join. Data Wrangler can directly connect to Redshift using JDBC credentials. For Data Wrangler to access resources in a private subnet, it must be configured to run within a VPC that has network connectivity (subnets, security groups) to the Redshift cluster. The associated IAM role needs permissions for both S3 and Redshift. The incorrect options propose unfeasible or less direct methods. Data Wrangler does not automatically create a Redshift database proxy. Exporting both datasets to S3 and using Glue ETL for the join bypasses Data Wrangler's capabilities for data preparation and transformation. Performing a federated query from Redshift to S3 and expecting Data Wrangler to push the join down without network configuration is incorrect; Data Wrangler needs direct access to both data sources for its join transformation.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed