|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/dp-900-microsoft/
课程评论：没有评论
课程名称：DP-900：Microsoft Azure数据基础知识模拟测试 课程概述： 本课程旨在为希望在云中处理数据的候选人提供有关核心数据概念的基础知识，以及如何使用Microsoft Azure数据服务实施这些概念。此考试适合刚开始接触云数据的人员。参与者应熟悉关系型和非关系型数据的概念，以及不同类型的数据工作负载，如事务型和分析型。此外，Azure数据基础知识也可为其他Azure角色认证（如Azure数据库管理员助理或Azure数据工程师助理）做准备，但不是这些认证的前提条件。 技能测评： 1. 描述核心数据概念（15-20%） - 核心数据工作负载类型 - 批量数据与流数据的区别 - 数据分析核心概念 2. 在Azure上处理关系型数据（25-30%） - 理解关系型数据工作负载 - 识别适合关系型工作负载的数据服务 - 识别基本的关系型数据管理任务 3. 在Azure上处理非关系型数据（25-30%） - 理解非关系型数据工作负载和特征 - 推荐合适的非关系型数据存储 - 识别基本的非关系型数据管理任务 4. 在Azure上的分析工作负载（25-30%） - 理解分析工作负载与事务工作负载的区别 - 确定何时需要数据仓库解决方案 - 描述现代数据仓库的组件与架构 5. 数据可视化在Microsoft Power BI中的应用 - 描述分页报告、交互式报告和仪表板的角色 - 了解Power BI中的工作流程 通过完成本课程，学员将获得在Azure平台上有效处理和管理数据的基本知识，为今后的更高层次的Azure认证打下坚实的基础。
Candidates for this exam should have foundational knowledge of core data concepts and how they are implemented using Microsoft Azure data services.This exam is intended for candidates beginning to work with data in the cloud.Candidates should be familiar with the concepts of relational and non-relational data, and different types of data workloads such as transactional or analytical.Azure Data Fundamentals can be used to prepare for other Azure role-based certifications like Azure Database Administrator Associate or Azure Data Engineer Associate, but it's not a prerequisite for any of them.Skills MeasuredDescribe core data concepts (15-20%)Describe types of core data workloads · describe batch data · describe streaming data · describe the difference between batch and streaming data · describe the characteristics of relational data Describe data analytics core concepts · describe data visualization (e.g., visualization, reporting, business intelligence · describe basic chart types such as bar charts and pie charts · describe analytics techniques (e.g., descriptive, diagnostic, predictive, prescriptive, cognitive) · describe ELT and ETL processing · describe the concepts of data processingDescribe how to work with relational data on Azure (25-30%)Describe relational data workloads · identify the right data offering for a relational workload · describe relational data structures (e.g., tables, index, views) Describe relational Azure data services · describe and compare PaaS, IaaS, and SaaS delivery models · describe Azure SQL Database · describe Azure Synapse Analytics · describe SQL Server on Azure Virtual Machine · describe Azure Database for PostgreSQL, Azure Database for MariaDB, and Azure Database for MySQL · describe Azure SQL Managed Instance Identify basic management tasks for relational data · describe provisioning and deployment of relational data services · describe method for deployment including ARM templates and Azure Portal · identify data security components (e.g., firewall, authentication) · identify basic connectivity issues (e.g., accessing from on-premises, access with Azure VNets, access from Internet, authentication, firewalls) · identify query tools (e.g., Azure Data Studio, SQL Server Management Studio, sqlcmd utility, etc.) Describe query techniques for data using SQL language · compare DDL versus DML · query relational data in PostgreSQL, MySQL, and Azure SQL DatabaseDescribe how to work with non-relational data on Azure (25-30%)Describe non-relational data workloads · describe the characteristics of non-relational data · describe the types of non-relational and NoSQL data · recommend the correct data store · determine when to use non-relational data Describe non-relational data offerings on Azure · identify Azure data services for non-relational workloads · describe Azure Cosmos DB APIs · describe Azure Table storage · describe Azure Blob storage · describe Azure File storage Identify basic management tasks for non-relational data · describe provisioning and deployment of non-relational data services · describe method for deployment including ARM templates and Azure Portal · identify data security components (e.g., firewall, authentication) · identify basic connectivity issues (e.g., accessing from on-premises, access with Azure VNets, access from Internet, authentication, firewalls) · identify management tools for non-relational dataDescribe an analytics workload on Azure (25-30%)Describe analytics workloads · describe transactional workloads · describe the difference between a transactional and an analytics workload · describe the difference between batch and real time · describe data warehousing workloads · determine when a data warehouse solution is needed Describe the components of a modern data warehouse · describe Azure data services for modern data warehousing such as Azure Data Lake, Azure Synapse Analytics, Azure Databricks, and Azure HDInsight · describe modern data warehousing architecture and workload Describe data ingestion and processing on Azure · describe common practices for data loading · describe the components of Azure Data Factory (e.g., pipeline, activities, etc.) · describe data processing options (e.g., HDI, Azure Databricks, Azure Synapse Analytics, Azure Data Factory) Describe data visualization in Microsoft Power BI · describe the role of paginated reporting · describe the role of interactive reports · describe the role of dashboards · describe the workflow in Power BI
