IBM ISW-9.7 & Smart Analytics Technical Mastery Test v1 (P2090-080) Free Practice Test

Question 1

What are the steps required before a Calculated Measure canbe used in an OLAP cube?

A. Add the new measure to the Fact Table in the database.

B. Add the new measure to the cube modeland then add it to the cube.

C. Add the new measure to the cube and then add it to the cube model.

D. Add the new measure to the Fact Table in the data model.

Correct Answer: B

Question 2

The Workload Management component of InfoSphere Warehouse 9.7 provides _________________.

A. control of individual database activities

B. All of the above

C. control of concurrency of database activities

D. fine grained, light weight monitoring of database activities

Correct Answer: B

Question 3

What steps are needed to create a parallel set of table load operations from already created data flows?

A. Put all the data flows into one data station and create a control flow.

B. Open a control flow and move a parallel process to a blank space in the flow; then drag the desired data flow operators into the parallel operator.

C. Open a data flow and move a parallel process to a blank space in the flow; then drag thedesired data flow operators into the parallel operator.

D. Open a control flow and place all of the dataflows on the canvas; connect the 'success' port of the preceding step to all of the data flows.

Correct Answer: B

Question 4

Which componentof DB2 9.7 is included in the InfoSphere Warehouse Enterprise Edition but NOT in the other Editions?

A. Data Partitioning Feature

B. Design Studio

C. Deep Compression

D. Cubing Services

Correct Answer: C

Question 5

Which trend is NOT causing data warehousing market expansion?

A. Growth in complexity of questions

B. Growth of data volumes

C. Faster OLTP response time

D. Shrinking of turnaround time requirements

Correct Answer: C

Welcome to TestSimulate

IBM ISW-9.7 & Smart Analytics Technical Mastery Test v1 (P2090-080) Free Practice Test