March Special Sale Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 713PS592

DP-900 Microsoft Azure Data Fundamentals Questions and Answers

Questions 4

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 5

Select the answer that correctly completes the sentence.

DP-900 Question 5

Options:

Buy Now
Questions 6

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 6

Options:

Buy Now
Questions 7

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

Your company needs to implement a relational database in Azure. The solution must minimize ongoing

maintenance.

Which Azure service should you use?

Options:

A.

Azure HDInsight

B.

Azure SQL Database

C.

Azure Cosmos DB

D.

SQL Server on Azure virtual machines

Buy Now
Questions 9

You need to store data in Azure Blob storage for seven years to meet your company's compliance

requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs.

Which storage tier should you use?

Options:

A.

Archive

B.

Hot

C.

Cool

Buy Now
Questions 10

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

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

DP-900 Question 11

Options:

Buy Now
Questions 12

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

DP-900 Question 12

Options:

Buy Now
Questions 13

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 14

Match the types of workloads the appropriate scenario.

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 14

Options:

Buy Now
Questions 15

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

DP-900 Question 15

Options:

Buy Now
Questions 16

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 17

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

DP-900 Question 17

Options:

Buy Now
Questions 18

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 18

Options:

Buy Now
Questions 19

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 stages. Each location may be used once, more than 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 19

Options:

Buy Now
Questions 20

You are reviewing the data model shown in the following exhibit.

DP-900 Question 20

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point

DP-900 Question 20

Options:

Buy Now
Questions 21

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 22

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 22

Options:

Buy Now
Questions 23

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

DP-900 Question 23

Options:

Buy Now
Questions 24

Match the datastore services to the appropriate descriptions.

To answer, drag the appropriate service from the column on the left to its description 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 24

Options:

Buy Now
Questions 25

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 25

Options:

Buy Now
Questions 26

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 26

Options:

Buy Now
Questions 27

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

DP-900 Question 27

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

Select the answer that correctly completes the sentence.

DP-900 Question 28

Options:

Buy Now
Questions 29

Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?

Options:

A.

Azure SQL Database Hyperscale

B.

Azure SQL managed instance

C.

Azure SQL Database serveless

D.

Azure SQL Database elastic pod

Buy Now
Questions 30

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 31

Select the answer that correctly completes the sentence.

DP-900 Question 31

Options:

Buy Now
Questions 32

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 33

Select the answer that correctly completes the sentence.

DP-900 Question 33

Options:

Buy Now
Questions 34

Select the answer that correctly completes the sentence.

DP-900 Question 34

Options:

Buy Now
Questions 35

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 36

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 37

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 38

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 39

Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?

Options:

A.

an Azure SQL Database elastic pool

B.

Azure SQL Managed Instance

C.

Azure Database for MySQL

D.

Azure SQL Database

Buy Now
Questions 40

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 40

Options:

Buy Now
Questions 41

Select the answer that correctly completes the sentence.

DP-900 Question 41

Options:

Buy Now
Questions 42

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 42

Options:

Buy Now
Questions 43

Match the tools to the appropriate descriptions.

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

NOTE: Each correct match is worth one point.

DP-900 Question 43

Options:

Buy Now
Questions 44

You have data saved in the following format.

DP-900 Question 44\

Which format was used?

Options:

A.

XML

B.

yaml

C.

JSON

D.

HTML

Buy Now
Questions 45

Which statement is an example of Data Definition Language (DDL)?

Options:

A.

SELECT

B.

JOIN

C.

MERGE

D.

CREATE

Buy Now
Questions 46

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 46

Options:

Buy Now
Questions 47

You have data saved in the following format:

DP-900 Question 47

Which format was used?

Options:

A.

YAML

B.

HTML

C.

XML

D.

JSON

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

Select the answer that correctly completes the sentence.

DP-900 Question 49

Options:

Buy Now
Questions 50

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

DP-900 Question 50

Options:

Buy Now
Questions 51

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

Buy Now
Questions 52

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 53

Select the answer that correctly completes the sentence.

DP-900 Question 53

Options:

Buy Now
Questions 54

Select the answer that correctly completes the sentence.

DP-900 Question 54

Options:

Buy Now
Questions 55

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 56

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

DP-900 Question 56

Options:

Buy Now
Questions 57

Your company needs to ensure that in Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet. What should you use?

Options:

A.

Azure DNS

B.

Azure Application Gateway

C.

Azure Private link

D.

Azure Traffic Manager

Buy Now
Questions 58

Match the types of visualizations to the appropriate descriptions.

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

NOTE: Each correct match is worth one point.

DP-900 Question 58

Options:

Buy Now
Questions 59

Select the answer that correctly completes the sentence.

DP-900 Question 59

Options:

Buy Now
Questions 60

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.)

NOTE: Each correct selection is worth one point.

Options:

A.

denormalized data

B.

schema defined when reading unstructured data from a database

C.

light writes and heavy reads

D.

normalized data

E.

schema defined in a database

F.

heavy writes and moderate reads

Buy Now
Questions 61

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 62

Select the answer that correctly completes the sentence.

DP-900 Question 62

Options:

Buy Now
Questions 63

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 63

Options:

Buy Now
Questions 64

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

Buy Now
Questions 65

Select the answer that correctly completes the sentence.

DP-900 Question 65

Options:

Buy Now
Questions 66

Select the answer that correctly completes the sentence.

DP-900 Question 66

Options:

Buy Now
Questions 67

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 67

Options:

Buy Now
Questions 68

Select the answer that correctly completes the sentence.

DP-900 Question 68

Options:

Buy Now
Questions 69

Select the answer that correctly completes the sentence.

DP-900 Question 69

Options:

Buy Now
Questions 70

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 70

Options:

Buy Now
Questions 71

Your company recently reported sales from the third quarter.

You have the chart shown in the following exhibit.

DP-900 Question 71

Which type of analysis is shown for the fourth quarter?

Options:

A.

predictive

B.

prescription

C.

descriptive

D.

diagnostic

Buy Now
Questions 72

Select the answer that correctly completes the sentence.

DP-900 Question 72

Options:

Buy Now
Questions 73

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 73

Options:

Buy Now
Questions 74

Select the answer that correctly completes the sentence.

DP-900 Question 74

Options:

Buy Now
Questions 75

You have a data store that has the structure shown in the following exhibit.

DP-900 Question 75

Which type of data store is this?

Options:

A.

object data

B.

graph

C.

key/value

D.

time series

Buy Now
Questions 76

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?

Options:

A.

a scalar function

B.

a table

C.

an index

D.

a view

Buy Now
Questions 77

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

DP-900 Question 77

Options:

Buy Now
Questions 78

Which storage solution supports access control lists (ACLs) at the file and folder level?

Options:

A.

Azure Data Lake Storage

B.

Azure Cosmos DB

C.

Azure Queue storage

D.

Azure Blob storage

Buy Now
Questions 79

You have the following two tables of customer data.

DP-900 Question 79

Which type of data do the tables contain?

Options:

A.

non-relational

B.

structured

C.

semi-structured

D.

unstructured

Buy Now
Questions 80

You need to design and model a database by using a graphical tool that supports project-oriented offline

database development.

What should you use?

Options:

A.

Microsoft SQL Server Data Tools (SSDT)

B.

Microsoft SQL Server Management Studio (SSMS)

C.

Azure Databricks

D.

Azure Data Studio

Buy Now
Questions 81

Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?

Options:

A.

consistency

B.

durability

C.

isolation

D.

atomicity

Buy Now
Questions 82

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 82

Options:

Buy Now
Questions 83

Your company is designing a data store tor internet-connected temperature sensors. The collected data will be used to analyze temperature trends. Which type of data store should you use?

Options:

A.

relational

B.

columnar

C.

graph

D.

time series

Buy Now
Questions 84

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

DP-900 Question 84

Options:

Buy Now
Questions 85

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

DP-900 Question 85

Options:

Buy Now
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:

Buy Now
Exam Code: DP-900
Exam Name: Microsoft Azure Data Fundamentals
Last Update: Mar 27, 2024
Questions: 292

PDF + Testing Engine

$70  $174.99

Testing Engine

$54  $134.99
buy now DP-900 testing engine

PDF (Q&A)

$48  $119.99
buy now DP-900 pdf