Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

SQL/Database question: Which of the following is not a reason why OLTP systems f

ID: 3576920 • Letter: S

Question

SQL/Database question:

Which of the following is not a reason why OLTP systems fall short when used for decision-support purposes?

Long chains of joins may queries difficult to formulate.

Aggregating over time (e.g. by quarter, by year) is difficult.

OLTP systems do not perform well on high volumes of transactions.

Data are not represented in a way that matches the way managers think about their data.

A.

Long chains of joins may queries difficult to formulate.

B.

Aggregating over time (e.g. by quarter, by year) is difficult.

C.

OLTP systems do not perform well on high volumes of transactions.

D.

Data are not represented in a way that matches the way managers think about their data.

Explanation / Answer

Answer:

D)Data are not represented in a way that matches the way managers think about their data