SnowPro Core Certification Exam (COF-C02) Free Questions - Part 16
Question No : 226) Which command can be used to load data files into a Snowflake stage?
A. JOIN
B. COPY INTO
C. PUT
D. GET
Question No : 227) What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)
A. Authentication
B. Resource management
C. Virtual warehouse caching
D. Query parsing and optimization
E. Query execution
F. Physical storage of micro-partitions
Question No : 228) A user has unloaded data from a Snowflake table to an external stage. Which command can be used to verify if data has been uploaded to the external stage named my_stage?
A. view @my_stage
B. list @my_stage
C. show @my_stage
D. display @my_stage
Question No : 229) What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?
A. The explain plan output is available graphically.
B. An explain plan can be used to conduct performance analysis without executing a query.
C. An explain plan will handle queries with temporary tables and the query profiler will not.
D. An explain plan's output will display automatic data skew optimization information.
Question No : 230) What affects whether the query results cache can be used?
A. If the query contains a deterministic function
B. If the virtual warehouse has been suspended
C. If the referenced data in the table has changed
D. If multiple users are using the same virtual warehouse
Question No : 231) What is the recommended compressed file size range for continuous data loads using Snowpipe?
A. 8-16 MB
B. 16-24 MB
C. 10-99 MB
D. 100-250 MB
Question No : 232) Which of the following is a data tokenization integration partner?
A. Protegrity
B. Tableau
C. DBeaver
D. SAP
Question No : 233) What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)
A. Custom Edition
B. Virtual Private Snowflake
C. Business Critical Edition
D. Standard Edition
E. Enterprise Edition
Question No : 234) Which of the following describes a Snowflake stored procedure?
A. They can be created as secure and hide the underlying metadata from the user.
B. They can only access tables from a single database.
C. They can contain only a single SQL statement.
D. They can be created to run with a caller's rights or an owner's rights.
Question No : 235) Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)
A. Files
B. External tables
C. Secure User-Defined Functions (UDFs)
D. Sequences
E. Streams
Question No : 236) Which Snowflake architectural layer is responsible for a query execution plan?
A. Compute
B. Data storage
C. Cloud services
D. Cloud provider
Question No : 237) What is a responsibility of Snowflake’s virtual warehouses?
A. Infrastructure management
B. Metadata management
C. Query execution
D. Query parsing and optimization
E. Permanent storage of micro-partitions
Question No : 238) Network policies can be set at which Snowflake levels? (Choose two.)
A. Role
B. Schema
C. User
D. Database
E. Account
F. Tables
Question No : 239) Using variables in Snowflake is denoted by using which SQL character?
A. @
B. &
C. $
D. #
Question No : 240) Which statement describes how Snowflake supports reader accounts?
A. A reader account can consume data from the provider account that created it and combine it with its own data.
B. A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.
C. The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.
D. The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.
COF-C02 Answers