nerdexam
SnowflakeSnowflake

DEA-C02 · Question #82

DEA-C02 Question #82: Real Exam Question with Answer & Explanation

Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #82. The question stem and answer options stay visible for context.

Data Movement

Question

A company has deployed a data pipeline that streams customer transaction data from an on- premises PostgreSQL database to Snowflake for real-time analytics. A Data Engineer needs to configure a connector that will continuously and reliably transfer data to Snowflake. Which connector configuration will meet these requirements, while providing MINIMAL latency, and OPTIMAL performance?

Options

  • AConfigure the Snowflake Connector for Kafka to continuously stream data from the PostgreSQL
  • BDeploy the Snowflake JDBC driver to connect the PostgreSQL database directly to Snowflake,
  • CInstall the Snowflake Connector for Python on the PostgreSQL server to stream data directly to
  • DConfigure the Snowflake Connector for Kafka on a Kafka Connect cluster to stream data from the

Unlock DEA-C02 to see the answer

You've previewed enough free DEA-C02 questions. Unlock DEA-C02 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.

Topics

#Kafka Connect#Data Streaming#Snowflake Connector for Kafka#Real-time Data Ingestion
Full DEA-C02 PracticeBrowse All DEA-C02 Questions