What is a characteristic of the Snowflake Query Profile?

• A.It can provide statistics on a maximum number of 100 queries per week.
• B.It provides a graphic representation of the main components of the query processing.
• C.It provides detailed statistics about which queries are using the greatest number of compute resources.
• D.It can be used by third-party software using the Query Profile API.

Comment: *

Name: *

Email: *

Verification: *

A user has unloaded data from Snowflake to a stage
Which SQL command should be used to validate which data was loaded into the stage?

• A.list @file__stage
• B.show @file__stage
• C.view @file__stage
• D.verify @file__stage

Comment: *

Name: *

Email: *

Verification: *

What value provides information about disk usage for operations where intermediate results do not fit in memory in a Query Profile?

• A.IO
• B.Network
• C.Pruning
• D.Spilling

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake storage object can be used to store data beyond a single session and will not incur Fail-safe costs?

• A.Permanent table
• B.Temporary table
• C.Transient table
• D.External table

Comment: *

Name: *

Email: *

Verification: *

Snowflake's access control framework combines which models for securing data? (Select TWO).

• A.Attribute-based Access Control (ABAC 1
• B.Discretionary Access Control (DAC)
• C.Access Control List (ACL)
• D.Role-based Access Control (RBAC)
• E.Rule-based Access Control (RuBAC)

Comment: *

Name: *

Email: *

Verification: *