COF-C02 V4

Which of the following objects can be shared through secure data sharing?A . Masking policyB . Stored procedureC . TaskD . External tableView AnswerAnswer: D Explanation: Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be...

What can be used to view warehouse usage over time? (Select Two).A . The load HISTORY viewB . The Query history viewC . The show warehouses commandD . The WAREHOUSE_METERING__HISTORY ViewE . The billing and usage tab in the Snowflake web UlView AnswerAnswer: D, E

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