Snowflake SnowPro Advanced Architect Certification Companion: Hands-on Preparation and Practice

Table of Contents
About the Author
About the Technical Reviewer
Acknowledgments
Foreword
Introduction
Chapter 1: Exam Overview
    Why Certify?
    Get Started
        Prerequisites
        Create a Trial Account
        Exam Cost and Validity
        Exam Registration
        Canceling or Rescheduling the Exam
        Exam Retake Policy
    Understand the Exam Structure
        Exam Format
        Exam Domain Breakdown
        Scaled Scoring
        Exam Results
        Exam Tips
    Summary
Chapter 2: Snowflake Architecture and Overview
    Snowflake Data Cloud
    Big Data Architecture Patterns
    Snowflake Architecture
    Other Architecture Considerations
        Data Governance
        Secure Data Sharing
        Securable Object Hierarchy
        Cloning
        Micro-Partitions and Clustering
        Caching
    Summary
Chapter 3: Kafka Connectors and Client Drivers
    Snowflake Kafka Connector
        Structure of Table Loaded by the Kafka Connector
        Kafka Connector Workflow
        Shut Down the Kafka Connector
        Managing Fault Tolerance
        Recommendations While Configuring Kafka Connectors
    Other Client Drivers
        Snowflake Connector for Python
        Snowflake Connector for Spark
    Snowpark
    Summary
Chapter 4: Loading Data into Snowflake
    Data Loading Types
        Bulk Data Loading
        Understanding Stage
        Continuous Data Loading
    Data Loading Using the COPY Command
    Snowpipe
        Snowpipe Stage File Availability Options
        Data Load Using Snowpipe
        Snowpipe Rest APIs
        Summary
Chapter 5: Data Unloading from Snowflake
    Bulk Unloading
    Data Unloading Using the COPY Command
    Summary
Chapter 6: Tables and Views
    Snowflake Tables
        Permanent Tables
        Transient Tables
        Temporary Tables
        External Tables
        Things to Remember
    CREATE TABLE Command
    SQL Syntax
        Top<n>
        STRIP_NULL_VALUE
        STATEMENT_TIMEOUT_IN_SECONDS
        RESULT_SCAN
    Using Dates and Timestamps
    Snowflake Views
        Regular Views
        Materialized Views
        Regular vs. Materialized View
        Secure Views
    Summary
Chapter 7: Clustering and Micro-Partitions
    Micro-Partitions
    Query Pruning
    Clustering
        Why Clustering?
        Reclustering
        Clustering Keys
        SYSTEM$CLUSTERING_DEPTH Function
        SYSTEM$CLUSTERING_INFORMATION Function
    Summary
Chapter 8: Cloning
    Zero-Copy Clone
        Create and Identify a Clone
        How a Clone Is Stored Internally
        Privileges
        Other Considerations
    Summary
Chapter 9: Secure Data Sharing
    What Is a Share?
        Data Sharing Personas
        Data Sharing Options
        Data Sharing
        Data Sharing Steps
        Managing Shares
        Key Considerations for Data Sharing
    Cross-Region Data Sharing
    Summary
Chapter 10: Semistructured Data
    Semistructured Data
    How Snowflake Handles Semistructured Data
        VARIANT Data Type
        Query Semistructured Data
        Create a View
    FLATTEN Function
    STRIP_NULL_VALUE Function
    SYSTEM$EXPLAIN_JSON_TO_TEXT Function
    PARSE_JSON Function
    OBJECT_CONTRUCT Function
    GET Function
    Summary
    References
Chapter 11: Time Travel and Fail-Safe
    Time Travel
        Continuous Data Protection
        How to Enable Time-Travel on a Table
    Data Retention Period
        DATA_RETENTION_TIME_IN_DAYS
        MIN_DATA_RETENTION_TIME_IN_DAYS
        Managing the Data Retention Period
        LIST DROPPED OBJECTS
    Managing Storage Fees
    Fail-Safe
    Important Considerations
    Summary
Chapter 12: Continuous Data Pipelines
    Snowflake Support for Continuous Data Pipelines
    Streams
        Stream Columns
        Stream Types
        Stream Data Retention Period
        DESCRIBE STREAM
        SHOW STREAMS
        RESULTS_SCAN Function
    Tasks
        Types of Tasks
        Direct Acyclic Graph
        SYSTEM$STREAM_HAS_DATA
        CREATE_TASK
    Snowpipe
        CREATE_PIPE
    Summary
Chapter 13: Data Replication and Failovers
    Data Replication
        Primary and Secondary Databases
        Database Replication Steps
        Dropping a Database
        Important Considerations
        Replication Functions
    Database Failover
    Summary
Chapter 14: Managing Accounts and Security
    Account Management
    User Management
        Important Commands
    Access Control Framework
        Securable Objects
        Roles
        Privileges
        Users
    Security
        Column-Level Security
        Row-Level Security
        Object Tagging
        Data Classification
        Access History
        Data Security
        Network Policy
        SSO
    Summary
Chapter 15: Query Profiles and Tuning
    Query Profiles
    Profiling Information
    Summary
Chapter 16: Performance and Resource Optimization
    Snowflake Search Optimization
        Access Control for the Search Optimization Service
        Optimization Techniques
        The Cost of Search Optimization
        SYSTEM$ESTIMATE_SEARCH_OPTIMIZATION_COSTS
        Search Optimization Limitations
    Caching
    Other Techniques
    Summary
Chapter 17: Snowflake Best Practices
    Best Practices for Query Optimization
    Best Practices for Data Loading
    Best Practices for Cost Optimization
    Best Practices for Compute Resource Optimization
    Summary
    References
Index