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

Microsoft DP-900 - Microsoft Azure Data Fundamentals

Page: 5 / 10
Total 316 questions

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?

A.

bridge

B.

dimension

C.

fact

Select the answer that correctly completes the sentence.

Which statement is an example of Data Definition Language (DDL)?

A.

SELECT

B.

INSERT

C.

DELETE

D.

DROP

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

A.

descriptive

B.

diagnostic

C.

predictive

D.

prescriptive

Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?

A.

isolation

B.

durability

C.

consistency

D.

atomicity

Select the answer that correctly completes the sentence.

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

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

NOTE: Each correct selection is worth one point.

Select the answer that correctly completes the sentence.

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.