What is meant by "Information as a Service"?
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?
Answer : A
What are three valid control flow components?
Answer : D
When debugging a data flow, how do you set a break point in the execution plan graph
(EPG)?
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?
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?
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?
Answer : A
Which two statements correctly describe the anatomy of a SQW flow? (Choose two.)
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?
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?
Answer : B
What does a Data Design Project within Design Studio contain?
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?
Answer : D
What are two primary goals of denormalization? (Choose two.)
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?
Answer : D