Winter Sale - Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dpm65

DP-900 Microsoft Azure Data Fundamentals Questions and Answers

Questions 4

Select the answer that correctly completes the sentence.

DP-900 Question 4

Options:

Buy Now
Questions 5

What should you use to automatically delete blobs from Azure Blob Storage?

Options:

A.

soft delete

B.

archive storage

C.

the change feed

D.

a lifecycle management policy

Buy Now
Questions 6

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 7

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 7

Options:

Buy Now
Questions 8

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 8

Options:

Buy Now
Questions 9

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

NOTE: Each correct selection is worth one point.

DP-900 Question 9

Options:

Buy Now
Questions 10

What is a characteristic of non-relational data?

Options:

A.

a well-defined schema

B.

no indexes

C.

self-describing entities

D.

no unique key values

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

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 13

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

DP-900 Question 13

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 14

Which three services support Apache Spark? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.

Options:

A.

Azure Data Explorer

B.

Azure Synapse Analytics

C.

Azure Databricks

D.

Azure Stream Analytics

E.

Azure HDInsight

Buy Now
Questions 15

Select the answer that correctly completes the sentence.

DP-900 Question 15

Options:

Buy Now
Questions 16

Select the answer the correctly completes the sentence.

DP-900 Question 16

Options:

Buy Now
Questions 17

Select the answer that correctly completes the sentence.

DP-900 Question 17

Options:

Buy Now
Questions 18

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 19

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 20

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 21

Select the answer that correctly completes the sentence.

DP-900 Question 21

Options:

Buy Now
Questions 22

Which type of database contains nodes and edges?

Options:

A.

graph

B.

columnar

C.

key/value

D.

time series

Buy Now
Questions 23

What is used to define a query in a stream processing jobs in Azure Stream Analytics?

Options:

A.

XML

B.

KQL

C.

YAML

D.

SQL

Buy Now
Questions 24

At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Options:

A.

container

B.

item

C.

database

D.

partition

Buy Now
Questions 25

What should you use to build a Microsoft Power BI paginated report?

Options:

A.

Power BI report Builder

B.

Power BI Desktop

C.

Charticulator

D.

the Power BI service

Buy Now
Questions 26

You need to create an Azure Storage account.

Data in the account must replica outside the Azure region automatically.

Which two types of replica can you us for the storage account? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one pint.

Options:

A.

read-access geo-redundant storage (RA_GRS)

B.

zone-redundant storage (ZRS)

C.

geo-redundant storage (GRS)

D.

locally-redundant storage (LRS)

Buy Now
Questions 27

Select the answer that correctly completes the sentence.

DP-900 Question 27

Options:

Buy Now
Questions 28

Select the answer that correctly completes the sentence.

DP-900 Question 28

Options:

Buy Now
Questions 29

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 29

Options:

Buy Now
Questions 30

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 30

Options:

Buy Now
Questions 31

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

DP-900 Question 31

Options:

Buy Now
Questions 32

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

DP-900 Question 32

Options:

Buy Now
Questions 33

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 34

correctly completes the sentence.

Options:

Buy Now
Questions 35

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 36

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 36

Options:

Buy Now
Questions 37

Select the answer that correctly completes the sentence.

DP-900 Question 37

Options:

Buy Now
Questions 38

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 38

Options:

Buy Now
Questions 39

Select the answer that correctly completes the sentence.

DP-900 Question 39

Options:

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

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 41

Options:

Buy Now
Questions 42

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

DP-900 Question 42

Options:

Buy Now
Questions 43

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

DP-900 Question 43

Options:

Buy Now
Questions 44

Select the answer that correctly completes the sentence.

DP-900 Question 44

Options:

Buy Now
Questions 45

Blob rehydration occurs in Azure Blob storage when a blob moves between which access tiers?

Options:

A.

Archive to Cool

B.

Hot to Cool

C.

Cool to Archive

D.

Hot to Archive

Buy Now
Questions 46

Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?

Options:

A.

WHERE

B.

SELECT

C.

JOIN

Buy Now
Questions 47

Match the job roles to the appropriate tasks.

To answer, drag the appropriate job 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 47

Options:

Buy Now
Questions 48

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 49

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

DP-900 Question 49

Options:

Buy Now
Questions 50

You need to modify a view in a relational database by adding a new column.

Which statement should you use?

Options:

A.

MERGE

B.

ALTER

C.

INSERT

D.

UPDATE

Buy Now
Questions 51

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 52

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 53

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 54

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 54

Options:

Buy Now
Questions 55

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 55

Options:

Buy Now
Questions 56

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 57

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

DP-900 Question 57

Options:

Buy Now
Questions 58

Which type of database is Azure Database for PostgreSQL?

Options:

A.

Platform as a service (PaaS)

B.

Infrastructure as a service (laaS)

C.

Microsoft SQL Server

D.

on-premises

Buy Now
Questions 59

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 60

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 60

Options:

Buy Now
Questions 61

Which command-line tool can you use to query Azure SQL databases?

Options:

A.

sqlcmd

B.

bcp

C.

azdata

D.

Azure CLI

Buy Now
Questions 62

tence.

Options:

Buy Now
Questions 63

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 64

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

DP-900 Question 64

Options:

Buy Now
Questions 65

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

DP-900 Question 65

Options:

Buy Now
Questions 66

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

DP-900 Question 66

Options:

Buy Now
Questions 67

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 68

Select the answer that correctly completes the sentence.

DP-900 Question 68

Options:

Buy Now
Questions 69

Match the security components to the appropriate scenarios.

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

NOTE: Each correct match is worth one point.

DP-900 Question 69

Options:

Buy Now
Questions 70

In Azure Table storage, each row in a table must be uniquely identified by which two components?

Each correct answer presents pan of the solution. NOTE: Each correct selection is worth one point.

Options:

A.

a timestamp

B.

a range

C.

a row key

D.

a partition key

Buy Now
Questions 71

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 72

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

DP-900 Question 72

Options:

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

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

DP-900 Question 74

Which type of data store should you use?

Options:

A.

graph

B.

key/value

C.

object

D.

columnar

Buy Now
Questions 75

Which language is used to define queries in Azure Synapse Data Explorer?

Options:

A.

Bash

B.

PowerShell

C.

KQL

D.

SQL

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

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

DP-900 Question 77

Options:

Buy Now
Questions 78

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 78

Options:

Buy Now
Questions 79

You have a SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours.

You need to minimize the cost of the SQL pool during idle times. The solution must ensure that the data

remains intact.

What should you do on the SQL pool?

Options:

A.

Scale down the data warehouse units (DWUs).

B.

Pause the pool.

C.

Create a user-defined restore point.

D.

Delete the pool

Buy Now
Questions 80

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 81

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

You have a banking application that transfers money in to and out of accounts.

Of which type of solution is this is an example?

Options:

A.

extract transform, and load (ETL)

B.

a data warehouse

C.

online analytical processing (OLAP)

D.

online transaction processing (OLTP)

Buy Now
Questions 84

You have a SQL query that combines customer data and order data. The query includes calculated columns.

You need to persist the SQL query so that other users can use the query. What should you create?

Options:

A.

a table

B.

an index

C.

scalar function

D.

a view

Buy Now
Questions 85

Which component of Azure Data Factory enables you to define a sequence of activities including for each iterators?

Options:

A.

control flow

B.

linked services

C.

datasets

D.

the integration runtime

Buy Now
Questions 86

You have a table named Sales that contains the following data.

DP-900 Question 86

You need to query the table to return the average sales amount day. The output must produce the following results.

DP-900 Question 86

How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value 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 86

Options:

Buy Now
Questions 87

You need to recommend a data store service that meets the following requirements:

    Native SQL API access

    Configurable indexes

What should you recommend?

Options:

A.

Azure Files

B.

Azure Blob storage

C.

Azure Table storage

D.

Azure Cosmos DB

Buy Now
Questions 88

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 88

Options:

Buy Now
Questions 89

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

DP-900 Question 89

Options:

Buy Now
Questions 90

You have data saved in the following format:

DP-900 Question 90

Which format was used?

Options:

A.

YAML

B.

HTML

C.

XML

D.

JSON

Buy Now
Questions 91

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 91

Options:

Buy Now
Exam Code: DP-900
Exam Name: Microsoft Azure Data Fundamentals
Last Update: Jan 11, 2025
Questions: 306

PDF + Testing Engine

$61.25  $174.99

Testing Engine

$47.25  $134.99
buy now DP-900 testing engine

PDF (Q&A)

$40.25  $114.99
buy now DP-900 pdf
dumpsmate guaranteed to pass
24/7 Customer Support

DumpsMate's team of experts is always available to respond your queries on exam preparation. Get professional answers on any topic of the certification syllabus. Our experts will thoroughly satisfy you.

Site Secure

mcafee secure

TESTED 18 Jan 2025