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

Questions 1–5

1. 1foundation · easy

   What is the purpose of row-level security in Snowflake?

   • ATo mask column values
   • BTo restrict which rows a user can see based on a policy
   • CTo control access to warehouses
   • DTo encrypt data at rest
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   When using Snowflake tasks for orchestration, how can you define that a task should run only after another task has successfully completed?

   • ABy setting the task's schedule to a later time
   • BBy using the AFTER clause in the task definition
   • CBy using a stored procedure to call the task
   • DBy using a stream to trigger the task
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which Snowflake feature can improve query performance on large tables by physically organizing data based on one or more columns?

   • AStreams
   • BExternal functions
   • CWarehouse sizing
   • DClustering keys
   Reveal Solution Discussion Select an answer first
5. 4expert · hard

   A media company streams user activity events from Kafka into Snowflake for real-time analytics. The pipeline uses Snowpipe Streaming, and the team has noticed that occasionally malformed JSON messages cause the pipe to fail, and the error is not visible in the Snowflake UI. The team needs to ensure that bad messages do not block the pipeline and that they are captured for later analysis. Which design should the architect implement?

   • AEnable the Snowpipe error notification feature to send alerts to an email distribution list when a load fails.
   • BConfigure the Kafka connector to send malformed messages to a dead-letter topic, and use a separate Snowpipe to load those messages into an error table.
   • CSet the Kafka connector to ignore malformed messages and continue processing, relying on Snowflake's automatic error handling.
   • DUse a Snowflake task to periodically query the PIPE_USAGE_HISTORY view and re-insert any failed messages from the Kafka topic.
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   What is the primary benefit of using streams and tasks for incremental loads compared to full reloads?

   • AIt reduces the amount of data processed
   • BIt simplifies the data model
   • CIt eliminates the need for a warehouse
   • DIt automatically cleans up old data
   Reveal Solution Discussion Select an answer first