Click on the banner to learn about and purchase my database training on Azure

80% DISCOUNT on the new DP-900 certification BETA test: Microsoft Azure Data Fundamentals

Views: 2.165 views
Reading Time: 4 minutes

Speak guys!
In this post I would like to share with you the fact that the NEW BETA DP-900 certification test: Microsoft Azure Data Fundamentals is 80% off for the first 300 people using this voucher. We will take advantage of this discount and the fact that we are in quarantine to study, improve our skills and the curriculum.

Remembering that the tests can be done ONLINE and REMOTE, from your home. To learn more about how certification exams work, read my article Microsoft Certifications - Tips, Links, and Study Materials for SQL Server 2016 MCSA and MCSE Tests.

Now is the time to search for new certification evidence from the Microsoft data area, because as was released 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 in Microsoft certifications, watch the video below where I participated in a live on this topic on the Coding Night channel:

If you are still a student and want to start with the first exam in the data area, which is the MTA, download the study materials and find out how this exam works in my article Microsoft Certifications - Portuguese Study Material for Your First Certification (MTA).

It is worth remembering that in beta tests, as you may know, the result does not come out on time (takes 3 to 4 months), there may be errors in the questions, there is only the option of language in English or Japanese, the tests have a lot more questions than the “final” tests, but being approved in a beta té test gives the same benefits of being approved in a “final” test (you don't need to retake the test when it is official).

In addition, beta tests have an even greater value than being approved in a “final” test, as there are no dumps (copies of the tests used by DRAGONS and dishonest people), nor official material, so the person in fact proves that they have knowledge.

DP-900 exam: 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 who start working with data in the cloud.

Candidates must 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 the Azure Database Administrator Associate or Azure Data Engineer Associate, but it is not a prerequisite for any of them.

It is the first test for those who will work with data in Azure. Accessing the link, you can schedule your test and on the checkout screen, you will use the discount coupon DP900 Norfolk to get your 80% discount.

Test link + learning guide:

80% off coupon: DP900 Norfolk

Contents of the test:

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 (eg, visualization, reporting, business intelligence
  • describe basic chart types such as bar charts and pie charts
  • describe analytics techniques (eg, 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 (eg, 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 (eg, firewall, authentication)
  • identify basic connectivity issues (eg, accessing from on-premises, access with Azure VNets, access from Internet, authentication, firewalls)
  • identify query tools (eg, Azure Data Studio, SQL Server Management Studio, sqlcmd utility, etc.)

Describe 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 (eg, firewall, authentication)
  • identify basic connectivity issues (eg, 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
  • When determining the 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 loading data
  • describe the components of Azure Data Factory (eg, pipeline, activities, etc.)
  • describe data processing options (eg, 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 !!