Neste artigo
ToggleHey guys!
In this article I would like to share with you some free study material for the certification exam DP-900 Microsoft Azure Data Fundamentals. This is your chance to have material that will make 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 key Microsoft Azure data concepts and related data services. This exam is intended for candidates new to 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 analytics.
The value 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, covering only basic concepts, but the content is very comprehensive, that is, there is a lot to study, many different topics, but the questions they are not difficult.
To schedule the test, simply click on this link here.
Some interesting links for you on this topic
- Microsoft Certification – Tips on how to take the test at home without a headache
- New Microsoft Certified Fundamentals portal for those looking to earn their first certification
- FREE Microsoft Foundation Certifications for Students
- Skills measured by the DP-900 Azure Data Fundamentals exam
- Sample (mock) questions from the DP-900 Azure Data Fundamentals exam
DP-900 Exam Learning Path Microsoft Azure Data Fundamentals
Below I will make available the link to the official Microsoft learning path.
- Explore key data concepts
- Explore relational data in Azure
- Explore non-relational data in Azure
- Explore Data Analytics in Azure
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'm going to share the playlist he made covering all the content of the DP-900 test.
English Study Materials for DP-900 Microsoft Azure Data Fundamentals
Describe core data concepts (15-20%)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/
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 versus 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 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 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 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-apresentacao-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 analysis techniques (eg, 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 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
Descrever e comparar modelos de entrega PaaS, IaaS e SaaS
• 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 deploying 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 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 storage
• 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 Azur
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 provisioning and deploying 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 transactional workloads
• https://docs.microsoft.com/pt-br/azure/architecture/data-guide/relational-data/online-transaction-processing
Describe the difference between a transactional and analytics 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 realtime
• 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 storage 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 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
And 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/
Portuguese 
English