- All Exams Instant Download
Which of the following is true of Snowpipe via REST API? Choose 2 answers
Which of the following is true of Snowpipe via REST API? Choose 2 answersA . you can only use it on internal Stages B. All COPY INTO options are available fluting pipe creation C. Snowflake automatically manages the compute required to execute the Pipe's copy into commands D. Snowpipe keeps...
What happens when a virtual warehouse is resized?
What happens when a virtual warehouse is resized?A . When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected B. When reducing the size of a warehouse the compute resources are removed only when they are no longer...
Which type of table corresponds to a single Snowflake session?
Which type of table corresponds to a single Snowflake session?A . Temporary B. Translent C. Provisional D. PermanentView AnswerAnswer: A Explanation: Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist...
True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.
True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)A . SCIM B. Federated authentication C. TLS 1.2 D. Key-pair authentication E. OAuth F. OCSP authenticationView AnswerAnswer: B,D,E
True or False: Once created, a micro-partition will never be changed.
True or False: Once created, a micro-partition will never be changed.A . True B. FalseView AnswerAnswer: A Explanation: Reference: https://interworks.com/blog/kbridges/2019/03/12/time-travel-with-snowflake/
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
Which data types does Snowflake support when querying semi-structured data? (Select TWO)A . VARIANT B. ARRAY C. VARCHAR D. XML E. BLOBView AnswerAnswer: A,B Explanation: https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY. The maximum length of...
True or False: Snowpipe via RFST API can only reference External Stages as source.
True or False: Snowpipe via RFST API can only reference External Stages as source.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default
True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.
True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.A . True B. FalseView AnswerAnswer: B
Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)
Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)A . Custom B. Economy C. Optimized D. StandardView AnswerAnswer: B,D Explanation: Reference: https://community.snowflake.com/s/article/Snowflake-Visualizing-Warehouse-Performance
