What is the relationship between a Query Profile and a virtual warehouse?
A. A Query Profile can help users right-size virtual warehouses.
B. A Query Profile defines the hardware specifications of the virtual warehouse.
C. A Query Profile can help determine the number of virtual warehouses available.
D. A Query Profile automatically scales the virtual warehouse based on the query complexity.
Which transformation is supported by a COPY INTO [table] command?
A. Filter using a WHERE clause
B. Filter using a LIMIT keyword
C. Cast using a SELECT statement
D. Order using an ORDER BY Clause
How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?
A. Review the granted privileges to the database object.
B. Review the row access policy for the database object.
C. Query the ACCESS_HISTORY view in the ACCOUNT_USAGE schema.
D. Query the REPLICATION_USAGE_HISTORY view in the ORGANIZATION_USAGE schema.
How does conditional data masking work in Snowflake?
A. It selectively masks plain text data.
B. It selectively masks multiple columns.
C. It masks all values in a given column.
D. It selectively masks a column value based on another column.
If a virtual warehouse runs for 61 seconds, shuts down, and then restarts and runs for 30 seconds, for how many seconds is it billed?
A. 60
B. 91
C. 120
D. 121
What function, combined with the copy command, should be used to unload data from a relational table into a JSON file?
A. LATERAL
B. CAST
C. FLATTEN
D. OBJECT_CONSTRUCT
What is the primary purpose of a directory table in Snowflake?
A. To store actual data from external stages
B. To automatically expire file URLs for security
C. To manage user privileges and access control
D. To store file-level metadata about data files in a stage
Which Snowflake table objects can be shared with other accounts? (Choose two.)
A. Temporary tables
B. Permanent tables
C. Transient tables
D. External tables
E. User-Defined Table Functions (UDTFs)
Which metadata table will store the storage utilization information even for dropped tables?
A. DATABASE_STORAGE_USAGE_HISTORY
B. TABLE_STORAGE_METRICS
C. STORAGE_DAILY_HISTORY
D. STAGE_STORAGE_USAGE_HISTORY
How is role hierarchy established in Snowflake?
A. By assigning users to roles
B. By default when a role is created
C. By granting one role to another role
D. By transferring ownership of one role to another role
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.