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)?
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
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
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
Answer: 1
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
