IBM C2090-719 - InfoSphere Warehouse V9.5 Exam

Page:    1 / 19   
Total 93 questions

Customer Relationship Management (CRM) requires business insights that enable firms to offer specific, personalized services, and products to their customers. Which mining method is used for customer segmentation CRM applications?

  • A. Association
  • B. Sequencing
  • C. Regression
  • D. Clustering


Answer : D

Your company's business analysts want to analyze ERP data with an OLAP tool. You have decided to build a data warehouse and use Cubing Services to create a cube that the tool will access. What is the process to build the data warehouse from the ERP database and then create the cube?

  • A. Create a Data Warehouse project to build the data warehouse; create the OLAP metadata andthe cube from the data warehouse.
  • B. Create an OLAP project to build the data warehouse; create the OLAP metadata and the cube.
  • C. Create a Data Warehouse project to create the data warehouse and an OLAP project; create the OLAP metadata and the cube from the data warehouse.
  • D. Create a Data Development project to create the data warehouse; create the OLAP metadata and the cube from the data warehouse.


Answer : C

You are debugging a SQL Warehousing Tool object. Which object requires that you generate an execution plan graph (EPG) in order to debug it?

  • A. data flow
  • B. control flow
  • C. subprocess
  • D. SQL flow


Answer : A

Click the Exhibit button.
In the exhibit, three workloads are created in the order shown from the specified DDL. You are a member of the FINANCE group, you submit a COGNOS job and your DB2 role is
MANAGER.
To which workload will your work activity be assigned?


  • A. the default workload
  • B. RPTG
  • C. RPTGR
  • D. RPT


Answer : B

You would like to change the value of a variable when deploying a warehouse application in the Admin Console. To which phase should a variable be set?

  • A. DESIGN_TIME, DEPLOYMENT_PREP, or DEPLOYMENT
  • B. DEPLOYMENT, EXECUTION, or RUNTIME_INSTANCE
  • C. RUNTIME, DESIGN_TIME, or DEPLOYMENT
  • D. DEPLOYMENT, RUNTIME, or EXECUTION_INSTANCE


Answer : D

Page:    1 / 19   
Total 93 questions