Summer Sale Special - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmaspas7

Easiest Solution 2 Pass Your Certification Exams

DP-900 Microsoft Azure Data Fundamentals Free Practice Exam Questions (2026 Updated)

Prepare effectively for your Microsoft DP-900 Microsoft Azure Data Fundamentals certification with our extensive collection of free, high-quality practice questions. Each question is designed to mirror the actual exam format and objectives, complete with comprehensive answers and detailed explanations. Our materials are regularly updated for 2026, ensuring you have the most current resources to build confidence and succeed on your first attempt.

Page: 3 / 5
Total 332 questions

In Azure Table storage, each row in a table must be uniquely identified by which two components?

Each correct answer presents pan of the solution. NOTE: Each correct selection is worth one point.

A.

a timestamp

B.

a range

C.

a row key

D.

a partition key

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

You need to develop a solution to provide data to executives. the solution must provide an interactive graphic interface, depict various key performance indications, and support data exploration by using drill down.

What should you use in Microsoft Power BI?

A.

a dashboard

B.

Microsoft Power Apps

C.

a dataflow

D.

a report

Which Azure Data Factory component initiates the execution of a pipeline?

A.

a control flow

B.

a trigger

C.

a parameter

D.

an activity

Match the terms to the appropriate descriptions.

To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

You have data saved in the following format:

Which format was used?

A.

YAML

B.

HTML

C.

XML

D.

JSON

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

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?

A.

a scalar function

B.

a table

C.

an index

D.

a view

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

You plan to deploy a PostgreSQL database to Azure.

Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

You need to store event log data that is semi-structured and received as the logs occur. What should you use?

A.

Azure Table storage

B.

Azure Queue storage

C.

Azure Files

Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a

complete solution. (Choose three.)

NOTE: Each correct selection is worth one point.

A.

a report page

B.

a Microsoft PowerPoint slide

C.

a visualization from a report

D.

a dataflow

E.

a text box

Select the answer that correctly completes the sentence.

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

In a fully denormalized database, how is data read and written for a single entity?

A.

Data is read from a single table and written to a single table.

B.

Data is read from multiple tables and written to a single table.

C.

Data is read from a single table and written to multiple tables.

D.

Data is read from multiple tables and written to multiple tables.

Page: 3 / 5
Total 332 questions
Copyright © 2014-2026 Solution2Pass. All Rights Reserved