IBM C2090-719 - InfoSphere Warehouse V9.5 Exam
Page: 1 / 19
Total 93 questions
Question #1 (Topic: )
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?
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
Question #2 (Topic: )
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?
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
Question #3 (Topic: )
You are debugging a SQL Warehousing Tool object. Which object requires that you
generate an execution plan graph (EPG) in order to debug it?
generate an execution plan graph (EPG) in order to debug it?
A. data flow
B. control flow
C. subprocess
D. SQL flow
Answer: A
Question #4 (Topic: )
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?
[IBM-C2090-719-3.0/IBM-C2090-719-3_2.png]
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?
[IBM-C2090-719-3.0/IBM-C2090-719-3_2.png]
A. the default workload
B. RPTG
C. RPTGR
D. RPT
Answer: B
Question #5 (Topic: )
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?
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
