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

DP-900 Questions and Answers

Question # 6

Select the answer that correctly completes the sentence.

Full Access
Question # 7

What can you use to create data ingestion pipelines?

A.

Azure HDInsight

B.

Azure SQL Database

C.

Azure Data Factory

D.

Azure Cosmos DB

Full Access
Question # 8

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

A.

complete control over backup and restore processes

B.

access to the latest features

C.

in-database machine learning services

D.

reduced administrative effort for managing the server infrastructure

Full Access
Question # 9

Select the answer that correctly completes the sentence.

Full Access
Question # 10

Select the answer that correctly completes the sentence.

Full Access
Question # 11

Your company recently reported sales from the third quarter.

You have the chart shown in the following exhibit.

Which type of analysis is shown for the fourth quarter?

A.

predictive

B.

prescription

C.

descriptive

D.

diagnostic

Full Access
Question # 12

Select the answer that correctly completes the sentence.

Full Access
Question # 13

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.

Full Access
Question # 14

Select the answer that correctly completes the sentence.

Full Access
Question # 15

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.

Full Access
Question # 16

Which Azure Storage service implements the key/value model?

A.

Azure Files

B.

Azure Table

C.

Azure Blob

D.

Azure Queue

Full Access
Question # 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.

Full Access
Question # 18

Which Azure Cosmos DB API stores data in the BSON format and uses MQL to query the data?

A.

MongoDB

B.

PostgreSQL

C.

Apache Gremlin

D.

Table

Full Access
Question # 19

What is a characteristic of non-relational data?

A.

a well-defined schema

B.

no indexes

C.

self-describing entities

D.

no unique key values

Full Access
Question # 20

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

A.

control flow

B.

linked services

C.

datasets

D.

the integration runtime

Full Access
Question # 21

You have an Azure SQL database that you access directly from the internet.

You recently changed your external IP address.

After changing the IP address, you can no longer access the database. You can connect to other resources in Azure

What is a possible cause of the issue?

A.

a database-level firewall

B.

role-based access control (RSAC)

C.

Dynamic Host Configuration Protocol (DHCP)

D.

Domain Name Service (DNS)

Full Access
Question # 22

Select the answer that correctly completes the sentence.

Full Access
Question # 23

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

NOTE: Each correct selection is worth one point.

Full Access
Question # 24

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

Full Access
Question # 25

Select the answer that correctly completes the sentence.

Full Access
Question # 26

What is a characteristic of a non-relational database?

A.

a fixed schema

B.

self-describing entities

C.

full support for Transact-SQL

Full Access
Question # 27

correctly completes the sentence.

Full Access
Question # 28

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

Full Access
Question # 29

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?

A.

graph

B.

key/value

C.

document

D.

columnar

Full Access
Question # 30

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

A.

sqlcmd

B.

bcp

C.

azdata

D.

Azure CLI

Full Access
Question # 31

Select the answer that correctly completes the sentence.

Full Access
Question # 32

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.

A.

a report page

B.

a Microsoft PowerPoint slide

C.

a visualization from a report

D.

a dataflow

E.

a text box

Full Access
Question # 33

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

NOTE: Each correct selection is worth one point.

Full Access
Question # 34

You have data saved in the following format:

Which format was used?

A.

YAML

B.

HTML

C.

XML

D.

JSON

Full Access
Question # 35

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

Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

A.

INSERT

B.

MERGE

C.

UPDATE

D.

CREATE

Full Access
Question # 36

Select the answer that correctly completes the sentence.

Full Access
Question # 37

Select the answer that correctly completes the sentence.

Full Access
Question # 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.

Full Access
Question # 39

Select the answer that correctly completes the sentence.

Full Access
Question # 40

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

Full Access
Question # 41

Select the answer that correctly completes the sentence.

Full Access
Question # 42

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

Full Access
Question # 43

Select the answer that correctly completes the sentence.

Full Access
Question # 44

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

NOTE Each correct selection is worth one point.

Full Access
Question # 45

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?

A.

a table

B.

an index

C.

scalar function

D.

a view

Full Access
Question # 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.

Full Access
Question # 47

Select the answer that correctly completes the sentence.

Full Access
Question # 48

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.

Full Access
Question # 49

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?

A.

Azure DNS

B.

Azure Application Gateway

C.

Azure Private link

D.

Azure Traffic Manager

Full Access
Question # 50

Which three actions are used when performing diagnostic analytics?

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.

Full Access
Question # 51

Select the answer that correctly completes the sentence.

Full Access
Question # 52

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.

Full Access
Question # 53

Select the answer that correctly completes the sentence.

Full Access
Question # 54

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?

A.

Azure Cosmos

B.

Azure Table storage

C.

Azure Files

D.

Azure Blob storage

Full Access
Question # 55

Select the answer that correctly completes the sentence.

Full Access
Question # 56

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?

A.

service principal authentication

B.

Azure Active Directory (Azure AD) authentication

C.

SQL authentication

D.

certificate authentication

Full Access
Question # 57

tence.

Full Access
Question # 58

Match the Azure services to appropriate requirements.

To answer, drag the appropriate services 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.

Full Access
Question # 59

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.

A.

a timestamp

B.

a range

C.

a row key

D.

a partition key

Full Access
Question # 60

Select the answer that correctly completes the sentence.

Full Access
Question # 61

Select the answer that correctly completes the sentence.

Full Access
Question # 62

What is a characteristic of batch processing?

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.

Full Access
Question # 63

Select the answer that correctly completes the sentence.

Full Access
Question # 64

Select the answer that correctly completes the sentence.

Full Access
Question # 65

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

Full Access
Question # 66

Which file format has defined names and data types for each column and uses compressed columnar storage?

A.

JSON

B.

CSV

C.

Apache Parquet

D.

HTML

Full Access
Question # 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.

Full Access
Question # 68

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.

Full Access
Question # 69

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?

A.

Microsoft SQL Server Management Studio (SSMS)

B.

Azure Data Studio

C.

Azure CLI

D.

Azure PowerShell

Full Access
Question # 70

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.

Full Access
Question # 71

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.

Full Access
Question # 72

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

Full Access
Question # 73

Select the answer that correctly completes the sentence.

Full Access
Question # 74

What is the responsibility of a database administrator?

A.

applying data cleaning routines

B.

creating data visualizations

C.

managing data integration processes

D.

storing backup copies of data

Full Access
Question # 75

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

Full Access
Question # 76

Select the answer that correctly completes the sentence.

Full Access
Question # 77

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

NOTE: Each correct selection is worth one point.

Full Access
Question # 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.

Full Access
Question # 79

What are two characteristics of real-time data processing? Each correct answer present a complete solution.

NOTE: Each correct selection is worth one point.

A.

Data is processed as it is created.

B.

Low latency is expected

C.

High latency acceptable

D.

Data is processed periodically

Full Access
Question # 80

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

A.

a few milliseconds

B.

a few seconds

C.

a few minutes

D.

a few hours

Full Access
Question # 81

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

    Native SQL API access

    Configurable indexes

What should you recommend?

A.

Azure Files

B.

Azure Blob storage

C.

Azure Table storage

D.

Azure Cosmos DB

Full Access
Question # 82

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.

Full Access
Question # 83

What is required to provision Azure Data Lake Storage in an Azure Storage account?

A.

Versioning must be enabled.

B.

Hierarchical namespace must be enabled.

C.

Hierarchical namespace must be disabled.

D.

Versioning must be disabled.

Full Access
Question # 84

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.

Full Access
Question # 85

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

A.

Azure Data Lake Storage

B.

Azure Cosmos DB

C.

Azure Queue storage

D.

Azure Blob storage

Full Access
Question # 86

Select the answer that correctly completes the sentence.

Full Access
Question # 87

Select the answer that correctly completes the sentence.

Full Access
Question # 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.

Full Access
Question # 89

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.

Full Access
Question # 90

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?

A.

Synapse pipelines

B.

a Synapse SQL pool

C.

Synapse Link

D.

Synapse Studio

Full Access
Question # 91

Which scenario is an example of a streaming workload?

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

Full Access
Question # 92

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?

A.

queue

B.

blob

C.

file

D.

table

Full Access
Question # 93

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.

Full Access