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

Microsoft DP-900 - Microsoft Azure Data Fundamentals

Page: 4 / 10
Total 306 questions

Select the answer that correctly completes the sentence.

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

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.

You need to modify a view in a relational database by adding a new column.

Which statement should you use?

A.

MERGE

B.

ALTER

C.

INSERT

D.

UPDATE

Select the answer that correctly completes the sentence.

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

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

NOTE: Each correct selection is worth one point.

When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?

A.

multi-master replication

B.

Availability Zones

C.

automatic failover

D.

the strong consistency level

What can be used with native notebook support to query and visualize data by using a web-based interface?

A.

Azure Databricks

B.

pgAdmin

C.

Microsoft Power Bl

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.