IBM C2090-311 Online Practice Questions and Exam Preparation

IBM C2090-311 Online Questions & Answers

• Question 11:

  Which two sources can be used to provide input to the InfoSphere Optim Query Workload Tuner that generate EXPLAIN information when creating the query workload?

  A. db2pd
  B. Routines
  C. EXPLAIN tables
  D. Snapshot monitor
  E. ACTIVITIES event monitors
  C. EXPLAIN tables
  D. Snapshot monitor

• Question 12:

  By default, the Optim Workload Table Organization Advisor will recommend converting row- organized tables to column-organized tables if it determines that the change will improve query performance, as a whole, by how much?

  A. 15 percent
  B. 20 percent
  C. 25 percent
  D. 30 percent
  B. 20 percent

• Question 13:

  Which type of compression is typically used with column-organized tables?

  A. BLU compression
  B. Value compression
  C. Actionable compression
  D. Adaptive row compression
  A. BLU compression

• Question 14:

  Which two HADR synchronization modes are supported in DB2 10.5 pureScale environments?

  A. SYNC
  B. ASYNC
  C. NEARSYNC
  D. SUPERSYNC
  E. SUPERASYNC
  B. ASYNC
  C. NEARSYNC

• Question 15:

  An expression-based index named EMPJND1 and a statistical view named EMP_IND1_V have been created for a table named EMPLOYEE.

  If the following command is used to set up a statistics profile on the statistical view EMP_IND1_V:

  RUNSTATS ON VIEW emp_ind1_v WITH DISTRIBUTION DEFAULT UM_FREQVALUES 50 SET PROFILE ONLY

  Which command will create a statistics profile on the EMPLOYEE table?

  A. RUNSTATS ON TABLE employee USE PROFILE
  B. RUNSTATS ON TABLE employee USE SAMPLED INDEX emp_ind1
  C. RUNSTATS ON TABLE employee WITH DISTRIBUTION AND SAMPLED DETAILED INDEXES ALL
  D. RUNSTATS ON TABLE employee WITH DISTRIBUTION AND SAMPLED INDEX emp_ind1 GENERATE PROFILE
  C. RUNSTATS ON TABLE employee WITH DISTRIBUTION AND SAMPLED DETAILED INDEXES ALL

• Question 16:

  What is a DB2 Advanced Copy Services (ACS) script used for?

  A. To install and configure DB2 Advanced Copy Services.
  B. To redirect Tivoli Storage FlashCopy Manager commands to DB2 Advanced Copy Services.
  C. To test the functionality of a DB2 ACS API vendor library without performing a snapshot backup or restore operation.
  D. To perform snapshot backup and restore operations on storage devices that do not have a DB2 ACS API vendor library.
  C. To test the functionality of a DB2 ACS API vendor library without performing a snapshot backup or restore operation.

• Question 17:

  Which command, when executed, will enable workload management for column-organized table workloads?

  A. db2setDB2_WORKLOAD=ANALYTICS
  B. db2set DB2_WLM_DISP_CONCUR=START
  C. UPDATE DBM CFG USING WLM_DISPATCHER YES
  D. UPDATE DBM CFG USING WORKLOAD TYPE ANALYTICAL
  C. UPDATE DBM CFG USING WLM_DISPATCHER YES

• Question 18:

  Which statement regarding NOT ENFORCED unique constraints is true?

  A. NOT ENFORCED unique constraints enforce uniqueness only for primary key columns.
  B. The query optimizer will consider a NOT ENFORCED unique constraint when selecting the optimal data access plan.
  C. Storage requirements for NOT ENFORCED unique constraints are identical to storage requirements for a unique index.
  D. When attempting to insert data that does not conform to the NOT ENFORCED unique constraint, an error will be returned and the record will not be inserted.
  A. NOT ENFORCED unique constraints enforce uniqueness only for primary key columns.

• Question 19:

  How is the Query Workload Tuner license installed and enabled?

  A. With Data Studio, using the license activation kit.
  B. By executing the db2licm command after data server installation.
  C. With the Optim Performance Manager Server, using the license activation kit.
  D. By running the Query Workload Tuner license activation command on the appropriate WebSphere server.
  A. With Data Studio, using the license activation kit.

• Question 20:

  If the DB2_WORKLOAD registry variable is set to ANALYTICS, what value will be assigned to the DFT_DEGREE database configuration parameter, by default?

  A. -1
  B. 1
  C. ON
  D. ANY
  A. -1