REDFSEC

PL-400 Exam

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):

Select one:

A. SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
B. SECURITYADMIN ACCOUNTADMIN, SYSADMIN
C. SECURITYADMIN, ACCOUNTADMIN
D. ACCOUNTADMIN

Answer: B

Question No 2:

Which of the following DML commands isn’t supported by Snowflake?

A. UPSERT
B. MERGE
C. UPDATE
D. TRUNCATE TABLE

Answer: A

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
stored_proc_multiple_statements_inside():
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.

Answer: C

https://www.dumpspedia.info/SnowPro-Core-questions-dumps.html