Design Data Ingestion and Transformation Pipelines ARA-C01 Practice Questions (Page 3)

Questions 11–15

1. 11foundation · easy

   Which Snowflake feature tracks changes (inserts, updates, deletes) in a table and can be used to implement change data capture?

   • AStream
   • BStored procedure
   • CView
   • DTask
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   Which Snowflake object is used to schedule SQL statements to run at a specified interval or after a preceding task completes?

   • AView
   • BStored procedure
   • CTask
   • DStream
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   Which approach is commonly used to validate data quality during a data pipeline in Snowflake?

   • AUsing the QUALITY_CHECK function
   • BUsing the COPY INTO command with the VALIDATE option
   • CRunning SELECT queries to check for NULLs or anomalies
   • DRelying on the source system to ensure data quality
   Reveal Solution Discussion Select an answer first
5. 14application · medium

   A retail company receives clickstream data from its website in JSON files that are appended to an S3 bucket every 5 minutes. The data is used for near-real-time dashboards that must reflect activity within 10 minutes, and the data must also be joined with a slowly changing dimension table in Snowflake. The team wants to minimize manual intervention and avoid managing separate load jobs. Which approach should the architect recommend?

   • AConfigure Snowpipe on the external stage to automatically load new files into a staging table, then use a stream on the staging table and a task to merge changes into the final table.
   • BCreate an external stage and use a Snowflake task scheduled every 5 minutes to run COPY INTO from the stage, then merge the data into the target table.
   • CSet up a Kafka connector to stream the JSON files from S3 into Snowflake using Snowpipe Streaming, bypassing the need for staging tables.
   • DUse an external table over the S3 bucket and query it directly in the dashboard, joining with the dimension table at query time.
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   Which factor most directly influences the parallelism of a COPY INTO operation in Snowflake?

   • AThe file format used
   • BThe size of the warehouse
   • CThe number of files in the stage
   • DThe ON_ERROR setting
   Reveal Solution Discussion Select an answer first