Microsoft DP-900 Exam Syllabus Topics:
| Topic | Details |
|---|---|
Describe 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 (BI)) - 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 processing |
Describe 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 solutions - describe Azure SQL family of products including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines - describe Azure Synapse Analytics - describe Azure Database for PostgreSQL, Azure Database for MariaDB, and Azure Database for MySQL |
| Identify basic management tasks for relational data | - describe provisioning and deployment of relational data services - describe method for deployment including the Azure portal, Azure Resource Manager templates, Azure PowerShell, and the Azure command-line interface (CLI) - 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 Data Definition Language (DDL) versus Data Manipulation Language (DML) - query relational data in Azure SQL Database, Azure Database for PostgreSQL, and Azure Database for MySQL |
Describe 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 the Azure portal, Azure Resource Manager templates, Azure PowerShell, and the Azure command-line interface (CLI) - identify data security components (e.g., firewall, authentication, encryption) - 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 data |
Describe 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 Storage Gen2, 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., Azure HDInsight, 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 |
Topics of Microsoft DP-900: Microsoft Azure Data Fundamentals Exam
- Describe how to work with relational data on Azure (25-30%)
- Describe core data concepts (15-20%)
- Describe an analytics workload on Azure (25-30%)
- Describe how to work with non-relational data on Azure (25-30%)
Reference: https://docs.microsoft.com/en-us/learn/certifications/exams/dp-900
Helpful Training Course for Acing DP-900
To help students get fully ready for DP-900, Microsoft has created an official 1-day teacher-guided program for students named ‘Course DP-900T00-A: Microsoft Azure Data Fundamentals’. There are 4 modules in this course which will address all the topics needed for the Microsoft DP-900. However, such a class does not have any related lab exercises, meaning students will not get the scope for applying the things they have learnt in theory. In general, this training is perfect for those who want to learn the main concepts and skills needed to provide cloud data services with the help of Microsoft Azure.
Considerate service
We always adhere to the customer is God and we want to establish a long-term relation of cooperation with customers, which are embodied in the considerate service we provided. We provide services include: pre-sale consulting and after-sales service. Firstly, if you have any questions about purchasing process of the DP-900日本語 training materials: Microsoft Azure Data Fundamentals (DP-900日本語版), and you could contact our online support staffs. Furthermore, we will do our best to provide best products with reasonable price and frequent discounts. Secondly, we always think of our customers. After your purchase the materials, we will provide technology support if you are under the circumstance that you don't know how to use the DP-900日本語 exam preparatory or have any questions about them.
Dear customers, welcome to browse our products. As the society developing and technology advancing, we live in an increasingly changed world, which have a great effect on the world we live. In turn, we should seize the opportunity and be capable enough to hold the chance to improve your ability even better. We offer you our DP-900日本語 test braindumps: Microsoft Azure Data Fundamentals (DP-900日本語版) here for you reference. So let us take an unequivocal look of the DP-900日本語 exam cram as follows
High quality questions
There are nothing irrelevant contents in the DP-900日本語 exam braindumps: Microsoft Azure Data Fundamentals (DP-900日本語版), but all high quality questions you may encounter in your real exam. Many exam candidates are afraid of squandering time and large amount of money on useless questions, but it is unnecessary to worry about ours. You will not squander time or money once you bought our DP-900日本語 certification training. If you are uncertain about it, there are free demos preparing for you freely as a reference. With the high quality features and accurate contents in reasonable prices, anyone can afford such a desirable product of our company. So it is our mutual goal to fulfil your dreams of passing the Microsoft Microsoft Azure Data Fundamentals (DP-900日本語版) actual test and getting the certificate successfully.
Renew contents for free
After your purchase of our DP-900日本語 training materials: Microsoft Azure Data Fundamentals (DP-900日本語版), you can get a service of updating the materials when it has new contents. There are some services we provide for you. Our experts will revise the contents of our DP-900日本語 exam preparatory. We will never permit any mistakes existing in our Microsoft Azure Data Fundamentals (DP-900日本語版) actual lab questions, so you can totally trust us and our products with confidence. We will send you an e-mail which contains the newest version when DP-900日本語 training materials: Microsoft Azure Data Fundamentals (DP-900日本語版) have new contents lasting for one year, so hope you can have a good experience with our products.
After purchase, Instant Download: Upon successful payment, Our systems will automatically send the product you have purchased to your mailbox by email. (If not received within 12 hours, please contact us. Note: don't forget to check your spam.)
The newest updates
Our questions are never the stereotypes, but always being developed and improving according to the trend. After scrutinizing and checking the new questions and points of Microsoft DP-900日本語 exam, our experts add them into the DP-900日本語 test braindumps: Microsoft Azure Data Fundamentals (DP-900日本語版) instantly and avoid the missing of important information for you, then we send supplement to you freely for one years after you bought our DP-900日本語 exam cram, which will boost your confidence and refrain from worrying about missing the newest test items.
