Free Snowflake COF-R02 Exam Dumps Questions & Answers

Which type of table corresponds to a single Snowflake session?

• A.Translent
• B.Permanent
• C.Temporary
• D.Provisional

Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)

• A.Query execution
• B.Time Travel data
• C.Security
• D.Data loading
• E.Authentication and access control

How a Snowpipe charges calculated?

• A.Per-second/per-core granularity
• B.Number of Pipes in account
• C.Per-second/per Warehouse size
• D.Total storage bucket size

Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

• A.# of clusters for the Warehouse
• B.Warehouse size
• C.Amount of data processed
• D.Number of users

What are value types that a VARIANT column can store? (Select TWO)

• A.BINARY
• B.OBJECT
• C.STRUCT
• D.ARRAY
• E.CLOB