What action can be performed using the GET command in Snowflake?
A. Automatically rename downloaded files.
B. Automatically decrypt downloaded data on a client machine.
C. Download data files from Snowflake internal stages to a local directory/folder.
D. Download data files from Snowflake external stages to a local directory/folder.
Which validation option is the only one that supports the COPY INTO command?
A. RETURN_ROWS
B. RETURN__ROWS
C. RETURN_ERRORS
D. RETURN_ALL_ERRORS
What are the correct settings for column and element names, regardless of which notation is used while accessing elements in a JSON object?
A. Both the column name and the element name are case-insensitive.
B. Both the column name and the element name are case-sensitive.
C. The column name is case-sensitive and the element names are case-insensitive.
D. The column name is case-insensitive and the element name is case-sensitive.
How can the Query Profile be used to identify the costliest operator of a query?
A. Select any node in the operator tree and look at the number of micro-partitions scanned.
B. Find the operator node with the highest fraction of time or percentage of total time.
C. Select the TableScan operator node and look at the percentage scanned from cache.
D. Look at the number of rows between operator nodes across the operator tree.
In order to access Snowflake Marketplace listings, who needs to accept the Snowflake Consumer Terms of Service?
A. SYSADMIN
B. SECURITYADMIN
C. ACCOUNTADMIN
D. ORGADMIN
Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory? (Choose two.)
A. Bytes scanned
B. Partitions scanned
C. Bytes spilled to local storage
D. Bytes spilled to remote storage
E. Percentage scanned from cache
How can a dropped internal stage be restored?
A. Enable Time Travel.
B. Clone the dropped stage.
C. Execute the UNDROP command.
D. Recreate the dropped stage.
Which Snowflake role can manage any object grant globally, including modifying and revoking grants?
A. USERADMIN
B. ORGADMIN
C. SYSADMIN
D. SECURITYADMIN
In the Data Exchange, who can get or request data from the listings? (Choose two.)
A. Users with ACCOUNTADMIN role
B. Users with SYSADMIN role
C. Users with ORGADMIN role
D. Users with IMPORT SHARE privilege
E. Users with MANAGE GRANTS privilege
Which Snowflake table type persists until it is explicitly dropped, is available for all users with relevant privileges (across sessions), and has no Fail-safe period?
A. External
B. Permanent
C. Temporary
D. Transient
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.