Hey guys!
In this post I would like to share with you the fact that the NEW BETA DP-900: Microsoft Azure Data Fundamentals certification test has an 80% discount for the first 300 people who use this voucher. Let's take advantage of this discount and the fact that we are in quarantine to study, improve our skills and resume.

Remembering that the tests can be taken ONLINE and REMOTE, from your home. To learn more about how certification tests work, read my article Microsoft Certifications – Tips, links and study materials for the SQL Server 2016 MCSA and MCSE exams.

Now is the time to look for the new certification tests in the Microsoft data area, as was published in this post here, the MCSA and MCSE tests are being DISCONTINUED and replaced by other tests. This deadline for deactivating the tests was scheduled for June 2020, but due to the COVID-19 pandemic, Microsoft released this post here where she informs that the new deadline will be in January 2021.

If you want to know more about the changes to Microsoft certifications, watch the video below where I participated in a live broadcast on this topic on the Coding Night channel:

If you are still a student and want to start with the first test in the data area, which is the MTA, download the study materials and find out how this test works in my article Microsoft Certifications – Study material in Portuguese to obtain your first certification (MTA).

It's worth remembering that in beta tests, as you may know, the results don't come out straight away (it takes 3 to 4 months), there may be errors in the questions, there is only the language option in English or Japanese, the tests have many more questions than the “final” tests, but passing a beta test even gives you the same benefits as passing a “final” test (you don't need to retake the test when it's official).

Furthermore, beta tests have an even greater value than passing a “final” test, as there are no dumps (copies of tests used by CHEATERS and dishonest people), nor official material, so the person actually proves that they have knowledge.

Exam DP-900: Microsoft Azure Data Fundamentals (beta)

Candidates for this exam must have fundamental knowledge of core data concepts and how they are implemented using Microsoft Azure data services and this exam is intended for candidates starting to work with data in the cloud.

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

Azure Data Fundamentals can be used to prepare for other Azure role-based certifications, such as Azure Database Administrator Associate or Azure Data Engineer Associate, but is not a prerequisite for any of them.

It is the first test for anyone who will work with data in Azure. Accessing the link https://docs.microsoft.com/en-us/learn/certifications/exams/dp-900, you can schedule your test and on the checkout screen, you will use the discount coupon DP900Norfolk to get your 80% discount.

Test link + learning guide: https://docs.microsoft.com/pt-br/learn/certifications/exams/dp-900

80% off coupon: DP900Norfolk

Test content:

Click to view content

Describe core data concepts (15-20%)

Describe types of core data workloads

  • describe batch data
  • describe streaming data
  • describe the difference between batch and streaming data
  • describe the characteristics of relational data

Describe data analytics core concepts

  • describe data visualization (e.g., visualization, reporting, business intelligence
  • describe basic chart types such as bar charts and pie charts
  • describe analytics techniques (e.g., descriptive, diagnostic, predictive, prescriptive, cognitive)
  • describe ELT and ETL processing
  • describe the concepts of 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
  • describe relational data structures (e.g., tables, index, views)

Describe relational Azure data services

  • describe and compare PaaS, IaaS, and SaaS delivery models
  • describe Azure SQL Database
  • describe Azure Synapse Analytics
  • describe SQL Server on Azure Virtual Machine
  • describe Azure Database for PostgreSQL, Azure Database for MariaDB, and Azure Database for MySQL
  • describe Azure SQL Managed Instance

Identify basic management tasks for relational data

  • describe provisioning and deployment of relational data services
  • describe method for deployment including ARM templates and Azure Portal
  • identify data security components (e.g., firewall, authentication)
  • identify basic connectivity issues (e.g., accessing from on-premises, access with Azure VNets, access from Internet, authentication, firewalls)
  • identify query tools (e.g., Azure Data Studio, SQL Server Management Studio, sqlcmd utility, etc.)

Describe query techniques for data using SQL language

  • compare DDL versus DML
  • query relational data in PostgreSQL, MySQL, and Azure SQL Database

Describe how to work with non-relational data on Azure (25-30%)

Describe non-relational data workloads

  • describe the characteristics of non-relational data
  • describe the types of non-relational and NoSQL data
  • recommend the correct data store
  • determine when to use non-relational data

Describe non-relational data offerings on Azure

  • identify Azure data services for non-relational workloads
  • describe Azure Cosmos DB APIs
  • describe Azure Table storage
  • describe Azure Blob storage
  • describe Azure File storage

Identify basic management tasks for non-relational data

  • describe provisioning and deployment of non-relational data services
  • describe method for deployment including ARM templates and Azure Portal
  • identify data security components (e.g., firewall, authentication)
  • identify basic connectivity issues (e.g., accessing from on-premises, access with Azure VNets, access from Internet, authentication, firewalls)
  • identify management tools for non-relational data

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

Describe analytics workloads

  • describe transactional workloads
  • describe the difference between a transactional and an analytics workload
  • describe the difference between batch and real time
  • describe data warehousing workloads
  • determine when a data warehouse solution is needed

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

  • describe modern data warehousing architecture and workload

Describe data ingestion and processing on Azure

  • describe common practices for data loading
  • describe the components of Azure Data Factory (e.g., pipeline, activities, etc.)
  • describe data processing options (e.g., HDI, Azure Databricks, Azure Synapse Analytics, Azure Data Factory)

Describe data visualization in Microsoft Power BI

  • describe the role of paginated reporting
  • describe the role of interactive reports
  • describe the role of dashboards
  • describe the workflow in Power BI

That's it, folks!
I hope you liked this tip, book your exams, good studies and good luck!!