Which command is used to unload data from a Snowflake table to an external stage?
A. COPY INTO
B. COPY INTO followed by GET
C. GET
D. COPY INTO followed by PUT
What is a characteristic of materialized views in Snowflake?
A. Materialized views do not allow joins.
B. Clones of materialized views can be created directly by the user.
C. Multiple tables can be joined in the underlying query of a materialized view.
D. Aggregate functions can be used as window functions in materialized views.
How does a Snowflake user extract the URL of a directory table on an external stage for further transformation?
A. Use the SHOW STAGES command.
B. Use the DESCRIBE STAGE command.
C. Use the GET_ABSOLUTE_PATH function.
D. Use the GET_STAGE_LOCATION function.
A Snowflake user needs to share unstructured data from an internal stage to a reporting tool that does not have Snowflake access.
Which file function should be used?
A. BUILD_SCOPED_FILE_URL
B. BUILD_STAGE_FILE_URL
C. GET_PRESIGNED_URL
D. GET_STAGE_LOCATION
Which Snowflake feature can be used to find sensitive data in a table or column?
A. Masking policies
B. Data classification
C. Row level policies
D. External functions
Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?
A. Tags
B. Comments
C. Internal tokenization
D. Row access policies
Snowflake's hierarchical key mode includes which keys? (Choose two.)
A. Account master keys
B. Database master keys
C. File keys
D. Secure view keys
E. Schema master keys
What can the Snowflake SCIM API be used to manage? (Choose two.)
A. Integrations
B. Network policies
C. Session policies
D. Roles
E. Users
Which privilege is required to use the search optimization service in Snowflake?
A. GRANT SEARCH OPTIMIZATION ON SCHEMA TO ROLE
B. GRANT SEARCH OPTIMIZATION ON DATABASE TO ROLE
C. GRANT ADD SEARCH OPTIMIZATION ON SCHEMA TO ROLE
D. GRANT ADD SEARCH OPTIMIZATION ON DATABASE TO ROLE
The use of which technique or tool will improve Snowflake query performance on very large tables?
A. Indexing
B. Clustering keys
C. Multi-clustering
D. Materialized views
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.