Summer 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

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

DP-900 Question 5

Options:

Buy Now
Questions 6

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 6

Options:

Buy Now
Questions 7

You need to store event log data that is semi-structured and received as the logs occur. What should you use?

Options:

A.

Azure Table storage

B.

Azure Queue storage

C.

Azure Files

Buy Now
Questions 8

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 9

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 10

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 11

Select the answer that correctly completes the sentence.

DP-900 Question 11

Options:

Buy Now
Questions 12

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 12

Options:

Buy Now
Questions 13

In a fully denormalized database, how is data read and written for a single entity?

Options:

A.

Data is read from a single table and written to a single table.

B.

Data is read from multiple tables and written to a single table.

C.

Data is read from a single table and written to multiple tables.

D.

Data is read from multiple tables and written to multiple tables.

Buy Now
Questions 14

When can you use an Azure Resource Manager template?

Options:

A.

to automate the creation of an interdependent group of Azure resources in a repeatable way

B.

to automate the creation of an interdependent and develop can deploy from the Azure portal

C.

To provision Azure subscriptions and apply policies for multi-tenant deployments

D.

To set complex permissions automatically on existing objects in an Azure subscription

Buy Now
Questions 15

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 15

Options:

Buy Now
Questions 16

Select the answer that correctly completes the sentence.

DP-900 Question 16

Options:

Buy Now
Questions 17

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

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

DP-900 Question 18

Options:

Buy Now
Questions 19

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

DP-900 Question 19

Options:

Buy Now
Questions 20

Select the answer that correctly completes the sentence.

DP-900 Question 20

Options:

Buy Now
Questions 21

Select the answer that correctly completes the sentence.

DP-900 Question 21

Options:

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

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 24

Match the processes to the appropriate scenarios.

To answer, drag the appropriate process from the column on the left to its scenario on the right. Each process 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

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 27

Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?

Options:

A.

isolation

B.

durability

C.

consistency

D.

atomicity

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

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

Options:

A.

REVOKE

B.

DISABLE

C.

CREATE

D.

UPDATE

Buy Now
Questions 31

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 31

Options:

Buy Now
Questions 32

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 33

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

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

DP-900 Question 36

Options:

Buy Now
Questions 37

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

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

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

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 41

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 41

Options:

Buy Now
Questions 42

Select the answer that correctly completes the sentence.

DP-900 Question 42

Options:

Buy Now
Questions 43

Select the answer that correctly completes the sentence.

DP-900 Question 43

Options:

Buy Now
Questions 44

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 45

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 46

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 47

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 48

Select the answer that correctly completes the sentence.

DP-900 Question 48

Options:

Buy Now
Questions 49

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 rec ommend?

Options:

A.

document

B.

key/value

C.

object

D.

columnar

Buy Now
Questions 50

Select the answer that correctly completes the sentence.

DP-900 Question 50

Options:

Buy Now
Questions 51

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

DP-900 Question 51

Options:

Buy Now
Questions 52

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

DP-900 Question 52

Options:

Buy Now
Questions 53

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

DP-900 Question 55

Options:

Buy Now
Questions 56

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 57

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 58

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

Which Azure service should you use?

Options:

A.

Azure Cosmos DB

B.

Azure Table storage

C.

Azure Files

D.

Azure Blob Storage

Buy Now
Questions 59

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

Options:

A.

SELECT

B.

JOIN

C.

MERGE

D.

CREATE

Buy Now
Questions 60

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 61

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 61

Options:

Buy Now
Questions 62

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

DP-900 Question 62

Options:

Buy Now
Questions 63

Select the answer that correctly completes the sentence.

DP-900 Question 63

Options:

Buy Now
Questions 64

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 65

Which type of database contains nodes and edges?

Options:

A.

graph

B.

columnar

C.

key/value

D.

time series

Buy Now
Questions 66

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 66

Options:

Buy Now
Questions 67

Select the answer that correctly completes the sentence.

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

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

Match the types of analytics that can be used to answer the business questions.

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

NOTE: Each correct match is worth one point.

DP-900 Question 70

Options:

Buy Now
Questions 71

You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database.

You need to embed documents and query results into a SQL notebook.

What should you use?

Options:

A.

Microsoft SQL Server Management Studio (SSMS)

B.

Azure Data Studio

C.

Azure CLI

D.

Azure PowerShell

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

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 75

Options:

Buy Now
Questions 76

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

DP-900 Question 76

Options:

Buy Now
Questions 77

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 78

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 79

You need to create a visualization of running sales totals per quarter as shown in the following exhibit.

DP-900 Question 79

What should you create in Power BI Desktop?

Options:

A.

a waterfall chart

B.

a ribbon chart

C.

a bar chart

D.

a decomposition tree

Buy Now
Questions 80

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

DP-900 Question 80

Options:

Buy Now
Questions 81

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

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.

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 Azure Cosmos DB API should you use for a graph database?

Options:

A.

Azure Cosmos DB for Apache Gremlin

B.

Azure Cosmos DB for NoSQL

C.

Azure Cosmos DB for Apache Cassandra

D.

Azure Cosmos DB for Table

Buy Now
Questions 86

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 86

Options:

Buy Now
Exam Code: DP-900
Exam Name: Microsoft Azure Data Fundamentals
Last Update: Jul 13, 2024
Questions: 289

PDF + Testing Engine

$59.5  $169.99

Testing Engine

$45.5  $129.99
buy now DP-900 testing engine

PDF (Q&A)

$38.5  $109.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 20 Jul 2024