- All Exams Instant Download
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
How often are encryption keys automatically rotated by Snowflake?
How often are encryption keys automatically rotated by Snowflake?A . 30 Days B. 60 Days C. 90 Days D. 365 DaysView AnswerAnswer: A Explanation: All Snowflake-managed keys are automatically rotated by Snowflake when they are more than 30 days old. Active keys are retired, and new keys are created. When...
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: D
