DP-900: Core Data Concepts
Core Data Concepts is one of the skill areas tested on the Azure Data Fundamentals (DP-900) exam. Below are free DP-900 practice questions with worked answers and a concept diagram — each with a plain-language explanation. Practice the first 10 questions of DP-900 free, no signup.
The concept, in one picture
3 free DP-900 Core Data Concepts questions
Choose the option that best completes the statement. The purpose of descriptive analytics is to reveal [answer choice].
- ✓ what events took place previously.
- the likelihood of a future event happening.
- the steps you should take to change a result.
- the reason a past event happened.
Descriptive analytics summarizes historical data to describe what has already happened, answering the question 'What happened?'
Pick the option that correctly finishes the sentence. An extract, transform, and load (ETL) pipeline requires [answer choice].
- the source and destination to share an identical schema.
- a destination store with enough compute power to transform the data.
- ✓ data to be completely processed before it is written to the destination store.
- the destination to be a relational database engine.
With ETL, transformation happens before loading, so the data is fully processed according to business rules before it reaches the destination store.
Choose the answer that correctly completes the statement. With batch processing, [answer choice].
- records must be added a single row at a time.
- the data is handled as it arrives in real time.
- ✓ a delay before the processing results are available is tolerable.
- the work can run only in a strictly serial fashion.
Batch processing groups data and processes it periodically, so latency before the results become available is acceptable.
Practice DP-900 free
The first 10 questions of every exam are free. No signup, no email wall.
Start practicing →Get a free DP-900 study plan by email
A short plan to work through DP-900 by skill area, plus a note when we add new questions. Optional — the practice above stays free. No spam, unsubscribe anytime.