SnowPro Certification || with Complete Solutions

What is the best way to store semi-structured data? correct answers Data should be loaded and stored in a VARIANT type column What is the best practice for handling semi-structured data with 3rd party BI tools? correct answers Create a Snowflake view that parse the semi-structured column into structure columns for the BI tool to retrieve True or False: Micro-partitions are immutable? correct answers True - subsequent changes of any type to the data will be written to additional micro-partitions A Snowflake mechanism that is used to limit the number of micro-partitions scanned by a query is called ________? correct answers Pruning What command is used to load files into an Internal Stage within Snowflake? A. PUT B. COPY INTO C. TRANSFER D. INSERT correct answers A. PUT When loading data into Snowflake, the COPY command supports: Choose 2 answers A. Joins B. Fitters C. Data type conversions D. Column reordering E. Aggregates correct answers C. Data Type Conversion & D. Column Reordering True or False: Snowpipe via RFST API can only reference External Stages as source. correct answers A. True On which of the following cloud platform can a Snowflake account be hosted? Choose 2 answers A. Amazon Web Services B. Private Virtual Cloud C. Oracle Cloud D. Microsoft Azure Cloud correct answers A. Amazon Web Services & D. Microsoft Azure Cloud How would you execute a series of SQL statements using Task? A. include the SQL statements in the body of the task create task mytask.. as insert into target1 select., from stream_s1 where ..INSERT INTO target2 SELECT .. FROM stream .s1 where .. B. A stored procedure can have only one DML statement per stored procedure invocation and therefore you should sequence stored procedures calls in the task definition CREATE TASK mytask.... AS call stored_prc1(); call stored_proc2t);