Which categories are included in the execution time summary in a Query Profile? (Select TWO).

• A.Pruning
• B.Spilling
• C.Initialization
• D.Local Disk I/O
• E.Percentage of data read from cache

Comment: *

Name: *

Email: *

Verification: *

User1, who has the SYSADMIN role, executed a query on Snowsight. User2, who is in the same Snowflake account, wants to view the result set of the query executed by User1 using the Snowsight query history.
What will happen if User2 tries to access the query history?

• A.If User2 has the sysadmin role they will be able to see the results.
• B.If User2 has the securityadmin role they will be able to see the results.
• C.If User2 has the ACCOUNTADMIN role they will be able to see the results.
• D.User2 will be unable to view the result set of the query executed by User1.

Comment: *

Name: *

Email: *

Verification: *

What does Snowflake attempt to do if any of the compute resources for a virtual warehouse fail to provision during start-up?

• A.Repair the failed resources.
• B.Restart failed resources.
• C.Queue the failed resources
• D.Provision the failed resources

Comment: *

Name: *

Email: *

Verification: *

Which of the following can be executed/called with Snowpipe?

• A.A User Defined Function (UDF)
• B.A stored procedure
• C.A single copy_into statement
• D.A single insert__into statement

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake technique can be used to improve the performance of a query?

• A.Clustering
• B.Indexing
• C.Fragmenting
• D.Using INDEX__HINTS

Comment: *

Name: *

Email: *

Verification: *