Snowflake SnowPro Certification Prep Questions And Answers

Snowflake SnowPro Certification Prep Questions And Answers How many times can a share be consumed by a single account? Once. "A share can only be consumed once per account." What is Federated Authentication? Federated Authentication enables users to connect using SSO via an external SAML 2.0 compliant identity provider (IdP). Brainpower Read More Previous Play Next Rewind 10 seconds Move forward 10 seconds Unmute 0:00 / 0:15 Full screen What is the defn of PaaS? Platform as a Service. You manage only the applications and data. Everything else is managed by the vendor. What are the three layers of Snowflake, bottom to top? Database Storage; Query processing - Virtual Warehouses; Cloud Services What does the Cloud Services Layer include? Infrastructure Manager Optimizer Metadata Manager Security Authentication and Access Control Database Layer - What are the 3 characteristics of how data is stored 1. Optimized 2. Compressed 3. Columnar Processing Layer - What is a virtual warehouse? An MPP compute cluster composed of multiple compute nodes allocation by Snowflake from a cloud provider. What impact to virtual warehouses (VW) have on each other? Each VW is an independent cluster that does not share compute resources with other VW. What are the 5 ways of connecting to Snowflake? 1. Web-based interface from which all aspects of managing Snowflake can be accessed. 2. SnowSQL - a command line interface (CLI) that can be used to manage all aspects of Snowflake. 3. ODBC and JDBC drivers 4. Native connectors (e.g. Python) 5. Third-party connectors that can be used to connect ETL or BI tools What are the three supported cloud platforms? 1. Amazon Web Services (AWS) 2. Google Cloud Platform (GCP) 3. Microsoft Azure (Azure) What are the 4 editions of Snowflake? 1. Standard 2. Enterprise 3. Business Critical 4. Virtual Private Snowflake (VPS) What does Enterprise Edition get you? 1. Standard + 2. Multi-cluster warehouse 3. Up to 90 days of Time Travel 4. Annual rekey of all encrypted data 5. Materialized Views What 9 things does Business Critical Edition get you? 1. Enterprise + 2. HIPPA support 3. PCI compliance