SnowPro Core Certification Exam (COF-C02) Free Questions - Part 13

Question No : 181) 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 No : 182) What COPY INTO SQL command should be used to unload data into multiple files?

A. SINGLE=TRUE

B. MULTIPLE=TRUE

C. MULTIPLE=FALSE

D. SINGLE=FALSE

Question No : 183) A running virtual warehouse is suspended. What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

A. 1 second

B. 60 seconds

C. 5 minutes

D. 60 minutes

Question No : 184) How many days is load history for Snowpipe retained?

A. 1 day

B. 7 days

C. 14 days

D. 64 days

Question No : 185) 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.)

Question No : 186) Which statement describes pruning?

A. The filtering or disregarding of micro-partitions that are not needed to return a query.

B. The return of micro-partitions values that overlap with each other to reduce a query's runtime.

C. A service that is handled by the Snowflake Cloud Services layer to optimize caching.

D. The ability to allow the result of a query to be accessed as if it were a table.

Question No : 187) 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 No : 188) The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

A. In the metadata of the target table for 14 days

B. In the metadata of the pipe for 14 days

C. In the metadata of the target table for 64 days

D. In the metadata of the pipe for 64 days

Question No : 189) True or False: Snowpipe via REST API can only reference External Stages as source.

A. True

B. False

Question No : 190) Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

A. Database replication and failover

B. Automated index management

C. Customer managed keys (Tri-secret secure)

D. Extended time travel

E. Native support for geospatial data

Question No : 191) What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

A. 30 days

B. 7 days

C. 48 hours

D. 24 hours

Question No : 192) 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 No : 193) Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

A. Caching query results

B. Running EXPLAIN and SHOW commands

C. Cloning a database

D. Running a custom query

E. Running COPY commands

Question No : 194) A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed. What will occur?

A. No virtual warehouse will be used, data will be read from the result cache.

B. No virtual warehouse will be used, data will be read from the local disk cache.

C. The default virtual warehouse will be used to read all data.

D. The virtual warehouse that is defined at the session level will be used to read all data.

Question No : 195) If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

A. 4

B. 8

C. 16

D. 32
 

COF-C02 Answers

 

Part 1

Part 2

Part 3

Part 4

Part 5

Part 6

Part 7

Part 8

Part 9

Part 10

Part 11

Part 12

Part 13

Part 14

Part 15

Part 16

Part 17

Part 18