Free Snowflake ADA-C01 Exam Questions

Core Snowflake Technologies:

• Federated Authentication and SSO - Identity Provider (IdP) configuration, federated authentication setup
• Multi-Factor Authentication (MFA) - User enrollment, MFA with different drivers and connectors, monitoring MFA status
• Key Pair Authentication - User setup, key pair rotation
• OAuth 2.0 - Snowflake OAuth vs External OAuth, custom clients, technology providers (Tableau, Looker, Power BI, OKTA, Azure AD)
• Network Policies - Account-level and user-level network policies, IP address allowed/blocked lists
• Private Connectivity - Cloud provider interfaces, private endpoints for internal stages, private connectivity to Snowflake service
• SCIM Integration - User and group management, SCIM configuration and management
• Role-Based Access Control (RBAC) - System-defined roles, custom security roles, role hierarchy, privilege inheritance
• Account Management - Organizations, account creation and management, Tri-Secret Secure, encryption key rotation
• Data Governance - Masking policies, row access policies, tagging, data classification, external tokenization
• Virtual Warehouses - Warehouse sizing, auto-suspend/auto-resume, multi-cluster warehouses, scaling policies
• Performance Monitoring - Query Profiles, explain plans, caching techniques, query optimization
• Resource Monitors - Cost management, credit consumption monitoring, warehouse usage optimization
• Data Clustering - Cluster keys, automatic clustering service, micro-partitions
• Data Sharing - One-to-one and one-to-many sharing, private exchange, Snowflake Marketplace, cross-region/cross-cloud sharing
• Data Exchange - Provider profiles, data listings, membership management
• Disaster Recovery - Database replication, primary and secondary databases, failover/failback, backup best practices
• Time Travel and Fail-safe - Data retention periods, querying historical data, restoring dropped objects

Exam Sections (5 Main Domains with Weightings):

1. Snowflake Security, RBAC, and User Administration (30%) - Authentication (federated, SSO, MFA, OAuth, key pair), network policies, private connectivity, SCIM, security administration, access control architecture, privilege management
2. Account Management and Data Governance (25%) - Organizations and accounts, Tri-Secret Secure, encryption keys, data governance (masking policies, row access policies, tagging, classification), account identifiers, database/table/view management, queries, stages, streams, and tasks
3. Performance Monitoring and Tuning (20%) - Virtual warehouse design and management, performance monitoring, Query Profiles, explain plans, caching, DML locking and concurrency, resource monitors, data clustering, cost management
4. Data Sharing, Data Exchange, and Snowflake Marketplace (10%) - Data sharing implementation, secure objects, readers accounts, Data Exchange administration, Snowflake Marketplace listings
5. Disaster Recovery, Backup, and Data Replication (15%) - Database replication, account-level object replication, failover/failback, backup best practices, Time Travel and Fail-safe

Advanced Skills Tested:

• Managing and administering Snowflake accounts with comprehensive security controls
• Implementing and managing Snowflake data security and governance policies
• Managing and maintaining database objects, tables, and views
• Managing and maintaining virtual warehouses for optimal performance
• Performing database monitoring and tuning for cost and performance optimization
• Performing data sharing and using the Data Exchange and Snowflake Marketplace
• Administering disaster recovery, backup, and data replication strategies
• Designing access control architectures based on business requirements
• Configuring authentication methods including SSO, MFA, OAuth, and key pair authentication
• Implementing network policies and private connectivity solutions
• Managing data governance with masking policies, row access policies, and tagging
• Optimizing query performance using Query Profiles, explain plans, and caching strategies
• Managing costs through resource monitors and warehouse optimization
• Implementing database replication and disaster recovery plans