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

Questions 21–25

1. 21application · medium

   A company is planning to implement streaming data ingestion into Snowflake. They have a variety of data sources, including files in cloud storage, Kafka topics, Kinesis streams, and direct application events. They want to choose the right tool for each source. Which combination is correct?

   • ASnowpipe for files, Snowpipe Streaming API for Kafka, Kinesis connector for Kinesis, and Kafka connector for direct events.
   • BKafka connector for files, Kinesis connector for Kafka, Snowpipe for Kinesis, and Snowpipe Streaming API for direct events.
   • CSnowpipe Streaming API for all sources.
   • DSnowpipe for files, Kafka connector for Kafka, Kinesis connector for Kinesis, and Snowpipe Streaming API for direct events.
   Reveal Solution Discussion Select an answer first
2. 22expert · hard

   A company is using the Snowflake Kinesis connector to ingest data from a Kinesis stream. They are experiencing high latency during peak hours. They have already increased the number of shards in the Kinesis stream. What else should they do to reduce latency?

   • AIncrease the Kinesis retention period.
   • BIncrease the number of Snowflake Kinesis connector tasks.
   • CUse a larger Snowflake virtual warehouse.
   • DEnable Kinesis Data Streams enhanced fan-out.
   Reveal Solution Discussion Select an answer first
4. 23foundation · easy

   Which of the following is required to configure the Snowflake Kafka connector?

   • AAn external cloud storage bucket for intermediate files
   • BA Snowflake stage and file format
   • CA virtual warehouse dedicated to the connector
   • DA Snowflake user with appropriate privileges and connection details
   Reveal Solution Discussion Select an answer first
5. 24expert · hard

   A company is using the Snowpipe Streaming API to ingest data into a Snowflake table. They notice that the ingestion latency is higher than expected. They have already verified that the network is not the bottleneck. What is the most likely cause?

   • AThe virtual warehouse is too small.
   • BThe target table has too many columns.
   • CThe data is being ingested into a clustered table.
   • DThe channel is not being flushed frequently enough.
   Reveal Solution Discussion Select an answer first
6. 25expert · hard

   A company is ingesting streaming data into Snowflake. They are using Snowpipe for file-based ingestion and the Snowpipe Streaming API for direct events. They want to ensure that the data is consistent across both ingestion paths. What should they do?

   • AUse the same channel for both ingestion paths.
   • BUse the same target table for both ingestion paths and rely on Snowflake's ACID guarantees.
   • CUse a staging table for all data and then move it to the final table.
   • DUse separate tables for each ingestion path and merge them later.
   Reveal Solution Discussion Select an answer first