Snowflake SnowPro Core Recertification - COF-R02 Free Exam Questions

A. Partitions scanned is equal to partitions total

B. A single join node uses more than 50% of the query time

C. The query is spilling to remote storage

D. An AggregateOperacor node is present

A. Percentage scanned from cache

B. Bytes sent over the network

C. Bytes scanned

D. External bytes scanned

E. Number of partitions scanned

A. Set the minimum and maximum clusters to autoscale

B. Use the standard warehouse scaling policy

C. Use the economy warehouse scaling policy

D. Configure the warehouse to a size larger than generally required

A. Use the ALTER VIEW command to update the view

B. Materialize the view to perform the changes

C. Modify the columns in the underlying table

D. Recreate the view with the required changes

A. AUTOMATIC__CLUSTERING

B. Snowpipe

C. Updating data

D. Scaling up a warehouse

E. Execute a COPY command

A. False

B. True

A. Permanent

B. Temporary

C. Provisional

D. Translent

A. Compute

B. Tri-Secret Secure

C. Cloud Services

D. Storage

A. False

B. True

A. Use auto-ingest Snowpipes to load large files in a serverless model.

B. Produce the largest files possible, reducing the overall number of files to process.

C. Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.

D. Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.

A. VARRAY

B. ARRAY

C. QUEUE

D. STRUCT

E. VARIANT

A. False

B. True

A. Metadata management

B. Infrastructure management

C. Management of the storage layer

D. Query parsing and optimization

E. Query execution