Snowflake COF-C02 Real Exam Questions and Answers FREE [Q402-Q416]

Q402. Which command can be used to list all the file formats for which a user has access privileges?

Q403. What is the default file size when unloading data from Snowflake using the COPY command?

Q404. What are benefits of using reader accounts when sharing data in Snowflake? (Select TWO)

Q405. The Query Profile shows the metrics of a query that ran on a size Large virtual warehouse.

What steps will improve the query performance? (Select TWO).

Q406. Which view can be used to determine if a table has frequent row updates or deletes?

Q407. Which items are considered schema objects in Snowflake? (Select TWO).

Q408. There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production. How can data be easily transferred from the production account to the non-production account?

Q409. Which Snowflake data types can be used to build nested hierarchical data? (Select TWO)

Q410. Authorization to execute CREATE <object> statements comes only from which role?

Q411. What happens when a cloned table is replicated to a secondary database? (Select TWO)

Q412. How many credits does a size 3X-Large virtual warehouse consume if it runs continuously for 2 hours?

Q413. Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

Q414. If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

Q415. What type of query benefits the MOST from search optimization?

Q416. What is the recommended method for loading data into Snowflake?