Question 281:
While running a query on a virtual warehouse in auto-scale mode, additional clusters are started immediately if which setting is configured?
A. MAX_CLUSTER_COUNT is increased and new_max_clusters is greater than running_clusters
B. MAX_CLUSTER_COUNT is decreased and new_max_clusters is less than running_clusters
C. MIN_CLUSTER_COUNT is increased and new_min_clusters is greater than running_clusters
D. MIN_CLUSTER_COUNT is decreased and new_min_clusters is less than running_clusters
Question 282:
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
Question 283:
Which statements describe benefits of Snowflake's separation of compute and storage?(Select TWO).
A. The separation allows independent scaling of computing resources.
B. The separation ensures consistent data encryption across all virtual data warehouses.
C. The separation supports automatic conversion of semi-structured data into structured data for advanced data analysis.
D. Storage volume growth and compute usage growth can be tightly coupled.
E. Compote can be scaled up or down without the requirement to add more storage.
Question 284:
Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?
A. CREATE STAGE
B. COPY INTO
C. COPY INTO
D. CREATE PIPE
Question 285:
What is the MINIMUM permission needed to access a file URL from an external stage?
A. MODIFY
B. READ
C. SELECT
D. USAGE
Question 286:
What is the only supported character set for loading and unloading data from all supported file formats?
A. UTF-8
B. UTF-16
C. ISO-8859-1
D. WINDOWS-1253
Question 287:
What value provides information about disk usage for operations where intermediate results do not fit in memory in a Query Profile?
A. IO
B. Network
C. Pruning
D. Spilling
Question 288:
Which command removes a role from another role or a user in Snowflak?
A. ALTER ROLE
B. REVOKE ROLE
C. USE ROLE
D. USE SECONDARY ROLES
Question 289:
What can a user win a reader account do in Snowflake?
A. Load now data
B. Update existing data
C. Create a new snare
D. Query shared data
Question 290:
How can a data provider ensure that a data consumer is going to have access to the required objects?
A. Enable the data sharing feature in the account and validate the view.
B. Use the CURRENT_ROLE and CURRENT_USER functions to validate secure views.
C. Use the CURRENT_ function to authorize users from a specific account to access rows in a base table.
D. Set the SIMULATED DATA SHARING CONSUMER session parameter to the name of the consumer account for which access is being simulated.
Tips on How to Prepare for the Exams
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.