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