Azure Data Fundamentals

(DP-900.AP1)/ISBN:978-1-64459-294-6

This course includes
Lessons
Hand-on Lab

Get hands-on experience in Azure data fundamentals with Microsoft Azure data fundamentals certification course and lab. The course is designed for Candidates to have subject matter expertise in identifying and describing core data concepts such as relational, non-relational, big data, and analytics and exploring how this technology is implemented with Microsoft Azure. They will explore the roles, tasks, and responsibilities in the world of data.

Here's what you will get

This exam provides hands-on experience that will validate a candidate that one is able to describe core data concepts, describe how to work with relational data on Azure, describe how to work with non-relational data on Azure, and describe an analytics workload on Azure.

Lessons

5+ Lessons | 10+ Exercises |

Hand on lab

12+ LiveLab | 12+ Video tutorials | 49+ Minutes

Here's what you will learn

Download Course Outline

Lessons 1: Introduction

  • Organization of this course
  • Preparing for the exam
  • Microsoft certifications
  • Quick access to online references

Lessons 2: Describe core data concepts

  • Skill 1.1: Describe types of core data workloads
  • Skill 1.2: Describe data analytics core concepts
  • Thought experiment
  • Lesson summary

Lessons 3: Describe how to work with relational data on Azure

  • Skill 2.1: Describe relational data workloads
  • Skill 2.2: Describe relational Azure data services
  • Skill 2.3: Identify basic management tasks for relational data
  • Skill 2.4: Describe query techniques for data using SQL language
  • Thought experiment
  • Lesson summary

Lessons 4: Describe how to work with non-relational data on Azure

  • Skill 3.1: Describe non-relational data workloads
  • Skill 3.2: Describe non-relational data offerings on Azure
  • Skill 3.3: Identify basic management tasks for non-relational data
  • Thought experiment
  • Lesson summary

Lessons 5: Describe an analytics workload on Azure

  • Skill 4.1: Describe analytics workloads
  • Skill 4.2: Describe the components of a modern data warehouse
  • Skill 4.3: Describe data ingestion and processing on Azure
  • Skill 4.4: Describe data visualization in Microsoft Power BI
  • Thought experiment
  • Lesson summary

Hands-on LAB Activities

Describe how to work with relational data on Azure

  • Creating an Azure SQL Database
  • Creating a SQL Server VM in the Azure Portal
  • Creating an Azure Database for PostgreSQL Servers
  • Deploying an ARM Template
  • Using an ARM Template in the Portal

Describe how to work with non-relational data on Azure

  • Creating a Cosmos DB Account and Getting the ARM Template
  • Creating a Table in Table Storage
  • Creating a Blob Container
  • Creating a Storage Account, Container, and Storage Blob Directory
  • Creating a Cosmos DB Account from the Azure Portal Using the ARM Template

Describe an analytics workload on Azure

  • Provisioning an Azure Databricks Workspace and Creating a Cluster
  • Creating an HDInsight Cluster

Exam FAQs

Candidates for this exam should have a foundational knowledge of core data concepts and how they are implemented using Microsoft Azure data services.

$ 99 USD

Pearson VUE & Certiport 

The exam contains 40-60 questions.

60 mins minutes

700

To retake an exam without waiting the required amount of time, you must submit a request for an exception. Requests will on be granted if they meet one of the exceptions listed below. Retake exceptions will not be granted if the exam failure is due to a candidate’s lack of preparation, knowledge, skill, or ability