Map the official objectives.
Read the current Microsoft objectives and make a short list of the areas you need to revisit before booking DP-900.
MICROSOFT CERTIFICATION STUDY GUIDE
Validates foundational knowledge of core data concepts and Azure data services.
Download Revizo
Validates foundational knowledge of core data concepts and Azure data services.
Exam details are based on the available Microsoft catalogue information. Confirm current requirements with the exam provider before booking.
Use the provider's current objectives as your source of truth, then organise your Revizo sessions around the Microsoft technologies, product capabilities and implementation decisions named in the certification. The DP-900 exam is listed as Multiple choice questions; your starting point should reflect No technical background required.
Read the current Microsoft objectives and make a short list of the areas you need to revisit before booking DP-900.
Select DP-900 in Revizo and use focused question sessions to test one topic or decision type at a time, rather than relying on a single long cram session.
Use your results to return to incorrect answers, revisit the official material behind them and repeat short DP-900 practice sessions until the gaps are clearer.
FREE PRACTICE PREVIEW
Review each question, its correct answer and any available source explanation before continuing your certification study in Revizo.
Answers & available explanations
QUESTION 1
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Correct answer: B
QUESTION 2
HOTSPOT -
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct answer: N, Y, Y
QUESTION 3
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Correct answer: C
QUESTION 4
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Correct answer: C
QUESTION 5
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Correct answer: A
QUESTION 6
DRAG DROP -
Match the types of analytics that can be used to answer the business questions.
To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
Correct answer: Item 1: B · Item 2: D · Item 3: C

QUESTION 7
HOTSPOT -
You have the following JSON document.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct answer: Item 1: C · Item 2: B · Item 3: A
QUESTION 8
HOTSPOT -
You are reviewing the data model shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point
Hot Area:
Correct answer: Item 1: B · Item 2: B


QUESTION 9
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Correct answer: A
QUESTION 10
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Correct answer: A
QUESTION 11
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Correct answer: C
QUESTION 12
HOTSPOT -
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct answer: Y, Y, Y
QUESTION 13
DRAG DROP -
Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process.
Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:
Correct answer: Item 1: B · Item 2: C · Item 3: C
Source explanation is not available for this question.
QUESTION 14
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Correct answer: B
QUESTION 15
DRAG DROP -
Match the types of visualizations to the appropriate descriptions.
To answer, drag the appropriate visualization type from the column on the left to its description on the right. Each visualization type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
Correct answer: Item 1: C · Item 2: A · Item 3: B

QUESTION 16
You need to create an Azure Storage account.
Data in the account must replicate outside the Azure region automatically.
Which two types of replication can you use for the storage account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Correct answer: B, D
QUESTION 17
HOTSPOT -
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct answer: Y, N, N

QUESTION 18
Which statement is an example of Data Manipulation Language (DML)?
Correct answer: C

QUESTION 19
You have a SQL query that combines customer data and order data. The query includes calculated columns.
You need to create a database object that would allow other users to rerun the same SQL query.
What should you create?
Correct answer: B
QUESTION 20
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Correct answer: B
Choose DP-900 in Revizo and work through original, question-by-question practice on your iPhone. Review results, revisit what needs attention and keep your next session tied to one specific certification objective.
Practise DP-900 with RevizoNo. Revizo is an independent iPhone app for certification practice. Refer to the provider's official resources for current exam policies and registration.
Use the exam code to select the matching certification in Revizo, then build short, focused sessions around the areas you want to review.
No. Revizo provides original practice questions for certification study. Use the provider's official objectives, documentation and policies as the source of truth for your preparation.
Use the current Microsoft objectives, documentation and registration guidance as your source of truth. Revizo is designed to support focused practice, not replace the provider's official materials.
Check the official Microsoft exam page for the latest objectives, registration details and policies.