• Database Introduction & Database Types
• OLTP, OLAP and Warehouse Databases
• Need for Datawarehouses; Advantages
• Popular Database Technologies
• Popular Datawarehouse Technologies
• Need for Cloud & Remote DWH Store
• Cloud Implementation Types & Usage
• IaaS: Infrastructure As A Service
• PaaS: Platform As A Service
• SaaS: Software As A Service
• Snowflake Cloud: Introduction
• Snowflake: Popular SaaS Platform
• Cloud Datawarehouse Concepts
• Advantages, Dependencies in Snowflake

• Creating Snowflake Account (Cloud)
• Snowflake Trail Account: Limitations, Uses
• Snowflake Account Components
• Cloud Platform: Azure, AWS, Google Cloud
• Regions and Availability with Snowflake
• Snowflake Editions, Credits; UI Usage
• Default Accounts; Web UI & Snow Sight
• Snowflake Storage: Ondemand, Capacity
• Snowflake Editions and Comparisons
• Standard Edition: Features, Advantages
• Enterprise Edition: Features, Advantages
• Business Critical Edition: Features, Usage
• Virtual Private Edition (VPS) & Pricing
• Snowflake Pricing: Ondemand Vs Capacity

• Snowflake Architecture & Compute
• Shared Disk, Shared Nothing Architecture
• Cluster Nodes and Snowflake Clusters
• CPU & Memory Resources in Clusters
• Disk Storage and Network Communication
• Storage Layer and Cloud Service Layer
• Database Query Layer & Data Cycle
• Snowflake Datawarehouse Architecture
• MPP: Massively Parallel Processing
• Compute and Storage Components
• Column Store and Virtual Warehouse
• Datawarehouse Creation in SnowSight
• Classic UI with Snowflake; Navigations
• Data Load and Billing; Auto Suspend

• Snowflake Databases and Data Storage
• Need for Snowflake Warehouse, Compute
• Database Objects and Hierarchy
• Snowflake Worksheet Parameters
• Database Creation with Snowflake UI
• Retention Time, DB List & Connections
• Permanent and Transient Databases
• Snowflake Tables and their Usage
• Permanent, Transient & Temp Tables
• Creating Tables with SnowSight
• Describe Options, Data Inserts
• CREATE TABLE AS SELECT
• Cloning Tables, Case Sensitivity Options
• Collation, ALTER, DROP & UNDROP

• Time Travel Feature in Snowflake
• DML Operations and Silent Audits
• Continuous Data Protection Life Cycle
• Invoking Time Travel Feature in Snowflake
• Timestamp, Offset & Query ID Options
• Time Travel using Offset Feature
• Time Travel using Query ID Feature
• Data Recovery using TIMESTAMP
• Using OFFSET options in Real-world
• Fail Safe and UNDROP Operations
• Transient Tables and Real-time Usage
• Permanent Table and Real-time Usage
• Restrictions with Permanent Tables
• Identical Names and Naming Conflicts

• Schemas: Creation, Real-time Usage
• Permanant and Transient Schemas
• Managed Schemas in Real-time Usage
• Verifying and Cloning Snowflake Schemas
• Invoking Schemas & Cloning Operations
• ALTER SCHEMA.. IF EXISTS Options
• Creating, Working with Managed Schema
• Snowflake Sessions (Workspaces)
• Session Context: Role and Warehouse
• Session Context: Database & Schema
• Working with Fully Qualified Names
• CTAS: Create Table As Select
• Data Loading with GUI, SQL Scripts
• Using Query and History Tab in GUI

• Snowflake Constraints, Data Validations
• NULL and NOT NULL Properties
• Unique, Primary and Foreign Keys
• Working with Named Constraints
• Single Column, Multi Column Constraints
• Inline and Out Of Line Constraints
• Table Constraints Types, Real-time Use
• Constraint Properties: ENFORCED
• DEFERRED, IMMEDIATE Options
• Numeric, String and Binary Data Types
• Boolean Data Types and Usage
• Date and Time Data Types
• Semi Structured Data Types
• Geospatial & Variant Data Types

• Cloning Operations with Snowflake
• Zero Copy and Schema Level Cloning
• Real-time Uses: Cloning in Snowflake
• Snapshot Concept, Metadata Options
• Possible Objects for Snowflake Clone
• Permissions for Snowflake Cloning
• Accessing, Controlling Cloned Objects
• Real-time Considerations @ Cloning
• Storage Layer and Metadata Layer
• Cloning with Foreign Key Constraints
• Cloning Snowflake Databases
• Cloning Snowflake Schemas, Tables
• Security and MANAGE GRANTS
• Cloning and COPY GRANTS Options

• Snowflake Procedures and Functions
• Creating and Using Stored Procedures
• Using CALL Command in Snowflake
• SQL and JavaScript Options with SPs
• Snowflake Deferred Name Resolution
• Overloading with Snowflake SPs
• Transactions & Injection
• Variables & CALL Command
• Using execute() with Procedures
• sqlText:command, createStatement
• Cursoring Operations
• Dynamic DML Operations with SPs
• Loops & next.scan()
• RETURN and RETURNS Statements
• Views & Query Storage
• DML and SELECT Operations on Views
• Regular Views, System Predefined Views
• Recursive Views, Parameterized Views

• Security Management Concepts
• Security Entities with Snowflake
• Securable Objects, Users & Roles
• Prevligies and Privilege Groups
• Snowflake Security Hierarchy
• Organization, Account, Users, Roles
• Schema, Tables, Other DB Objects
• Creating and Using Roles, Users
• System Defined Roles and Usage
• Role Hierarchy and Dependency
• Creating and Working with Users
• Auditing Users and Password Policy
• RBAC: Role Based Access Control
• DAC: Discretionary Access Control

• Working with Transactions (ACID)
• Atomicity, Consistency, Isolation
• Durability and Data Storage Options
• Transaction Types with Snowflake
• Implicit, Explicit and Auto Commit
• BEGIN TRANSACTION & COMMIT
• DDL Statements and Transactions
• BEGIN WORK Versus START
• current_transaction() and Usage
• to_timestamp_ltz and Usage
• Failed Transactions with SPs
• Batches Versus Transactions
• Transactions with Stored Procedures
• Scoped and INNER Transactions

• Working with Snowflake Streams
• Stream Object and DML Auditing
• Snapshot Creation, Offset Options
• METADATA$ACTION Parameter
• METADATA$ISUPDATE Parameter
• METADATA$ROW_ID Parameter
• Stream Types: Standard Stream
• Append Only Stream & Usage
• Insert Only Stream & Usage
• Data Flow with Snowflake Streams
• Auditing INSERT, UPDATE, DELETE
• show streams; desc streams
• Streams on Transient Tables
• Time Travel; Using Stream Tables

• Snowflake Tasks and Real-time Use
• Snowflake Serverless Compute Model
• User Managed & Snowflake Managed
• Tasks Tree: Root and Link Concepts
• Directed Acyclic Graph (DAG)
• Tasks Schedules and RESUME Options
• CREATE, ALTER, DESCRIBE, SHOW
• CREATE TASK … AFTER Statement
• ALTER TASK … ADD AFTER Statement
• CRON Syntax with Tasks, Procedures
• Virtual Warehouse Concepts (DWH)
• Multi Cluster Warehouse Config
• Client Utilities, Drivers & Connectors
• Auto Scale Options, Billing (Pricing)

• SnowSQL: Concepts, Client Installation
• SnowSQL Tool: Configuration Options
• SnowSQL: Account Authorization
• DDL, DML and SELECT Operations
• Snowflake SQL Query Syntax Format
• SnowSQL Command Line Options
• Working with DB, Schema and Tables
• Snowflake Variables, Batch Processing
• Snowflake SQL Data Types, Usage
• DECLARE, LET, BEGIN and END
• EXECUTE IMMEDIATE, FOR, END FOR
• Creating Warehouse, Database, Tables
• Granting Permissions, Query Execution
• Writing Output to Files (Win, MAC OS)

• Snowflake Partitions, Real-time use
• Service and Storage Layer Concepts
• Micro Partition with DML, CDC
• Cluster Key: Usage, ReClusters
• Depth and Overlap Properties
• Internal Partition Types & Usage
• List, Range and Hash Partitions
• SYSTEM$CLUSTERING_INFORMATION
• Snowflake Stages and Usage
• Internal and External Stages
• User Stages : Creation, Usage
• Table Stages: Creation, Usage
• Internal Named Stages, Usage
• COPY Command, Bulk Data Loads

• Working with Azure Storage
• Azure Subscription, Resources
• Create, Use Azure Storage Account
• Storage Containers, BLOB Data
• Using SnowSQL with Azure BLOB
• SAS [Shared Access Signature]
• Using SAS Key and FILE PATH
• External Stages in Snowflake
• File Formats: Creation, Usage
• Creating & Using External Stages
• Azure Storage with BLOB
• COPY INTO Command Usage
• Listing Stages with Snowflake
• Snowflake Patterns & RegEx

• Snowflake SnowPipes: Incremental Loads & SnowPipe
• Creating Azure Account For BLOB
• Creating Container, Generate SAS Key
• Creating Azure Queue and Event Grid
• Notification Integration in Snowflake
• Integrations: Show, Describe, Use
• Azure Active Directory & IAM
• Linking Azure AD with Snowflake
• Enterprise Application, Authentication
• File Formats with Regular Expr
• External Data Stages
• Data Unloading Concepts
• PUT and GET with SnowSQL
• Bulk Unloads; Data Preparation & Stages
• Data Unloading to User Stages
• Data Unloading to Table Stages

Mindmajix offers advanced Snowflake interview questions and answers along with Snowflake resume samples. Take a free sample practice test before appearing in the certification to improve your chances of scoring high.