Guia de Estudos: DP-900 Microsoft Azure Data Fundamentals
Tags: certification, azure, data, braziliansintech
Published: 2023-05-31 11:45:00

---
title: Guia de Estudos: DP-900 Microsoft Azure Data Fundamentals
published: true
description: Preparando-se para o exame DP-900 Microsoft Azure Data Fundamentals e não sabe por onde começar? Este artigo é um guia de estudo para certificação DP-900!
tags: certification, azure, data, braziliansintech
cover_image: https://dev-to-uploads.s3.amazonaws.com/uploads/articles/mcdj9znrnf3rb0rpin3n.jpg
# Use a ratio of 100:42 for best results.
published_at: 2023-05-31 11:45 +0000
---

A certificação DP-900 Microsoft Azure Data Fundamentals é voltada para profissionais que desejam começar a trabalhar com dados na nuvem e desempenhar funções relacionadas ao armazenamento, processamento e análise de dados usando os recursos do Azure.

**Este artigo é um guia de estudos completo para você se preparar para prova de certificação, trazendo uma série de recursos no Microsoft Learn, Microsoft Docs e vídeo aulas.**

![Microsoft Learn](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/5v740dhao10vhpvka4jg.jpg)
Recursos de aprendizado
----------------------------------

Se você não tem muita familiaridade com computação em nuvem, recomendo estudar a trilha [Azure Fundamentals](https://learn.microsoft.com/pt-br/training/paths/microsoft-azure-fundamentals-describe-cloud-concepts/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/paths/microsoft-azure-fundamentals-describe-cloud-concepts/?WT.mc_id=academic-96223-cyzanon"):

*   [Conceitos de nuvem](https://learn.microsoft.com/pt-br/training/paths/microsoft-azure-fundamentals-describe-cloud-concepts/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/paths/microsoft-azure-fundamentals-describe-cloud-concepts/?WT.mc_id=academic-96223-cyzanon")
*   [Arquitetura e os serviços do Azure](https://learn.microsoft.com/pt-br/training/paths/azure-fundamentals-describe-azure-architecture-services/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/paths/azure-fundamentals-describe-azure-architecture-services/?WT.mc_id=academic-96223-cyzanon")
*   [Gerenciamento e a governança do Azure](https://learn.microsoft.com/pt-br/training/paths/describe-azure-management-governance/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/paths/describe-azure-management-governance/?WT.mc_id=academic-96223-cyzanon")

As porcentagens indicadas em cada tópico da prova são referentes ao peso / volume de questões que você poderá encontrar no exame.

### **Descrever os principais conceitos de dados (25-35%)**

#### Descrever maneiras de representar dados

*   [Descrever dados estruturados](https://learn.microsoft.com/pt-br/training/modules/explore-core-data-concepts/2-data-formats/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/modules/explore-core-data-concepts/2-data-formats/?WT.mc_id=academic-96223-cyzanon")
*   [Descrever dados semi-estruturados](https://learn.microsoft.com/pt-br/training/modules/explore-core-data-concepts/2-data-formats/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/modules/explore-core-data-concepts/2-data-formats/?WT.mc_id=academic-96223-cyzanon")
*   [Descrever dados não estruturados](https://learn.microsoft.com/pt-br/training/modules/explore-core-data-concepts/2-data-formats/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/modules/explore-core-data-concepts/2-data-formats/?WT.mc_id=academic-96223-cyzanon")

#### Identificar opções para armazenamento de dados

*   [Descrever formatos comuns para arquivos de dados](https://learn.microsoft.com/pt-br/training/modules/explore-core-data-concepts/3-file-storage/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/modules/explore-core-data-concepts/3-file-storage/?WT.mc_id=academic-96223-cyzanon")
*   [Tipos de bancos de dados](https://learn.microsoft.com/pt-br/training/modules/explore-core-data-concepts/4-databases/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/modules/explore-core-data-concepts/4-databases/?WT.mc_id=academic-96223-cyzanon")
*   [Banco de Dados no Azure](https://azure.microsoft.com/pt-br/product-categories/databases/?WT.mc_id=academic-96223-cyzanon "https://azure.microsoft.com/pt-br/product-categories/databases/?WT.mc_id=academic-96223-cyzanon")

#### Descrever cargas de trabalho de dados comuns

*   [Processamento de Dados Transacionais (OLTP)](https://learn.microsoft.com/pt-br/azure/architecture/data-guide/relational-data/online-transaction-processing/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/azure/architecture/data-guide/relational-data/online-transaction-processing/?WT.mc_id=academic-96223-cyzanon")
*   [Processamento de Dados Analíticas (OLAP)](https://learn.microsoft.com/pt-br/azure/architecture/data-guide/relational-data/online-analytical-processing/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/azure/architecture/data-guide/relational-data/online-analytical-processing/?WT.mc_id=academic-96223-cyzanon")

#### Identificar funções e responsabilidades para cargas de trabalho de dados

*   [Administradores de Banco de Dados](https://learn.microsoft.com/pt-br/training/modules/explore-roles-responsibilities-world-of-data/2-explore-job-roles/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/modules/explore-roles-responsibilities-world-of-data/2-explore-job-roles/?WT.mc_id=academic-96223-cyzanon")
*   [Engenheiros de Dados](https://learn.microsoft.com/pt-br/training/modules/explore-roles-responsibilities-world-of-data/2-explore-job-roles/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/modules/explore-roles-responsibilities-world-of-data/2-explore-job-roles/?WT.mc_id=academic-96223-cyzanon")
*   [Analistas de dados](https://learn.microsoft.com/pt-br/training/modules/explore-roles-responsibilities-world-of-data/2-explore-job-roles/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/modules/explore-roles-responsibilities-world-of-data/2-explore-job-roles/?WT.mc_id=academic-96223-cyzanon")

### **Dados relacionais no Azure (20-25%)**

#### Descrever conceitos de banco de dados relacionais

*   [Identificar recursos de banco de dados relacionais](https://learn.microsoft.com/pt-br/training/modules/explore-relational-data-offerings/2-understand-relational-data/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/modules/explore-relational-data-offerings/2-understand-relational-data/?WT.mc_id=academic-96223-cyzanon")
*   [O que é normalização e por que ela é usada](https://learn.microsoft.com/pt-br/training/modules/explore-relational-data-offerings/3-normalization/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/modules/explore-relational-data-offerings/3-normalization/?WT.mc_id=academic-96223-cyzanon")
*   [Linguagem SQL](https://learn.microsoft.com/pt-br/training/modules/explore-relational-data-offerings/4-query-with-sql/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/modules/explore-relational-data-offerings/4-query-with-sql/?WT.mc_id=academic-96223-cyzanon")
*   [Objetos de banco de dados comuns](https://learn.microsoft.com/pt-br/training/modules/explore-relational-data-offerings/5-database-objects/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/modules/explore-relational-data-offerings/5-database-objects/?WT.mc_id=academic-96223-cyzanon")
*   [O que é o Azure Data Studio?](https://learn.microsoft.com/pt-br/sql/azure-data-studio/what-is-azure-data-studio?view=sql-server-ver15/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/sql/azure-data-studio/what-is-azure-data-studio?view=sql-server-ver15/?WT.mc_id=academic-96223-cyzanon")

#### Descrever os serviços de dados relacionais do Azure

*   [Tipos de Serviço de Cloud](https://docs.microsoft.com/pt-br/learn/modules/principles-cloud-computing/5-types-of-cloud-services/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/learn/modules/principles-cloud-computing/5-types-of-cloud-services/?WT.mc_id=academic-96223-cyzanon")
*   [Descrever a família de produtos Azure SQL](https://learn.microsoft.com/pt-br/training/modules/explore-provision-deploy-relational-database-offerings-azure/2-azure-sql/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/modules/explore-provision-deploy-relational-database-offerings-azure/2-azure-sql/?WT.mc_id=academic-96223-cyzanon")
*   [Azure SQL Database](https://docs.microsoft.com/pt-br/azure/azure-sql/database/sql-database-paas-overview "https://docs.microsoft.com/pt-br/azure/azure-sql/database/sql-database-paas-overview")
*   [Azure SQL Managed Instance?](https://docs.microsoft.com/pt-br/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview "https://docs.microsoft.com/pt-br/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview")
*   [SQL Server on Azure Virtual Machines?](https://docs.microsoft.com/pt-br/azure/azure-sql/virtual-machines/windows/sql-server-on-azure-vm-iaas-what-is-overview "https://docs.microsoft.com/pt-br/azure/azure-sql/virtual-machines/windows/sql-server-on-azure-vm-iaas-what-is-overview")
*   [Identificar os serviços de banco de dados do Azure para sistemas de banco de dados de open source](https://learn.microsoft.com/pt-br/training/modules/explore-provision-deploy-relational-database-offerings-azure/3-azure-database-open-source/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/modules/explore-provision-deploy-relational-database-offerings-azure/3-azure-database-open-source/?WT.mc_id=academic-96223-cyzanon")
*   [Visão geral Azure Database for PostgreSQL?](https://docs.microsoft.com/pt-br/azure/postgresql/overview/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/postgresql/overview/?WT.mc_id=academic-96223-cyzanon")
*   [Visão geral Azure Database for MariaDB?](https://docs.microsoft.com/pt-br/azure/mariadb/overview/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/mariadb/overview/?WT.mc_id=academic-96223-cyzanon")
*   [Visão geral Azure Database for MySQL?](https://docs.microsoft.com/pt-br/azure/mysql/overview/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/mysql/overview/?WT.mc_id=academic-96223-cyzanon")

Segurança e Conectividade

*   [Azure SQL Database firewall](https://docs.microsoft.com/pt-br/azure/security/fundamentals/infrastructure-sql#azure-sql-database-firewall/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/security/fundamentals/infrastructure-sql#azure-sql-database-firewall/?WT.mc_id=academic-96223-cyzanon")
*   [Azure Azure AD authentication](https://docs.microsoft.com/pt-br/azure/azure-sql/database/authentication-aad-overview/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/azure-sql/database/authentication-aad-overview/?WT.mc_id=academic-96223-cyzanon")
*   [Proteção e criptografia de informações](https://docs.microsoft.com/pt-br/azure/azure-sql/database/security-overview#information-protection-and-encryption/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/azure-sql/database/security-overview#information-protection-and-encryption/?WT.mc_id=academic-96223-cyzanon")
*   [Solução de problemas de conectividade e outros erros](https://docs.microsoft.com/pt-br/azure/azure-sql/database/troubleshoot-common-errors-issues/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/azure-sql/database/troubleshoot-common-errors-issues/?WT.mc_id=academic-96223-cyzanon")
*   [Solução de problemas de conectividade do banco de dados SQL do Azure](https://techcommunity.microsoft.com/t5/azure-database-support-blog/azure-sql-db-connectivity-troubleshooting/ba-p/1158677/?WT.mc_id=academic-96223-cyzanon "https://techcommunity.microsoft.com/t5/azure-database-support-blog/azure-sql-db-connectivity-troubleshooting/ba-p/1158677/?WT.mc_id=academic-96223-cyzanon")
*   [Solucionar problemas de conexão com o Banco de Dados SQL do Azure](https://github.com/uglide/azure-content/blob/master/articles/sql-database/sql-database-troubleshoot-common-connection-issues.md/?WT.mc_id=academic-96223-cyzanon "https://github.com/uglide/azure-content/blob/master/articles/sql-database/sql-database-troubleshoot-common-connection-issues.md/?WT.mc_id=academic-96223-cyzanon")

#### Ferramentas para queries

*   [Conectar-se a uma instância do SQL Server e consultá-la usando o SSMS (SQL Server Management Studio)](https://docs.microsoft.com/pt-br/sql/ssms/tutorials/connect-query-sql-server?view=sql-server-ver15/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/sql/ssms/tutorials/connect-query-sql-server?view=sql-server-ver15/?WT.mc_id=academic-96223-cyzanon")
*   [Utilitário sqlcmd](https://docs.microsoft.com/pt-br/sql/ssms/scripting/sqlcmd-use-the-utility?view=sql-server-ver15/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/sql/ssms/scripting/sqlcmd-use-the-utility?view=sql-server-ver15/?WT.mc_id=academic-96223-cyzanon")
*   [Usar o Azure Data Studio para conectar-se ao PostgreSQL e consultá-lo](https://docs.microsoft.com/pt-br/sql/azure-data-studio/quickstart-postgres?view=sql-server-ver15/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/sql/azure-data-studio/quickstart-postgres?view=sql-server-ver15/?WT.mc_id=academic-96223-cyzanon")
*   [Usar o MySQL Workbench para se conectar e consultar dados no Banco de Dados do Azure para MySQL](https://docs.microsoft.com/pt-br/azure/mysql/connect-workbench/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/mysql/connect-workbench/?WT.mc_id=academic-96223-cyzanon")
*   [Usar o editor de consultas (versão prévia) do portal do Azure para consultar o Banco de Dados SQL do...](https://docs.microsoft.com/pt-br/azure/azure-sql/database/connect-query-portal/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/azure-sql/database/connect-query-portal/?WT.mc_id=academic-96223-cyzanon")

Práticas

*   [Criar um banco de dados individual no Banco de Dados SQL do Azure usando um modelo do ARM](https://docs.microsoft.com/pt-br/azure/azure-sql/database/single-database-create-arm-template-quickstart/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/azure-sql/database/single-database-create-arm-template-quickstart/?WT.mc_id=academic-96223-cyzanon")
*   [Criar um banco de dados individual – Banco de Dados SQL do Azure](https://docs.microsoft.com/pt-br/azure/azure-sql/database/single-database-create-quickstart?tabs=azure-portal/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/azure-sql/database/single-database-create-quickstart?tabs=azure-portal/?WT.mc_id=academic-96223-cyzanon")
*   [Use o PowerShell para criar um banco de dados individual e configurar uma regra de firewall no nível...](https://docs.microsoft.com/pt-br/azure/azure-sql/database/scripts/create-and-configure-database-powershell?toc=/powershell/module/toc.json/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/azure-sql/database/scripts/create-and-configure-database-powershell?toc=/powershell/module/toc.json/?WT.mc_id=academic-96223-cyzanon")
*   [Criar um banco de dados e configurar uma regra de firewall usando a CLI do Azure](https://docs.microsoft.com/pt-br/azure/azure-sql/database/scripts/create-and-configure-database-cli/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/azure-sql/database/scripts/create-and-configure-database-cli/?WT.mc_id=academic-96223-cyzanon")

### **Descrever dados não relacionais em Azure (15-20%)**

#### Descrever os recursos do armazenamento do Azure

*   [O que são banco de dados NoSQL?](https://azure.microsoft.com/pt-br/overview/nosql-database/?WT.mc_id=academic-96223-cyzanon "https://azure.microsoft.com/pt-br/overview/nosql-database/?WT.mc_id=academic-96223-cyzanon")
*   [Armazenamento de dados não relacionais](https://learn.microsoft.com/pt-br/azure/architecture/data-guide/big-data/non-relational-data#typical-requirements/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/azure/architecture/data-guide/big-data/non-relational-data#typical-requirements/?WT.mc_id=academic-96223-cyzanon")
*   [Descrever o armazenamento de Blobs do Azure](https://learn.microsoft.com/pt-br/azure/storage/blobs/storage-blobs-introduction/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/azure/storage/blobs/storage-blobs-introduction/?WT.mc_id=academic-96223-cyzanon")
*   [Descrever o armazenamento de arquivos do Azure](https://learn.microsoft.com/pt-br/azure/storage/files/storage-files-introduction/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/azure/storage/files/storage-files-introduction/?WT.mc_id=academic-96223-cyzanon")
*   [Descrever o armazenamento de tabelas do Azure](https://learn.microsoft.com/pt-br/azure/storage/tables/table-storage-overview/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/azure/storage/tables/table-storage-overview/?WT.mc_id=academic-96223-cyzanon")

#### Descrever capacidades e recursos do Azure Cosmos DB

*   [Identificar casos de uso para Azure Cosmos DB](https://learn.microsoft.com/pt-br/azure/cosmos-db/use-cases/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/azure/cosmos-db/use-cases/?WT.mc_id=academic-96223-cyzanon")
*   [Descrever as APIs do Azure Cosmos DB](https://learn.microsoft.com/pt-br/azure/cosmos-db/choose-api/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/azure/cosmos-db/choose-api/?WT.mc_id=academic-96223-cyzanon")
*   [Escolhendo APIs do Azure Cosmos DB](https://docs.microsoft.com/pt-br/learn/modules/choose-api-for-cosmos-db/2-identify-the-technology-options/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/learn/modules/choose-api-for-cosmos-db/2-identify-the-technology-options/?WT.mc_id=academic-96223-cyzanon")

Segurança e Conectividade

*   [Configurar o firewall de IP no Azure Cosmos DB](https://docs.microsoft.com/pt-br/azure/cosmos-db/how-to-configure-firewall/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/cosmos-db/how-to-configure-firewall/?WT.mc_id=academic-96223-cyzanon")
*   [Visão geral da segurança do banco de dados no Azure Cosmos DB](https://docs.microsoft.com/pt-br/azure/cosmos-db/database-security/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/cosmos-db/database-security/?WT.mc_id=academic-96223-cyzanon")
*   [Proteger o acesso aos dados no Azure Cosmos DB](https://docs.microsoft.com/pt-br/azure/cosmos-db/secure-access-to-data/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/cosmos-db/secure-access-to-data/?WT.mc_id=academic-96223-cyzanon")
*   [Criptografia de dados do Azure Cosmos DB](https://docs.microsoft.com/pt-br/azure/cosmos-db/database-encryption-at-rest/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/cosmos-db/database-encryption-at-rest/?WT.mc_id=academic-96223-cyzanon")
*   [Diagnosticar e solucionar problemas ao usar o SDK . NET para Azure Cosmos DB](https://docs.microsoft.com/pt-br/azure/cosmos-db/troubleshoot-dot-net-sdk/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/cosmos-db/troubleshoot-dot-net-sdk/?WT.mc_id=academic-96223-cyzanon")
*   [Solucione problemas com uma política de controle de acesso IP](https://docs.microsoft.com/pt-br/azure/cosmos-db/how-to-configure-firewall#troubleshoot-ip-firewall/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/cosmos-db/how-to-configure-firewall#troubleshoot-ip-firewall/?WT.mc_id=academic-96223-cyzanon")

#### Ferramentas para queries

*   [Trabalhar com os dados usando o Azure Cosmos DB Explorer](https://docs.microsoft.com/pt-br/azure/cosmos-db/data-explorer/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/cosmos-db/data-explorer/?WT.mc_id=academic-96223-cyzanon")

Práticas

*   [Criar uma conta, um banco de dados, um contêiner e itens do Azure Cosmos DB usando o portal do Azure](https://docs.microsoft.com/pt-br/azure/cosmos-db/create-cosmosdb-resources-portal/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/cosmos-db/create-cosmosdb-resources-portal/?WT.mc_id=academic-96223-cyzanon")
*   [Criar um cluster do Apache HBase no Azure HDInsight usando um modelo do Resource Manager](https://docs.microsoft.com/pt-br/azure/hdinsight/hbase/quickstart-resource-manager-template/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/hdinsight/hbase/quickstart-resource-manager-template/?WT.mc_id=academic-96223-cyzanon")
*   [Azure Cosmos account, database from the Azure portal](https://docs.microsoft.com/pt-br/azure/cosmos-db/create-cosmosdb-resources-portal/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/cosmos-db/create-cosmosdb-resources-portal/?WT.mc_id=academic-96223-cyzanon")
*   [Criar uma conta, um banco de dados, um contêiner e itens do Azure Cosmos DB usando o portal do Azure](https://docs.microsoft.com/pt-br/azure/cosmos-db/quick-create-template?tabs=CLI/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/cosmos-db/quick-create-template?tabs=CLI/?WT.mc_id=academic-96223-cyzanon")
*   [Criar um banco de dados e um contêiner para o Azure Cosmos DB - API para NoSQL](https://docs.microsoft.com/pt-br/azure/cosmos-db/scripts/powershell/sql/create?toc=/powershell/module/toc.json/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/cosmos-db/scripts/powershell/sql/create?toc=/powershell/module/toc.json/?WT.mc_id=academic-96223-cyzanon")
*   [Criar uma conta, um banco de dados e um contêiner do Azure Cosmos DB for NoSQL usando a CLI do Azure](https://docs.microsoft.com/pt-br/azure/cosmos-db/scripts/cli/sql/create?toc=/cli/azure/toc.json/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/cosmos-db/scripts/cli/sql/create?toc=/cli/azure/toc.json/?WT.mc_id=academic-96223-cyzanon")

### **Análise de Dados no Azure (25-30%)**

#### Descrever elementos comuns de análise em larga escala

*   [ETL (extração, transformação e carregamento)](https://learn.microsoft.com/pt-br/azure/architecture/data-guide/relational-data/etl/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/azure/architecture/data-guide/relational-data/etl/?WT.mc_id=academic-96223-cyzanon")
*   [Estratégias de carregamento de dados para pool de SQL dedicado no Azure Synapse Analytics](https://learn.microsoft.com/pt-br/azure/synapse-analytics/sql-data-warehouse/design-elt-data-loading/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/azure/synapse-analytics/sql-data-warehouse/design-elt-data-loading/?WT.mc_id=academic-96223-cyzanon")
*   [Descrever considerações para ingestão e processamento de dados](https://learn.microsoft.com/pt-br/training/modules/examine-components-of-modern-data-warehouse/3-data-ingestion-pipelines/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/modules/examine-components-of-modern-data-warehouse/3-data-ingestion-pipelines/?WT.mc_id=academic-96223-cyzanon")
*   [Descrever opções para armazenamento de dados analíticos](https://learn.microsoft.com/pt-br/training/modules/examine-components-of-modern-data-warehouse/4-analytical-data-stores/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/modules/examine-components-of-modern-data-warehouse/4-analytical-data-stores/?WT.mc_id=academic-96223-cyzanon")
*   [Descrever os serviços do Azure para armazenamento de dados, incluindo Azure Synapse Analytics, Azure...](https://learn.microsoft.com/pt-br/training/modules/examine-components-of-modern-data-warehouse/4-analytical-data-stores/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/modules/examine-components-of-modern-data-warehouse/4-analytical-data-stores/?WT.mc_id=academic-96223-cyzanon")
*   [Azure HDInsight](https://docs.microsoft.com/pt-br/azure/hdinsight/hdinsight-overview/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/hdinsight/hdinsight-overview/?WT.mc_id=academic-96223-cyzanon")
*   [Azure Databricks](https://docs.microsoft.com/pt-br/azure/databricks/scenarios/what-is-azure-databricks/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/databricks/scenarios/what-is-azure-databricks/?WT.mc_id=academic-96223-cyzanon")
*   [Azure Synapse Analytics](https://docs.microsoft.com/pt-br/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-what-is/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-what-is/?WT.mc_id=academic-96223-cyzanon")
*   [Azure Data Factory](https://docs.microsoft.com/pt-br/azure/data-factory/introduction/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/data-factory/introduction/?WT.mc_id=academic-96223-cyzanon")

#### Descrever a análise de dados em tempo real

*   [Descrever a diferença entre dados em lote (batch) e streaming(real-time)](https://learn.microsoft.com/pt-br/training/modules/explore-fundamentals-stream-processing/2-batch-stream/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/modules/explore-fundamentals-stream-processing/2-batch-stream/?WT.mc_id=academic-96223-cyzanon")
*   [Descrever tecnologias para análise em tempo real, incluindo Azure Stream Analytics, Azure Synapse](https://learn.microsoft.com/pt-br/training/modules/explore-fundamentals-stream-processing/3-explore-common-elements/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/modules/explore-fundamentals-stream-processing/3-explore-common-elements/?WT.mc_id=academic-96223-cyzanon")
*   [O que é o Azure Synapse Analytics?](https://docs.microsoft.com/pt-br/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-what-is/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-what-is/?WT.mc_id=academic-96223-cyzanon")
*   [Data Explorer e streaming estruturado do Spark](https://learn.microsoft.com/pt-br/training/modules/explore-fundamentals-stream-processing/8-data-explorer/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/modules/explore-fundamentals-stream-processing/8-data-explorer/?WT.mc_id=academic-96223-cyzanon")

#### Descrever a visualização de dados no Microsoft Power BI

*   [O que é visualização de dados?](https://powerbi.microsoft.com/pt-br/data-visualization/?WT.mc_id=academic-96223-cyzanon "https://powerbi.microsoft.com/pt-br/data-visualization/?WT.mc_id=academic-96223-cyzanon")
*   [Identificar recursos do Power BI](https://learn.microsoft.com/pt-br/power-bi/fundamentals/service-features-license-type/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/power-bi/fundamentals/service-features-license-type/?WT.mc_id=academic-96223-cyzanon")
*   [Dashboards para usuários de negócios do serviço do Power BI](https://docs.microsoft.com/pt-br/power-bi/consumer/end-user-dashboards/?WT.mc_id=academic-96223-cyzanon "https://docs.microsoft.com/pt-br/power-bi/consumer/end-user-dashboards/?WT.mc_id=academic-96223-cyzanon")
*   [Recursos de modelos de dados no Power BI](https://learn.microsoft.com/pt-br/training/modules/design-model-power-bi/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/modules/design-model-power-bi/?WT.mc_id=academic-96223-cyzanon")
*   [Visualizações apropriadas para dados](https://learn.microsoft.com/pt-br/training/modules/introduction-power-bi/2a-data-modeling-visualizations/?WT.mc_id=academic-96223-cyzanon "https://learn.microsoft.com/pt-br/training/modules/introduction-power-bi/2a-data-modeling-visualizations/?WT.mc_id=academic-96223-cyzanon")

## Extra: Vídeos da #SprintDP900

### #SprintDP900: Introdução à Banco de dados no Azure e tipos de serviços

{% embed https://www.youtube.com/embed/cQnETjTzaeU %}

### #SprintDP900: Banco de Dados não relacional no Azure

{% embed https://www.youtube.com/embed/jUe4yTfbFfA %}

### #SprintDP900: Análise de Dados no Azure
{% embed https://www.youtube.com/embed/6P3-qV20dYY %}