Which kind of Snowflake table stores file-level metadata for each file in a stage?

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

Comment: *

Name: *

Email: *

Verification: *

True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake feature is used for both querying and restoring data?

• A.Cluster keys
• B.Time Travel
• C.Fail-safe
• D.Cloning

Comment: *

Name: *

Email: *

Verification: *

Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory?
(Select TWO).

• A.Bytes scanned
• B.Partitions scanned
• C.Bytes spilled to local storage
• D.Bytes spilled to remote storage
• E.Percentage scanned from cache

Comment: *

Name: *

Email: *

Verification: *

Which statement best describes Snowflake tables?

• A.Snowflake tables are logical representations of underlying physical data
• B.Snowflake tables are the physical instantiation of data loaded into Snowflake
• C.Snowflake tables require that clustering keys be defined to perform optimally
• D.Snowflake tables are owned by a user

Comment: *

Name: *

Email: *

Verification: *