← Back to exam page

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

Loading demo links...

Showing 7–9 of 10 questions

Question 7 (Volume A)

Columns in a table may be zonemapped. How are those columns chosen?

Select an option, then click Submit answer.

  • ○

    They are automatically selected by the system.
  • ○

    They are based on the same columns as the table's distribution key.
  • ○

    They are added via the ALTER TABLE ADD INDEX(column_name) statement.
  • ○

    They are added via the ALTER TABLE ADD ZONEMAP(column_name) statement.
Question 8 (Volume A)

If 'admin' user is running a query, what percentage of resources are available when Guaranteed Resource Allocation (GRA) is Enabled?

Select an option, then click Submit answer.

  • ○

    The maximum GRA assigned to the ADMIN group.
  • ○

    The maximum GRA assigned to the PUBLIC group.
  • ○

    100% of the resources while other resource groups are active.
  • ○

    Typically half of the resources while other resource groups are active.
Question 9 (Volume B)

The simplest query execution plan file must have the following minimum nodes?

Select an option, then click Submit answer.

  • ○

    ScanNode, RestrictNode, LimitNode, ReturnNode
  • ○

    ScanNode, RestrictNode, HashNode, ReturnNode
  • ○

    ScanNode, RestrictNode, ProjectNode, ReturnNode
  • ○

    ScanNode, RestrictNode, AggregateNode, ReturnNode