Winter 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

In an analytical data model, which type of table contains entities that are used to aggregate numeric values, where each entity is represented by a row with a unique key value?

Options:

A.

bridge

B.

dimension

C.

fact

Buy Now
Questions 5

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 6

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 7

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

DP-900 Question 7

Options:

Buy Now
Questions 8

What is the primary purpose of a data warehouse?

Options:

A.

to provide answers to complex queries that rely on data from multiple sources

B.

to provide transformation services between source and target data stores

C.

to provide read-only storage of relational and non-relational historical data

D.

to provide storage for transactional line-of-business (LOB) applications

Buy Now
Questions 9

Select the answer that correctly completes the sentence.

DP-900 Question 9

Options:

Buy Now
Questions 10

Which clause should you use in a select statement to combine rows in one table with rows in another table?

Options:

A.

JOIN

B.

VALUES

C.

set

D.

KEY

Buy Now
Questions 11

Select the answer that correctly completes the sentence.

DP-900 Question 11

Options:

Buy Now
Questions 12

Select the answer that correctly completes the sentence.

DP-900 Question 12

Options:

Buy Now
Questions 13

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 13

Options:

Buy Now
Questions 14

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 14

Options:

Buy Now
Questions 15

What is the responsibility of a database administrator?

Options:

A.

applying data cleaning routines

B.

creating data visualizations

C.

managing data integration processes

D.

storing backup copies of data

Buy Now
Questions 16

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

DP-900 Question 16

Options:

Buy Now
Questions 17

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 17

Options:

Buy Now
Questions 18

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 19

Select the answer that correctly completes the sentence.

DP-900 Question 19

Options:

Buy Now
Questions 20

Select the answer that correctly completes the sentence.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 20

Options:

Buy Now
Questions 21

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

Options:

A.

INSERT

B.

DISABLE

C.

ALTER

D.

DROP

Buy Now
Questions 22

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

DP-900 Question 22

Options:

Buy Now
Questions 23

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 24

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 25

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 26

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 26

Options:

Buy Now
Questions 27

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 27

Options:

Buy Now
Questions 28

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 29

Select the answer that correctly completes the sentence.

DP-900 Question 29

Options:

Buy Now
Questions 30

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

DP-900 Question 30

Options:

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

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 33

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 33

Options:

Buy Now
Questions 34

Select the answer that correctly completes the sentence.

DP-900 Question 34

Options:

Buy Now
Questions 35

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 36

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 36

Options:

Buy Now
Questions 37

Match the types of data stores to the appropriate scenarios.

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

NOTE: Each correct match is worth one point.

DP-900 Question 37

Options:

Buy Now
Questions 38

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

DP-900 Question 38

Options:

Buy Now
Questions 39

correctly completes the sentence.

Options:

Buy Now
Questions 40

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 40

Options:

Buy Now
Questions 41

Select the answer that correctly completes the sentence.

DP-900 Question 41

Options:

Buy Now
Questions 42

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 43

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 44

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

DP-900 Question 44

Options:

Buy Now
Questions 45

You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP).

Which Azure service should you use to support the application?

Options:

A.

Azure Cosmos DB

B.

Azure Synapse Analytics

C.

Azure HDInsight

D.

Azure SQL Database

Buy Now
Questions 46

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 47

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 47

Options:

Buy Now
Questions 48

Select the answer that correctly completes the sentence.

DP-900 Question 48

Options:

Buy Now
Questions 49

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 49

Options:

Buy Now
Questions 50

Select the answer that correctly completes the sentence.

DP-900 Question 50

Options:

Buy Now
Questions 51

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

DP-900 Question 51

Which type of data store should you use?

Options:

A.

graph

B.

key/value

C.

object

D.

columnar

Buy Now
Questions 52

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 53

You have an e-commerce application that reads and writes data to an Azure SQL database. Which type of processing does the application use?

Options:

A.

stream processing

B.

batch processing

C.

Online Analytical Processing (OLTP)

D.

Online Transaction Processing (OLTP)

Buy Now
Questions 54

Select the answer that correctly completes the sentence.

DP-900 Question 54

Options:

Buy Now
Questions 55

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 55

Options:

Buy Now
Questions 56

Select the answer that correctly completes the sentence.

DP-900 Question 56

Options:

Buy Now
Questions 57

Which Azure Data Factory component initiates the execution of a pipeline?

Options:

A.

a control flow

B.

a trigger

C.

a parameter

D.

an activity

Buy Now
Questions 58

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 59

Select the answer that correctly completes the sentence.

DP-900 Question 59

Options:

Buy Now
Questions 60

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 61

A bar chart showing year-to date sales by region is an example of which type of analytics?

Options:

A.

descriptive

B.

diagnostic

C.

predictive

D.

prescriptive

Buy Now
Questions 62

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 62

Options:

Buy Now
Questions 63

What is the typical latency for read operations against media files stored in the Cool access tier of Azure Blob Storage?

Options:

A.

a few milliseconds

B.

a few seconds

C.

a few minutes

D.

a few hours

Buy Now
Questions 64

Select the answer that correctly completes the sentence.

DP-900 Question 64

Options:

Buy Now
Questions 65

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

DP-900 Question 65

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 66

Select the answer that correctly completes the sentence.

DP-900 Question 66

Options:

Buy Now
Questions 67

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 67

Options:

Buy Now
Questions 68

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 68

Options:

Buy Now
Questions 69

Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back?

Options:

A.

isolation

B.

durability

C.

atomicity

D.

consistency

Buy Now
Questions 70

Select the answer that correctly completes the sentence.

DP-900 Question 70

Options:

Buy Now
Questions 71

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 71

Options:

Buy Now
Questions 72

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 73

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 74

Select the answer that correctly completes the sentence.

DP-900 Question 74

Options:

Buy Now
Questions 75

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 75

Options:

Buy Now
Questions 76

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 77

What is a characteristic of batch processing?

Options:

A.

The data ingested during batch processing must be processed as soon as the data is received.

B.

Large datasets must be split into batches of less than 1 GB before the data can be processed.

C.

There is a noticeable time delay between ingesting data and obtaining the data processing results.

D.

Batch processing can only process data that is structured.

Buy Now
Questions 78

Select the answer that correctly completes the sentence.

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 have a transactional application that stem data in an Azure SQL managed instance. When should you implement a read-only database replica?

Options:

A.

You need to generate reports without affecting the transactional workload.

B.

You need to audit the transactional application.

C.

You need to implement high availability in the event of a regional outage

D.

You need to improve the recovery point objective (RPO).

Buy Now
Questions 81

Which type of database contains nodes and edges?

Options:

A.

graph

B.

columnar

C.

key/value

D.

time series

Buy Now
Questions 82

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 82

Options:

Buy Now
Questions 83

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

DP-900 Question 83

Options:

Buy Now
Questions 84

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 84

Options:

Buy Now
Questions 85

Select the answer that correctly completes the sentence.

DP-900 Question 85

Options:

Buy Now
Questions 86

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

Options:

A.

Bash

B.

PowerShell

C.

KQL

D.

SQL

Buy Now
Questions 87

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 88

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

DP-900 Question 88

Which type of data store is this?

Options:

A.

object data

B.

graph

C.

key/value

D.

time series

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

Which scenario is an example of a streaming workload?

Options:

A.

sending transactions that are older than a month to an archive

B.

sending transactions daily from point of sale (POS) devices

C.

sending telemetry data from edge devices

D.

sending cloud infrastructure metadata every 30 minutes

Buy Now
Questions 91

Select the answer that correctly completes the sentence.

DP-900 Question 91

Options:

Buy Now
Exam Code: DP-900
Exam Name: Microsoft Azure Data Fundamentals
Last Update: Nov 30, 2024
Questions: 306

PDF + Testing Engine

$70  $174.99

Testing Engine

$54  $134.99
buy now DP-900 testing engine

PDF (Q&A)

$46  $114.99
buy now DP-900 pdf