Free Snowflake COF-C03 Exam Dumps Questions & Answers

A user needs to implement a Slowly Changing Dimension Type 2 to track historical changes.
Which action will accomplish this?

• A.  Use a stream on the source or staging table with a task that runs a MERGE to expire current rows and insert new versioned rows with effective dates.
• B.  Use Snowpipe for automatic ingestion and materialized views to propagate changes into the dimension table for versioning.
• C.  Enable CHANGE_TRACKING on the dimension table and use a scheduled task to run a MERGE that reads only changed rows.
• D.  Use Time Travel with periodic clones to snapshot the dimension and reconstruct its history using views.

In which use cases does Snowflake apply egress charges?

• A.  Database replication
• B.  Loading data into Snowflake
• C.  Query result retrieval
• D.  Data sharing within a specific region

At what level is the MIN_DATA_RETENSION_TIME_IN_DAYS parameter set?

• A.  Table
• B.  Database
• C.  Account
• D.  Schema

Which statement about billing applies to Snowflake credits?

• A.  Credits are used to pay for cloud data storage usage
• B.  Credits are consumed based on the warehouse size and the time the warehouse is running
• C.  Credits are billed per-minute with a 60-minute minimum
• D.  Credits are consumed based on the number of credits billed for each hour that a warehouse runs

What metadata does Snowflake store for rows in micro-partitions? (Select TWO).

• A.  Distinct values
• B.  Null values
• C.  Index values
• D.  Range of values
• E.  Sorted values