Snowflake SnowPro Certification Tests Bundle Set

When unloading (or extracting) data using a Query, you can extract data from - Answer Multiple tables joined together a view a single table What are some of the ways to improve performance of an external table? - Answer Partition the external table (if the logical folder structure permi...

Which of the following are true of Multi-cluster warehouses? Select all that apply. 1) Adds clusters automatically based on query activity 2) Sizes each cluster optimally based on the queries 3) Scales down when query activity slows 4) Multi-cluster warehouses will never auto-suspend - Answer ...

True or False: Data Storage is independent from compute? - Answer True True or False: All virtual warehouses have access to all data? - Answer True True or False: Al interactions with data are initialized through the services layer? - Answer True True or False: Multi-Cluster Warehouse...

How are VARIANT columns stored? As a separate physical columns Are common and/or frequent fields/paths in VARIANT columns stored as separate physical columns? Yes For data that is mostly regular and uses only native JSON types (strings and numbers, not timestamps), are both storage and q...

What are the 4 Snowflake table types? - Answer Permanent External Temporary Transient Which of the following are Snowflake view types? Secure Permanent External Standard Materialized Transient - Answer Secure Standard Materialized What are the three Snowflake Stage types? Secure ...

Which of the following terms are associated with the Cloud Services Layer? Query Processing Query Planning Query Optimization Query Design Query Compilation - Answer Query Planning Query Optimization Query Compilation Which of the following terms are associated with the Compute/Warehouse...

Snowflake Editions - Answer 1. Standard 2. Enterprise 3. Business Critical Edition 4. Virtual Private Snowflake (VPS) Standard Edition - Answer -Complete SQL data warehouse -Secure data sharing -Premier support 24x365 -1 day of time travel -Enterprise-grade encryption -Dedicated virtu...

Multi-Cluster warehouses are which Snowflake edition's feature? - Answer Enterprise When the Warehouse is resumed, what is the amount of Snowflake credit charged? - Answer 1 Minute After 1 minute, per second What are the security and authentication features offered by Snowflake? - Answer...

Snowflake supports which of the following file formats for data loading? Select all that apply. Parquet ORC CSV PDF Answer Parquet ORC CSV Which type of Data Integration tools leverage Snowflake's scalable compute for data transformation? Select the best answer. Database Replication ...

Database Storage(Layer 3) Answer Responsible - Data loaded into snowflake is reorganized into internal optimized/compressed/columnar format - Data objects stored by Snowflake are not directly visible nor accessible by customers - Manages all aspects of data(size,compression etc) Query Processi...

Answer True or False: Network policies for granting or restricting users access to the site based on their IP address (i.e. IP whitelisting). Answer True True or False: Snowflake does NOT provide Verification/authentication required for any users accessing your account (includes support for M...

What is the best way to store semi-structured data? Answer 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? Answer Create a Snowflake view that parse the semi-structured column into structure columns for...

True or False? Metadata is created when you load data from a file in an internal stage to a Snowflake table. Answer True True or False? Are Snowpipe charges calculated per second and per core? Answer True What types of views are available in Snowflake? Answer Regular, secure and materialized ...

What is the best way to store semi-structured data? Answer 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? Answer Create a Snowflake view that parse the semi-structured column into structure columns for...