← Back to exam page

C2090-600 – IBM DB2 11.1 DBA for LUW

Loading demo links...

Showing 1–3 of 10 questions

Question 1

Which two of the following functions of DB2 Workload Manager are restricted by license? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Creating, using, or altering thresholds
  • ○

    Granting, altering, or revoking workload privileges
  • ○

    Using or altering the default service classes and workloads
  • ○

    Creating service classes, service subclasses, and workloads
  • ○

    Creating, activating, stopping or dropping workload management event monitors
Question 2

Which two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a DB2 database? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Catalog a storage access alias in the DB2 database
  • ○

    Create an FTP account on IBM Softlayer Object Storage
  • ○

    Use the DB2REMOTE parameter of the LOAD command
  • ○

    Establish a remote connection to IBM Softlayer Object Storage using DB2 Connect
  • ○

    Create a local disk alias at the database server operating system level that points to IBM Softlayer Object Storage
Question 3

When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    The PAGESIZE database configuration parameter is set to 32K.
  • ○

    The AUTO_REORG database configurationparameter is set to NO.
  • ○

    The DFT_EXTENT_SZ database configuration parameter is set to 8.
  • ○

    The DFT_TABLE_ORG database configuration parameter is set to COLUMN.
  • ○

    The INTRA_PARALLEL database manager configuration parameter is set to NO.