Weekend Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: Board70

DP-900 Exam Dumps - Microsoft Certified: Azure Data Fundamentals Questions and Answers

Question # 74

What is a characteristic of a non-relational database?

Options:

A.

a fixed schema

B.

self-describing entities

C.

full support for Transact-SQL

Buy Now
Question # 75

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Question # 76

You have an inventory management database that contains the following table.

Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

Options:

A.

INSERT

B.

MERGE

C.

UPDATE

D.

CREATE

Buy Now
Question # 77

You have an application that runs on Windows and requires access to a mapped drive.

Which Azure service should you use?

Options:

A.

Azure Files

B.

Azure Blob storage

C.

Azure Cosmos DB

D.

Azure Table storage

Buy Now
Question # 78

What Is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

Options:

A.

native support for cross-database queries and transactions

B.

built-in high availability

C.

system-Initiated automatic backups

D.

support for encryption at rest

Buy Now
Question # 79

Select the answer that correctly completes the sentence.

Options:

Buy Now
Question # 80

You have data saved in the following format.

\

Which format was used?

Options:

A.

XML

B.

yaml

C.

JSON

D.

HTML

Buy Now
Question # 81

What ate three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.

Options:

A.

normalized data

B.

schema defined in a database

C.

schema defined when reading unstructured data from a database

D.

normalized data

E.

light writes and heavy reads

F.

heavy writes and moderate reads

Buy Now
Question # 82

A bank has a system that manages financial transactions.

When transferring money between accounts, the system must never retrieve a value for the source account that reflects the balance before the transfer and a value for the destination account that reflects the balance after the transfer.

Of which ACID semantic is this an example?

Options:

A.

atomicity

B.

isolation

C.

durability

D.

consistency

Buy Now
Question # 83

SELECT, INSERT, and UPDATE are examples of which type of SQL statement?

Options:

A.

Data Definition Language (DDL)

B.

Data Control Language (DCL)

C.

Data Manipulation Language (DML)

Buy Now
Exam Code: DP-900
Exam Name: Microsoft Azure Data Fundamentals
Last Update: Aug 16, 2025
Questions: 313
DP-900 pdf

DP-900 PDF

$28.5  $94.99
DP-900 Engine

DP-900 Testing Engine

$33  $109.99
DP-900 PDF + Engine

DP-900 PDF + Testing Engine

$43.5  $144.99