DP-900: Microsoft Azure Data Fundamentals

Question #: 11
Topic #: 1
HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

C

Question #: 30
Topic #: 1
HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Descriptive

Question #: 29
Topic #: 1
HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Cognitive

Question #: 26
Topic #: 1
DRAG DROP –
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.
Select and Place:

CRM – DW -DW

Question #: 25
Topic #: 1
DRAG DROP –
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.
Select and Place:

Batch, Streaming,Batch

Question #: 24
Topic #: 1
DRAG DROP –
Match the Azure Data Factory components to the appropriate descriptions.
To answer, drag the appropriate component from the column on the left to its description on the right. Each component may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:

Dataset
Linked Service
Pipeline

Question #: 22
Topic #: 1
DRAG DROP –
Match the Azure Data Lake Storage Gen2 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.
Select and Place:

Azure storage account
Container

Question #: 21
Topic #: 1
DRAG DROP –
Match the types of data to the appropriate Azure data services.
To answer, drag the appropriate data type 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.
Select and Place:

1. Image files = Azure Blob storage
2. Relationship between employyes = Azure Cosmos DB Gremlin API
3. Key/value pairs = Azure Table Storage

Question #: 20
Topic #: 1
HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Simple lookups

Question #: 42
Topic #: 1
DRAG DROP –
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.
Select and Place:

Diagnostic
Predictive
Cognitive

Question #: 41
Topic #: 1
HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Stored Procedure

Question #: 39
Topic #: 1
HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

C

Question #: 36
Topic #: 1
HOTSPOT –
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.
Hot Area:

Iaas and Paas

Question #: 35
Topic #: 1
HOTSPOT –
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Y N Y

Question #: 33
Topic #: 1
HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Core(SQL)

Question #: 53
Topic #: 1
HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:

Simple Lookup

Question #: 52
Topic #: 1
HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:

graph db

Question #: 51
Topic #: 1
HOTSPOT –
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Y N Y

Question #: 50
Topic #: 1
HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:

C

Question #: 49
Topic #: 1
HOTSPOT –
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Y Y N

Question #: 48
Topic #: 1
HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:

D

Question #: 46
Topic #: 1
HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:

D

Question #: 72
Topic #: 1
HOTSPOT –
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Y Y Y

Question #: 70
Topic #: 1
HOTSPOT –
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Y N Y

Question #: 69
Topic #: 1
DRAG DROP –
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.
Select and Place:

SSMS,
Azure Data Studio,
SSDT

Question #: 65
Topic #: 1
DRAG DROP –
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.
Select and Place:

Table
View
Index

Question #: 60
Topic #: 1
HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:

DATA ENGINEER

Question #: 56
Topic #: 1
HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:

C

Question #: 55
Topic #: 1
HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:

B

Question #: 54
Topic #: 1
HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:

D

Question #: 82
Topic #: 1
DRAG DROP –
You have a table named Sales that contains the following data.

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

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.
Select and Place:

Question #: 81
Topic #: 1
HOTSPOT –
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

N Y N

Question #: 78
Topic #: 1
HOTSPOT –
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Y N Y

Question #: 76
Topic #: 1
HOTSPOT –
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

N N Y

Question #: 75
Topic #: 1
HOTSPOT –
You have the following SQL query.

What are dbo.Products and ProductName? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Table, column

Question #: 74
Topic #: 1
HOTSPOT –
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Y Y Y

Question #: 73
Topic #: 1
HOTSPOT –
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Y Y Y

Question #: 101
Topic #: 1
HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:

B

Question #: 99
Topic #: 1
DRAG DROP –
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 its worth one point.
Select and Place:

Single, MI, single.

Question #: 95
Topic #: 1
HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

C

Question #: 94
Topic #: 1
HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

C

Question #: 93
Topic #: 1
HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

D

Question #: 91
Topic #: 1

DRAG DROP –
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.
Select and Place:

Question #: 89
Topic #: 1
HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

B

Question #: 86
Topic #: 1
HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

C

Question #: 116
Topic #: 1
HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

D

Question #: 115
Topic #: 1
HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

A

Question #: 114
Topic #: 1
DRAG DROP –
Match the Azure Cosmos DB APIs to the appropriate data structures.
To answer, drag the appropriate API from the column on the left to its data structure on the right. Each API may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:

GRemlin
GRaph

Question #: 108
Topic #: 1
DRAG DROP –
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.
Select and Place:

Key/value
object
Graph