SnowPro Core Certification Exam (COF-C02) Free Questions - Part 17
Question No : 241) A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers. How can this requirement be met?
A. Use data encryption.
B. Use dynamic data masking.
C. Use secure materialized views.
D. Revoke all roles for functional managers and end users.
Question No : 242) Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE)
A. Snowflake data and services are deployed in a single availability zone within a cloud provider's region.
B. Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.
C. Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage
D. Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage
E. All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform
F. Snowflake data and services are deployed in at least three availability zones within a cloud provider's region
Question No : 243) What is the MINIMUM Snowflake edition required to use the periodic rekeying of micropartitions?
A. Enterprise
B. Business Critical
C. Standard
D. Virtual Private Snowflake
Question No : 244) Which of the following statements apply to Snowflake in terms of security? (Choose two.)
A. Snowflake leverages a Role-Based Access Control (RBAC) model.
B. Snowflake requires a user to configure an IAM user to connect to the database.
C. All data in Snowflake is encrypted.
D. Snowflake can run within a user's own Virtual Private Cloud (VPC).
E. All data in Snowflake is compressed.
Question No : 245) The Snowflake Search Optimization Services supports improved performance of which kind of query?
A. Queries against large tables where frequent DML occurs
B. Queries against tables larger than 1 TB
C. Selective point lookup queries
D. Queries against a subset of columns in a table
Question No : 246) Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?
A. SELECT SUM (ORDER_AMT) FROM SALES;
B. SELECT AVG(ORDER_QTY) FROM SALES;
C. SELECT MIN(ORDER_AMT) FROM SALES;
D. SELECT ORDER_AMT * ORDER_QTY FROM SALES;
Question No : 247) What is cached during a query on a virtual warehouse?
A. All columns in a micro-partition
B. Any columns accessed during the query
C. The columns in the result set of the query
D. All rows accessed during the query
Question No : 248) The following JSON is stored in a VARIANT column called src of the CAR_SALES table:
A user needs to extract the dealership information from the JSON. How can this be accomplished?
A. select src:dealership from car_sales;
B. select src.dealership from car_sales;
C. select src:Dealership from car_sales;
D. select dealership from car_sales;
Question No : 249) Which formats does Snowflake store unstructured data in? (Choose two.)
A. GeoJSON
B. Array
C. XML
D. Object
E. BLOB
Question No : 250) Which of the following objects can be directly restored using the UNDROP command? (Choose two.)
A. Schema
B. View
C. Internal stage
D. Table
E. User
F. Role
Question No : 251) Which Snowflake tool would be BEST to troubleshoot network connectivity?
A. SnowCLI
B. SnowUI
C. SnowSQL
D. SnowCD
Question No : 252) What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)
A. Row level access policies
B. Data masking policies
C. Data encryption
D. Time Travel
E. External tokenization
Question No : 253) What is the minimum Snowflake edition that has column-level security enabled?
A. Standard
B. Enterprise
C. Business Critical
D. Virtual Private Snowflake
Question No : 254) The is the minimum Fail-safe retention time period for transient tables?
A. 1 day
B. 7 days
C. 12 hours
D. 0 days
Question No : 255) Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)
A. CONTENT
B. PATH
C. BYTE_SIZE
D. INDEX
E. DATATYPE
COF-C02 Answers