- All Exams Instant Download
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.A . True B. FalseView AnswerAnswer: A Explanation: You can experiment the same with snowflake UI.
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?A . An FTP server with TLS encryption B. An HTTPS server with WebDAV C. A Google Cloud storage bucket D. A Windows server file share on AzureView AnswerAnswer: C
What is a limitation of a Materialized View?
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?
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?
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.)
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
Which statements will provide this access?
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)
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?
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?
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.
