SnowPro Core Certification Exam (COF-C02) Free Questions - Part 12
Question No : 166) Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
A. CREATE_SHARE on the account
B. SHARE on databases and schemas
C. SELECT on tables used by the secure view
D. REFERENCE_USAGE on databases
Question No : 167) Which SQL command can be used to see the CREATE definition of a masking policy?
A. SHOW MASKING POLICIES
B. DESCRIBE MASKING POLICY
C. GET_DDL
D. LIST MASKING POLICIES
Question No : 168) A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table. How can this be accomplished?
A. Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
B. The transient table version cannot be retrieved after 24 hours.
C. Contact Snowflake Support to have the data retrieved from Fail-safe storage.
D. Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.
Question No : 169) Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)
A. UPDATE TABLE FROM STREAM
B. SELECT FROM STREAM
C. INSERT INTO TABLE SELECT FROM STREAM
D. ALTER TABLE AS SELECT FROM STREAM
E. BEGIN COMMIT
Question No : 170) What do the terms scale up and scale out refer to in Snowflake? (Choose two.)
A. Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
B. Scaling out adds clusters of varying sizes to a virtual warehouse.
C. Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.
D. Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.
E. Scaling up resizes a virtual warehouse so it can handle more complex workloads.
F. Scaling up adds additional database servers to an existing running cluster to handle larger workloads.
Question No : 171) Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)
A. SHOW STORAGE BY TABLE;
B. SHOW TABLES;
C. Information Schema -> TABLE_HISTORY
D. Information Schema -> TABLE_FUNCTION
E. Information Schema -> TABLE_STORAGE_METRICS
Question No : 172) Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?
A. External Tokenization
B. External Tables
C. Materialized Views
D. User-Defined Table Functions (UDTF)
Question No : 173) What type of query benefits the MOST from search optimization?
A. A query that uses only disjunction (i.e., OR) predicates
B. A query that includes analytical expressions
C. A query that uses equality predicates or predicates that use IN
D. A query that filters on semi-structured data types
Question No : 174) If a Snowflake user decides a table should be clustered, what should be used as the cluster key?
A. The columns that are queried in the select clause.
B. The columns with very high cardinality.
C. The columns with many different values.
D. The columns most actively used in the select filters.
Question No : 175) Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)
A. Bytes sent over network
B. Percentage scanned from cache
C. Partitions total
D. Bytes spilled to local storage
E. Partitions scanned
Question No : 176) What is the purpose of multi-cluster virtual warehouses?
A. To create separate data warehouses to increase query optimization
B. To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
C. To eliminate or reduce Queuing of concurrent queries
D. To allow the warehouse to resize automatically
Question No : 177) Which of the following objects are contained within a schema? (Choose two.)
A. Role
B. Stream
C. Warehouse
D. External table
E. User
F. Share
Question No : 178) Which data type can store more than one type of data structure?
A. JSON
B. BINARY
C. VARCHAR
D. VARIANT
Question No : 179) Users are responsible for data storage costs until what occurs?
A. Data expires from Time Travel
B. Data expires from Fail-safe
C. Data is deleted from a table
D. Data is truncated from a table
Question No : 180) Which feature allows a user the ability to control the organization of data in a micropartition?
A. Range Partitioning
B. Search Optimization Service
C. Automatic Clustering
D. Horizontal Partitioning
COF-C02 Answers