SnowPro Certification Exam Questions And Answers All Verified

SnowPro Certification Exam Questions And Answers All Verified What is the best way to store semi-structured data? - ANS 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? - ANS 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? - ANS 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 ________? - ANS Pruning What command is used to load files into an Internal Stage within Snowflake? A. PUT B. COPY INTO C. TRANSFER D. INSERT - ANS 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 - ANS C. Data Type Conversion & D. Column Reordering True or False: Snowpipe via RFST API can only reference External Stages as source. - ANS 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 - ANS A. Amazon Web Services & D. Microsoft Azure Cloud How would you execute a series of SQL statements using Task?