Overview

This three-day, role-specific course provides an in-depth exploration of database administrator duties and responsibilities in the Snowflake AI Data Cloud. This course covers data loading performance, security, role hierarchy design, and performance tuning. The course consists of lectures, labs, demonstrations, and discussions.

Skills Covered

  • Identify the various aspects of Snowflake compute and storage management.
  • Define the administrative tasks performed in support of the Snowflake AI Data Cloud.
  • Apply Snowflake’s recommended best practices and considerations for managing load operations and performance.
  • Described at a governance in Snowflake, including column-level data security using secure views and dynamic data masking features.
  • Explain the data definition language (DDL) operations that work with fundamental database objects.
  • Apply strategies for Snowflake performance-
  • Design and develop secure access to objects in Snowflake with Role-based Access Control (RBAC).
  • Utilize Snowflake’s recommended management, monitoring, and optimization best practices.

Prerequisites

  • Recommended completion of the “Snowflake Multi-Factor Authentication (MFA) Essentials” free on-demand course.
  • Completion of “Snowflake Foundations” one-day course or equivalent Snowflake knowledge.
  • A background in database administration or management is required.

Target Audience

  • Database Administrators
  • System Administrators
  • Database Architects
  • Data Engineers

Course Curriculum

Module 1: Snowflake Administration

Clients, Connectors, and Ecosystems

  • Clients and Interfaces

Managing Security

  • Overview
  • Access
  • Authentication
  • Programmatic Access Token (PAT)
  • Key-Pair Authentication
  • What is an Integration?
  • Security Integrations
  • Security Best Practices
  • Trust Center

Managing Roles

  • Users and Roles
  • Types of Roles
  • Using and Showing Grants
  • Ownership

Managing Users

  • User Management Overview
  • Password Policies
  • Managing Session Policies

Snowflake Environment

  • Account Structure
  • Set Account Parameters
  • Virtual Warehouse Scaling

Database Objects and Commands

  • Objects
  • Tables
  • Constraints
  • Views
  • Using the Result_Scan Function
  • System Functions
  • External Tables
  • Dynamic Tables
  • Dynamic Table Advantages
  • Monitoring Dynamic Tables

Managing Data Ingestion

  • Data Loading Overview
  • Bulk Loading
  • Error Handling
  • Fixing Load Failures
  • Loading Data Using the Web Interface
  • Continuous Loading with Snowpipe
  • Unloading Data
  • Storage Integrations
  • Notification Integrations

Work with Semi-structured Data

  • Loading Semi-structured Data
  • Querying Semi-structured Data

Module 2: Work with Unstructured Data

Schema Inference and Evolution

  • Schema Inference
  • Schema Evolution

Tasks

  • Tasks Overview
  • Creating Tasks
  • Managing Tasks

Module 3: Streams

Managing Query Performance

  • Get_Query_Operator_Stats
  • Writing Efficient Queries
  • Join Elimination

Data Manipulation Language (DML) and Transaction Concurrency

  • Transaction Concurrency Goals
  • System’s Point of View
  • Monitoring and Management Functions

Managing Data Governance

  • Data Governance and Snowflake
  • Classification and Tagging
  • Row Access Policies
  • Masking Policies
  • Context Functions
  • Auditing Access History
  • Access History and Column Lineage
  • Snowsight Data Governance Dashboard

Dates & Locations

Let’s make it work for you

Can’t find a date that fits? Need to train your whole team? Looking for a discount?
Speak to one of our learning experts today.

There’s no intakes scheduled for this course at the moment!

For enquiries, please contact our reps.

Exam & Certification

SnowPro® Advanced: Administrator 

The SnowPro® Advanced: Administrator Certification will validate advanced knowledge and skills used to apply comprehensive data cloud administrative principles using Snowflake and its components.

This certification will test the ability to:

  • Manage and administer Snowflake accounts, data security, and governance
  • Manage and maintain database objects and virtual warehouses
  • Perform database monitoring, tuning, and optimization
  • Perform data sharing and use the Snowflake Marketplace
  • Implement disaster recovery, perform backups, and replicate data

Training & Certification Guide

  • Exam Version: DSA-C03
  • Total Number of Questions: 65
  • Question Types: Multiple Select, Multiple Choice, Interactive
  • Time Limit: 115 minutes
  • Language: English
  • Registration Fee: $375 USD
  • India Registration Fee: $300 USD
  • Passing Score: 750+ scaled score out of 1000
  • Unscored Content: Exams may include unscored items for statistical purposes. These questions are not identified and do not affect your score. Additional time is included to account for these items.
  • Prerequisites: SnowPro Core Certified

  • 1.0 Snowflake Security, RBAC, and User Administration – 31%
  • 2.0 Account Management & Data Governance – 18%
  • 3.0 Data and Object Management – 15%
  • 4.0 Performance Monitoring & Tuning – 20%
  • 5.0 Data Sharing and Snowflake Marketplace – 7%
  • 6.0 Disaster Recovery, Backup & Data Replication – 9%

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

Preferred mode of training
Checkboxes