Other than ownership what privileges does a user need to view and modify resource monitors in Snowflake? (Choose two.)
A. ALTER
B. MONITOR
C. MODIFY
D. CREATE
E. DROP
Which command should be used when loading many flat files into a single table?
A. PUT
B. INSERT
C. COPY INTO
D. MERGE
What technique does Snowflake recommend for determining which virtual warehouse size to select?
A. Always start with an X-Small and increase the size if the query does not complete in 2 minutes
B. Experiment by running the same queries against warehouses of different sizes
C. Use the default size Snowflake chooses
D. Use X-Large or above for tables larger than 1 GB
Where can a Snowflake user find the query history in Snowsight?
A. Admin
B. Activity
C. Dashboards
D. Data
Why do Snowflake's virtual warehouses have scaling policies?
A. To help save extra storage costs
B. To help increase the performance of serverless computing features
C. To help control the credits consumed by a multi-cluster warehouse running in auto-scale mode
D. To help control the credits consumed by a multi-cluster warehouse running in maximized mode
How long is a query visible in the Query History page in the Snowflake Web Interface (UI)?
A. 60 minutes
B. 24 hours
C. 14 days
D. 30 days
Two users share a virtual warehouse named WH_DEV_01. When one of the users loads data, the other one experiences performance issues while querying data.
How does Snowflake recommend resolving this issue?
A. Scale up the existing warehouse
B. Create separate warehouses for each user
C. Create separate warehouses for each workload
D. Stop loading and querying data at the same time
What is SnowSQL?
A. Snowflake's new user interface where users can visualize data into charts and dashboards.
B. Snowflake's proprietary extension of the ANSI SQL standard, including built-in keywords and system functions.
C. Snowflake's command line client built on the Python connector which is used to connect to Snowflake and execute SQL.
D. Snowflake's library that provides a programming interface for processing data on Snowflake without moving it to the system where the application code runs.
Which view will return users who have queried a table?
A. SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_EVENT_HISTORY
B. SNOWFLAKE.ACCOUNT_USAGE.ACCESS_HISTORY
C. SNOWFLAKE.ACCOUNT_USAGE.COLUMNS
D. SNOWFLAKE.ACCOUNT_USAGE.OBJECT_DEPENDENCIES
If a virtual warehouse runs for 30 seconds after it is provisioned, how many seconds will the customer be billed for?
A. 30 seconds
B. 60 seconds
C. 121 seconds
D. 1 hour
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.