|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/new-snowpro-advanced-architect-ara-c01-certification-2023-g/
课程评论：没有评论
课程名称：Snowflake Architect ARA-C01 认证考试！ 课程概述：此课程旨在通过模拟考试评估考生对 Snowflake 的高级知识和技能，帮助考生掌握综合架构解决方案的应用。考试内容包括场景基础问题和真实案例，以检验考生的实际能力。主要考核内容包括： - 设计从数据源到消费的完整数据流，使用 Snowflake 数据云。 - 设计和部署符合业务、安全和合规要求的数据架构。 - 选择合适的 Snowflake 及第三方工具，以优化架构性能。 - 使用 Snowflake 市场和数据交换设计和部署共享数据集。 目标受众：需要具备2年以上在生产环境中担任 Snowflake 架构师的实践经验。合格考生通常具备： - SQL 和 SQL 分析的实际操作经验。 - 建立复杂 ETL/ELT 流水线的经验。 - 实施安全和合规要求的经验。 - 了解不同数据建模技术的经验。 具备 SQL 之外的编码经验和 DevOps/DataOps 设计经验者优先考虑。 考试对象： - 解决方案架构师 - 1级/2级架构师 - 系统架构师 - 高级顾问 考试领域与权重： 1. 账户与安全 25% 2. Snowflake 架构 30% 3. 数据工程 25% 4. 性能优化 20% 课程大纲： 1. 账户与安全 - 设计 Snowflake 账户和数据库策略。 - 设计满足数据安全、隐私、合规和治理要求的架构。 - 概述 Snowflake 安全原则及适用的用例。 2. Snowflake 架构 - 概述 Snowflake 环境中各种数据模型的优势与限制。 - 设计基于不同用例的数据共享解决方案。 - 创建支持开发生命周期和工作负载需求的架构解决方案。 3. 数据工程 - 确定满足业务需求的数据加载和卸载解决方案。 - 概述 Snowflake 生态系统中的关键工具及其交互方式。 - 确定满足业务需求的数据转换解决方案。 4. 性能优化 - 概述性能工具、最佳实践及适用的场景。 - 解决现有架构中的性能问题。 祝学习愉快！
The SnowPro Advanced: Architect Practice Exam Assess candidate's advanced knowledge and skills used to apply comprehensive architect solutions using Snowflake. The exam will assess skills through scenario-based questions and real-world examples.This certification Mock test will test the ability to:● Design an end-to-end data flow from source to consumption using the Snowflake Data Cloud.● Design and deploy a data architecture that meets business, security, and compliance requirements.● Select appropriate Snowflake and third-party tools to optimize architecture performance.● Design and deploy a shared data set using the Snowflake Marketplace and Data Exchange.Target Audience:2+ years of practical experience with Snowflake as an Architect in a production environment. In addition, successful candidates may have:● Hands-on expertise with SQL and SQL analytics● Experience building out a complex ETL/ELT pipeline● Experience implementing security and compliance requirements● Working with different data modeling techniques.Having coding experience outside of SQL and DevOps/DataOps design experience is a plus.This exam is designed for:● Solution Architects● Level 1/Level 2 Architects● System Architects● Senior ConsultantsDomain Domain Weightings on Exams1.0 Accounts and Security 25%2.0 Snowflake Architecture 30%3.0 Data Engineering 25%4.0 Performance Optimization 20%SNOWPRO ADVANCED: ARCHITECT DOMAINS & OBJECTIVESDomain 1.0: Account and Security1.1 Design a Snowflake account and database strategy, based on business requirements.● Create and configure Snowflake parameters based on a central account and any additional accounts.● List the benefits and limitations of one Snowflake account as compared to multiple Snowflake accounts.1.2 Design an architecture that meets data security, privacy, compliance, and governance requirements.● Configure Role Based Access Control (RBAC) hierarchy● System roles and associated best practices● Data access● Data security● Compliance1.3 Outline Snowflake security principles and identify use cases where they should be applied.● Encryption● Network security● User, role, grants provisioning● AuthenticationDomain 2.0: Snowflake Architecture2.1 Outline the benefits and limitations of various data models in a Snowflake environment.● Data models2.2 Design data sharing solutions, based on different use cases.● Use cases○ Sharing within the same organization/same Snowflake account○ Sharing within a cloud region○ Sharing across cloud regions○ Sharing between different Snowflake accounts○ Sharing to a non-Snowflake customer○ Sharing across platforms● Snowflake Marketplace● Data Exchange● Data sharing methods2.3 Create architecture solutions that support development lifecycles as well as workload requirements.● Data lakes and environments● Workloads● Development lifecycle support2.4 Given a scenario, outline how objects exist within the Snowflake object hierarchy and how the hierarchy impacts an architecture.● Roles● Virtual warehouses● Object hierarchy● Database2.5 Determine the appropriate data recovery solution in Snowflake and how data can be restored.● Backup/recovery● Disaster recoveryDomain 3.0: Data Engineering3.1 Determine the appropriate data loading or data unloading solution to meet business needs.● Data sources● Ingestion of the data● Architecture changes● Data unloading3.2 Outline key tools in Snowflake's ecosystem and how they interact with Snowflake.● Connectors○ Kafka○ Spark○ Python● Drivers○ JDBC○ ODBC● API endpoints● SnowSQL3.3 Determine the appropriate data transformation solution to meet business needs.● Materialized views, views, and secure views● Staging layers and tables● Querying semi-structured data● Data processing● Stored procedures● Streams and tasks● Functions○ External functions○ User-Defined Functions (UDFs)Domain 4.0: Performance Optimization4.1 Outline performance tools, best practices, and appropriate scenarios where they should be applied.● Query profiling● Virtual warehouse configuration● Clustering● Search optimization service● Caching● Query rewrite4.2 Troubleshoot performance issues with existing architectures.● JOIN explosions● Virtual warehouse selection (scaling up as compared to scaling out)● Best practices and optimization techniques● Duplication of data● Monitoring and alerting○ Statistics○ Resource monitoring○ Account usage and information schemaHappy Learning!!
