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 Savill’s DP-900

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)?

1. INSERT

2. REVOKE

3. REDUCE

4. GRANT

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

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.

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

1. CREATE

2. UPDATE

3. DISABLE

4. REVOKE

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.

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

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

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

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

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.

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

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

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

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store