Which Snowflow object does not consume and storage costs?

• A.Secure view
• B.Materialized view
• C.Temporary table
• D.Transient table

Comment: *

Name: *

Email: *

Verification: *

Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

• A.INSERT INTO TABLE SELECT FROM STREAM
• B.UPDATE TABLE FROM STREAM
• C.BEGIN COMMIT
• D.ALTER TABLE AS SELECT FROM STREAM
• E.SELECT FROM STREAM

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)

• A.Storage expands without the requirement to add more compute
• B.Growth of storage and compute are tightly coupled together
• C.Compute can be scaled up or down without the requirement to add more storage
• D.Multiple compute clusters can access stored data without contention

Comment: *

Name: *

Email: *

Verification: *

By default, which role has access to the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function?

• A.ACCOUNTADMIN
• B.SECURITYADMIN
• C.SYSADMIN
• D.ORGADMIN

Comment: *

Name: *

Email: *

Verification: *

True or False: The COPY command must specify a File Format in order to execute.

• A.False
• B.True

Comment: *

Name: *

Email: *

Verification: *