IBM InfoSphere Warehouse V9.5 - C2090-719 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

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

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

Discussion 0

Correct Answer: D Vote an answer

Question 2

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 data model. B. You can work in offline mode only if the Design Studio is connected to a database. C. You can work in online mode only if the Design Studio is connected to a database. D. You can work in real time mode only if the Design Studio is connected to a data model. E. You can work in real time mode only if the Design Studio is connected to a database.

Discussion 0

Correct Answer: A,C Vote an answer

Question 3

Which two InfoSphere Warehouse components are included in the logical group for the Application Server? (Choose two.)

A. IBM Data Server Client B. Intelligent Miner Visualization C. WebSphere Application Server D. Design Studio E. Workload Management plug-in

Discussion 0

Correct Answer: A,C Vote an answer

Question 4

An administrator has three data flows that will run for different lengths of time. All data flows must be completed before the next step in the control flow can be initiated. Due to an overlap in the data, they cannot be run in parallel. As each data flow completes successfully, a status file is created. What can be used within the control flow to perform a wait for all three data flows to complete?

A. Use a File Wait operator that checks for all three status files to be updated. B. Use a Parallel Container with three File Wait operators that check that the status files do not exist. C. Use a File Wait operator with three input ports that checks for the existence of the status files. D. Use a Parallel Container with three File Wait operators that check for the existence of the status files.

Discussion 0

Correct Answer: D Vote an answer

Question 5

What is meant by "Information as a Service"?

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

Discussion 0

Correct Answer: C Vote an answer

Question 6

A high-quality physical database design is one that meets which two goals? (Choose two.)

A. Improves the efficiency of database management. B. Creates design features that optimizes query performance regardless of impact on maintenance operations. C. Compresses the data. D. Minimizes the need for database backups. E. Minimizes I/O.

Discussion 0

Correct Answer: A,E Vote an answer

Question 7

You want an employee to be able to create, deploy, and schedule applications in the InfoSphere Warehouse. At a minimum, which roles should be assigned to the employee?

A. Administrator and Operator B. Manager and Operator C. Administrator and Manager D. Administrator, Manager, and Power User

Discussion 0

Correct Answer: C Vote an answer

Question 8

Which type of information extraction for text analytics is defined using Java regular expressions?

A. rule-based B. list-based C. expression-based D. dictionary-based

Discussion 0

Correct Answer: A Vote an answer

Question 9

Which two functions can the SQW tool perform for a data flow? (Choose two.)

A. parallel process execution B. business processes such as secure command and secure FTP C. range partitioning for staging tables D. operators for row compression, roll-in, and roll-out E. filtering and sorting for operator properties such as table columns

Discussion 0

Correct Answer: C,E Vote an answer

Question 10

What is the reason for creating a subprocess?

A. to make a data flow easier to understand B. to order data flows that will run in parallel C. to allow the subprocess to be re-used as needed in other control flows and ubprocesses D. to improve the performance of a control flow

Discussion 0

Correct Answer: C Vote an answer