课程详情

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 Monitoring and Tuning3.1 Given business requirements, design, manage, and maintain virtual warehouses.Outline the impact on billing, data loading, and query processing based on warehouse sizesGiven a scenario, manage warehouse usage in sessions and size the warehouse accordinglyGiven a scenario, manage a multi-cluster warehouse3.2 Monitor Snowflake performance.Evaluate and interpret query profiles to improve performanceDescribe the components of the query profilersCompare compile versus runtime optimizationsIdentify/create efficient queriesTroubleshoot common errors in the query profilerIf data spilling is present, describe its impact and remediation tacticsIf data pruning is present, describe its impact and remediation tacticsDescribe the various timeout parametersUse an explain planCompare and contrast different caching techniques available in Snowflake and the impact of caching on performanceImplement performance improvements3.3 Manage DML locking and concurrency in Snowflake.Follow best practices for DML locking and concurrencyMonitor transaction activity3.4 Given a scenario, implement resource monitors.Create, manage, modify, and remove resource monitors based on use cases and business requirements3.5 Interpret and make recommendations for data clustering.Configure and maintain cluster keysDescribe micro-partitions, their benefits, and their impactRetrieve clustering information3.6 Manage costs and pricing.Manage organization costsForecast and monitor costs and pricingDescribe the use cases for the account_usage and information_schemaMonitor and calculate data storage usage/credit, data transfer costs, data replication costs, and/or warehouse usage/creditsDescribe how Snowflake credits are consumed by service layer activities (e.g., Snowpipe, materialized views, automatic clustering, etc.)Apply techniques for reducing costs4.0 Domain: Data Sharing, Data Exchange, and Data Marketplace4.1 Manage and implement data sharing.Given a scenario, implement sharing solutions and outline any business impactsManage data providers and consumers4.2 Use the Snowflake Data Exchange.Manage administration and membershipOutline the process of becoming a data providerManage data listings4.3 Use the Snowflake Data Marketplace.Access Snowflake Data Marketplace to browse listingsRequest that new data or a data provider be added to the Snowflake Data MarketplaceManage listing requestsManage data listings5.0 Domain: Disaster Recovery, Backup, and Data Replication5.1 Manage data replication.Describe the difference between primary and secondary databasesReplicate database objectsManage access controls with respect to replicationPerform database replication and encryptionEnable scheduled replicationOutline the database replication processes with respect to the different Snowflake editionsDescribe the limitations of database replicationsOutline the billing implications for database replicationOutline database replications considerations for:Perform replication across multiple accountsPlan and implement disaster recovery and business continuity plansImplement backup best practices in Snowflake5.2 Given a scenario, manage Snowflake Time Travel and Fail-safe.Retention periodsQuery historical dataRestore dropped objectsSnowflake edition implicationsStorage costs

课程标签

0人关注该课程

主题相关的课程