COF-C02 V1

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 of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?A . Each Snowflake account can be hosted in a different cloud vendor and region. B. Each Snowflake account must be hosted in a different cloud vendor and region C. All Snowflake accounts...

A sales table FCT_SALES has 100 million records. The following Query was executed SELECT COUNT (1) FROM FCT__SALES; How did Snowflake fulfill this query?A . Query against the result set cache B. Query against a virtual warehouse cache C. Query against the most-recently created micro-partition D. Query against the metadata...

In which use cases does Snowflake apply egress charges?A . Data sharing within a specific region B. Query result retrieval C. Database replication D. Loading data into SnowflakeView AnswerAnswer: A Explanation: Cloud providers apply data egress charges in either of the following use cases: ✑ Data is transferred from one...

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

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

What is the default File Format used in the COPY command if one is not specified?A . CSV B. JSON C. Parquet D. XMLView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html

What features does Snowflake Time Travel enable?A . Querying data-related objects that were created within the past 365 days B. Restoring data-related objects that have been deleted within the past 90 days C. Conducting point-in-time analysis for Bl reporting D. Analyzing data usage/manipulation over all periods of timeView AnswerAnswer: B...

What are two ways to create and manage Data Shares in Snowflake? (Choose two.)A . Via the Snowflake Web Interface (Ul) B. Via the data_share=true parameter C. Via SQL commands D. Via Virtual WarehousesView AnswerAnswer: A,C Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html

What is the minimum Snowflake edition required to create a materialized view?A . Standard Edition B. Enterprise Edition C. Business Critical Edition D. Virtual Private Snowflake EditionView AnswerAnswer: B Explanation: Materialized views require Enterprise Edition. To inquire about upgrading, please contact Snowflake Support https://docs.snowflake.com/en/sql-reference/sql/create-materialized-view.html#:~:text=Materialized%20views%20require%20Enterprise%20Edition,upgrading%2C%20please%20contact%20Snowflake%20Support.