SnowPro Core Certification Exam (COF-C02) Free Questions - Part 15
Question No : 211) 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
Question No : 212) When should a multi-cluster warehouse be used in auto-scaling mode?
A. When it is unknown how much compute power is needed
B. If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
C. If the runtime of the executed query is very slow
D. When a large number of concurrent queries are run on the same warehouse
Question No : 213) Which Snowflake layer is always leveraged when accessing a query from the result cache?
A. Metadata
B. Data Storage
C. Compute
D. Cloud Services
Question No : 214) Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?
A. INSERT
B. PUT
C. GET
D. COPY
Question No : 215) Files have been uploaded to a Snowflake internal stage. The files now need to be deleted. Which SQL command should be used to delete the files?
A. PURGE
B. MODIFY
C. REMOVE
D. DELETE
Question No : 216) What is the minimum Snowflake edition required for row level security?
A. Standard
B. Enterprise
C. Business Critical
D. Virtual Private Snowflake
Question No : 217) Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)
A. Query execution
B. Data loading
C. Time Travel data
D. Security
E. Authentication and access control
Question No : 218) What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?
A. Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 30 days. Fail Safe retention time is 1 day.
B. Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 365 days. Fail Safe retention time is 7 days.
C. Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.
D. Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.
E. Default Time Travel Retention is set to 7 days. Maximum Time Travel Retention is 1 day. Fail Safe retention time is 90 days.
F. Default Time Travel Retention is set to 90 days. Maximum Time Travel Retention is 7 days. Fail Safe retention time is 356 days.
Question No : 219) Which of the following are characteristics of security in Snowflake?
A. Account and user authentication is only available with the Snowflake Business Critical edition.
B. Support for HIPAA and GDPR compliance is available for UI Snowflake editions.
C. Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher
D. Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.
Question No : 220) Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?
A. Pre-signed URL
B. Scoped URL
C. Signed URL
D. File URL
Question No : 221) When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?
A. The cloned views and the stored procedures will reference the cloned tables in the cloned database.
B. An error will occur, as views with qualified references cannot be cloned.
C. An error will occur, as stored objects cannot be cloned.
D. The stored procedures and views will refer to tables in the source database.
Question No : 222) What file formats does Snowflake support for loading semi-structured data? (Choose three.)
A. TSV
B. JSON
C. PDF
D. Avro
E. Parquet
F. JPEG
Question No : 223) Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)
A. Schema Stage
B. User Stage
C. Database Stage
D. Table Stage
E. External Named Stage
F. Internal Named Stage
Question No : 224) When cloning a database, what is cloned with the database? (Choose two.)
A. Privileges on the database
B. Existing child objects within the database
C. Future child objects within the database
D. Privileges on the schemas within the database
E. Only schemas and tables within the database
Question No : 225) What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)
A. The clone always stays in sync with the original table.
B. The clone has better query performance.
C. The clone is created almost instantly.
D. The clone will have time travel history from the original table.
E. The clone saves space by not duplicating storage.
COF-C02 Answers