InfoSphere Warehouse V9.5 v3.0 (C2090-719)

Page:    1 / 7   
Total 102 questions

What is meant by "Information as a Service"?

  • A. expanding a traditional data warehouse with XML capabilities for the data
  • B. extending the traditional data warehouse by providing business context layers to the data
  • C. accessing a traditional data warehouse with a Web-based application for the data
  • D. storing all analytical data in a multidimensional cube instead of a traditional data warehouse


Answer : B

A new data mart or star schema has been physically designed in a data modeling tool by someone in the team, and the SQW developer wants to use that model to design some data flows. Which data modeling tool is supported by the Data Model Import Wizard of
Design Studio?

  • A. ERwin
  • B. Oracle Designer
  • C. ModelRight
  • D. ER/Studio


Answer : A

What are three valid control flow components?

  • A. stored procedures, triggers, subprocess
  • B. process flow, subflow, flow charts
  • C. sources, transformers, targets
  • D. operators, variables, connections


Answer : D

When debugging a data flow, how do you set a break point in the execution plan graph
(EPG)?

  • A. Select Toggle Breakpoint on a node.
  • B. Select Set Breakpoint on a node.
  • C. Select Toggle Breakpoint on a connector.
  • D. Select Set Breakpoint on a connector.


Answer : A

A logical data model was created in a design tool. It is needed as a reference for a datawarehouse project. How can the logical model be used within Design Studio to create a database model?

  • A. The logical model objects can be reverse engineered directly into the Design Studio.
  • B. The logical data model objects can be imported into Design Studio using the Data Model Import Wizard.
  • C. Use the design tool to create a DDL file then use Design Studio to reverse engineer the model from the DDL file.
  • D. The logical data model objects can be exported into metadata format which can be imported into Design Studio using the Data Model Import Wizard.


Answer : C

A customer needs to merge unstructured repositories with a traditional data mining solution for a production environment. Which edition of InfoSphere Warehouse should they buy?

  • A. InfoSphere Warehouse Base
  • B. InfoSphere Warehouse Intermediate
  • C. InfoSphere Warehouse Enterprise
  • D. InfoSphere Warehouse Developer


Answer : C

You have an existing database that has referential integrity defined between the fact and dimension tables. What would the OLAP Quick Start wizard do in this scenario?

  • A. Detects corresponding dimensions after the fact table is specified.
  • B. Detects corresponding dimensions and levels after the fact table is specified.
  • C. Detects corresponding dimensions and hierarchies after the fact table is specified.
  • D. Detects corresponding dimensions, hierarchies, and levels after the fact table is specified.


Answer : A

Which two statements correctly describe the anatomy of a SQW flow? (Choose two.)

  • A. When connecting a Table Source operator to a Distinct operator, these operators can connect at both operator-level and column-level.
  • B. A data flow can have one or more Data Flow operators and each operator can have one or more input and output ports.
  • C. A control flow can have multiple Start and End operators; the Start operator has three exit ports and the End operator has one entry port.
  • D. In a data flow, the output port of a transform operator can be directed to the input port of another transform operator.
  • E. The anatomy of a data flow and control flow have the same functions.


Answer : A,D

A warehouse application contains a process that in turn contains an activity that references a variable with a final phase of EXECUTION_INSTANCE. When going through the schedule wizard, which object is actually scheduled?

  • A. the process
  • B. the activity
  • C. a process profile
  • D. the warehouse application


Answer : C

An analyst wants to be able to see the Store hierarchy as of the date the report was run.
The data is to be exported to a file with the execution date as part of the file name. A data flow is created using an Export To File operator. What should be entered on the Properties tab of this operator to create the file names each time the report is run without having to edit the data flow each time it is executed?

  • A. Enter the current date as part of the filename.
  • B. Enter the Date variable from the RESERVED variable group.
  • C. Enter the reserved word "CURRENT_DATE" as part of the filename.
  • D. Create a Date variable in a new or existing variable group. Enter the new variable name as part of the filename.


Answer : B

What does a Data Design Project within Design Studio contain?

  • A. physical data model
  • B. SQW work flows
  • C. data mining flows
  • D. logical data model


Answer : A

You have used the Optimization Advisor of cubing services to suggest MQTs based upon a cube model and the data in the star schema. You would now like to see if the DB2 Design
Advisor might suggest alternative MQTs.
How can you accomplish this?

  • A. Pass the MDX queries used by the applications that will benefit from the MQTs to the DB2 Design Advisor.
  • B. In the Admin Console, choose to manage OLAP metadata; select the Summary Table Usage pushbutton; specify to pass the results to the DB2 Design Advisor.
  • C. After having invoked the Optimization Advisor from the Design Studio, export the generated metadata and pass that to the DB2 Design Advisor.
  • D. Use the SQL log generated by the cube server to find the generated SQL statements to be passed to the DB2 Design Advisor.


Answer : D

What are two primary goals of denormalization? (Choose two.)

  • A. to allow for data compression
  • B. to decrease the redundancy of data within a database
  • C. to increase the number of tables in the model
  • D. to improve performance of a system
  • E. to simplify the querying of the database


Answer : D,E

An administrator has created a database connection to the Production transactional relational database. A data mart is desired that extracts data from that database. Taking time and ease into account, how should the database physical model for the input tables be created?

  • A. The physical database objects can be imported into Design Studio.
  • B. The physical data model must be converted to a logical data model which can be imported intoDesign Studio.
  • C. The physical database must be used to create DDL which is then reverse engineered in Design Studio.
  • D. The physical database objects can be reverse engineered in Design Studio.


Answer : D

Input variables allow variable values to be passed to data flows, mining flows and subprocesses. What supports output variables?

  • A. data flows
  • B. mining flows
  • C. subprocesses
  • D. subflows


Answer : C

Page:    1 / 7   
Total 102 questions