Which levels can apply network policies? (Choose two.)
A. Account
B. Database
C. Role
D. Schema
E. User
What causes objects in a data share to become unavailable to a consumer account?
A. The DATA_RETENTION_IT parameter in the consumer account is set to 0.
B. The consumer account runs the GRANT INPORTED PRIVILEGES command on the data share every 24 hours.
C. The objects in the data share are being deleted and the grant pattern is not re-applied systematically.
D. The consumer account acquires the data share through a private data exchange.
What unit of storage supports efficient query processing in Snowflake?
A. Blobs
B. JSON
C. Block storage
D. Micro-partitions
Snowflake Partner Connect is limited to users with a verified email address and which role?
A. SYSADMIN
B. SECURITYADMIN
C. ACCOUNTADMIN
D. USERADMIN
Which view in SNOWFLAKE.ACCOUNT_USAGE shows from which IP address a user connected to Snowflake?
A. ACCESS_HYSTORY
B. LOGIN_HYSTORY
C. SESSIONS
D. QUERY_HISTORY
What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?
A. READ
B. OWNERSHIP
C. USAGE
D. WRITE
What is the advantage of using a reader account?
A. It can be used by a client that does not have a Snowflake account
B. It is read-only and prevents the shared data from being updated by the provider.
C. It can be connected to a Snowflake account in a different region.
D. It provides limited access to the data share and is therefore cheaper for the data provider.
What is the MAXIMUM Time Travel retention period for a transient table?
A. 0 days
B. 1 day
C. 7 days
D. 90 days
Which URL type does Snowflake recommend to use when providing unstructured data to other accounts through a share?
A. File
B. Pre-signed
C. Scoped
D. Staged
Use of which Snowflake function is recommended when unloading data from a relational table into a JSON file?
A. TO_JSON
B. TO_VARIANT
C. OBJECT_INSERT
D. OBJECT_CONSTRUCT
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Snowflake exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your COF-C02 exam preparations and Snowflake certification application, do not hesitate to visit our Vcedump.com to find your solutions here.