Click on the banner to learn about and purchase my database training on Azure

Microsoft Azure Data Fundamentals DP-900 Exam – Free Certification Exam Study Material

This post is the 13 part of 13 in the series. Microsoft Certification
Reading Time: 8 minutes

Speak guys!
In this article I would like to share with you a free study material for the certification exam DP-900 Microsoft Azure Data Fundamentals. This is your chance to have a material that will make you pass the exam without too many difficulties 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 starting out in the cloud data environment.

Candidates should be familiar with relational and non-relational data concepts and with 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, charging only 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, just click this link here.

It is worth remembering that if you are 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 it, read my article. New Microsoft Certified Fundamentals portal for those looking to get their first certification.

Some interesting links for you on this topic

Microsoft Azure Data Fundamentals DP-900 Exam Learning Path

Below I will make available the link to the official Microsoft learning roadmap.

Material created by Eduardo Popovici

I will share this excellent material created by Eduardo Popovici about the DP-900 test which is sensational!

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 will share the playlist he made covering all the content of the DP-900 test.

English Study Material for the 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 (eg, 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 (eg, 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 (eg, 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 (eg, 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 (eg, 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 (eg, 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 (eg, 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 (eg, 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 the 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 (eg, 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 (eg, 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 the DP-900 Microsoft Azure Data Fundamentals

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

Describing 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-apresentacao-de-dados-para-tomada-de-decisao/

Describe basic types of charts, 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 analysis techniques (e.g. descriptive, diagnostic, predictive, prescriptive, cognitive)
https://blog.academiain1.com.br/big-data-voce-conhece-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 considerations for relational data 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 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 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, internet access, 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 versus 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 correct data storage
https://docs.microsoft.com/pt-br/azure/architecture/data-guide/big-data/non-relational-data#typical-requirements

Determining 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 in 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 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 provisioning and deployment of non-relational data services
https://docs.microsoft.com/pt-br/azure/cosmos-db/sql/create-cosmosdb-resources-portal

Describe 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, internet access, 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 in 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 modern data warehouse architecture and workload
https://docs.microsoft.com/pt-br/azure/architecture/solution-ideas/articles/enterprise-data-warehouse

Describe ingesting and processing data 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 role 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 workflow in Power BI
https://curbal.com/blog/lesson/power-bi-workflow

That's it folks!
Good luck to you, good test 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/