Ingest Streaming Data DEA-C02 Practice Questions (Page 6)

Questions 26–28

1. 26foundation · easy

   Which practice is recommended to optimize cost when using Snowpipe for streaming ingestion?

   • ADisabling automatic ingestion and using manual COPY commands
   • BUsing a large virtual warehouse for all loads
   • CLoading each file as soon as it arrives, regardless of size
   • DBatching small files into larger files before loading
   Reveal Solution Discussion Select an answer first
2. 27foundation · easy

   What is the primary purpose of the Snowpipe Streaming API?

   • ATo ingest rows of data directly into Snowflake tables with low latency, without staging files
   • BTo transform data using SQL before loading it into tables
   • CTo load data from files in cloud storage stages automatically
   • DTo create and manage virtual warehouses for loading data
   Reveal Solution Discussion Select an answer first
3. 28expert · hard

   A company is using the Snowflake Kafka connector to ingest data from a Kafka topic. They need to ensure that the data is not lost if the connector fails. They also want to minimize the impact on Snowflake performance. Which configuration should they use?

   • AUse Kafka's exactly-once semantics with the connector.
   • BUse a separate Snowflake account for the connector to isolate performance.
   • CEnable Kafka's at-least-once delivery and configure Snowflake to handle duplicate records.
   • DSet the connector to use a larger batch size to reduce the number of requests to Snowflake.
   Reveal Solution Discussion Select an answer first