DEA-C01 · Question #173
DEA-C01 Question #173: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #173. The question stem and answer options stay visible for context.
Question
A company has three subsidiaries. Each subsidiary uses a different data warehousing solution. The first subsidiary hosts its data warehouse in Amazon Redshift. The second subsidiary uses Teradata Vantage on AWS. The third subsidiary uses Google BigQuery. The company wants to aggregate all the data into a central Amazon S3 data lake. The company wants to use Apache Iceberg as the table format. A data engineer needs to build a new pipeline to connect to all the data sources, run transformations by using each source engine, join the data, and write the data to Iceberg. Which solution will meet these requirements with the LEAST operational effort?
Options
- AUse native Amazon Redshift, Teradata, and BigQuery connectors to build the pipeline in AWS
- BUse the Amazon Athena federated query connectors for Amazon Redshift, Teradata, and
- CUse the native Amazon Redshift connector, the Java Database Connectivity (JDBC) connector for
- DUse the native Amazon Redshift, Teradata, and BigQuery connectors in Amazon Appflow to write
Unlock DEA-C01 to see the answer
You've previewed enough free DEA-C01 questions. Unlock DEA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.