A physical database is used to create the model for the data warehouse. The original database has no referential integrity defined. You have defined the primary key for each table using Design Studio. Which process will define the foreign key constraints?

• A. Click on the "Fact" table and under the "Columns" tab of the "Properties" view, define the Foreign keys.
• B. Click on each foreign key column of the Fact table and under the "Advanced" tab of the
  "Properties" view, define the Foreign key.
• C. Click on the "Line" object on the palette and draw lines from the Fact table to the dimension tables.
• D. Click on a blank space on the editor canvas and select "Show Implicit Relationships".

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.

You manage a store and want to increase the sales of some high profit items. One way to do this is by placing these items close to other products that are often purchased with the high profit items.
You have a year's history of all sales, including all the items that were purchased in each sale. To determine optimal product placement for the high profit items, which mining method should be used to analyze your data?

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

A customer wants to evaluate deep data compression in an AIX development environment.
Which edition of InfoSphere Warehouse should they buy?

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

In which two modes can you create mining flows? (Choose two.)

• A. You can work in offline mode only if the Design Studio is connected to a database.
• B. You can work in real time mode only if the Design Studio is connected to a data model.
• C. You can work in real time mode only if the Design Studio is connected to a database.
• D. You can work in online mode only if the Design Studio is connected to a database.
• E. You can work in offline mode only if the Design Studio is connected to a data model.