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

Questions 6–10

1. 6application · medium

   A company is evaluating streaming ingestion options for a new project. They have a requirement to ingest data from a variety of sources, including files in cloud storage, Kafka topics, and direct application events. They want to use a single, unified approach. What should they do?

   • AUse Snowpipe for all sources, including Kafka and direct events.
   • BUse the Kafka connector for all sources, including files and direct events.
   • CUse Snowpipe for file-based sources, the Kafka connector for Kafka topics, and the Snowpipe Streaming API for direct events.
   • DUse the Snowpipe Streaming API for all sources, including files and Kafka.
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   How does Snowpipe automatically load data from files in cloud storage?

   • AIt requires a user to manually run a COPY INTO command after uploading files
   • BIt streams data directly from the source system without storing files in cloud storage
   • CIt monitors the stage for new files and loads them into the target table using a COPY INTO statement
   • DIt uses a scheduled task that runs every minute to copy new files
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A logistics company needs to ingest IoT sensor data from delivery vehicles. The data arrives in bursts, and they need to make it available for analysis as soon as possible. They are considering between Snowpipe and the Snowpipe Streaming API. Which factor should most influence their decision?

   • AThe need for a virtual warehouse: Snowpipe Streaming API requires a warehouse, while Snowpipe does not.
   • BThe latency requirement: Snowpipe Streaming API offers lower latency than Snowpipe for row-level data.
   • CThe data format: Snowpipe Streaming API only supports JSON, while Snowpipe supports all formats.
   • DThe cost: Snowpipe is always cheaper than the Snowpipe Streaming API.
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A company is ingesting streaming data into Snowflake and wants to minimize cost while ensuring data is not lost during ingestion. They are using Snowpipe for file-based ingestion. Which practice should they follow?

   • ALoad data as frequently as possible to minimize latency, regardless of file size.
   • BSet up error notifications and monitor Snowpipe for failed loads.
   • CUse the Snowpipe Streaming API instead of Snowpipe for all file-based ingestion.
   • DUse a dedicated virtual warehouse for Snowpipe to ensure predictable performance.
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   What is a recommended practice for ensuring reliability when ingesting streaming data into Snowflake?

   • AImplementing monitoring and alerting on ingestion pipelines
   • BUsing only manual loading to avoid automation errors
   • CUsing a single large batch load at the end of the day
   • DIgnoring error records and only loading successful ones
   Reveal Solution Discussion Select an answer first