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

Microsoft DP-900 Microsoft Azure Data Fundamentals Exam Practice Test

Demo: 29 questions
Total 216 questions

Microsoft Azure Data Fundamentals Questions and Answers

Question 1

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

Question 2

You have the following JSON document.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document.

NOTE: Each correct selection is worth one point.

Options:

Question 3

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

Options:

Question 4

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

Note: Each correct selection is worth one point.

Options:

Question 5

Which two Azure services can be used to provision Spark clusters? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Options:

A.

Azure Databricks

B.

Azure Log Analytics

C.

Azure Time Series Insights

D.

Azure HDinsight

Question 6

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

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

Question 7

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

Question 8

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

Options:

A.

document

B.

key/value

C.

object

D.

columnar

Question 9

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

Options:

Question 10

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.

Options:

Question 11

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

Options:

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

Options:

Question 13

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.

Options:

Question 14

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

Question 15

You have an Azure Cosmos DB account that uses the Core (SQL) API.

Which two settings can you configure at the container level? Each correct answer presents a complete

solution. (Choose two.)

NOTE: Each correct selection is worth one point.

Options:

A.

the throughput

B.

the read region

C.

the partition key

D.

the API

Question 16

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.

Question 17

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

Question 18

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

NOTE: Each correct selection is worth one point.

Options:

Question 19

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

Question 20

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

Question 21

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

Question 22

Select the answer that correctly completes the sentence.

Options:

Question 23

Select the answer that correctly completes the sentence.

Options:

Question 24

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

Options:

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

Options:

Question 26

Select the answer that correctly completes the sentence.

Options:

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

Options:

Question 28

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

Question 29

You need to store data by using Azure Table storage.

What should you create first?

Options:

A.

an Azure Cosmos DB instance

B.

a storage account

C.

a blob container

D.

a table

Demo: 29 questions
Total 216 questions