COF-C02 exam

Which of the following compute resources or features are managed by Snowflake? (Select TWO).A . Execute a COPY commandB . Updating dataC . SnowpipeD . AUTOMATIC__CLUSTERINGE . Scaling up a warehouseView AnswerAnswer: A, D

Which of the following describes external functions in Snowflake?A . They are a type of User-defined Function (UDF).B . They contain their own SQL code.C . They call code that is stored inside of Snowflake.D . They can return multiple rows for each row receivedView AnswerAnswer: A Explanation: External functions...

Which data type can be used to store geospatial data in Snowflake?A . VariantB . ObjectC . GeometryD . GeographyView AnswerAnswer: D Explanation: https://docs.snowflake.com/en/sql-reference/data-types-geospatial.html#:~:text=have%20SRID%3D4326.-,Geospatial%20Object%20Types,Point

Which statement about billing applies to Snowflake credits?A . Credits are billed per-minute with a 60-minute minimumB . Credits are used to pay for cloud data storage usageC . Credits are consumed based on the number of credits billed for each hour that a warehouse runsD . Credits are consumed...

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?A . InformaticaB . Power BlC . AdobeD . Data RobotView AnswerAnswer: D Explanation: https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html

Where would a Snowflake user find information about query activity from 90 days ago?A . account__usage . query history viewB . account__usage.query__history__archive ViewC . information__schema . cruery_history viewD . information__schema - query history_by_ses s i on viewView AnswerAnswer: B

A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH. Which of the following statements will accommodate this request?A . ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;B . GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;C . GRANT MODIFY...

Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?A . Compute layerB . Storage layerC . Cloud infrastructure layerD . Cloud services layerView AnswerAnswer: D

When is the result set cache no longer available? (Select TWO)A . When another warehouse is used to execute the queryB . When another user executes the queryC . When the underlying data has changedD . When the warehouse used to execute the query is suspendedE . When it has...

Which command can be used to stage local files from which Snowflake interface?A . SnowSQLB . Snowflake classic web interface (Ul)C . SnowsightD . .NET driverView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/snowsql-use.html