Microsoft · DP-900

DP-900 Exam Practice Questions

Name: DP-900 Exam Practice Questions PDF
Brand: ExamPico
Price: 14.99 USD
Availability: InStock

Azure Data Fundamentals

DP-900 English PDF practice questions: 323 questions in source order, with options supported by the source format, answers and available explanations. Access covers this exam only. One-time payment; no automatic renewal.

Exam overview

For beginners learning relational and nonrelational data concepts and Azure analytics workloads.

Exam code: DP-900
Official exam / credential: Azure Data Fundamentals
Exam format: Proctored assessment; interactive items may be included
Exam duration: 45 minutes
Official exam languages: English, Japanese, Simplified Chinese, Korean, French, German, Spanish, Portuguese (Brazil), Russian, Indonesian, Arabic (Saudi Arabia), Traditional Chinese, Italian

Official exam languages and practice-question file languages are listed separately. Confirm the exam version and available languages when booking with the provider.

Official sources: Provider reference
Information checked: 2026-10-20

Supported languages

English
Simplified Chinese
Japanese

Try before you buy

First 20 practice questions

323 total questions

Questions follow the source order. Expand each answer to see its explanation.

Disclaimer: All questions on ExamPico are compiled from internet sources and are provided for study reference only.

Question 16

Question#16Topic1

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.

A. zone-redundant storage (ZRS)
B. read-access geo-redundant storage (RA-GRS)
C. locally-redundant storage (LRS)
D. geo-redundant storage (GRS)

Show answer and explanation

Answer

Explanation

D: Azure Storage offers two options for copying your data to a secondary region:
✑ Geo-redundant storage (GRS)
✑ Geo-zone-redundant storage (GZRS)
B: With GRS or GZRS, the data in the secondary region isn't available for read or write access unless there is a failover to the secondary region. For read access to the secondary region, configure your storage account to use read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-
GZRS).
Reference:
https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy#redundancy-in-a-secondary-region

Question 17

Question#17Topic1

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:
Question illustration

Show answer and explanation

Answer

YNN

Explanation

Box 1: Yes -
Like IaaS, PaaS includes infrastructure ג€' servers, storage, and networking ג€' but also middleware, development tools, business intelligence (BI) services, database management systems, and more. PaaS is designed to support the complete web application lifecycle: building, testing, deploying, managing, and updating.
PaaS allows you to avoid the expense and complexity of buying and managing software licenses, the underlying application infrastructure and middleware, container orchestrators such as Kubernetes, or the development tools and other resources

Box 2: No -
You manage the applications and services you develop, and the cloud service provider typically manages everything else.
Question illustration

Box 3: No -
There really is no way to pause / stop billing for your Azure SQL Database.
Microsoft's official answer 'Yes, you can export your database. Delete the Azure SQL database and that will pause billing. Then when you need it you can create a new database and import your previously exported DB.'
Reference:
https://azure.microsoft.com/en-us/overview/what-is-paas

Question 18

Question#18Topic1

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

A. REVOKE
B. DISABLE
C. INSERT
D. GRANT

Show answer and explanation

Answer

Explanation

Data Manipulation Language (DML) affect the information stored in the database. Use these statements to insert, update, and change the rows in the database.

BULK INSERT -
Question illustration

✑ DELETE
✑ INSERT
✑ SELECT
✑ UPDATE
✑ MERGE
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/statements

Question 19

Question#19Topic1

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. an index
B. a view
C. a scalar function
D. a table

Show answer and explanation

Answer

Explanation

A view is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/views/views

Question 20

Question#20Topic1

HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Question illustration

Show answer and explanation

Answer

Explanation

Box 1: simple lookups -
A key/value store associates each data value with a unique key. Most key/value stores only support simple query, insert, and delete operations. To modify a value
(either partially or completely), an application must overwrite the existing data for the entire value. In most implementations, reading or writing a single value is an atomic operation.
An application can store arbitrary data as a set of values. Any schema information must be provided by the application. The key/value store simply retrieves or stores the value by key.
Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Downloads and personal use

Purchase this exam question set separately with 1, 3, 6 or 12 months of download access.
After payment confirmation, your library shows the download link and exact expiry time.
Download again during your term. Purchase a new term after expiry.
PDFs are licensed for personal study only and must not be resold or shared publicly.
Files already saved to your device are not remotely deleted when access expires.

How to choose your certification