Fail-safe is unavailable on which table types?

• A.Translent
• B.Permanent
• C.Provisional
• D.Temporary

Comment: *

Name: *

Email: *

Verification: *

Which statements are true of micro-partitions?
Choose 2 answers

• A.They are approximately 16MB in size
• B.They are stored compressed only if COMPRESS=TRUE on Table
• C.They are Immutable
• D.They are only encrypted in the Enterprise edition and above

Comment: *

Name: *

Email: *

Verification: *

When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:
Select one.

• A.Concurrency
• B.Performance

Comment: *

Name: *

Email: *

Verification: *

In a Snowflake role hierarchy, what is the top-level role?

• A.ACCOUNTADMIN
• B.SYSADMIN
• C.ORGADMIN
• D.SECURITYADMIN

Comment: *

Name: *

Email: *

Verification: *

How would you execute a series of SQL statements using Task?

• A.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.
• B.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 ..
• C.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);
• D.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():

Comment: *

Name: *

Email: *

Verification: *