nerdexam
IBM

P2090-027 · Question #48

What is the output of the Cubing Services Optimization Advisor?

The correct answer is B. SQL scripts of MQT definitions which must be executed to take effect. See the full explanation below for the reasoning.

Question

What is the output of the Cubing Services Optimization Advisor?

Options

  • ASQL scripts of MDC definitions which must be executed to take effect.
  • BSQL scripts of MQT definitions which must be executed to take effect.
  • CSQL scripts that optimize the queries being run against cubing services.
  • DSQL scripts of cube definitions which create the cubes on the server.

How the community answered

(34 responses)
  • A
    18% (6)
  • B
    74% (25)
  • C
    6% (2)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full P2090-027 Practice