Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)
A. Use the DROP command after the load completes.
B. Specify the TEMPORARY option when creating the file format.
C. Specify the PURGE copy option in the COPY INTO
command. D. Use the REMOVE command after the load completes.
E. Use the DELETE LOAD HISTORY command after the load completes.
Question 914:
Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)
A. SHOW STORAGE BY TABLE;
B. SHOW TABLES;
C. Information Schema-> TABLE_HISTORY
D. Information Schema-> TABLE_FUNCTION
E. Information Schema-> TABLE_STORAGE_METRICS
Question 915:
What is the purpose of multi-cluster virtual warehouses?
A. To create separate data warehouses to increase query optimization
B. To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
C. To eliminate or reduce Queuing of concurrent queries
D. To allow the warehouse to resize automatically
Correct Answer: C
https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html#:~:text=Multi%2Dcluster%20warehouses%20enable%20you,during%20peak%20and% 20off%20hours.
Question 916:
The Snowflake cloud services layer is responsible for which tasks? (Choose two.)
A. Local disk caching
B. Authentication and access control
C. Metadata management
D. Query processing
E. Database storage
Question 917:
Where can a user find and review the failed logins of a specific user for the past 30 days?
A. The USERS view in ACCOUNT_USAGE
B. The LOGIN_HISTORY view in ACCOUNT_USAGE
C. The ACCESS_HISTORY view in ACCOUNT_USAGE
D. The SESSIONS view in ACCOUNT_USAGE
Question 918:
What internal stages are available in Snowflake? (Choose three.)
A. Schema stage
B. Named stage
C. User stage
D. Stream stage
E. Table stage
F. Database stage
Question 919:
Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?
A. PUT
B. GET
C. COPY
D. SELECT
Correct Answer: B
Reference: https://docs.snowflake.com/en/sql-reference/sql/get.html
Question 920:
Which file formats are supported for unloading data from Snowflake? (Choose two.)
A. Avro
B. JSON
C. ORC
D. XML
E. Delimited (CSV, TSV, etc.)
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.