DP-900 Exam Questions and Answers | Exam-Dumps (Page: 4)

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.

zone-redundant storage (ZRS)
read-access geo-redundant storage (RA-GRS)
locally-redundant storage (LRS)
geo-redundant storage (GRS)

Answer(s): B,D

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

Reveal Solution Next Question

QUESTION: 17

HOTSPOT (Drag and Drop is not supported)
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:

See Explanation section for answer.

Answer(s): A

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.

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

Reveal Solution Next Question

QUESTION: 18

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

REVOKE
DISABLE
INSERT
GRANT

Answer(s): C

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
- DELETE
- INSERT
- SELECT
- UPDATE
- MERGE

Reference:

https://docs.microsoft.com/en-us/sql/t-sql/statements/statements

Reveal Solution Next Question

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?

an index
a view
a scalar function
a table

Answer(s): B

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

Reveal Solution Next Question

QUESTION: 20

HOTSPOT (Drag and Drop is not supported)
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

See Explanation section for answer.

Answer(s): A

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

Reveal Solution Next Question

Microsoft DP-900 Exam (page: 4) Microsoft Azure Data Fundamentals Updated on: 28-Nov-2025

QUESTION: 16

Explanation:

Reference:

QUESTION: 17

Explanation:

Reference:

QUESTION: 18

Explanation:

Reference:

QUESTION: 19

Explanation:

Reference:

QUESTION: 20

Explanation:

Reference:

Microsoft DP-900 Exam (page: 4)
Microsoft Azure Data Fundamentals
Updated on: 28-Nov-2025