Which privilege on the source table is required to create an additional 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 additional stream?

Explanation:
Creating a stream is about observing changes to a table, so you need to be able to read the table's data. The SELECT privilege provides that read access, which is why it’s required to define a stream. DML privileges like INSERT, UPDATE, and DELETE control modifying the data, not reading it, so they aren’t the privileges you need to create a stream. In short, streams rely on reading the table to capture changes, so SELECT is the necessary privilege.

Creating a stream is about observing changes to a table, so you need to be able to read the table's data. The SELECT privilege provides that read access, which is why it’s required to define a stream. DML privileges like INSERT, UPDATE, and DELETE control modifying the data, not reading it, so they aren’t the privileges you need to create a stream. In short, streams rely on reading the table to capture changes, so SELECT is the necessary privilege.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy