Design scalable cloud data architectures and optimize enterprise analytics using Snowflake platform capabilities.
Gain Snowflake skills required to to architect Snowflake environments using data warehousing design principles, performance optimization, data sharing, security, governance and scalable cloud analytics architectures for enterprise data platforms.
- Why get trained: Learn how to design Snowflake architectures, optimize performance, manage secure data sharing and implement scalable cloud data platform solutions for enterprise analytics environments.
- Why it matters: Snowflake architecture capabilities help organizations modernize analytics infrastructure, improve data scalability and support high-performance cloud data operations and governance initiatives.
- Who should attend: Data architects, cloud engineers, database professionals, analytics teams and IT practitioners responsible for designing and managing Snowflake data platform environments.
Build practical Snowflake architecture and enterprise cloud analytics capabilities with Trainocate. HRD Corp Claimable.
Overview
This three‐day course for Architects and Technical Leaders provides the skills, knowledge, and Snowflake‐recommended best practices to deploy and operate Snowflake, insights and recommendations based upon real‐world customer experiences, and the confidence to get the most out of Snowflake’s technology
Skills Covered
- Examine the tradeoffs associated with the available environment and Snowflake account deployment options.
- Use the Snowflake data security framework to balance the often-conflicting needs of protecting sensitive data while democratizing access and facilitating sharing.
- Apply Snowflake-recommended best practices to maximize performance and efficient use of resources during data ingestion, transformation, and end-user queries.
- Analyze Snowflake metadata to identify performance and cost issues and recommend remedial action.
Prerequisites
- Recommended completion of the “Snowflake Multi-Factor Authentication (MFA) Essentials” free on-demand course.
- Completion of Snowflake Fundamentals or equivalent Snowflake knowledge.
- SQL skills, a background in database management, and ideally, experience in designing and deploying analytics-based systems are required.
Target Audience
- Solution Architects
- Data Architects
- Database Architects
- Enterprise Data Architects
- Senior Data Engineers
- Technical Team Leads
Architecture Overview
- Snowflake Architecture
- Snowflake’s Layered Architecture
Deployment Considerations
- Organization
- Geographic Account Considerations
- Snowflake Security Domains
- Environment Deployment Options
- Cross Environment Data Transfer
- Data Transfer Options
- Environment Separation
- Logical Data Architecture (Layers)
- Physical Architecture Options
- Database Considerations
- Database Reference Options
- Summary and Recommendations
Data Architecture
- Overall Data Flow
- Reference Data Architecture
- Handling Raw History
- Integration With a Data Lake
- Create External Table
- Query External Table
- Partitioned External Tables
- External Network Access
- Change Data Capture, Creating and Managing Streams
- Snowpipe Streaming Overview
- Dynamic Tables
- Hybrid Tables
- Snowflake Postgres
- Apache Iceberg™ Tables in Snowflake
- Apache Polaris™ and Snowflake Open Catalog
- Snowflake Openflow and dbt Projects Overview
Virtual Warehouse Management
- Virtual Warehouse Scaling Re-Cap
- How Queries Scale
- Virtual Warehouse Deployment
- Measuring Virtual Warehouses
- Measuring Workloads
Overview of Snowpark Container Services
- What is a Container?
- Use Cases
Snowflake AI/ML Batch
- Why Snowflake for AI/ML
- Incorporating into the Batch Cycle
- Benefits
Data Security Framework
- Data Security Framework
- Data Classification
- Identify Data Sensitivity
Role-Based Access Control (RBAC)
- Overview
- RBAC Requirements
- RBAC Hierarchy Design
- RBAC Role Design
- Naming Standards
- RBAC Script Building
- Snowflake-recommended RBAC Best Practices
- Snowflake User-based Access Control (UBAC)
Data Governance Features
- Data Masking and Row Access Policies
- Dynamic Data Masking
- Row Access Policies
- Summary
Sharing Architecture
- Use Case
- Direct Share
- With Replication
- Data Products in Snowflake
- Auto-fulfillment
- How Auto-fulfillment Works
- Data Clean Rooms
- Native Apps
- Native Apps Demo
Snowflake Data Storage
- Data Storage Standard Tables
- Data Storage Hybrid Tables
- Snowflake Data Storage Management
- Data Storage Implications
- Data Storage DML Implications
- Time Travel
- Key Point
- Clones
- Data Recovery
- Agile Data Management
- Development
- System Testing
- Deployment
Performance Optimization
- What is Table Clustering?
- Partition Pruning (Elimination)
- Overlapping Values
- Evaluating Clustering
- Implement and Test Clustering Keys
- Search Optimization
- How Does It Work?
- Materialized Views
- Materialized View Use Cases
- Query Acceleration Service (QAS)
Exam & Certification
SnowPro® Advanced: Architect
The SnowPro® Advanced: Architect Certification will validate advanced knowledge and skills used to apply comprehensive architect solutions using Snowflake.
This certification will test the ability to:
- Design an end-to-end data flow from source to consumption using the Snowflake Platform
- Design and deploy a data architecture that meets business, security, and compliance requirements
- Select appropriate Snowflake and third-party tools to optimize architecture performance
- Design and deploy a shared data set using the Snowflake Marketplace and Data Exchange
Training & Certification Guide
Why train with Trainocate
Speak to a Training Consultant
All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631
