Passing Azure Data Fundamentals — DP-900 First Time!

“This exam is intended for candidates beginning 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 like Azure Database Administrator Associate or Azure Data Engineer Associate, but it is not a prerequisite for any of them.”

First things first, run through the Microsoft Learn Course!

It’s free and all the content is there. The “Review” questions will most likely appear in the exam, so take them in.

You also have an array of free content available online. When I first started out, I looked for pay content however, I’ve found it often stale. The content is boring and not engaging. With the free content, the hosts try more in order to get viewers. This pressure creates great content!

Below are some of my favorites:

John has helped a lot of people pass the Microsoft exams, and you can see why. This has to be on the list for prep work!

It is a quick overview, however, I would recommend pausing and searching Google if you hear something you’ve never heard before.

FreeCodeCamp is also an option however is targeted more at the full course:

This covers more in-depth. Some people watch this as a whole, but for me, I picked and chose what I wanted to learn.

This strategy really works for me. Basically, If you know some of the content, focus on the subjects you don’t know:

Look at the broken out exam outline, jot down “areas” or keywords and start from there: Exam Outline

Another tip is to use the free exams by Microsoft. Again, some of these turned up in the actual exam so worth reviewing: Microsoft Free Exam

I found it best to run through exams like this, looked at what I failed at, note it down, and focus my efforts there. Then retake the tests.

I’ve added a few more examples below. Scroll slowly so that you don’t see the answers. I’ve added extra spaces to help.

Which statement is an example of Data Manipulation Language (DML)?





Answer: 1

Ref: What is Data Manipulation Language (DML)? — Definition from Techopedia

Select the type of analytics that can be used to answer the business question –

Why did sales increase last month?

1. Predictive

2. Cognitive

3. Descriptive

4. Diagnostic

Answer: 4

Ref: Types of Analytics:Descriptive,Predictive,Prescriptive Analytics (

Select the correct option to complete the sentence.

The massively parallel processing (MPP) engine of Azure Synapse Analytics _____________

1. redirects client connections across control nodes.

2. distributes processing across compute nodes.

3. distributes processing across control nodes.

4. redirects client connections across compute nodes.

Answer: 2

Ref: Synapse SQL architecture — Azure Synapse Analytics | Microsoft Docs

Which statement is an example of Data Manipulation Language (DML)?





Answer: 2

Ref: Difference Between DDL and DML in DBMS (with Comparison Chart) -Tech Differences

To complete the sentence, select the appropriate option in the answer area.

An extract, transform, and load (ETL) process requires ____________

1. a matching schema in the data source and the data target.

2. that the data target be a relational database

3. a target data store powerful enough to transform data.

4. data that is fully processed before being loaded to the target data store.

Answer: 4

Ref: Extract, transform, and load (ETL) — Azure Architecture Center | Microsoft Docs

Select the type of analytics that can be used to answer the business question –

Which people are mentioned in a company’s business documents?

1. Predictive

2. Cognitive

3. Prescriptive

4. Descriptive

Answer: 4

Ref: Describe, diagnose, and predict with IoT Analytics | Azure Blog and Updates | Microsoft Azure

Multiple: Select correct options

1. Normalization improves data integrity.

2. Normalization involves eliminating relationships between database tables.

3. Normalizing a database reduces data redundancy.

4. Normalizing reduces data integrity

Answer: 1 & 3

Ref: Database normalization description — Office | Microsoft Docs

Fill in the Gap:

______________ is an object associated with a table that sorts and stores the data rows in the table based on their key values.

1. A FileTable

2. A stored procedure

3. A foreign key

4. A clustered index

Answer: 4

Ref: When to Use Clustered or Non-Clustered Indexes in SQL Server (

You need to create an Azure resource to store data in Azure Table storage.

Which command should you run?

1. az storage container create

2. az storage share create

3. az storage account create

4. az cosmosdb create

Answer: 1

Ref: Azure Command-Line Interface (CLI) — Overview | Microsoft Docs

Ref2: az storage container | Microsoft Docs

To complete the sentence, select the appropriate option in the answer area.

In batch processing, ____________

1. processing can only execute serially.

2. data is always inserted one row at a time.

3. data is processed in real-time.

4. latency is expected.

Answer: 4

Ref: Batch processing — Azure Architecture Center | Microsoft Docs

To complete the sentence, select the appropriate option in the answer area.

Creating closed caption text for audio files is an example of _________________ analytics.

1. predictive

2. prescriptive

3. descriptive

4. cognitive

Answer: 3

Ref: The Differences Between Descriptive, Diagnostic, Predictive & Cognitive Analytics | Demand Planning .com (

You need to create a database object that would allow other users to rerun the same SQL query.

What should you create?

1. a view

2. a table

3. an index

4. a scalar function

Answer: 1

Ref: Views — SQL Server | Microsoft Docs

Good luck, and hope this has helped!

If you are looking for extra ways to revise, and don’t mind spending. I do recommend heading over to Udemy: DP-900: Azure Data Fundamentals 2022 — Exam Practice!! | Udemy


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Create a website or blog at

%d bloggers like this: