Most UptoDate Snowflake COF-C02 Exam Dumps PDF 2025 [Q215-Q229]

Q215. Which Snowflake object can be used to record DML changes made to a table?

Q216. Which data sharing option allows a Snowflake user to set up and manage a group of accounts and offer a share to that group?

Q217. When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

Q218. What SQL command would be used to view all roles that were granted to user.1?

Q219. Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory?
(Select TWO).

Q220. Which stage type can be altered and dropped?

Q221. What transformations are supported in a CREATE PIPE … AS COPY … FROM (….) statement? (Select TWO.)

Q222. A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:
1. Created a user called “CONSUMER”
2. Created a database to hold the share and an extra-small warehouse to query the data
3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share Based on this configuration what is true of the reader account?

Q223. How can an administrator check for updates (for example, SCIM API requests) sent to Snowflake by the identity provider?

Q224. Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

Q225. A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:
1. Created a user called “CONSUMER”
2. Created a database to hold the share and an extra-small warehouse to query the data
3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share Based on this configuration what is true of the reader account?

Q226. The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

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

Q228. A virtual warehouse’s auto-suspend and auto-resume settings apply to which of the following?

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