|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/google-professional-cloud-database-engineer-practice-test-t/
课程评论：没有评论
课程名称：Google专业云数据库工程师实践测试 概述： Google专业云数据库工程师认证是由Google Cloud提供的专业级认证，旨在验证个人在设计、构建和管理Google Cloud数据库解决方案方面的专业知识。该认证展示了候选人利用Google Cloud技术设计、实施和维护高性能、可扩展和可靠的数据库的能力，以满足各种应用的需求。获得该认证的候选人需要对Google Cloud数据库服务（如Cloud SQL、Cloud Spanner、Firestore和Bigtable）有扎实的理解，并掌握数据库设计、数据建模、复制、备份、性能调优和安全性等关键概念。 考试格式： - 考试时长：120分钟 - 语言：英语 - 题目数量：50道选择题和多项选择题 - 及格分数：70% 认证考试指南： 专业云数据库工程师是一名拥有两年Google Cloud经验和五年整体数据库与IT经验的数据库专业人员。专业云数据库工程师负责设计、创建、管理和故障排除由应用程序使用的Google Cloud数据库，以存储和检索数据。该工程师应能够将业务和技术要求转化为可扩展且具有成本效益的数据库解决方案。 课程内容： **第一部分：设计可扩展和高可用性云数据库解决方案** - 进行数据库容量和使用规划的相关变量分析 - 评估数据库高可用性和灾难恢复选项 - 确定应用程序如何连接数据库 - 评估Google Cloud上的适当数据库解决方案 **第二部分：管理跨多个数据库解决方案的方案** - 确定数据库连接和访问管理注意事项 - 配置数据库监控和故障排除选项 - 设计数据库备份和恢复解决方案 - 优化Google Cloud中的数据库成本和性能 - 确定自动化数据库任务的解决方案 **第三部分：迁移数据解决方案** - 设计和实施数据迁移和复制 **第四部分：在Google Cloud中部署可扩展和高可用的数据库** - 应用概念实施高度可扩展和可用的数据库 - 定期测试高可用性和灾难恢复策略 在成功通过考试后，认证有效期为两年，认证人员必须重新认证以保持其资格。Google专业云数据库工程师认证在行业内得到了广泛认可，有助于专业人士在云和数据库管理领域的发展。
The Google Professional Cloud Database Engineer certification is a professional-level certification offered by Google Cloud that validates an individual's expertise in designing, building, and managing Google Cloud database solutions. This certification demonstrates a candidate's ability to leverage Google Cloud technologies to design, implement, and maintain high-performance, scalable, and reliable databases for various applications.To earn this certification, candidates must have a solid understanding of Google Cloud database services, including Cloud SQL, Cloud Spanner, Firestore, and Bigtable, as well as key concepts such as database design, data modeling, replication, backups, performance tuning, and security.This exam format:Length: 120 minLanguage: EnglishNumber of questions: 50 multiple choice and multiple select questionsPassing scor: 70%Certification exam guide:A Professional Cloud Database Engineer is a database professional with two years of Google Cloud experience and five years of overall database and IT experience. The Professional Cloud Database Engineer designs, creates, manages, and troubleshoots Google Cloud databases used by applications to store and retrieve data. The Professional Cloud Database Engineer should be comfortable translating business and technical requirements into scalable and cost-effective database solutions.Section 1: Design scalable and highly available cloud database solutions1.1 Analyze relevant variables to perform database capacity and usage planning. Activities include:● Given a scenario, perform solution sizing based on current environment workload metrics and future requirements● Evaluate performance and cost tradeoffs of different database configurations (machine types, HDD versus SSD, etc.)● Size database compute and storage based on performance requirements1.2 Evaluate database high availability and disaster recovery options given the requirements. Activities include:● Evaluate tradeoffs between multi-region, region, and zonal database deployment strategies● Given a scenario, define maintenance windows and notifications based on application availability requirements● Plan database upgrades for Google Cloud-managed databases1.3 Determine how applications will connect to the database. Activities include:● Design scalable, highly available, and secure databases● Configure network and security (Cloud SQL Auth Proxy, CMEK, SSL certificates)● Justify the use of session pooler services● Assess auditing policies for managed services1.4 Evaluate appropriate database solutions on Google Cloud. Activities include:● Differentiate between managed and unmanaged database services (self-managed, bare metal, Google-managed databases and partner database offerings)● Distinguish between SQL and NoSQL business requirements (structured, semi-structured, unstructured)● Analyze the cost of running database solutions in Google Cloud (comparative analysis)● Assess application and database dependenciesSection 2: Manage a solution that can span multiple database solutions2.1 Determine database connectivity and access management considerations. Activities include:● Determine Identity and Access Management (IAM) policies for database connectivity and access control● Manage database users, including authentication and access2.2 Configure database monitoring and troubleshooting options. Activities include:● Assess slow running queries and database locking and identify missing indexes● Monitor and investigate database vitals: RAM, CPU storage, I/O, Cloud Logging● Monitor and update quotas● Investigate database resource contention● Set up alerts for errors and performance metrics2.3 Design database backup and recovery solutions. Activities include:● Given SLAs and SLOs, recommend backup and recovery options (automatic scheduled backups)● Configure export and import data for databases● Design for recovery time objective (RTO) and recovery point objective (RPO)2.4 Optimize database cost and performance in Google Cloud. Activities include:● Assess options for scaling up and scaling out.● Scale database instances based on current and upcoming workload● Define replication strategies● Continuously assess and optimize the cost of running a database solution2.5 Determine solutions to automate database tasks. Activities include:● Perform database maintenance● Assess table fragmentation● Schedule database exportsSection 3: Migrate data solutions3.1 Design and implement data migration and replication. Activities include:● Develop and execute migration strategies and plans, including zero downtime, near-zero downtime, extended outage, and fallback plans● Reverse replication from Google Cloud to source● Plan and perform database migration, including fallback plans and schema conversion● Determine the correct database migration tools for a given scenarioSection 4: Deploy scalable and highly available databases in Google Cloud4.1 Apply concepts to implement highly scalable and available databases in Google Cloud. Activities include:● Provision high availability database solutions in Google Cloud● Test high availability and disaster recovery strategies periodically● Set up multi-regional replication for databases● Assess requirements for read replicas● Automate database instance provisioningAfter successfully passing the exam, the certification is valid for two years, and certified individuals must recertify to maintain their credential. The Google Professional Cloud Database Engineer certification is widely recognized in the industry and can help professionals advance their careers in the cloud and database management domains.
