Snowflake SnowPro Certification Study Guide Questions With Correct Answers

Snowflake SnowPro Certification Study
Guide Questions With Correct Answers

What are the 3 Cloud Providers available for Snowflake - CORRECT
| | | | | | | | | | |



ANSWER✔✔-1) AWS - a provider since inception | | | | | |




2) Azure Cloud Platforms - generally available as of Sept. 2018
| | | | | | | | | |




3) Google Cloud Platform - trialed late 2019
| | | | | | |




Snowflake is currently the only DW built for the cloud (T/F) - CORRECT
| | | | | | | | | | | | |



ANSWER✔✔-True


How does Snowflake describe their architecture?
| | | | |




A) Multi-Cluster, Shared Data
| | |




B) Single-Cluster, Shared Data - CORRECT ANSWER✔✔-A) Multi-Cluster,
| | | | | | | |



Shared Data |




What are the 3 components of Snowflake's architecture (both the name
| | | | | | | | | | |



and descriptor) - CORRECT ANSWER✔✔-1) Storage - Databases
| | | | | | |




2) Compute - Virtual Warehouses
| | | |




3) Cloud Services - Front End
| | | | |

,What are the Cloud Object Storage options? - CORRECT ANSWER✔✔-1)
| | | | | | | | | |



AWS S3 |




2) Azure Blobs
| |




3) GCP
|




How are storage costs calculated? - CORRECT ANSWER✔✔-A daily
| | | | | | | | |



average of all compressed data storage, including data stored according
| | | | | | | | | |



to Time Travel retention policy and failsafe procedures
| | | | | | |




Which Microsoft and Amazon systems does Compute leverage? -
| | | | | | | | |



CORRECT ANSWER✔✔-1) AWS EC2 | | |




2) Azure Compute
| |




Compute can't scale out as queries are running (T/F) - CORRECT
| | | | | | | | | | |



ANSWER✔✔-False


Which services does Cloud Services provide? - CORRECT ANSWER✔✔-1)
| | | | | | | |



Security Management
| |




2) Infrastructure Management
| |




3) Metadata Management
| |




4) Query Optimization
| |




Are Snowflake's Storage (DB) and Compute (WH) layers
| | | | | | |

, A) Separate and Independent
| | |




B) Together and Dependent - CORRECT ANSWER✔✔-A) Separate and
| | | | | | | | |



Independent


In addition to multiple Virtual Warehouses, Multi-Cluster means
| | | | | | | |



individual Virtual Warehouses can... - CORRECT ANSWER✔✔-Scale up
| | | | | | | |



or down automatically
| |




Multi-Cluster turn off clusters when activity slows down (T/F) - CORRECT
| | | | | | | | | |



ANSWER✔✔-True
|




Snowflake uses ANSI-SQL (T/F) - CORRECT ANSWER✔✔-True
| | | | | |




What is Snowflake's semi-structured data type called? - CORRECT
| | | | | | | | |



ANSWER✔✔-VARIANT


What are the three types of caching in Snowflake? - CORRECT
| | | | | | | | | | |



ANSWER✔✔-1) Warehouse |




2) Metadata
|




3) Results
|




All cache data are cleared if the underlying data changes (T/F) -
| | | | | | | | | | | |



CORRECT ANSWER✔✔-True |