Practice Free COF-C02 Exam Online Questions
What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?
- A . 30 days
- B . 7 days
- C . 48 hours
- D . 24 hours
What action can a user take to address query concurrency issues?
- A . Enable the query acceleration service.
- B . Enable the search optimization service.
- C . Add additional clusters to the virtual warehouse
- D . Resize the virtual warehouse to a larger instance size.
If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?
- A . Table definition
- B . Stage definition
- C . Session level
- D . COPY INTO TABLE statement
A sales table FCT_SALES has 100 million records.
The following Query was executed
SELECT COUNT (1) FROM FCT__SALES;
How did Snowflake fulfill this query?
- A . Query against the result set cache
- B . Query against a virtual warehouse cache
- C . Query against the most-recently created micro-partition
- D . Query against the metadata excite
What is a key feature of Snowflake architecture?
- A . Zero-copy cloning creates a mirror copy of a database that updates with the original
- B . Software updates are automatically applied on a quarterly basis
- C . Snowflake eliminates resource contention with its virtual warehouse implementation
- D . Multi-cluster warehouses allow users to run a query that spans across multiple clusters
- E . Snowflake automatically sorts DATE columns during ingest for fast retrieval by date
True or False: Snowpipe via REST API can only reference External Stages as source.
- A . True
- B . False
What can a Snowflake user do with the information included in the details section of a Query Profile?
- A . Determine the total duration of the query.
- B . Determine the role of the user who ran the query.
- C . Determine the source system that the queried table is from.
- D . Determine if the query was on structured or semi-structured data.
Which of the following commands cannot be used within a reader account?
- A . CREATE SHARE
- B . ALTER WAREHOUSE
- C . DROP ROLE
- D . SHOW SCHEMAS
- E . DESCRBE TABLE
The is the minimum Fail-safe retention time period for transient tables?
- A . 1 day
- B . 7 days
- C . 12 hours
- D . 0 days
Which statement about billing applies to Snowflake credits?
- A . Credits are billed per-minute with a 60-minute minimum
- B . Credits are used to pay for cloud data storage usage
- C . Credits are consumed based on the number of credits billed for each hour that a warehouse runs
- D . Credits are consumed based on the warehouse size and the time the warehouse is running