Which file function generates a SnowFlake-hosted URL that must be authenticated when used?

• A.GET_PRESENT_URL
• B.BUILD_STAGE_FILE_URL
• C.GET_STATE_LOCATION
• D.BUILD_SCOPED_FILE_URL

Comment: *

Name: *

Email: *

Verification: *

What does the Remote Disk I/O statistic in the Query Profile indicate?

• A.Time spent reading from the result cache.
• B.Time spent reading from the virtual warehouse cache.
• C.Time when the query processing was blocked by remote disk access.
• D.The level of network activity between the Cloud Services layer and the virtual warehouse.

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake table type persists until it is explicitly dropped. is available for all users with relevant privileges (across sessions). and has no Fail-safe period?

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

Comment: *

Name: *

Email: *

Verification: *

When is the result set cache no longer available? (Select TWO)

• A.When another warehouse is used to execute the query
• B.When another user executes the query
• C.When the underlying data has changed
• D.When the warehouse used to execute the query is suspended
• E.When it has been 24 hours since the last query

Comment: *

Name: *

Email: *

Verification: *

The effects of query pruning can be observed by evaluating which statistics? (Select TWO).

• A.Bytes scanned
• B.Bytes written
• C.Partitions total
• D.Bytes read from result
• E.Partitions scanned

Comment: *

Name: *

Email: *

Verification: *