Which SnowFlake edition enables data sharing only through Snowflake Support?
A. Virtual Private Snowflake
B. Business Critical
C. Enterprise
D. Standard
How many credits does a size 3X-Large virtual warehouse consume if it runs continuously for 2 hours?
A. 32
B. 64
C. 128
D. 256
By default, which role has access to the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function?
A. ACCOUNTADMIN
B. SECURITYADMIN
C. SYSADMIN
D. ORGADMIN
How does Snowflake define i1s approach to Discretionary Access Control (DAC)?
A. A defined level of access to an object
B. An entity in which access can be granted
C. Each object has an owner, who can in turn grail access to that object.
D. Access privileges are assigned to roles. which are in turn assigned to use's
If a virtual warehouse is suspended, what happens lo the warehouse cache?
A. The cache is dropped when the warehouse is suspended and is no longer available upon restart.
B. The warehouse cache persists for as long the warehouse exists, regardless of its suspension status.
C. The cache is maintained for up to two hours and can be restored If the warehouse Is restarted within this limit.
D. The cache is maintained for the auto suspend duration and can be restored it the warehouse 15 restarted within this limit.
What information does the Query Profile provide?
A. Graphical representation of the data model
B. Statistics for each component of the processing plan
C. Detailed Information about I he database schema
D. Real-time monitoring of the database operations
Who can create network policies within Snowflake? (Select TWO).
A. SYSADMIN only
B. ORCADMIN only
C. SECURITYADMIN or higher roles
D. A role with the CREATE NETWORK POLICY privilege
E. A role with the CREATE SECURITY INTEGRATION privilege
Which command can be used to list all the file formats for which a user has access privileges?
A. LIST
B. ALTER FILE FORMAT
C. DESCRIBE FILE FORMAT
D. SHOW FILE FORMATS
Which Snowflake feature records changes mace to a table so actions can be taken using that change data capture?
A. Materialized View
B. Pipe
C. Stream
D. Task
In which hierarchy is tag inheritance possible?
A. Organization » Account » Role
B. Account » User » Schema
C. Database » View » Column
D. Schema » Table » Column
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.