SnowPro Core Certification Exam (COF-C02) Free Questions - Part 3
Question No : 31) Will data cached in a warehouse be lost when the warehouse is resized?
A. Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
B. Yes. because the compute resource is replaced in its entirety with a new compute resource.
C. No. because the size of the cache is independent from the warehouse size
D. Yes. became the new compute resource will no longer have access to the cache encryption key
Question No : 32) Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?
A. Each Snowflake account can be hosted in a different cloud vendor and region.
B. Each Snowflake account must be hosted in a different cloud vendor and region
C. All Snowflake accounts must be hosted in the same cloud vendor and region
D. Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.
Question No : 33) What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)
A. Data can be filtered by an optional where clause
B. Incoming data can be joined with other tables
C. Columns can be reordered
D. Columns can be omitted
E. Row level access can be defined
Question No : 34) What is a responsibility of Snowflake's virtual warehouses?
A. Infrastructure management
B. Metadata management
C. Query execution
D. Query parsing and optimization
E. Management of the storage layer
Question No : 35) What tasks can be completed using the copy command? (Select TWO)
A. Columns can be aggregated
B. Columns can be joined with an existing table
C. Columns can be reordered
D. Columns can be omitted
E. Data can be loaded without the need to spin up a virtual warehouse
Question No : 36) Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
A. Load files that are approximately 25 MB or smaller.
B. Remove all dates and timestamps.
C. Load files that are approximately 100-250 MB (or larger)
D. Avoid using embedded characters such as commas for numeric data types
E. Remove semi-structured data types
Question No : 37) 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
Question No : 38) Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?
A. Pipes
B. Streams
C. Tasks
D. Procedures
Question No : 39) The fail-safe retention period is how many days?
A. 1 day
B. 7 days
C. 45 days
D. 90 days
Question No : 40) In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)
A. Bytes scanned
B. Bytes sent over the network
C. Number of partitions scanned
D. Percentage scanned from cache
E. External bytes scanned
Question No : 41) What is the purpose of an External Function?
A. To call code that executes outside of Snowflake
B. To run a function in another Snowflake database
C. To share data in Snowflake with external parties
D. To ingest data from on-premises data sources
Question No : 42) Which command can be used to load data into an internal stage?
A. LOAD
B. copy
C. GET
D. PUT
Question No : 43) What feature can be used to reorganize a very large table on one or more columns?
A. Micro-partitions
B. Clustering keys
C. Key partitions
D. Clustered partitions
Question No : 44) True or False: A Virtual Warehouse can be resized while suspended.
A. True
B. False
Question No : 45) Which of the following describes how clustering keys work in Snowflake?
A. Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.
B. Clustering keys sort the designated columns over time, without blocking DML operations
C. Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns
D. Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time
COF-C02 Answers