COF-C02 exam

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?A . A single join node uses more than 50% of the query time B. Partitions scanned is equal to partitions total C. An AggregateOperacor node is present D. The query...

A user unloaded a Snowflake table called mytable to an internal stage called mystage. Which command can be used to view the list of files that has been uploaded to the staged?A . list @mytable; B. list @%raytable; C. list @ %m.ystage; D. list @mystage;View AnswerAnswer: D

What are ways to create and manage data shares in Snowflake? (Select TWO)A . Through the Snowflake web interface (Ul) B. Through the DATA_SHARE=TRUE parameter C. Through SQL commands D. Through the enable__share=true parameter E. Using the CREATE SHARE AS SELECT * TABLE commandView AnswerAnswer: C,D

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?A . It removes the last element of the outer array. B. It removes the outer array structure and loads...

The fail-safe retention period is how many days?A . 1 day B. 7 days C. 45 days D. 90 daysView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html

A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?A . Yes, because a table owner has full control and can unset...

Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?A . Pipes B. Streams C. Tasks D. ProceduresView AnswerAnswer: B Explanation: https://dataterrain.com/how-to-change-tracking-using-table-streams-in-snowflake/#:~:text=A%20stream%20is%20a%20Snowflake,as%20metadata%20about%20 each%20change.

True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.A . True B. FalseView AnswerAnswer: A

What is a responsibility of Snowflake's virtual warehouses?A . Infrastructure management B. Metadata management C. Query execution D. Query parsing and optimization E. Management of the storage layerView AnswerAnswer: C

What is the MOST performant file format for loading data in Snowflake?A . CSV (Unzipped) B. Parquet C. CSV (Gzipped) D. ORCView AnswerAnswer: A