Summer Special 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: bestdeal

Free Microsoft DP-900 Practice Exam with Questions & Answers | Set: 9

Questions 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

Microsoft DP-900 Premium Access
Questions 82

What is a primary characteristic of a relational database?

Options:
A.

data is queried and manipulated by using a variant of the SQL language

B.

a flexible data structure

C.

a lack of dependencies between tables

D.

a large amount of duplicate data

Questions 83

You manage an application that stores data in a shared folder on a Windows server.

You need to move the shared folder to Azure Storage.

Which type of Azure Storage should you use?

Options:
A.

queue

B.

blob

C.

file

D.

table

Questions 84

For each of the following statements. select Yes if the statement is true. Otherwise, select No. NOTE Each correct selection is worth one point.

DP-900 Question 84

Options:
Questions 85

Which three actions are used when performing diagnostic analytics?

Options:
A.

• Identify data anomalies

• Collect anomaly-related data

• Discover relationships and trends that explain anomalies.

B.

• Identify data anomalies

• Predict when anomalies are likely to recur

• Use analytical tools such as decision trees and regression.

C.

• Apply serf-learning loops to draw inferences from anomalies.

• Predict when anomalies are likely to recur

• Use analytical tools such as decision trees and regression.

D.

• Identify data anomalies

• Use machine learning to find patterns in large datasets.

• Discover relationships and trends that explain anomalies.

Questions 86

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

NOTE: Each correct selection is worth one point.

DP-900 Question 86

Options:
Questions 87

You have data saved in the following format.

DP-900 Question 87\

Which format was used?

Options:
A.

XML

B.

yaml

C.

JSON

D.

HTML

Questions 88

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

DP-900 Question 88

Options:
Questions 89

Select the answer that correctly completes the sentence.

Options:
Questions 90

Your company is designing a database that will contain session data for a website. The data will include

notifications, personalization attributes, and products that are added to a shopping cart.

Which type of data store will provide the lowest latency to retrieve the data?

Options:
A.

key/value

B.

graph

C.

columnar

D.

document

Exam Code: DP-900
Certification Provider: Microsoft
Exam Name: Microsoft Azure Data Fundamentals
Last Update: Jul 9, 2025
Questions: 306

Microsoft Related Exams

MB-310 - Microsoft Dynamics 365 Finance
MO-210 - Microsoft Excel (Microsoft 365 Apps)
MB-230 - Microsoft Dynamics 365 for Customer Service
DP-700 - Implementing Data Engineering Solutions Using Microsoft Fabric (beta)
AZ-104 - Microsoft Azure Administrator
77-427 - Excel 2013 Expert Part One
PL-900 - Microsoft Power Platform Fundamentals
PL-100 - Microsoft Power Platform App Maker
DP-420 - Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB
MB-280 - Microsoft Dynamics 365 Customer Experience Analyst
SC-900 - Microsoft Security Compliance and Identity Fundamentals
MO-200 - Microsoft Excel (Excel and Excel 2019)
MO-201 - Microsoft Excel Expert (Excel and Excel 2019)
AZ-400 - Microsoft Azure DevOps Solutions
AZ-120 - Planning and Administering Microsoft Azure for SAP Workloads
Microsoft Free Access
Get Microsoft Full Access

Microsoft Free Exams
Microsoft Free Exams
Prepare effectively for Microsoft certification exams with free study resources and practice tests from Examstrack.