SnowPro Core Certification Exam (COF-C02) Free Questions - Part 9
Question No : 121) Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?
A. Optimizes the virtual warehouse size and multi-cluster setting to economy mode
B. Allows a user to import the files in a sequential order
C. Increases the latency staging and accuracy when loading the data
D. Allows optimization of parallel operations
Question No : 122) Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)
A. Schemas
B. Roles
C. Secure Views
D. Stored Procedures
E. Tables
F. Secure User-Defined Functions (UDFs)
Question No : 123) What are supported file formats for unloading data from Snowflake? (Choose three.)
A. XML
B. JSON
C. Parquet
D. ORC
E. AVRO
F. CSV
Question No : 124) What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?
A. The warehouse size does not change until all queries currently running in the warehouse have completed.
B. The warehouse size does not change until all queries currently in the warehouse queue have completed.
C. The warehouse size does not change until the warehouse is suspended and restarted.
D. It does not return from the command until the warehouse has finished changing its size.
Question No : 125) Which of the following statements describe features of Snowflake data caching? (Choose two.)
A. When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
B. When the data cache is full, the least-recently used data will be cleared to make room.
C. A user can only access their own queries from the query result cache.
D. A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
E. The RESULT_SCAN table function can access and filter the contents of the query result cache.
Question No : 126) Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)
A. Data is live, ready-to-query, and can be personalized.
B. Data needs to be loaded into a cloud provider as a consumer account.
C. Data is not available for copying or moving to an individual Snowflake account.
D. Data is available without copying or moving.
E. Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.
Question No : 127) In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?
A. When the system has enough load for 2 minutes
B. When the system has enough load for 6 minutes
C. When the system has enough load for 8 minutes
D. When the system has enough load for 10 minutes
Question No : 128) A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:
1. Created a user called "CONSUMER"
2. Created a database to hold the share and an extra-small warehouse to query the data
3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share. Based on this configuration what is true of the reader account?
A. The reader account will automatically use the Standard edition of Snowflake.
B. The reader account compute will be billed to the provider account.
C. The reader account can clone data the provider has shared, but cannot re-share it.
D. The reader account can create a copy of the shared data using CREATE TABLE AS...
Question No : 129) Which command sets the Virtual Warehouse for a session?
A. COPY WAREHOUSE FROM <>;
B. SET WAREHOUSE = <>;
C. USE WAREHOUSE <>;
D. USE VIRTUAL_WAREHOUSE <>;
Question No : 130) Which of the following accurately describes shares?
A. Tables, secure views, and secure UDFs can be shared
B. Shares can be shared
C. Data consumers can clone a new table from a share
D. Access to a share cannot be revoked once granted
Question No : 131) Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)
A. The number of queries executed
B. The number of active users assigned to the warehouse
C. The size of the virtual warehouse
D. The length of time the warehouse is running
E. The duration of the queries that are executed
Question No : 132) How can a user change which columns are referenced in a view?
A. Modify the columns in the underlying table
B. Use the ALTER VIEW command to update the view
C. Recreate the view with the required changes
D. Materialize the view to perform the changes
Question No : 133) Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?
A. COPY INTO
B. CREATE PIPE
C. INSERT INTO
D. TABLE STREAM
Question No : 134) What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?
A. Standard
B. Enterprise
C. Business Critical
D. Virtual Private Snowflake
Question No : 135) What are common issues found by using the Query Profile? (Choose two.)
A. Identifying queries that will likely run very slowly before executing them
B. Locating queries that consume a high amount of credits
C. Identifying logical issues with the queries
D. Identifying inefficient micro-partition pruning
E. Data spilling to a local or remote disk
COF-C02 Answers