ARA-C01 Question #29: Real Exam Question with Answer & Explanation

Question

What does a Snowflake Architect need to consider when implementing a Snowflake Connector for Kafka?

Options

• AEvery Kafka message is in JSON or Avro format.
• BThe default retention time for Kafka topics is 14 days.
• CThe Kafka connector supports key pair authentication, OAUTH. and basic authentication (for
• DThe Kafka connector will create one table and one pipe to ingest data for each topic. If the

Explanation

The Snowflake Connector for Kafka is a Kafka Connect sink connector that reads data from one or more Apache Kafka topics and loads the data into a Snowflake table. The connector supports different authentication methods to connect to Snowflake, such as key pair authentication, OAUTH, and basic authentication (for example, username and password). The connector also supports different encryption methods, such as HTTPS and SSL. The connector does not require that every Kafka message is in JSON or Avro format, as it can handle other formats such as CSV, XML, and Parquet. The default retention time for Kafka topics is not relevant for the connector, as it only consumes the messages that are available in the topics and does not store them in Kafka. The connector will create one table and one pipe to ingest data for each topic by default, but this behavior can be customized by using the snowflake.topic2table.map configuration property. If the connector cannot create the table or the pipe, it will log an error and retry the operation until it succeeds or the connector is stopped.

No community discussion yet for this question.