Snowflake SnowPro Certification Prep
How many times can a share be consumed by a single account? - Answer- Once. "A share can only be consumed once per account." What is Federated Authentication? - Answer- Federated Authentication enables users to connect using SSO via an external SAML 2.0 compliment identity provider (IdP). What is the defn of PaaS? - Answer- 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? - Answer- Database Storage; Query processing - Virtual Warehouses; Cloud Services What does the Cloud Services Layer include? - Answer- Infrastructure Manager Optimizer Metadata Manager Security Authentication and Access Control Database Layer - What are the 3 characteristics of how data is stored - Answer- 1. Optimized 2. Compressed 3. Columnar Processing Layer - What is a virtual warehouse? - Answer- 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? - Answer- Each VW is an independent cluster that does not share compute resources with other VW. What are the 5 ways of connecting to Snowflake? - Answer- 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? - Answer- 1. Amazon Web Services (AWS) 2. Google Cloud Platform (GCP) 3. Microsoft Azure (Azure) What are the 4 editions of Snowflake? - Answer- 1. Standard 2. Enterprise 3. Business Critical 4. Virtual Private Snowflake (VPS) What does Enterprise Edition get you? - Answer- 1. Standard + 2. Multi-clus
Información del documento
- Subido en
- 16 de febrero de 2023
- Número de páginas
- 17
- Escrito en
- 2022/2023
- Tipo
- Examen
- Contiene
- Preguntas y respuestas