SnowPro Advanced: Architect — Question 42

What is a characteristic of loading data into Snowflake using the Snowflake Connector for Kafka?

Answer options

• A. The Connector only works in Snowflake regions that use AWS infrastructure.
• B. The Connector works with all file formats, including text, JSON, Avro, Ore, Parquet, and XML.
• C. The Connector creates and manages its own stage, file format, and pipe objects.
• D. Loads using the Connector will have lower latency than Snowpipe and will ingest data in real time.

Correct answer: D

Explanation

The correct answer is D because the Snowflake Connector for Kafka is designed to provide real-time data ingestion with lower latency compared to Snowpipe. Options A, B, and C are incorrect as they either misrepresent the capabilities of the Connector or limit its functionality to specific conditions.