Which Snowflake layer is always leveraged when accessing a query from the result cache?

• A.Metadata
• B.Data Storage
• C.Compute
• D.Cloud Services

Comment: *

Name: *

Email: *

Verification: *

Which Query Profile metrics can be used to determine if a query is pruning efficiently?

• A.Number of rows inserted and Number of rows updated
• B.Partitions scanned and Partitions total
• C.Bytes read from result and Bytes written to result
• D.Bytes spilled to local storage and Bytes spilled to remote storage

Comment: *

Name: *

Email: *

Verification: *

Which table function is used to perform additional processing on the results of a previously-run query?

• A.QUERY_HISTORY
• B.RESULT_SCAN
• C.DESCRIBE_RESULTS
• D.QUERY HISTORY BY SESSION

Comment: *

Name: *

Email: *

Verification: *

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

• A.A single join node uses more than 50% of the query time
• B.Partitions scanned is equal to partitions total
• C.An AggregateOperacor node is present
• D.The query is spilling to remote storage

Comment: *

Name: *

Email: *

Verification: *

What is the purpose of key-pair authentication?

• A.To encrypt data that can be accessed with one of two keys
• B.To allow multiple users to securely share data
• C.To securely authenticate a user or an application
• D.To enforce Multi-Factor Authentication, or MFA

Comment: *

Name: *

Email: *

Verification: *