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

Questions 16–20

1. 16expert · hard

   A company is using Snowpipe to load data from files and the Snowpipe Streaming API for direct events. They want to minimize the total cost of ingestion. What should they do?

   • AUse Snowpipe for file-based data and the Streaming API for direct events, and monitor usage to optimize.
   • BUse Snowpipe for all data, including direct events, by writing them to files first.
   • CUse the Streaming API for all data, including file-based data, by reading files and inserting rows.
   • DUse a virtual warehouse to load all data manually.
   Reveal Solution Discussion Select an answer first
2. 17application · medium

   A media company runs Apache Kafka on-premises and wants to stream user activity events into Snowflake for real-time analytics. They need to ensure that the ingestion pipeline is resilient to Kafka broker failures and can handle high throughput. Which configuration should they use?

   • AConfigure the Snowflake Kafka connector to consume from the Kafka topic and write to Snowflake, using the Snowpipe Streaming API for low-latency ingestion.
   • BUse the Kinesis connector to consume from Kafka and write to Snowflake.
   • CWrite a custom application that reads from Kafka and uses the Snowpipe REST API to load data.
   • DSet up a separate Snowpipe for each Kafka partition to load data from files that the connector writes to a stage.
   Reveal Solution Discussion Select an answer first
4. 18application · medium

   A company is using the Snowpipe Streaming API to ingest data into Snowflake. They want to ensure that the data is available for querying as soon as possible after ingestion. What should they configure?

   • ASet the flush interval of the channel to a low value.
   • BUse a larger batch size for the channel.
   • CEnable automatic clustering on the target table.
   • DUse a virtual warehouse to process the data.
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   What is the role of the Snowflake Amazon Kinesis connector?

   • ATo manage Kinesis stream shards from Snowflake
   • BTo transform Kinesis records using Snowflake SQL before delivery
   • CTo consume records from Kinesis streams and load them into Snowflake tables
   • DTo copy data from Snowflake tables into Kinesis streams
   Reveal Solution Discussion Select an answer first
6. 20application · medium

   A company is using Snowpipe to load data from an S3 bucket. They notice that some files are not being loaded. They have verified that the files are in the correct bucket and the stage is configured correctly. What should they check next?

   • ACheck the Snowpipe error notifications and the COPY history for the pipe.
   • BCheck if the virtual warehouse is running.
   • CCheck if the S3 bucket has versioning enabled.
   • DCheck if the files are in a subdirectory of the stage.
   Reveal Solution Discussion Select an answer first