← Back to exam page

P2090-050 – IBM PureData System for Analytics Technical Mastery Test v1

Loading demo links...

Showing 1–3 of 10 questions

Question 1 (Volume B)

Given a plan ID, how would you obtain the query execution plan? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Turn ODBC tracing ON.
  • ○

    Issue "SELECT * FROM _V_SESSION;"
  • ○

    Go to the query history within the Windows NzAdmin GUI tool.
  • ○

    Run EXECUTION PLAN before the query has been submitted.
  • ○

    Issue "SHOW PLANFILE ;" after the query has been submitted.
Question 2 (Volume A)

In order to set a runaway query event to trigger when a query runs longer than two minutes, which two items must be configured? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    The runaway query event was enabled.
  • ○

    The pg.log file was configured for two minutes.
  • ○

    The runaway query event was configured for two minutes.
  • ○

    The nzsystem command was used to set the QUERYTIMEOUT to two minutes.
  • ○

    The CREATE USER command was used to set the QUERYTIMEOUT to two minutes.
Question 3 (Volume A)

Which two statements are true about queries on the PureData System for Analytics Appliance? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Queries are executed in parallel by the host.
  • ○

    Queries must be compressed before they can be executed.
  • ○

    Queries are compiled into snippets and executed in parallel by the S-Blades.
  • ○

    Queries must be uncompressed by the user and executed in parallel by the host.
  • ○

    A query is compiled into a snippet which is executed across all available S-Blades.