What are characteristics of Snowflake network policies? (Select TWO).

• A.They can be set for any Snowflake Edition.
• B.They can be applied to roles.
• C.They restrict or enable access to specific IP addresses.
• D.They are activated using ALTER DATABASE SQL commands.
• E.They can only be managed using the ORGADMIN role.

Comment: *

Name: *

Email: *

Verification: *

Which kind of Snowflake table stores file-level metadata for each file in a stage?

• A.Directory
• B.External
• C.Temporary
• D.Transient

Comment: *

Name: *

Email: *

Verification: *

How would a user execute a series of SQL statements using a 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
• B.A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS
• C.Use 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 task1, task2, etc. sequentially.

Comment: *

Name: *

Email: *

Verification: *

What is the MINIMUM Snowftake edition that supports database replication?

• A.Standard
• B.Enterprise
• C.Business Critical
• D.Virtual Private Snowflake (VPS)

Comment: *

Name: *

Email: *

Verification: *

What factors impact storage costs in Snowflake? (Select TWO).

• A.The account type
• B.The storage file format
• C.The cloud region used by the account
• D.The type of data being stored
• E.The cloud platform being used

Comment: *

Name: *

Email: *

Verification: *