SnowPro Advanced: Architect — Question 61

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

Answer options

• A. Every Kafka message is in JSON or Avro format.
• B. The default retention time for Kafka topics is 14 days.
• C. The Kafka connector supports key pair authentication, OAUTH, and basic authentication (for example, username and password).
• D. The Kafka connector will create one table and one pipe to ingest data for each topic. If the connector cannot create the table or the pipe it will result in an exception.

Correct answer: D

Explanation

The correct answer is D because the Kafka connector is designed to create a separate table and pipe for each Kafka topic to facilitate data ingestion. Options A, B, and C provide useful information about Kafka but do not address the specific behavior of the connector in relation to table and pipe creation.