How to Become SnowPro-Core Certified?
SnowPro-Core is one of the most well known manufacturers of snowboards in the entire world. But how did they get where they are today? And why should you become SnowPro-Certified yourself? In this article we will answer these questions and more.
Question No 1:
Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):
A. SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
B. SECURITYADMIN ACCOUNTADMIN, SYSADMIN
C. SECURITYADMIN, ACCOUNTADMIN
Question No 2:
Which of the following DML commands isn’t supported by Snowflake?
D. TRUNCATE TABLE
Question No 3:
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 call
D. Create a task for each SQL statement (e.g. resulting in task1. task2, etc) and string the series of SQL statements by having a control task
calling task 1, task 2 sequentially.