Free Practice Questions for Snowflake ADA-C02 Certification

• Identify use cases and follow best practices for ORGADMIN and ACCOUNTADMIN roles (note: ORGADMIN will be replaced with GLOBARORGADMIN ) • Analyze the impact of organizational-level changes on account-level objects

• Identify use cases for the different frameworks

- Discretionary Access Control (DAC) - Role-Based Access Control (RBAC) - User-based access Control (UBAC)

• Determine the use cases for, and hierarchy of, system-defined roles • Determine the use cases for custom security roles • Analyze the implications of role inheritance when granting or revoking privileges • Grant access to specific objects within a database that require privilege inheritance

• Identify and apply different privileges available for each object type • Custom security roles and users (SHOW command) • Analyze and audit user and query activity history using the ACCOUNT_USAGE and ORGANIZATION_USAGE schemas

• Secure the ACCOUNTADMIN role • Use and manage database roles and use cases • Create custom roles • Determine use cases for primary and secondary roles • Align usage of object access with business functions • Manage cloned objects and their impact on granted privileges • Create additional Administrators • Monitor granted privileges to users and roles, and on objects • Implement and manage future grants including restrictions • Manage warehouse grants (for example, USAGE , OPERATE , MODIFY , MONITOR ) • Implement and manage managed access schemas • Provide access to non-account Administrators to monitor billing and usage information • Manage account-level permissions • Enable security and access control for AI/ML models

• Establish federated authentication and Single Sign-on (SSO) to Snowflake

- Configure an Identity Provider (IdP) for Snowflake - Configure, use, and manage federated authentication with Snowflake

• Implement and manage passwords and multi-factor authentication (MFA)

- Manage user types ( PERSON , NULL and SERVICE ) - Manage passwords and password policies - Manage user MFA enrollment - Manage key-pair authentication and rotation - Manage programmatic authentication tokens and rotation - Report on users who do not have MFA enabled - Reset passwords and temporarily disable MFA for users

• Configure and use OAuth protocols

- Use OAuth 2.0 in Snowflake - Compare Snowflake OAuth to External OAuth - Configure Snowflake OAuth for custom clients - Analyze how Snowflake OAuth is impacted by federated authentication, network policies, and private connectivity

• Establish network rules

- Configure and manage network rules - Analyze network policy behavior when both account-level and user-level network rules exist

• Establish private connectivity to Snowflake internal stages and the Snowflake service

- Implement and manage cloud provider interfaces and private endpoints for internal stages - Manage private connectivity between cloud providers and Snowflake

• Secure and Integrate the Snowflake SQL API

• Use and monitor SCIM

- Analyze SCIM and its use cases as they relate to Snowflake - Manage users and groups with SCIM - Enable, configure, and manage SCIM integration

• Prevent data exfiltration with PREVENT_UNLOAD_TO_INLINE_URL and REQUIRE_STORAGE_INTEGRATION _FOR_STAGE_CREATION • Manage service accounts, API integration, and automated authentication (for example, key-pair authentication) • Manage access to AI features and models

• Evaluate the benefits and costs of using a Snowflake Organization • Perform organizational tasks

- Create and name an organization - Name various types of organization accounts - Identify which regions are available for a given organization

• Perform account tasks

- View, create, and list accounts - Change account names

• Manage Tri-Secret Secure • Manage encryption keys in Snowflake

- Describe how Snowflake encrypts customer data - Describe encryption key rotation and periodic rekeying configuration

• Manage account-level parameters and features

- Enable Cortex AI features for users

• Protect sensitive data with security policies

- Implement column-level security using data masking policies - Use external tokenization - Evaluate the use of data masking versus external tokenization based on business requirements - Configure a row access policy on an object - Compare row access policies to secure views - Identify the impact of attaching a row access policy to an object

• Audit access history using the ACCESS_HISTORY views • Use tagging and classification in Snowflake

- Identify tagging use cases - Implement and manage tagging - Implement tag-based masking policies - Implement data classification (EXTRACT_SEMANTIC_CATEGORIES, ASSOCIATE_SEMANTIC_CATEGORIES)

• Manage data governance through Snowsight

- Configuring and monitor tags - Implement and manage Trust Center

• Manage Horizon Catalog, Universal Search, and Data Lineage

• Differentiate between account names and account locators • Identify when a given account identifier needs to be used • Use region IDs and region groups

• Analyze the impact on data loading and query processing based on warehouse sizes and types • Configure warehouse properties (auto-suspend, auto-resume, max clusters) • Given a scenario, manage warehouse usage in sessions, and size the warehouse accordingly • Given a scenario, manage a multi-cluster warehouse

- Determine use cases and benefits - Implement and maintain a scaling policy - Monitor multi-cluster warehouses

• Manage tables

- Analyze table design considerations - Implement Snowflake table structures and types - Create and manage external tables - Create and manage iceberg tables

• Implement and manage views, secure views, and materialized views • Identify use cases for cloning databases and tables

• Create and manage Snowflake storage integration

- External stages - Data exfiltration

• Create and manage EXTERNAL_VOLUME with Iceberg tables • Create and configure the Polaris Catalog

• Configure tasks

- Manage and schedule tasks - Set permissions for creating and executing tasks - Troubleshoot task historical runs - Identify use cases

• Differentiate between user-managed and Snowflake-managed tasks and identify use cases.

• Use Snowflake sequences and identify limitations • Use persisted query results • Cancel statements for single users or multiple users • Use query history filters including client-generated queries and queries executed by user tasks • Visualize query results with Snowsight

- Use Snowsight dashboards to monitor activity - Share worksheets and dashboards - Generate and share Snowsight charts - Identify constraints with sharing a Snowsight chart - Recover dropped dashboards

• Evaluate and interpret Query Profiles to improve performance

- Analyze the components of the Query Profile: - Steps - Operator tree - Operator nodes - Operator types - Compare compile versus runtime optimizations - Identify and create efficient queries - Articulate the execution path - Use effective joining conditions - Perform grouping, sorting, and ordering - Troubleshoot common query performance issues - Identify impact and solutions for data spilling - Identify impact and solutions if data pruning is not happening - Identify the various timeout parameters

• Use an explain plan • Compare and contrast different caching techniques and the impact of caching on performance

- Result cache - Local disk (warehouse) cache - Explain the impact on the local disc cache when a warehouse is suspended or resumed - Metadata cache

• Implement performance improvements

- Recommend the use of materialized views - Use the search optimization service - Create external tables - Use data caching - Use the query acceleration service

• Analyze DML concurrency considerations • Implement best practices for DML locking and concurrency • Monitor and manage transaction activity

• Create and manage resource monitors based on use cases and business requirements • Set up a dashboard to monitor Snowflake costs

• Manage event tables

- Consider the use of default system event tables compared to custom tables - Configure event tables - Set levels for logs, metrics and tracing

• Analyze event tables for system health indicators • Use log data to monitor user activity, threat detection, and access control

- Create alerts

• Use log trace data to perform root cause analyses • Use log trace data to optimize performance

• Manage organization costs

- Differentiate use cases for the ACCOUNT_USAGE and ORGANIZATION_USAGE views - Monitor accounts and usage - Use the ORGANIZATION_USAGE schema in the SNOWFLAKE shared database - Monitor and calculate data transfer costs and replication costs - Calculate data storage usage and credit consumption - Apply techniques for cost optimization

• Evaluate use cases for the ACCOUNT_USAGE and INFORMATION_SCHEMA

- Views available from the INFORMATION_SCHEMA - Latency and data retention considerations - Latency for historical views

• Manage costs for virtual warehouses

- Determine when warehouses should be suspended or resumed based on cost and pricing - Calculate warehouse usage and credit consumption - Demonstrate cost saving strategies - Calculate and minimize IDLE time cost - Use Budgets - Use WAREHOUSE_MONITORING to optimize costs - Monitor and assess automatic clustering usage

• Manage costs for serverless and AI features

- Analyze how Snowflake credits are consumed by the cloud services layer (such as Snowpipe, materialized views, and automatic clustering) - Monitor AI and ML function costs - Monitor Notebooks consumption - Monitor AI usage and costs

• Given a scenario, implement sharing solutions

- Evaluate different sharing models (one to one, one to many, private, public) - Share data among different Snowflake editions - Configure cross-region and cross-cloud data sharing - Explain the role of replications - Use Cross-cloud auto fulfillment for listings - Use Cross-cloud Data Governance - Configure data sharing programmatically - Share different types of data objects including secure functions - Determine the role of context functions in data sharing

• Manage data providers and consumers

- Create and maintain outbound data shares - Share objects securely in a data share (for example, what type to use) - Identify use cases for views and secure views - Share data with secure User-defined Functions (UDFs) - Create and maintain reader accounts - Create user and role for access - Create resource monitors - Create objects - Determine if there is a need to store data (CREATE DATABASE ) - Import and maintain inbound data shares

• Configure and manage Snowflake Data Clean Rooms

- Install the clean room native app - Bring users into the clean room - Manage collaborators

• Access the public and internal Marketplace • Determine use cases for internal versus public data listings • Manage the process of becoming a data provider

- Create, edit, or delete provider profiles

• Create, submit, manage, and modify a data listing • Manage listings and listing requests • Monitor data sharing usage • Manage Native Apps

• Differentiate the use cases for primary and secondary databases • Replicate database objects • Replicate account-level objects • Analyze the impact of replication on access controls • Perform account replication • Enable scheduled replication • Differentiate between replication Groups and failover groups • Given a scenario, determine account replication considerations with respect to the different Snowflake editions

- Replicate data to a lower Snowflake edition

• Identify key-considerations for account replications • Analyze the impact of account replication on:

- Automatic clustering - Materialized views - External tables - Policies (masking and row access) and tags - Streams and tasks - Stages, pipes, and clones objects - Historical usage data - Iceberg tables

• Analyze the impact of database failover across multiple accounts • Analyze the impact of database failover and failback on schemas • Redirect client connections in case of a failover • Design and implement disaster recovery and business continuity plans

- Identify the appropriate failover or failback procedure

• Implement best practices for backups in Snowflake

• Establish data retention periods • Query historical data • Restore dropped objects • Enable or disable Time Travel

- Analyze Snowflake edition implications for Time Travel