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

Questions 1–5

1. 1foundation · easy

   What is the primary function of the Snowflake Kafka connector?

   • ATo produce messages to Kafka topics from Snowflake tables
   • BTo consume messages from Kafka topics and write them into Snowflake tables
   • CTo transform Kafka messages using SQL before storing them
   • DTo manage Kafka cluster configuration from Snowflake
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which scenario is the most appropriate use case for streaming data ingestion into Snowflake?

   • APeriodically copying a nightly export from a transactional database into Snowflake for daily reporting
   • BContinuously loading clickstream events from a website into a Snowflake table as they occur, enabling near-real-time analytics
   • CLoading a one-time historical dataset from an on-premises data lake into Snowflake for a migration project
   • DManually uploading a CSV file from a local machine to a Snowflake stage using the web interface
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   What is the primary benefit of using streaming data ingestion in Snowflake compared to batch loading?

   • AIt eliminates the need for any data transformation before loading
   • BIt provides lower latency between data generation and data availability for querying
   • CIt automatically enforces data quality rules on every record
   • DIt reduces the total storage cost of the data in Snowflake
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which component is used by the Snowpipe Streaming API to buffer and send rows to Snowflake?

   • AA Kafka topic
   • BA virtual warehouse
   • CA client-side SDK or library that batches rows and sends them via HTTP requests
   • DA Snowflake stage
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A retail company wants to load clickstream data from JSON files that are continuously written to an Amazon S3 bucket. They need the data to appear in a Snowflake table within a few minutes of the files being written, and they want to minimize manual intervention. Which approach should they use?

   • ASet up a Kafka connector to consume the files from S3 and write them into Snowflake.
   • BCreate an external stage pointing to the S3 bucket and run a COPY INTO command every 5 minutes using a task.
   • CUse the Snowpipe Streaming API to insert rows directly into the table from the application that writes the files.
   • DConfigure Snowpipe to automatically load files from the S3 stage into the target table as soon as they are available.
   Reveal Solution Discussion Select an answer first