COF-C02 V2

What is a limitation of a Materialized View?A . A Materialized View cannot support any aggregate functions B. A Materialized View can only reference up to two tables C. A Materialized View cannot be joined with other tables D. A Materialized View cannot be defined with a JOINView AnswerAnswer: D...

Which Snowflake feature is used for both querying and restoring data?A . Cluster keys B. Time Travel C. Fail-safe D. CloningView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/data-availability.html#:~:text=Snowflake%20provides%20powerful%20CDP%20features,days%2 0through%20Snowflake%20Time%20Travel.

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

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

A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access? A.GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE; B.GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1; C.GRANT ROLE...

Which of the following are benefits of micro-partitioning? (Select TWO)A . Micro-partitions cannot overlap in their range of values B. Micro-partitions are immutable objects that support the use of Time Travel. C. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses D. Rows are automatically stored...

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 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.

Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?A . Compute layer B. Storage layer C. Cloud infrastructure layer D. Cloud services layerView AnswerAnswer: D Explanation: For query execution, Snowflake uses the Virtual Warehouse. The query processing layer is separated from the disk storage layer in...

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...