Which privilege on the source table is required to create an initial stream?

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards
From $25.99Unlock all

Master Snowflake Data Engineer Exam. Study with flashcards and multiple choice questions, each question includes hints and explanations. Prepare for your success!

Multiple Choice

Which privilege on the source table is required to create an initial stream?

Explanation:
Reading the current contents of the source table is required to establish the stream’s starting point. A stream tracks changes by comparing future changes against a baseline snapshot of the table, and Snowflake needs the ability to read the existing data to create that baseline. The SELECT privilege on the source table provides this read access, enabling the initial setup of the stream. Privileges that only allow modifying data (INSERT, UPDATE, DELETE) don’t grant the necessary read access, so they aren’t sufficient to create the initial stream.

Reading the current contents of the source table is required to establish the stream’s starting point. A stream tracks changes by comparing future changes against a baseline snapshot of the table, and Snowflake needs the ability to read the existing data to create that baseline. The SELECT privilege on the source table provides this read access, enabling the initial setup of the stream. Privileges that only allow modifying data (INSERT, UPDATE, DELETE) don’t grant the necessary read access, so they aren’t sufficient to create the initial stream.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy