Weekend Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: pass65

DP-900 Microsoft Azure Data Fundamentals Questions and Answers

Questions 4

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

DP-900 Question 4

Options:

Buy Now
Questions 5

How is raw data stored in a data lakehoose?

Options:

A.

as tables

B.

as queues

C.

as files

D.

as disks

Buy Now
Questions 6

Select the answer that correctly completes the sentence.

DP-900 Question 6

Options:

Buy Now
Questions 7

You have structured data in tabular format.

What represents an individual instance of a data entity?

Options:

A.

a column

B.

a cell

C.

a row

D.

a table

Buy Now
Questions 8

You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL

database.

Which type of authentication should you use?

Options:

A.

service principal authentication

B.

Azure Active Directory (Azure AD) authentication

C.

SQL authentication

D.

certificate authentication

Buy Now
Questions 9

You have data saved in the following format.

DP-900 Question 9

Which format was used?

Options:

A.

HTML

B.

CSV

C.

JSON

D.

YAML

Buy Now
Questions 10

Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract load, and transform (ELT) process.

Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct. Each location may be used once, or not at all, You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

DP-900 Question 10

Options:

Buy Now
Questions 11

Select the answer that correctly completes the sentence.

DP-900 Question 11

Options:

Buy Now
Questions 12

You have data saved in the following format:

DP-900 Question 12

Which format was used?

Options:

A.

YAML

B.

HTML

C.

XML

D.

JSON

Buy Now
Questions 13

Match the Azure services to the appropriate locations in the architecture.

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

NOTE: Each correct match is worth one point.

DP-900 Question 13

Options:

Buy Now
Questions 14

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

Options:

A.

REVOKE

B.

DISABLE

C.

CREATE

D.

UPDATE

Buy Now
Questions 15

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 16

Match the Azure Cosmos DB APIs to the appropriate data structures.

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

NOTE: Each correct match is worth one point.

DP-900 Question 16

Options:

Buy Now
Questions 17

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

DP-900 Question 17

Options:

Buy Now
Questions 18

Select the answer that correctly completes the sentence.

DP-900 Question 18

Options:

Buy Now
Questions 19

Select the answer that correctly completes the sentence.

DP-900 Question 19

Options:

Buy Now
Questions 20

Match the Azure services to the appropriate requirements.

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

NOTE: Each correct match is worth one point.

DP-900 Question 20

Options:

Buy Now
Questions 21

Your company needs to design a database that shows how changes traffic in one area of a network affect other components on the network.

Which type of data store should you use?

Options:

A.

Key/value

B.

Graph

C.

Document

D.

columnar

Buy Now
Questions 22

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
Questions 23

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 24

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?

Options:

A.

a dashboard

B.

Microsoft Power Apps

C.

a dataflow

D.

a report

Buy Now
Questions 25

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

DP-900 Question 25

Options:

Buy Now
Questions 26

Which type of Microsoft Power Bl visual can you use to examine trends over time for one or more series of values?

Options:

A.

funnel chart

B.

pie chart

C.

table

D.

line chart

Buy Now
Questions 27

Select the answer that correctly completes the sentence.

DP-900 Question 27

Options:

Buy Now
Questions 28

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.

DP-900 Question 28

Options:

Buy Now
Questions 29

Match the database normalization 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.

DP-900 Question 29

Options:

Buy Now
Questions 30

Match the Azure services to the appropriate locations in the architecture.

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

NOTE: Each correct match is worth one point.

DP-900 Question 30

Options:

Buy Now
Questions 31

You need to perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos DB data sources by using Azure Synapse Analytics.

What should you use?

Options:

A.

Synapse pipelines

B.

a Synapse SQL pool

C.

Synapse Link

D.

Synapse Studio

Buy Now
Questions 32

Select the answer that correctly completes the sentence.

DP-900 Question 32

Options:

Buy Now
Questions 33

Select the answer that correctly completes the sentence.

DP-900 Question 33

Options:

Buy Now
Questions 34

correctly completes the sentence.

Options:

Buy Now
Questions 35

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 35

Options:

Buy Now
Questions 36

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 37

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 37

Options:

Buy Now
Questions 38

You need to query a table named Products in an Azure SQL database.

Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. (Choose three.)

NOTE: Each correct selection is worth one point.

Options:

A.

You must be assigned the Reader role for the resource group that contains the database.

B.

You must have SELECT access to the Products table.

C.

You must have a user in the database.

D.

You must be assigned the Contributor role for the resource group that contains the database.

E.

Your IP address must be allowed to connect to the database.

Buy Now
Questions 39

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 39

Options:

Buy Now
Questions 40

Match the Azure SQL services to the appropriate use cases.

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

NOTE: Each correct match is worth one point.

DP-900 Question 40

Options:

Buy Now
Questions 41

A data engineer is responsible for which task?

Options:

A.

Design and build analytical models.

B.

Design and implement data stores for analytical workloads.

C.

Explore data to identify trends.

D.

Implement policies, tools. and processes for backup and recovery plans.

Buy Now
Questions 42

Match the types of workloads to the appropriate scenarios.

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

NOTE: Each correct match is worth one point.

DP-900 Question 42

Options:

Buy Now
Questions 43

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.

Options:

A.

a report page

B.

a Microsoft PowerPoint slide

C.

a visualization from a report

D.

a dataflow

E.

a text box

Buy Now
Questions 44

Match the types of activities to the appropriate Azure Data Factory activities.

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

NOTE: Each correct match is worth one point.

DP-900 Question 44

Options:

Buy Now
Questions 45

Select the answer that correctly completes the sentence.

DP-900 Question 45

Options:

Buy Now
Questions 46

When you create an Azure SQL database, which account can always connect to the database ?

Options:

A.

the Azure Active director/ (Azure AO) account that created the database

B.

the Azure Active Directly Azure AD) administrator account

C.

the sa account

D.

the server admin login account of the logical server

Buy Now
Questions 47

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 47

Options:

Buy Now
Questions 48

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 48

Options:

Buy Now
Questions 49

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

DP-900 Question 49

Options:

Buy Now
Questions 50

Your company is designing a data store that will contain student data. The data has the following format.

DP-900 Question 50

Which type of data store should you use?

Options:

A.

graph

B.

key/value

C.

object

D.

columnar

Buy Now
Questions 51

Match the data processing languages to the appropriate real-time analytics services.

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

NOTE: Each correct match is worth one point.

DP-900 Question 51

Options:

Buy Now
Questions 52

Select the answer that correctly completes the sentence.

DP-900 Question 52

Options:

Buy Now
Questions 53

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 53

Options:

Buy Now
Questions 54

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 54

Options:

Buy Now
Questions 55

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
Questions 56

Match the types of data to the appropriate Azure data services.

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

NOTE: Each correct match is worth one point.

DP-900 Question 56

Options:

Buy Now
Questions 57

You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse.

What should you use to query the files?

Options:

A.

Azure Functions

B.

Microsoft SQL Server Integration Services (SSIS)

C.

PolyBase

D.

Azure Data Factory

Buy Now
Questions 58

You have data in a tabular format as shown in the following table.

DP-900 Question 58

Of which type of data is this an example?

Options:

A.

unstructured data

B.

semi-structured data

C.

document

D.

structured data

Buy Now
Questions 59

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

Buy Now
Questions 60

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

DP-900 Question 60

Options:

Buy Now
Questions 61

Select the answer that correctly completes the sentence.

DP-900 Question 61

Options:

Buy Now
Questions 62

You need to gather real-time telemetry data from a mobile application.

Which type of workload describes this scenario?

Options:

A.

Online Transaction Processing (OLTP)

B.

batch

C.

massively parallel processing (MPP)

D.

streaming

Buy Now
Questions 63

Your company needs to design a database that illustrates the relationships between utilization levels of individual network devices across a local area network.

Which type of data store should you use?

Options:

A.

graph

B.

key/value

C.

document

D.

columnar

Buy Now
Questions 64

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

DP-900 Question 64

Options:

Buy Now
Questions 65

What can you use to create data ingestion pipelines?

Options:

A.

Azure HDInsight

B.

Azure SQL Database

C.

Azure Data Factory

D.

Azure Cosmos DB

Buy Now
Questions 66

Select the answer that correctly completes the sentence.

DP-900 Question 66

Options:

Buy Now
Questions 67

Select the answer that correctly completes the sentence.

DP-900 Question 67

Options:

Buy Now
Questions 68

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

DP-900 Question 68

Options:

Buy Now
Questions 69

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 69

Options:

Buy Now
Questions 70

Select the answer that correctly completes the sentence.

DP-900 Question 70

Options:

Buy Now
Questions 71

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.

DP-900 Question 71

Options:

Buy Now
Questions 72

Which Azure Data Factory component provides the compute environment for activities?

Options:

A.

a linked service

B.

an integration runtime

C.

a control flow

D.

a pipeline

Buy Now
Questions 73

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

DP-900 Question 73

Options:

Buy Now
Questions 74

Which service is optimized for loT scenarios that involve streaming time series data?

Options:

A.

SQL Server on Azure Virtual Machines

B.

Azure SQL Managed Instance

C.

Azure SQL Database

D.

Azure SQL Edge

Buy Now
Questions 75

You need to recommend a non-relational data store that is optimized for storing and retrieving files, videos, audio stream, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file.

Which type of data store should you recommend?

Options:

A.

document

B.

key/value

C.

object

D.

columnar

Buy Now
Questions 76

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 76

Options:

Buy Now
Questions 77

Select the answer that correctly completes the sentence.

DP-900 Question 77

Options:

Buy Now
Questions 78

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

DP-900 Question 78

Options:

Buy Now
Questions 79

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

DP-900 Question 79

Options:

Buy Now
Questions 80

You plan to deploy an app. The app requires a nonrelational data service that will provide latency guarantees of less than 10-ms for reads and writes. What should you include in the solution?

Options:

A.

Azure Cosmos

B.

Azure Table storage

C.

Azure Files

D.

Azure Blob storage

Buy Now
Questions 81

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

DP-900 Question 81

Options:

Buy Now
Questions 82

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

DP-900 Question 82

Options:

Buy Now
Questions 83

Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution. (Choose two.)

NOTE: Each correct selection is worth one point.

Options:

A.

Azure Time Series Insights

B.

Azure HDInsight

C.

Azure Databricks

D.

Azure Log Analytics

Buy Now
Questions 84

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 85

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 85

Options:

Buy Now
Questions 86

Select the answer that correctly completes the sentence.

DP-900 Question 86

Options:

Buy Now
Questions 87

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

DP-900 Question 87

Options:

Buy Now
Questions 88

Match the job roles to the appropriate tasks.

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

NOTE: Each correct match is worth one point.

DP-900 Question 88

Options:

Buy Now
Questions 89

Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy.

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

NOTE: Each correct match is worth one point.

DP-900 Question 89

Options:

Buy Now
Questions 90

Which two activities can be performed entirely by using the Microsoft Power BI service? Each correct answer presents a complete solution. (Choose two.)

NOTE: Each correct selection is worth one point.

Options:

A.

report and dashboard creation

B.

report sharing and distribution

C.

data modeling

D.

data acquisition and preparation

Buy Now
Questions 91

Select the answer that correctly completes the sentence.

DP-900 Question 91

Options:

Buy Now
Questions 92

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

DP-900 Question 92

Options:

Buy Now
Questions 93

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

Options:

A.

INSERT

B.

DISABLE

C.

ALTER

D.

DROP

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

PDF + Testing Engine

$65.27  $186.49

Testing Engine

$52.32  $149.49
buy now DP-900 testing engine

PDF (Q&A)

$48.12  $137.49
buy now DP-900 pdf