Neste artigo
ToggleFala 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
- Certificação Microsoft – Dicas de como fazer a prova em casa sem dor de cabeça
- Novo portal Microsoft Certified Fundamentals para quem quer obter sua primeira certificação
- Certificações de Fundamentos da Microsoft GRATUITAS para Alunos
- Habilidades medidas pela prova DP-900 Azure Data Fundamentals
- Questões de exemplo (simulado) da prova DP-900 Azure Data Fundamentals
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.
- Explorar os principais conceitos de dados
- Explorar dados relacionais no Azure
- Explorar dados não relacionais no Azure
- Explorar a análise de dados no Azure
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 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
Material de Estudo em Português para a DP-900 Microsoft Azure Data Fundamentals
Descrever os principais conceitos de dados (25-30%)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
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 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 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/