Clique no banner para conhecer e adquirir o meu treinamento de Bancos de Dados no Azure

Exame DP-900 Microsoft Azure Data Fundamentals – Material de estudo gratuito para a prova de certificação

Visualizações: 7.031 views
Esse post é a parte 13 de 15 da série Certificação Microsoft
Tempo de Leitura: 8 minutos

Fala pessoal!
Nesse artigo eu gostaria de compartilhar com vocês um material de estudo gratuito para a prova de certificação DP-900 Microsoft Azure Data Fundamentals. Essa é a sua chance de ter um material que vai te fazer passar na prova sem muitas dificuldades e obter sua certificação Microsoft Certified: Azure Data Fundamentals.

Este exame é uma oportunidade para demonstrar o conhecimento dos principais conceitos de dados e serviços de dados relacionados do Microsoft Azure. Este exame destina-se a candidatos que estão iniciando no ambiente de dados em nuvem.

Os candidatos devem estar familiarizados com os conceitos de dados relacionais e não relacionais e com diferentes tipos de cargas de trabalho de dados, como transacionais ou analíticas.

O valor dessa prova é de 60 dólares para o Brasil, você terá 90 minutos para terminar a prova e ela possui de 40 a 60 questões. O nível das questões é básico, então as perguntas são bem superficiais, sem exigir muito conhecimento ou experiência, cobrando apenas conceitos básicos mesmo, mas o conteúdo é bem abrangente, ou seja, tem muita coisa para estudar, muitos tópicos diferentes, mas as perguntas não são difíceis.

Para agendar a prova, basta clicar nesse link aqui.

Vale lembrar que se você for estudante, você pode fazer as provas de fundamentos (AZ-900, PL-900, DP-900 e outras) sem pagar nada. DE GRAÇA. Se você quiser saber mais sobre isso, leia o meu artigo Novo portal Microsoft Certified Fundamentals para quem quer obter sua primeira certificação.

Alguns links interessantes para você sobre esse tema

Roteiro de Aprendizado da prova DP-900 Microsoft Azure Data Fundamentals

Abaixo vou deixar disponível o link do roteiro de aprendizado oficial da Microsoft.

Material criado pelo Eduardo Popovici

Vou compartilhar esse material excelente criado pelo Eduardo Popovici sobre a prova DP-900 que está sensacional!

Treinamento DP-900 com o Henrique Souza

O Henrique Souza tem um canal no YouTube sensacional, onde ele posta diversos vídeos, e, entre eles, cursos sobre algumas provas de certificação. E vou compartilhar a playlist que ele fez abordando todo o conteúdo da prova DP-900.

Material de Estudo em Inglês para a 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 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 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

Material de Estudo em Português para a DP-900 Microsoft Azure Data Fundamentals

Descrever os principais conceitos de dados (25-30%)
Descrever os tipos de cargas de trabalho de dados principais
Descrever dados de lote
https://docs.microsoft.com/pt-br/azure/architecture/data-guide/big-data/batch-processing

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

Descrever a diferença entre dados em lote e streaming
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

Descrever as características dos dados relacionais
https://docs.microsoft.com/pt-br/learn/modules/describe-concepts-of-relational-data/
https://www.oracle.com/br/database/what-is-a-relational-database

Descrever os principais conceitos de análise de dados
Descrever a visualização de dados (por exemplo, visualização, relatórios, inteligência de negócios)
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/

Descrever tipos básicos de gráficos, como gráficos de barras e gráficos de pizza
https://docs.microsoft.com/pt-br/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a

Descrever técnicas de análise (por exemplo, descritivas, diagnósticas, preditivas, prescritivas, cognitivas)
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/

Descrever o processamento ELT e ETL
https://docs.microsoft.com/pt-br/azure/architecture/data-guide/relational-data/etl

Descrever os conceitos de processamento de dados
https://www.crtrj.gov.br/o-que-e-processamento-de-dados

Identificar considerações sobre dados relacionais no Azure (20-25%)
Descrever cargas de trabalho de dados relacionais
Identifique a oferta de dados certa para uma carga de trabalho relacional
https://docs.microsoft.com/pt-br/azure/architecture/guide/technology-choices/data-store-overview
https://azure.microsoft.com/pt-br/products/category/databases/

Descrever estruturas de dados relacionais (por exemplo, tabelas, índices, visualizações)
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/

Descrever os Serviços de Dados Relacionais do Azure
Descrever e comparar modelos de entrega PaaS, IaaS e SaaS
https://docs.microsoft.com/pt-br/learn/modules/fundamental-azure-concepts/

Descrever o Banco de Dados SQL do Azure
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

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

Descrever o SQL Server na Máquina Virtual do Azure
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

Descrever o Banco de Dados do Azure para PostgreSQL, Banco de Dados do Azure para MariaDB e Banco de Dados do Azure para 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

Descrever a Instância Gerenciada do Azure SQL
https://docs.microsoft.com/pt-br/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview

Identificar tarefas básicas de gerenciamento para dados relacionais
Descrever o provisionamento e a implantação de serviços de dados relacionais
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/

Descrever o método para implantação, incluindo modelos ARM e Portal do Azure
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

Identificar componentes de segurança de dados (por exemplo, firewall, autenticação)
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

Identifique problemas básicos de conectividade (por exemplo, acesso local, acesso com VNets do Azure, acesso pela Internet, autenticação, 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

Identificar ferramentas de consulta (por exemplo, Azure Data Studio, SQL Server Management Studio, utilitário sqlcmd 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

Descrever técnicas de consulta para dados usando a linguagem SQL
Comparar DDL versus DML
https://pt.gadget-info.com/difference-between-ddl

Consultar dados relacionais no PostgreSQL, MySQL e Banco de Dados SQL do Azure
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/

Descrever considerações sobre o trabalho com dados não relacionais no Azure (15-20%)
Descrever cargas de trabalho de dados não relacionais
Descrever as características dos dados não relacionais
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

Descrever os tipos de dados não relacionais e NoSQL
https://docs.microsoft.com/pt-br/azure/architecture/data-guide/big-data/non-relational-data

Recomendar o armazenamento de dados correto
https://docs.microsoft.com/pt-br/azure/architecture/data-guide/big-data/non-relational-data#typical-requirements

Determinar quando usar dados não relacionais
https://www.pluralsight.com/blog/software-development/relational-non-relational-databases
https://docs.rackspace.com/support/how-to/properties-of-rdbmss-and-nosql-databases/

Descrever ofertas de dados não relacionais no Azure
Identifique os serviços de dados do Azure para cargas de trabalho não relacionais
https://azure.microsoft.com/pt-br/overview/nosql-database/
https://docs.microsoft.com/pt-br/azure/architecture/guide/technology-choices/data-store-overview

Descrever as APIs do Azure Cosmos DB
https://docs.microsoft.com/pt-br/learn/modules/choose-api-for-cosmos-db/

Descrever o armazenamento de tabelas do Azure
https://azure.microsoft.com/pt-br/services/storage/tables/

Descrever o armazenamento de Blobs do Azure
https://azure.microsoft.com/pt-br/services/storage/blobs/

Descrever o armazenamento de arquivos do Azure
https://azure.microsoft.com/pt-br/services/storage/files/

Identificar tarefas básicas de gerenciamento para dados não relacionais
Descrever o provisionamento e a implantação de serviços de dados não relacionais
https://docs.microsoft.com/pt-br/azure/cosmos-db/sql/create-cosmosdb-resources-portal

Descrever o método para implantação, incluindo modelos ARM e Portal do Azure
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

Identificar componentes de segurança de dados (por exemplo, firewall, autenticação)
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

Identifique problemas básicos de conectividade (por exemplo, acesso local, acesso com VNets do Azure, acesso pela Internet, autenticação, 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

Identificar ferramentas de gerenciamento para dados não relacionais
https://docs.microsoft.com/pt-br/azure/cosmos-db/data-explorer

Descrever uma carga de trabalho de análise no Azure (25% – 30%)
Descrever cargas de trabalho do Analytics
Descrever cargas de trabalho transacionais
https://docs.microsoft.com/pt-br/azure/architecture/data-guide/relational-data/online-transaction-processing

Descrever a diferença entre uma carga de trabalho transacional e analítica
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/

Descreva a diferença entre lote e tempo real
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

Descrever cargas de trabalho de armazenamento de dados
https://azure.microsoft.com/pt-br/updates/workload-importance-for-azure-sql-data-warehouse-is-now-generally-available/

Determine quando uma solução de data warehouse é necessária
https://www.fiveacts.com.br/data-warehouse/
https://www.devmedia.com.br/data-warehouse/12609

Descrever os componentes de um data warehouse moderno
Descrever os serviços de dados do Azure para data warehousing moderno, como Azure Data Lake, Azure Synapse Analytics, Azure Databricks e 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/

Descrever a arquitetura moderna de data warehouse e a carga de trabalho
https://docs.microsoft.com/pt-br/azure/architecture/solution-ideas/articles/enterprise-data-warehouse

Descrever a ingestão e processamento de dados no Azure
Descrever práticas comuns para carregamento de dados
https://docs.microsoft.com/pt-br/azure/synapse-analytics/sql-data-warehouse/design-elt-data-loading

Descrever os componentes do Azure Data Factory (por exemplo, pipeline, atividades etc.)
https://docs.microsoft.com/pt-br/azure/data-factory/concepts-pipelines-activities

Descrever as opções de processamento de dados (por exemplo, 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

Descrever a visualização de dados no Microsoft Power BI
Descrever a função dos relatórios paginados
https://docs.microsoft.com/pt-br/power-bi/paginated-reports/paginated-reports-report-builder-power-bi

Descrever o papel dos relatórios interativos
https://powerbi.microsoft.com/pt-br/desktop/

Descrever o papel dos painéis
https://docs.microsoft.com/pt-br/power-bi/consumer/end-user-dashboards
https://www.alura.com.br/artigos/dashboards-vs-relatorios

Descrever o fluxo de trabalho no Power BI
https://curbal.com/blog/lesson/power-bi-workflow

É isso aí, pessoal!
Boa sorte pra vocês, boa prova e um grande abraço.

Referências
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/