Chapter 5: Data Pipelines

Question 1

Which of the following is a way to view task execution history for tasks that use a user-managed virtual warehouse?

SELECT task_execution_history from the session.
Query the task_execution_history table in the system schema.
Query the information_schema.task_history() table function.
It is not possible to view the task execution history.

Answer 1

Query the information_schema.task_history() table function.

Question 2

Which of the following privileges is required to set a task to resumed state?

EDIT TASK privilege
EXECUTE TASK privilege
RESUME TASK privilege
ADMIN TASK privilege

Answer 2

EXECUTE TASK privilege

Question 3

Which of the following are valid scheduling approaches for tasks? (Choose all that apply.)

ON EVENT
Using CRON

<num> MINUTE
ON DATE
</num>

Answer 3

Using CRON

<num> MINUTE
</num>

Question 4

You have just created a new task. What would be the initial state of this task?

Suspended
Active
Resumed
Running

Answer 4

Suspended

Question 5

Which of the following is true regarding task trees? (Choose all that apply.)

Multiple tasks connected in a parent-child relationship form a task tree.
Only the root node can have a schedule in a task tree.
Tasks can have multiple parents.
All tasks in a tree of tasks must have the same task owner.

Answer 5

Multiple tasks connected in a parent-child relationship form a task tree.
Only the root node can have a schedule in a task tree.
All tasks in a tree of tasks must have the same task owner.

Question 6

Which of the following is true regarding serverless tasks? (Choose all that apply.)

Serverless tasks use Snowflake-managed compute resources.
Serverless tasks are billed differently and have a 1.5 multiplier when calculating credit usage.
Snowflake scales the compute up and down for serverless tasks as per workload requirements.
Serverless tasks cannot have any child tasks.

Answer 6

Serverless tasks use Snowflake-managed compute resources.
Serverless tasks are billed differently and have a 1.5 multiplier when calculating credit usage.
Snowflake scales the compute up and down for serverless tasks as per workload requirements.

Question 7

Streams are a Snowflake mechanism that provides which of the following functionalities?

Message queue capabilities
Change data capture
Data archival
Scheduled execution of SQL

Answer 7

Change data capture

Question 8

Streams can capture which of the following changes in a table? (Choose all that apply.)

INSERTs
UPDATEs
DELETEs
Table structure changes
Table name changes

Answer 8

INSERTs
UPDATEs
DELETEs

Question 9

Which of the following is true regarding streams? (Choose all that apply.)

Streams can be queried like a table.
Once a stream is created, it cannot be dropped unless the whole table is dropped.
Multiple streams can be created on the same table.
Streams don’t contain any data but are bookmarks to the data changes.

Answer 9

Streams can be queried like a table.
Multiple streams can be created on the same table.
Streams don’t contain any data but are bookmarks to the data changes.