Visualizações: 7.128 views
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 .
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 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 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%)
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 uma carga de trabalho de análise no Azure (25% – 30%)
É 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/