Free SnowPro-Core Exam Dumps

Question 101

- (Exam Topic 1)
What privileges are required to execute a task?

A. To execute a task, you need the EXECUTE TASK.
B. A task is an account-level object and can only be executed by the Account Admin role.
C. Tasks run automatically and do run under any rote.
D. Tasks are stored in a special database called the utility database and require EXECUTE TASK privilege in the utility database.

Correct Answer:A

Question 102

- (Exam Topic 2)
Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

A. Standard
B. Premium
C. Enterprise
D. Business Critical

Correct Answer:D
https://docs.snowflake.com/en/user-guide/privatelink-azure.html

Question 103

- (Exam Topic 1)
How would you execute a series of SQL statements using Task?

A. include the SQL statements in the body of the task create task mytask.. as insert into target1 select., from stream_s1 where ..INSERT INTO target2 SELECT .. FROM stream .s1 where ..
B. A stored procedure can have only one DML statement per stored procedure invocation and therefore you should sequence stored procedures calls in the task definition CREATE TASK mytask.... AS call stored_prc1(); call stored_proc2t);
C. A stored procedure executing multiple SQL statements and invoke the stored procedure from the task.CREATE TASK mytask.... AS callstored_proc_multiple_statements_inside():
D. Create a task for each SQL statement (e.
E. resulting in task1. task2, etc) and string the series of SQL statements by having a control task calling task 1, task 2 sequentially.

Correct Answer:C

Question 104

- (Exam Topic 1)
Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?
Select one.

A. 1 Hour
B. 3 Hours
C. 12 hours
D. 24 hours

Correct Answer:D
Reference: https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse

Question 105

- (Exam Topic 3)
Which Snowflake architectural layer is responsible for a query execution plan?

A. Compute
B. Data storage
C. Cloud services
D. Cloud provider

Correct Answer:D