Microsoft DP-900 Exam - Topic 9 Question 29 Discussion

Actual exam question for Microsoft's DP-900 exam

Question #: 29
Topic #: 9

Your company has a reporting solution that has paginated reports. The reports query a dimensional model in a data warehouse. Which type of processing does the reporting solution use?

Astream processing

BOnline Transaction Processing (OLTP)

Cbatch processing

DOnline Analytical Processing (OLAP)

Show Suggested Answer

Suggested Answer: D

https://datawarehouseinfo.com/how-does-oltp-differ-from-olap-database/

by Laurel at May 04, 2022, 02:39 AM

Limited Time Offer

25%

Off

Get Premium DP-900 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Deeann

5 months ago

Batch processing is too slow for this kind of reporting!

upvoted 0 times

...

Bernardine

5 months ago

Wait, are we sure it's not stream processing?

upvoted 0 times

...

Merlyn

5 months ago

Agree, OLAP makes the most sense here!

upvoted 0 times

...

Scot

5 months ago

I think it's batch processing, right?

upvoted 0 times

...

Blondell

5 months ago

Definitely OLAP for querying dimensional models.

upvoted 0 times

...

Zana

5 months ago

I recall that paginated reports usually involve batch processing, but since we're querying a dimensional model, maybe it's OLAP?

upvoted 0 times

...

Santos

5 months ago

I'm a bit confused between batch processing and OLAP. I feel like both could apply, but I lean towards OLAP for reporting.

upvoted 0 times

...

Desire

5 months ago

I remember practicing a question about OLTP and OLAP, and I think OLAP is more suited for reporting solutions like this one.

upvoted 0 times

...

Jovita

5 months ago

I think this might be OLAP since it deals with analyzing data from a data warehouse, but I'm not completely sure.

upvoted 0 times

...

Rhea

6 months ago

Okay, let's see. Usability inspections are carried out by either users or experienced professionals, so I think the answer is C.

upvoted 0 times

...

Edmond

6 months ago

This question seems straightforward. I think the answer is C, Selecting sellers, since a weighting system is used to evaluate and select the best seller for a contract.

upvoted 0 times

...

Melinda

6 months ago

I'm a bit unsure if both statements are correct or just one. I feel like both make sense, but I can't recall for sure.

upvoted 0 times

...