Hey guys!
In this article I would like to share with you free study material for the certification test DP-900 Microsoft Azure Data Fundamentals. This is your chance to have material that will help you pass the test without much difficulty and obtain your Microsoft Certified: Azure Data Fundamentals certification.

This exam is an opportunity to demonstrate knowledge of core data concepts and related Microsoft Azure data services. This exam is intended for candidates who are new to the cloud data environment.

Candidates should be familiar with relational and non-relational data concepts and different types of data workloads, such as transactional or analytical.

The cost of this test is 60 dollars for Brazil, you will have 90 minutes to finish the test and it has 40 to 60 questions. The level of the questions is basic, so the questions are very superficial, without requiring much knowledge or experience, only asking for basic concepts, but the content is very comprehensive, that is, there is a lot to study, many different topics, but the questions are not difficult.

To schedule the test, simply click this link here.

It's worth remembering that if you're a student, you can take the fundamentals tests (AZ-900, PL-900, DP-900 and others) without paying anything. FOR FREE. If you want to know more about this, read my article New Microsoft Certified Fundamentals portal for those looking to obtain their first certification.

Learning Path for the DP-900 Microsoft Azure Data Fundamentals test

Below I will make available the link to Microsoft's official learning path.

Material created by Eduardo Popovici

I'm going to share this excellent material created by Eduardo Popovici about the DP-900 test, which is amazing!

DP-900 training with Henrique Souza

Henrique Souza has a YouTube channel sensational, where he posts several videos, and, among them, courses on some certification tests. And I'm going to share the playlist he made covering all the content of the DP-900 test.

English Study Material for DP-900 Microsoft Azure Data Fundamentals

Describe core data concepts (15-20%)
Describe Types of Core Data Workloads
Describe batch data
• https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/batch-processing
• https://7wdata.be/business-analytics/batch-vs-real-time-data-processing/

Describe streaming data
• https://en.wikipedia.org/wiki/Streaming_data
• https://docs.microsoft.com/en-us/learn/paths/implement-data-streaming-with-asa/

Describe the difference between batch and streaming data
• https://thenewstack.io/the-big-data-debate-batch-processing-vs-streaming-processing/

Describe the characteristics of relational data
• https://www.oracle.com/database/what-is-a-relational-database/
• https://binaryterms.com/relational-data-model.html
• https://docs.rackspace.com/support/how-to/properties-of-rdbmss-and-nosql-databases/

Describe Data Analytics Core Concepts
Describe data visualization (e.g., visualization, reporting, business intelligence)
• https://www.tableau.com/learn/articles/data-visualization
• https://www.cio.com/article/272364/business-intelligence-definition-and-solutions.html

Describe basic chart types such as bar charts and pie charts
• https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a
• https://chartio.com/learn/charts/how-to-choose-pie-chart-vs-bar-chart/
• https://chartio.com/learn/charts/pie-chart-complete-guide/#what-is-a-pie-chart

Describe analytics techniques (e.g., descriptive, diagnostic, predictive, prescriptive, cognitive)
• https://www.investopedia.com/terms/d/data-analytics.asp
• https://insightsoftware.com/blog/comparing-descriptive-predictive-prescriptive-and-diagnostic-analytics
• https://www.expert.ai/blog/what-is-cognitive-analytics/

Describe ELT and ETL processing
• https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl
• https://www.integrate.io/blog/etl-vs-elt/

Describe the concepts of data processing
• https://www.mbaknol.com/management-information-systems/concept-of-data-processing/
• https://www.talend.com/resources/what-is-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
• https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
• https://azure.microsoft.com/en-us/products/category/databases/

Describe relational data structures (e.g., tables, index, views)
• https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
• https://www.cs.wcupa.edu/~zjiang/RDB_table.htm
• https://www.essentialsql.com/what-is-a-database-index/
• https://www.geeksforgeeks.org/sql-views/

Describe Relational Azure Data Services
Describe and compare PaaS, IaaS, and SaaS delivery models
• https://docs.microsoft.com/en-us/learn/modules/fundamental-azure-concepts/
• https://www.nigelfrank.com/blog/iaas-vs-saas-vs-paas-a-guide-to-azure-cloud-service-types/

Describe Azure SQL Database
• https://azure.microsoft.com/en-us/services/sql-database/#product-overview
• https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview?view=azuresql

Describe Azure Synapse Analytics
• https://azure.microsoft.com/en-us/services/synapse-analytics/

Describe SQL Server on Azure Virtual Machine
• https://azure.microsoft.com/en-us/services/virtual-machines/sql-server/#overview
• https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-server-on-azure-vm-iaas-what-is-overview?view=azuresql

Describe Azure Database for PostgreSQL, Azure Database for MariaDB, and Azure Database for MySQL
• https://azure.microsoft.com/en-us/services/postgresql/
• https://azure.microsoft.com/en-us/services/mariadb/
• https://azure.microsoft.com/en-us/services/mysql/#product-overview
• https://docs.microsoft.com/en-us/azure/mysql/single-server/overview
• https://docs.microsoft.com/en-us/azure/postgresql/single-server/overview

Describe Azure SQL Managed Instance
• https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview

Identify Basic Management Tasks for Relational Data
Describe provisioning and deployment of relational data services
• https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview
• https://docs.microsoft.com/en-us/learn/modules/provision-azure-sql-db/

Describe method for deployment including ARM templates and Azure Portal
• https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-arm-template-quickstart
• https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart?tabs=azure-portal
• https://docs.microsoft.com/en-us/azure/azure-sql/database/scripts/create-and-configure-database-powershell
• https://docs.microsoft.com/en-us/azure/azure-sql/database/arm-templates-content-guide?tabs=single-database
• https://docs.microsoft.com/en-us/azure/azure-sql/database/scripts/create-and-configure-database-cli

Identify data security components (e.g., firewall, authentication)
• https://docs.microsoft.com/en-us/azure/azure-sql/database/secure-database-tutorial
• https://docs.microsoft.com/en-us/azure/security/fundamentals/infrastructure-sql#azure-sql-database-firewall
• https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview
• https://docs.microsoft.com/en-us/azure/azure-sql/database/security-overview#information-protection-and-encryption

Identify basic connectivity issues (e.g., accessing from on-premises, access with Azure VNets, access from Internet, authentication, firewalls)
• https://docs.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-errors-issues
• https://techcommunity.microsoft.com/t5/azure-database-support-blog/azure-sql-db-connectivity-troubleshooting/ba-p/1158677

Identify query tools (e.g., Azure Data Studio, SQL Server Management Studio, sqlcmd utility, etc.)
• https://docs.microsoft.com/en-us/azure/azure-sql/database/connect-query-ssms
• https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-data-studio
• https://docs.microsoft.com/en-us/sql/ssms/quickstarts/ssms-connect-query-sql-server

Describe Query Techniques for Data Using SQL Language
Compare DDL vs DML
• https://www.geeksforgeeks.org/difference-between-ddl-and-dml-in-dbms/

Query relational data in PostgreSQL, MySQL, and Azure SQL Database
• https://docs.microsoft.com/en-us/sql/azure-data-studio/quickstart-postgres
• https://docs.microsoft.com/en-us/azure/mysql/connect-workbench
• https://docs.microsoft.com/en-us/azure/azure-sql/database/connect-query-portal
• https://azure.microsoft.com/en-us/blog/fast-and-easy-dev-with-azure-db-for-mysql-and-azuredb-for-postgresql/

Describe how to work with non-relational data on Azure (25-30%)
Describe Non-Relational Data Workloads
Describe the characteristics of non-relational data
• https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/non-relational-data
• https://docs.rackspace.com/support/how-to/properties-of-rdbmss-and-nosql-databases/#properties-of-nosql-databases

Describe the types of non-relational and NoSQL data
• https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/non-relational-data

Recommend the correct data store
• https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/non-relational-data#typical-requirements

Determine when to use non-relational data
• https://www.pluralsight.com/blog/software-development/relational-non-relational-databases
• https://docs.rackspace.com/support/how-to/properties-of-rdbmss-and-nosql-databases/

Describe Non-Relational Data Offerings on Azure
Identify Azure data services for non-relational workloads
• https://azure.microsoft.com/en-us/overview/nosql-database/
• https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Describe Azure Cosmos DB APIs
• https://docs.microsoft.com/en-us/learn/modules/choose-api-for-cosmos-db/

Describe Azure Table storage
• https://azure.microsoft.com/en-us/services/storage/tables/

Describe Azure Blob storage
• https://azure.microsoft.com/en-us/services/storage/blobs/

Describe Azure File storage
• https://azure.microsoft.com/en-us/services/storage/files/

Identify Basic Management Tasks for Non-Relational Data
Describe provisioning and deployment of non-relational data services
• https://docs.microsoft.com/en-us/azure/cosmos-db/sql/create-cosmosdb-resources-portal

Describe method for deployment including ARM templates and Azure Portal
• https://docs.microsoft.com/en-us/azure/cosmos-db/sql/create-cosmosdb-resources-portal
• https://docs.microsoft.com/en-us/azure/cosmos-db/scripts/powershell/sql/create
• https://docs.microsoft.com/en-us/azure/cosmos-db/scripts/cli/sql/create
• https://docs.microsoft.com/en-us/azure/cosmos-db/sql/quick-create-template?tabs=CLI

Identify data security components (e.g., firewall, authentication)
• https://docs.microsoft.com/en-us/azure/cosmos-db/database-security
• https://docs.microsoft.com/en-us/azure/cosmos-db/how-to-configure-firewall
• https://docs.microsoft.com/en-us/azure/cosmos-db/secure-access-to-data
• https://docs.microsoft.com/en-us/azure/cosmos-db/database-encryption-at-rest

Identify basic connectivity issues (e.g., accessing from on-premises, access with Azure VNets, access from Internet, authentication, firewalls)
• https://docs.microsoft.com/en-us/azure/cosmos-db/sql/troubleshoot-dot-net-sdk
• https://docs.microsoft.com/en-us/azure/cosmos-db/how-to-configure-firewall#troubleshoot-ip-firewall
• https://github.com/Azure/azure-cosmos-dotnet-v2/issues/662

Identify management tools for non-relational data
• https://docs.microsoft.com/en-us/azure/cosmos-db/data-explorer

Describe an Analytics Workload on Azure (25-30%)
Describe Analytics Workloads
Describe transactional workloads
• https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processing

Describe the difference between a transactional and an analytics workload
• https://datawarehouseinfo.com/how-does-oltp-differ-from-olap-database/

Describe the difference between batch and real time
• https://7wdata.be/business-analytics/batch-vs-real-time-data-processing/

Describe data warehousing workloads
• https://www.itprotoday.com/sql-server/data-warehouse-workloads-and-use-cases
• https://azure.microsoft.com/en-us/updates/workload-importance-for-azure-sql-data-warehouse-is-now-generally-available/

Determine when a data warehouse solution is needed
• https://www.jamesserra.com/archive/2013/07/why-you-need-a-data-warehouse/

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
• https://azure.microsoft.com/en-us/solutions/data-lake/
• https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-introduction
• https://azure.microsoft.com/en-us/services/synapse-analytics/
• https://docs.microsoft.com/en-us/azure/databricks/scenarios/what-is-azure-databricks
• https://azure.microsoft.com/en-us/services/databricks/
• https://docs.microsoft.com/en-us/azure/hdinsight/

Describe modern data warehousing architecture and workload
• https://docs.microsoft.com/en-us/azure/architecture/solution-ideas/articles/enterprise-data-warehouse

Describe Data Ingestion and Processing on Azure
Describe common practices for data loading
• https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/design-elt-data-loading

Describe the components of Azure Data Factory (e.g., pipeline, activities, etc.)
• https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities
• https://www.youtube.com/watch?v=UQpAZVrRrzs

Describe data processing options (e.g., HDI, Azure Databricks, Azure Synapse Analytics, Azure Data Factory)
• https://docs.microsoft.com/en-us/azure/hdinsight/hdinsight-overview
• https://docs.microsoft.com/en-us/azure/data-factory/introduction
• https://docs.microsoft.com/en-us/azure/databricks/scenarios/what-is-azure-databricks
• https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-what-is
• https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/data-storage

Describe Data Visualization in Microsoft Power BI
Describe the role of paginated reporting
• https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-bi

Describe the role of interactive reports
• https://powerbi.microsoft.com/en-us/desktop/

Describe the role of dashboards
• https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboards
• https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboards

Describe the workflow in Power BI
• https://curbal.com/blog/lesson/power-bi-workflow

Study Material in Portuguese for DP-900 Microsoft Azure Data Fundamentals

Describe key data concepts (25-30%)
Describe the types of core data workloads
Describe batch data
• https://docs.microsoft.com/pt-br/azure/architecture/data-guide/big-data/batch-processing

Describe streaming data
• https://pt.wikipedia.org/wiki/Streaming_data
• https://docs.microsoft.com/pt-br/learn/paths/implement-data-streaming-with-asa/

Describe the difference between batch and streaming data
• https://insightlab.ufc.br/entenda-como-funciona-streaming-de-dados-em-tempo-real-2
• https://santodigital.com.br/processamento-de-dados-o-que-e-batch-e-stream

Describe the characteristics of relational data
• https://docs.microsoft.com/pt-br/learn/modules/describe-concepts-of-relational-data/
• https://www.oracle.com/br/database/what-is-a-relational-database

Describe the main concepts of data analysis
Describe data visualization (e.g. visualization, reporting, business intelligence)
• https://powerbi.microsoft.com/pt-br/data-visualization/
• https://itforum.com.br/noticias/o-que-e-visualizacao-de-dados-sistemacao-de-dados-para-tomada-de-decisao/

Describe basic chart types, such as bar charts and pie charts
• https://docs.microsoft.com/pt-br/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a

Describe analytical techniques (e.g., descriptive, diagnostic, predictive, prescriptive, cognitive)
• https://blog.academiain1.com.br/big-data-voce-conhecimento-os-4-tipos-de-analise-de-dados/
• https://www.aquare.la/analise-descritiva-preditiva-prescritiva-e-cenarizacao/
• https://www.geofusion.com.br/blog/analises-descritivas-diagnosticas-preditivas-prescritivas/

Describe ELT and ETL processing
• https://docs.microsoft.com/pt-br/azure/architecture/data-guide/relational-data/etl

Describe data processing concepts
• https://www.crtrj.gov.br/o-que-e-processamento-de-dados

Identify relational data considerations in Azure (20-25%)
Describe relational data workloads
Identify the right data offering for a relational workload
• https://docs.microsoft.com/pt-br/azure/architecture/guide/technology-choices/data-store-overview
• https://azure.microsoft.com/pt-br/products/category/databases/

Describe relational data structures (e.g. tables, indexes, views)
• https://blog.betrybe.com/tecnologia/banco-de-dados-relacional/
• https://pt.wikipedia.org/wiki/Banco_de_dados_relacional
• https://www.devmedia.com.br/introducao-a-views/1614
• http://thiagocury.eti.br/disciplinas/banco-de-dados-relacional/conceito-de-chaves-no-banco-de-dados-relacional.php
• http://www.bosontreinamentos.com.br/bancos-de-dados/o-que-sao-indices-em-bancos-de-dados-indexacao-em-tabelas/

Describe Azure Relational Data Services
Describe and compare PaaS, IaaS, and SaaS delivery models
• https://docs.microsoft.com/pt-br/learn/modules/fundamental-azure-concepts/

Describe Azure SQL Database
• https://azure.microsoft.com/pt-br/services/sql-database/#product-overview
• https://docs.microsoft.com/pt-br/azure/azure-sql/database/sql-database-paas-overview?view=azuresql

Describe Azure Synapse Analytics
• https://azure.microsoft.com/pt-br/services/synapse-analytics/

Describe SQL Server on Azure Virtual Machine
• https://azure.microsoft.com/pt-br/services/virtual-machines/sql-server/#overview
• https://docs.microsoft.com/pt-br/azure/azure-sql/virtual-machines/windows/sql-server-on-azure-vm-iaas-what-is-overview?view=azuresql

Describe Azure Database for PostgreSQL, Azure Database for MariaDB, and Azure Database for MySQL
• https://azure.microsoft.com/pt-br/services/postgresql/
• https://azure.microsoft.com/pt-br/services/mariadb/
• https://azure.microsoft.com/pt-br/services/mysql/#product-overview
• https://docs.microsoft.com/pt-br/azure/mysql/single-server/overview
• https://docs.microsoft.com/pt-br/azure/postgresql/single-server/overview

Describe Azure SQL Managed Instance
• https://docs.microsoft.com/pt-br/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview

Identify basic management tasks for relational data
Describe the provisioning and deployment of relational data services
• https://docs.microsoft.com/pt-br/azure/azure-sql/database/sql-database-paas-overview
• https://docs.microsoft.com/pt-br/learn/modules/provision-azure-sql-db/

Describe the method for deployment, including ARM templates and Azure Portal
• https://docs.microsoft.com/pt-br/azure/azure-sql/database/single-database-create-arm-template-quickstart
• https://docs.microsoft.com/pt-br/azure/azure-sql/database/single-database-create-quickstart?tabs=azure-portal
• https://docs.microsoft.com/pt-br/azure/azure-sql/database/scripts/create-and-configure-database-powershell
• https://docs.microsoft.com/pt-br/azure/azure-sql/database/arm-templates-content-guide?tabs=single-database
• https://docs.microsoft.com/pt-br/azure/azure-sql/database/scripts/create-and-configure-database-cli

Identify data security components (e.g. firewall, authentication)
• https://docs.microsoft.com/pt-br/azure/azure-sql/database/secure-database-tutorial
• https://docs.microsoft.com/pt-br/azure/security/fundamentals/infrastructure-sql#azure-sql-database-firewall
• https://docs.microsoft.com/pt-br/azure/azure-sql/database/authentication-aad-overview
• https://docs.microsoft.com/pt-br/azure/azure-sql/database/security-overview#information-protection-and-encryption

Identify basic connectivity issues (e.g. on-premises access, access with Azure VNets, access over the internet, authentication, firewalls)
• https://docs.microsoft.com/pt-br/azure/azure-sql/database/troubleshoot-common-errors-issues
• https://techcommunity.microsoft.com/t5/azure-database-support-blog/azure-sql-db-connectivity-troubleshooting/ba-p/1158677

Identify query tools (e.g. Azure Data Studio, SQL Server Management Studio, sqlcmd utility, etc.)
• https://docs.microsoft.com/pt-br/azure/azure-sql/database/connect-query-ssms
• https://docs.microsoft.com/pt-br/sql/azure-data-studio/what-is-azure-data-studio
• https://docs.microsoft.com/pt-br/sql/ssms/quickstarts/ssms-connect-query-sql-server

Describe query techniques for data using the SQL language
Compare DDL vs DML
• https://pt.gadget-info.com/difference-between-ddl

Query relational data in PostgreSQL, MySQL, and Azure SQL Database
• https://docs.microsoft.com/pt-br/sql/azure-data-studio/quickstart-postgres
• https://docs.microsoft.com/pt-br/azure/mysql/connect-workbench
• https://docs.microsoft.com/pt-br/azure/azure-sql/database/connect-query-portal
• https://azure.microsoft.com/pt-br/blog/fast-and-easy-dev-with-azure-db-for-mysql-and-azuredb-for-postgresql/

Describe considerations for working with non-relational data in Azure (15-20%)
Describe non-relational data workloads
Describe the characteristics of non-relational data
• https://docs.microsoft.com/pt-br/azure/architecture/data-guide/big-data/non-relational-data
• https://docs.rackspace.com/support/how-to/properties-of-rdbmss-and-nosql-databases/#properties-of-nosql-databases

Describe non-relational and NoSQL data types
• https://docs.microsoft.com/pt-br/azure/architecture/data-guide/big-data/non-relational-data

Recommend the right data store
• https://docs.microsoft.com/pt-br/azure/architecture/data-guide/big-data/non-relational-data#typical-requirements

Determine when to use non-relational data
• https://www.pluralsight.com/blog/software-development/relational-non-relational-databases
• https://docs.rackspace.com/support/how-to/properties-of-rdbmss-and-nosql-databases/

Describe non-relational data offerings on Azure
Identify Azure data services for non-relational workloads
• https://azure.microsoft.com/pt-br/overview/nosql-database/
• https://docs.microsoft.com/pt-br/azure/architecture/guide/technology-choices/data-store-overview

Describe the Azure Cosmos DB APIs
• https://docs.microsoft.com/pt-br/learn/modules/choose-api-for-cosmos-db/

Describe Azure table storage
• https://azure.microsoft.com/pt-br/services/storage/tables/

Describe Azure Blob storage
• https://azure.microsoft.com/pt-br/services/storage/blobs/

Describe Azure file storage
• https://azure.microsoft.com/pt-br/services/storage/files/

Identify basic management tasks for non-relational data
Describe the provisioning and deployment of non-relational data services
• https://docs.microsoft.com/pt-br/azure/cosmos-db/sql/create-cosmosdb-resources-portal

Describe the method for deployment, including ARM templates and Azure Portal
• https://docs.microsoft.com/pt-br/azure/cosmos-db/sql/create-cosmosdb-resources-portal
• https://docs.microsoft.com/pt-br/azure/cosmos-db/scripts/powershell/sql/create
• https://docs.microsoft.com/pt-br/azure/cosmos-db/scripts/cli/sql/create
• https://docs.microsoft.com/pt-br/azure/cosmos-db/sql/quick-create-template?tabs=CLI

Identify data security components (e.g. firewall, authentication)
• https://docs.microsoft.com/pt-br/azure/cosmos-db/database-security
• https://docs.microsoft.com/pt-br/azure/cosmos-db/how-to-configure-firewall
• https://docs.microsoft.com/pt-br/azure/cosmos-db/secure-access-to-data
• https://docs.microsoft.com/pt-br/azure/cosmos-db/database-encryption-at-rest

Identify basic connectivity issues (e.g. on-premises access, access with Azure VNets, access over the internet, authentication, firewalls)
• https://docs.microsoft.com/pt-br/azure/cosmos-db/sql/troubleshoot-dot-net-sdk
• https://docs.microsoft.com/pt-br/azure/cosmos-db/how-to-configure-firewall#troubleshoot-ip-firewall
• https://github.com/Azure/azure-cosmos-dotnet-v2/issues/662

Identify management tools for non-relational data
• https://docs.microsoft.com/pt-br/azure/cosmos-db/data-explorer

Describe an analytics workload on Azure (25% – 30%)
Describe Analytics workloads
Describe transactional workloads
• https://docs.microsoft.com/pt-br/azure/architecture/data-guide/relational-data/online-transaction-processing

Describe the difference between a transactional and analytical workload
• https://canaltech.com.br/business-intelligence/o-que-significa-oltp-e-olap-na-pratica/
• https://4future.com.br/index.php/2022/04/19/dados-transacionais-e-dados-analiticos/
• https://www.dataex.com.br/oltp-e-olap/

Describe the difference between batch and real time
• https://insightlab.ufc.br/entenda-como-funciona-streaming-de-dados-em-tempo-real-2
• https://santodigital.com.br/processamento-de-dados-o-que-e-batch-e-stream

Describe data warehousing workloads
• https://azure.microsoft.com/pt-br/updates/workload-importance-for-azure-sql-data-warehouse-is-now-generally-available/

Determine when a data warehouse solution is needed
• https://www.fiveacts.com.br/data-warehouse/
• https://www.devmedia.com.br/data-warehouse/12609

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
• https://azure.microsoft.com/pt-br/solutions/data-lake/
• https://docs.microsoft.com/pt-br/azure/storage/blobs/data-lake-storage-introduction
• https://azure.microsoft.com/pt-br/services/synapse-analytics/
• https://docs.microsoft.com/pt-br/azure/databricks/scenarios/what-is-azure-databricks
• https://azure.microsoft.com/pt-br/services/databricks/
• https://docs.microsoft.com/pt-br/azure/hdinsight/

Describe the modern data warehouse architecture and workload
• https://docs.microsoft.com/pt-br/azure/architecture/solution-ideas/articles/enterprise-data-warehouse

Describe data ingestion and processing in Azure
Describe common practices for loading data
• https://docs.microsoft.com/pt-br/azure/synapse-analytics/sql-data-warehouse/design-elt-data-loading

Describe Azure Data Factory components (e.g. pipeline, activities, etc.)
• https://docs.microsoft.com/pt-br/azure/data-factory/concepts-pipelines-activities

Describe data processing options (e.g. HDI, Azure Databricks, Azure Synapse Analytics, Azure Data Factory)
• https://docs.microsoft.com/pt-br/azure/hdinsight/hdinsight-overview
• https://docs.microsoft.com/pt-br/azure/data-factory/introduction
• https://docs.microsoft.com/pt-br/azure/databricks/scenarios/what-is-azure-databricks
• https://docs.microsoft.com/pt-br/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-what-is
• https://docs.microsoft.com/pt-br/azure/architecture/data-guide/technology-choices/data-storage

Describe data visualization in Microsoft Power BI
Describe the function of paginated reports
• https://docs.microsoft.com/pt-br/power-bi/paginated-reports/paginated-reports-report-builder-power-bi

Describe the role of interactive reports
• https://powerbi.microsoft.com/pt-br/desktop/

Describe the role of panels
• https://docs.microsoft.com/pt-br/power-bi/consumer/end-user-dashboards
• https://www.alura.com.br/artigos/dashboards-vs-relatorios

Describe the workflow in Power BI
• https://curbal.com/blog/lesson/power-bi-workflow

That's it, folks!
Good luck to you, good race and a big hug.

References
https://www.testpreptraining.com/blog/dp-900-microsoft-azure-data-fundamentals-cheat-sheet/
https://johnmccormack.it/2020/08/dp-900-exam-prep-reading-list/
https://learncloud.info/dp-900-exam-study-guide-microsoft-azure-data-fundamentals/
https://usc.pax8.com/resource/display/79440
https://cloudkeeda.com/dp-900/

Career, Courses and Certifications certification dp-900 exam