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

Post Views 6,427 views

In this article

Esse post é a parte 13 de 15 da série Microsoft Certification

Microsoft Certifications – Study material in Portuguese to get your first certification (MTA)
Microsoft Certifications - Tips, links and study materials for SQL Server 2016 MCSA and MCSE exams
Microsoft Certification Exams: 50% off for students (Undergraduate, Graduate, Masters, Doctorate)
SQL Server – How to learn from basics to certification (Courses, Virtual Labs, Virtual Academy)
MCP Professional – How to share your certifications and find certified professionals
SQL Server - Study Material for the 70-764 Administering a SQL Database Certification Exam
How was the Microsoft Certifications Webinar in the data area (Data Platform)
Microsoft Certification – Tips on how to take the test at home without a headache
My impressions and study material for the DP-300 exam – Administering Relational Databases on Microsoft Azure (beta)
My impressions and study material from the DA-100 certification exam – Analyzing Data with Microsoft Power BI (beta)
Certification test simulations? RUN THEM!
DP-900 Microsoft Azure Data Fundamentals Exam - Free Study Materials for the Certification Exam
New Microsoft Certified Fundamentals portal for those looking to earn their first certification
Exam AZ-305: Designing Microsoft Azure Infrastructure Solutions - Free Study Material
Microsoft Certification Exams: Official Practice Assessments and Study Materials

Reading time 8 minutes

Hey guys!
In this article I would like to share with you some free study material for the certification exam DP-900 Microsoft Azure Data Fundamentals. This is your chance to have material that will make you pass the test without much difficulty and obtain your Microsoft Certified: Azure Data Fundamentals certification.

This exam is an opportunity to demonstrate knowledge of key Microsoft Azure data concepts and related data services. This exam is intended for candidates new to the cloud data environment.

Candidates should be familiar with relational and non-relational data concepts and with different types of data workloads, such as transactional or analytics.

The value of this test is 60 dollars for Brazil, you will have 90 minutes to finish the test and it has 40 to 60 questions. The level of the questions is basic, so the questions are very superficial, without requiring much knowledge or experience, covering only basic concepts, but the content is very comprehensive, that is, there is a lot to study, many different topics, but the questions they are not difficult.

To schedule the test, simply click on this link here.

It is worth remembering that if you are a student, you can take the fundamental tests (AZ-900, PL-900, DP-900 and others) without paying anything. FOR FREE. If you want to know more about it, read my article New Microsoft Certified Fundamentals portal for those looking to earn their first certification.

Some interesting links for you on this topic

DP-900 Exam Learning Path Microsoft Azure Data Fundamentals

Below I will make available the link to the official Microsoft learning path.

Material created by Eduardo Popovici

I will share this excellent material created by Eduardo Popovici about the DP-900 test which is sensational!

DP-900 training with Henrique Souza

Henrique Souza has a YouTube channel sensational, where he posts several videos, and, among them, courses on some certification tests. And I'm going to share the playlist he made covering all the content of the DP-900 test.

English Study Materials for 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

Study Material in Portuguese for DP-900 Microsoft Azure Data Fundamentals

Describe key data concepts (25-30%)

Describe the types of core data workloads
Describe batch data
• https://docs.microsoft.com/pt-br/azure/architecture/data-guide/big-data/batch-processing

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

Describe the difference between batch and streaming data
• 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

Describe the characteristics of relational data
• https://docs.microsoft.com/pt-br/learn/modules/describe-concepts-of-relational-data/
• https://www.oracle.com/br/database/what-is-a-relational-database

Describe the main concepts of data analysis
Describe data visualization (e.g. visualization, reporting, business intelligence)
• 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/

Describe basic chart types, such as bar charts and pie charts
• https://docs.microsoft.com/pt-br/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a

Describe analysis techniques (eg, descriptive, diagnostic, predictive, prescriptive, cognitive)
• 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/

Describe ELT and ETL processing
• https://docs.microsoft.com/pt-br/azure/architecture/data-guide/relational-data/etl

Describe data processing concepts
• https://www.crtrj.gov.br/o-que-e-processamento-de-dados

Identify considerations for relational data in Azure (20-25%)

Describe relational data workloads
Identify the right data offering for a relational workload
• https://docs.microsoft.com/pt-br/azure/architecture/guide/technology-choices/data-store-overview
• https://azure.microsoft.com/pt-br/products/category/databases/

Describe relational data structures (e.g. tables, indexes, views)
• 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/

Describe Azure Relational Data Services
Descrever e comparar modelos de entrega PaaS, IaaS e SaaS
• https://docs.microsoft.com/pt-br/learn/modules/fundamental-azure-concepts/

Describe Azure SQL Database
• 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

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

Describe SQL Server on Azure Virtual Machine
• 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

Describe Azure Database for PostgreSQL, Azure Database for MariaDB, and Azure Database for 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

Describe Azure SQL Managed Instance
• https://docs.microsoft.com/pt-br/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview

Identify basic management tasks for relational data
Describe provisioning and deploying relational data services
• 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/

Describe method for deployment, including ARM templates and Azure Portal
• 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

Identify data security components (e.g. firewall, authentication)
• 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

Identify basic connectivity issues (e.g. on-premises access, access with Azure VNets, internet access, authentication, 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

Identify query tools (e.g. Azure Data Studio, SQL Server Management Studio, sqlcmd utility, 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

Describe query techniques for data using the SQL language
Compare DDL versus DML
• https://pt.gadget-info.com/difference-between-ddl

Query relational data in PostgreSQL, MySQL and Azure SQL Database
• 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/

Describe considerations for working with non-relational data on Azure (15-20%)

Describe non-relational data workloads
Describe the characteristics of non-relational data
• 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

Describe non-relational and NoSQL data types
• https://docs.microsoft.com/pt-br/azure/architecture/data-guide/big-data/non-relational-data

Recommend the right data storage
• https://docs.microsoft.com/pt-br/azure/architecture/data-guide/big-data/non-relational-data#typical-requirements

Describe non-relational data offerings on Azur
Identify Azure data services for non-relational workloads
• https://azure.microsoft.com/pt-br/overview/nosql-database/
• https://docs.microsoft.com/pt-br/azure/architecture/guide/technology-choices/data-store-overview

Describe the Azure Cosmos DB APIs
• https://docs.microsoft.com/pt-br/learn/modules/choose-api-for-cosmos-db/

Describe Azure Table Storage
• https://azure.microsoft.com/pt-br/services/storage/tables/

Describe Azure Blob storage
• https://azure.microsoft.com/pt-br/services/storage/blobs/

Describe Azure File Storage
• https://azure.microsoft.com/pt-br/services/storage/files/

Identify basic management tasks for non-relational data
Describe provisioning and deploying non-relational data services
• https://docs.microsoft.com/pt-br/azure/cosmos-db/sql/create-cosmosdb-resources-portal

Describe method for deployment, including ARM templates and Azure Portal
• 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

Identify data security components (e.g. firewall, authentication)
• 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

Identify basic connectivity issues (e.g. on-premises access, access with Azure VNets, internet access, authentication, 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

Identify management tools for non-relational data
• https://docs.microsoft.com/pt-br/azure/cosmos-db/data-explorer

Describe an analytics workload on Azure (25% – 30%)

Describe Analytics workloads
Describe transactional workloads
• https://docs.microsoft.com/pt-br/azure/architecture/data-guide/relational-data/online-transaction-processing

Describe the difference between a transactional and analytics workload
• 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/

Describe the difference between batch and realtime
• 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

Describe data storage workloads
• https://azure.microsoft.com/pt-br/updates/workload-importance-for-azure-sql-data-warehouse-is-now-generally-available/

Determine when a data warehouse solution is needed
• https://www.fiveacts.com.br/data-warehouse/
• https://www.devmedia.com.br/data-warehouse/12609

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/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/

Describe the modern data warehouse architecture and workload
• https://docs.microsoft.com/pt-br/azure/architecture/solution-ideas/articles/enterprise-data-warehouse