Awarding a user which privileges on all virtual warehouses is equivalent to granting the user the global MANAGE WAREHOUSES privilege?
A. MODIFY, MONITOR and OPERATE privileges
B. OWNERSHIP and USAGE privileges
C. APPLYBUDGET and AUDIT privileges
D. MANAGE LISTING AUTOFULFILLMENT and RESOLVE ALL privileges
A Snowflake account has activated federated authentication.
What will occur when a user with a password that was defined by Snowflake attempts to log in to Snowflake?
A. The user will be unable to enter a password.
B. The user will encounter an error, and will not be able to log in.
C. The user will be able to log into Snowflake successfully.
D. After entering the username and password, the user will be redirected to an Identity Provider (IdP) login page.
Which solution improves the performance of point lookup queries that return a small number of rows from large tables using highly selective filters?
A. Automatic clustering
B. Materialized views
C. Query acceleration service
D. Search optimization service
What does a Notify and Suspend action for a resource monitor do?
A. Send an alert notification to all account users who have notifications enabled.
B. Send an alert notification to all virtual warehouse users when thresholds over 100% have been met.
C. Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses after all statements being executed by the warehouses have completed.
D. Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses immediately, canceling any statements being executed by the warehouses.
Which function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs, with a file URL that does not expire?
A. BUILD_SCOPED_FILE_URL
B. BUILD_STAGE_FILE_URL
C. GET_ABSOLUTE_PATH
D. GET_PRESIGNED_URL
When a Snowflake user loads CSV data from a stage, which COPY INTO [table] command guideline should they follow?
A. The CSV field delimiter must be a comma character (`,').
B. The number of columns in each row should be consistent.
C. The data file in the stage must be in a compressed format.
D. The data file must have the same number of columns as the target table.
Which function unloads data from a relational table to JSON?
A. TO_OBJECT
B. TO_JSON
C. TO_VARIANT
D. OBJECT_CONSTRUCT
What is the purpose of the STRIP_NULL_VALUES file format option when loading semi-structured data files into Snowflake?
A. It removes null values from all columns in the data.
B. It converts null values to empty strings during loading.
C. It skips rows with null values during the loading process.
D. It removes object or array elements containing null values.
According to best practices, which table type should be used if the data can be recreated outside of Snowflake?
A. Permanent table
B. Temporary table
C. Transient table
D. Volatile table
When working with a managed access schema, who has the OWNERSHIP privilege of any tables added to the schema?
A. The database owner
B. The object owner
C. The schema owner
D. The Snowflake user's 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.