Exam DP-900 topic 1 question 227 discussion

Actual exam question from Microsoft's DP-900

Question #: 227
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.

Show Suggested Answer

Suggested Answer:

by StressFree at Jan. 31, 2023, 9:31 a.m.

Comments

Submit Cancel

StressFree

Highly Voted 1 year, 10 months ago

Agree ETL https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl Fact table https://www.techtarget.com/searchdatamanagement/definition/fact-table#:~:text=A%20fact%20table%20stores%20quantitative,fact%20table%20can%20be%20analyzed. DW https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/data-warehousing

upvoted 17 times

...

AGTraining

Most Recent 9 months ago

Etl Fact table Dw

upvoted 2 times

...

takusui

1 year, 4 months ago

I think the correct answer is actually: Online analytical processing (OLAP). See first figure here: https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-analytical-processing Fact tables Data warehouses Otherwise, can someone explain to me why it is ETL instead of OLAP? It clearly says that it's taking data from files and OLTP, and sends it to an analytical processing system.

upvoted 2 times

Yomzie

9 months, 2 weeks ago

The question says, "A solution that copies data from..." meaning there is an EXTRACTION, then TRANSFORMATION of the OLTP and flat-file data, after which the data is LOADED into an Analytical System. OLAP is not a solution, it is a WORKLOAD type (e.g.: transactional workload, analytical workload, batch workload, streaming workload)

upvoted 4 times

...