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.
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 obtain their first certification
- FREE Microsoft Fundamentals Certifications for Students
- Skills measured by the DP-900 Azure Data Fundamentals test
- Example (simulated) questions from the DP-900 Azure Data Fundamentals test
Learning Path for the DP-900 Microsoft Azure Data Fundamentals test
Below I will make available the link to Microsoft's official learning path.
- Explore key data concepts
- Explore relational data in Azure
- Explore non-relational data in Azure
- Explore data analytics on Azure
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 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 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 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-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 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 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 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/
Dirceu Resende
Database & BI Architect · Microsoft MVP · MCSE, MCSA, MCT, MTA, MCP.

Comentários (0)
Carregando comentários…