Visualizações: 7.720 views 
 
Tempo de Leitura:    8  minutos Fala pessoal!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 .
Abaixo vou deixar disponível o link do roteiro de aprendizado oficial da Microsoft.
Vou compartilhar esse material excelente criado pelo Eduardo Popovici  sobre a prova DP-900 que está sensacional!
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.
VIDEO 
Describe core data concepts (15-20%) 
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 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 Databasehttps://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 Analyticshttps://azure.microsoft.com/en-us/services/synapse-analytics/ 
Describe SQL Server on Azure Virtual Machinehttps://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 MySQLhttps://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 Instancehttps://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview 
Identify Basic Management Tasks for Relational Data 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 Portalhttps://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 https://www.geeksforgeeks.org/difference-between-ddl-and-dml-in-dbms/ 
Query relational data in PostgreSQL, MySQL, and Azure SQL Databasehttps://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 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 workloadhttps://datawarehouseinfo.com/how-does-oltp-differ-from-olap-database/ 
Describe the difference between batch and real timehttps://7wdata.be/business-analytics/batch-vs-real-time-data-processing/ 
Describe data warehousing workloadshttps://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 neededhttps://www.jamesserra.com/archive/2013/07/why-you-need-a-data-warehouse/ 
Describe the Components of a Modern Data Warehouse 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 workloadhttps://docs.microsoft.com/en-us/azure/architecture/solution-ideas/articles/enterprise-data-warehouse 
Describe Data Ingestion and Processing on Azure 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 https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-bi 
Describe the role of interactive reportshttps://powerbi.microsoft.com/en-us/desktop/ 
Describe the role of dashboardshttps://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 BIhttps://curbal.com/blog/lesson/power-bi-workflow 
 
Descrever os principais conceitos de dados (25-30%) 
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 https://docs.microsoft.com/pt-br/learn/modules/fundamental-azure-concepts/ 
Descrever o Banco de Dados SQL do Azurehttps://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 Analyticshttps://azure.microsoft.com/pt-br/services/synapse-analytics/ 
Descrever o SQL Server na Máquina Virtual do Azurehttps://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 MySQLhttps://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 SQLhttps://docs.microsoft.com/pt-br/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview 
Identificar tarefas básicas de gerenciamento para 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 Azurehttps://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 https://pt.gadget-info.com/difference-between-ddl 
Consultar dados relacionais no PostgreSQL, MySQL e Banco de Dados SQL do Azurehttps://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 uma carga de trabalho de análise no Azure (25% – 30%) 
É isso aí, pessoal!
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/ 
												
				
					 
				
Que material completo, ja estou no meio do caminho atras da minha primeira certificação, obg por tudo