Snowflake Exam Study Set 2023 with 100% complete answers

True or false: A table in Snowflake can contain both a variant columns and a timestamp. correct answersTrue True or false: The warehouse cache may be reset if a running warehouse is suspended and then resumed. correct answersTrue Which of the following are true of Multi-Cluster warehouses? Select all that apply. correct answersAdds clusters automatically based on query activity; Scales down when query activity slows Which of the following are options when creating a Virtual Warehouse? correct answersAuto-suspend; Auto-resume What is the recommended approach for making a variant column accessible in a BI tool? correct answersA view Which of the following statements are true about Snowflake Data sharing? Select all that apply. correct answersConsumers can query shared tables in the same query as their own tables; Data Sharing is integrated with role-based access controls The Snowflake metadata repository contains which of the following? Select all that apply correct answersTable definitions; References to all of the micropartition files for that table; Tracking of all versions of the table data within the data retention window Which transformations are available when using the COPY INTO command to load data files into Snowflake from a stage? (select all that apply) correct answersColumn data type conversion; Column concatenation