Computer Architecture > EXAM > Snowflake - Advanced Architecture ALL ANSWERS 100% CORRECT SPRING FALL-2023/24 EDITION GUARANTEED GR (All)

Snowflake - Advanced Architecture ALL ANSWERS 100% CORRECT SPRING FALL-2023/24 EDITION GUARANTEED GRADE A+

Document Content and Description Below

What components make up a VPC Pod? Load Balancer, Cloud Services, Metadata Store and Virtual Warehouse What are the benefits of a Snowflake multi-tenant deployment with shared resources? Performanc... e (increases peak capacity), Cost (better resource utilization and Value (more bang for the buck) List the Security protocols incorporated in Snowflake. 1. AES 256 - secure encryption 2. HTTPS - all communications end-to-end 3. TLS 1.2 4. Authentication for ALL communications 5. IP Whitelisting available What are the layers of adaptive caching for fast access? 1. Metadata - for query plan in Global Services 2. Data - Virtual DW in SSD in Data Storage 3. Query Results - stored in cloud storage Characteristics of Data Sharing No movement of data, live access and ready to use for consumption Account Name format is... <Account>.<Region>.<Cloud Provider> Object Hierarchy in Snowflake Warehouse --> Database --> Schema --> Tables How is data stored in Snowflake? In Blob storage in files that are micro-partition (FDN) with max size of 16 mb compressed, 50-500 mb uncompressed. Infrastructure Management in the Global Services consists of.... Organization, File Size, Structure, Metadata, Statistics What is FDN? Snowflake's proprietary data file format extension. FDN is snowflake in french "Flocon De Neige" What is the Logical Data Organization? Account --> Database --> Schema {Tables, Views, Stages, File Formats, Sequences} Micro-Partition characteristics are [Show More]

Last updated: 2 years ago

Preview 1 out of 3 pages

Buy Now

Instant download

We Accept: