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

Microsoft DP-900 - Microsoft Azure Data Fundamentals

Page: 6 / 10
Total 332 questions

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

NOTE: Each correct selection is worth one point.

What should you use to automatically delete blobs from Azure Blob Storage?

A.

soft delete

B.

archive storage

C.

the change feed

D.

a lifecycle management policy

Select the answer that correctly completes the sentence.

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.

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

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

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.

You have a banking application that transfers money in to and out of accounts.

Of which type of solution is this is an example?

A.

extract transform, and load (ETL)

B.

a data warehouse

C.

online analytical processing (OLAP)

D.

online transaction processing (OLTP)

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.