The SnowPro Advanced: Administrator Certification Exam will test your knowledge of advanced concepts and your ability to apply comprehensive data cloud administrative principles using Snowflake and its components. This certification will test your ability to: Manage and administer Snowflake accountsManage and administer Snowflake data security and governanceManage and maintain database objectsManage and maintain virtual warehousesPerform database monitoring and tuningPerform data sharing and use the Snowflake Data Exchange and Data MarketplaceAdminister disaster recovery, backup, and data replicationTotal Number of Questions: 65Question Types: Multiple Select, Multiple ChoiceTime Limit: 115 minutesPrerequisites: SnowPro Core Certified Domain Percentage Range of Exam 1.0 Snowflake Security, Role-based Access Control (RBAC), 25-30%and User Administration2.0 Account Management and Data Governance 25-30%3.0 Performance Monitoring and Tuning 20-25%4.0 Data Sharing, Data Exchange, and Data Marketplace 10-15%5.0 Disaster Recovery, Backup, and Data Replication 10-15%This Study Course designed to cover all the essentials Domains area & their components.1.0 Domain: Snowflake Security, Role-Based Access Control (RBAC), and User Administration1.1 Set up and manage Snowflake authentication. Establish and implement federated authentication and Single Sign-on (SSO)Implement Multi-Factor Authentication (MFA)Perform key pair authentication and key pair rotationConfigure and use OAuth1.2 Set up and manage network and private connectivity. Establish network policiesEstablish private connectivity to Snowflake internal stagesEstablish private connectivity to the Snowflake serviceUse IP address whitelists/allowed lists and blocked lists for access using network access policies1.3 Set up and manage security administration and authorization. Use and monitor SCIMPrevent data exfiltration with PREVENT UNLOAD TO INLINE URL/REQUIRE STORAGE INTEGRATION FOR STAGE CREATIONManage service accounts, API integration, and automated authentication (e.g, key pair)1.4 Given a set of business requirements, establish access control architecture. Access control frameworkSecurable objectsDescribe the uses for, and hierarchy of, system-defined roles (e.g, ORGADMIN, ACCOUNTADMIN, SYSADMIN, SECURITYADMIN, and USERADMIN).Use an enforcement modelDemonstrate how to grant access to specific objects within a database that requires privilege inheritance1.5 Given a scenario, create and manage access control. List and use the different privileges available for each object type in SnowflakeImplement custom security roles and users (e.g, include related SHOW commands)Audit user activity history and query activity history across a Snowflake account1.6 Given a scenario, configure access controls. Use system-defined rolesCreate custom rolesImplement inheritance and nesting of system-defined rolesAlign usage of object access with business functionsDescribe cloned objects and their impact on granted privilegesDesignate additional administrators in SnowflakeView granted privileges to users, roles, and/or on objectsImplement and manage future grants, including restrictions and limitationsEvaluate the various scenarios using warehouse grants (e.g, USAGE, OPERATE, MODIFY, MONITOR)Implement and manage managed access schemasManage account-level permissions2.0 Domain: Account Management and Data Governance2.1 Manage organizations and accounts. Describe the benefits of an organizationDescribe organizational tasksUnderstand account tasks2.2 Manage organization security and access control. Follow best practice when using the ORGADMIN roleCompare the differences between ORGADMIN and ACCOUNTADMIN roles2.3 Implement and manage data governance in Snowflake. Mask column data in SnowflakeImplement and manage row access policiesPerform auditing of access historyImplement and manage tagging in Snowflake2.4 Given a scenario, manage account identifiers. Describe the differences between account names and account locatorsIdentify when a given account identifier needs to be usedUse region groups2.5 Given a scenario, manage databases, tables, and views. Implement Snowflake table structuresEstablish and use temporary and transient tablesEstablish and use external tablesImplement and manage views, secure views, and materialized viewsOutline table design considerationsOutline the use cases when cloning is beneficialOutline data storage and data retention considerations2.6 Perform queries in Snowflake. Use Snowflake sequencesUse persisted query resultsDemonstrate the ability to cancel statements for both a single user as well as for other usersUse query history filters including client-generated queries and queries executed by user tasks2.7 Given a scenario, stage data in Snowflake. Stage data files from a local file systemCreate, manage, and maintain Snowflake internal and external stages2.8 Given a scenario, manage database streams and tasks. Outline database tasks and associated use casesOutline database streams and associated use cases3.0 Domain: Performance Mo
