|
via Udemy |
Go to Course: https://www.udemy.com/course/new-snowflake-advanced-administrator-practice-exam-2023/
The SnowPro Advanced: Administrator Certification Exam course available on Coursera is a comprehensive and in-depth program designed for experienced Snowflake administrators and data professionals aiming to validate and enhance their expertise. This course thoroughly covers all critical domains and components necessary for effective Snowflake account management, security, performance optimization, data sharing, and disaster recovery, among others. **Course Overview and Content** This course prepares you to confidently take the SnowPro Advanced: Administrator Certification Exam, which features 65 questions spanning multiple domains, including security, account management, data governance, performance tuning, data sharing, and disaster recovery. With a time limit of 115 minutes, it challenges your ability to apply advanced data cloud principles using Snowflake and its ecosystem. Key domains covered include: - **Security & Role-Based Access Control (RBAC):** Setting up secure authentication methods like SSO, MFA, OAuth, network policies, access control hierarchy, privilege management, and audit practices. - **Account Management & Data Governance:** Managing organizational accounts, implementing data masking, access policies, and tagging to uphold governance standards. - **Performance Monitoring & Tuning:** Designing virtual warehouses, optimizing query performance, managing concurrency, resource monitoring, and cost management. - **Data Sharing & Marketplace:** Implementing data sharing strategies, managing external data exchange, utilizing the Snowflake Data Marketplace, and handling data providers and consumers. - **Disaster Recovery & Data Replication:** Understanding primary/secondary database setup, replication processes, backup best practices, and time travel features to ensure business continuity. **Course Design & Approach** The course is tailored to cover all essential facets of Snowflake administration through detailed modules, case scenarios, and practical insights. It emphasizes not only theoretical knowledge but also the application of best practices to meet real-world business requirements. You’ll learn how to configure access controls, optimize performance, manage costs, and implement robust disaster recovery plans, ensuring you’re well-prepared for the certification exam and professional challenges. **Review & Recommendations** This course is highly recommended for IT professionals, database administrators, and data engineers seeking to deepen their Snowflake expertise and earn the Advanced Administrator Certification. The extensive coverage, combined with practical scenarios, makes it an invaluable resource for mastering Snowflake’s administrative capabilities. The curriculum's detailed nature ensures that learners are equipped to handle complex cloud data environments, implement security best practices, and effectively manage resources. Whether you are preparing for the certification or looking to improve your Snowflake administration skills, this course offers comprehensive training aligned with industry standards. **Final Verdict:** If you're committed to excelling in Snowflake data cloud management and achieving advanced certification, enrolling in this Coursera course is a strategic step. Its in-depth modules, expert insights, and practical focus make it one of the best learning investments for aspiring Snowflake data administrators.
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