Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released C2090-719
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-719.html

InfoSphere Warehouse V9.5

Question No: 11

Several operators are defined and linked together in DataFlow1. Another set of operators make up DataFlow2. A control flow is defined and both DataFlow1 and DataFlow2 areused. You require that DataFlow1 dynamically change the variable values used in DataFlow2.

How can you fulfill this requirement?

  1. The inherent design of the SQL Warehouse Tool is that any variable value changed in one data flow is accessible by any other data flow as long as the data flows are defined in the same warehouse project.

  2. Using the File Export operator, DataFlow1 writes a file that contains updated variable values. DataFlow2 accesses those updated variable values by reading that same file using an Import File operator.

  3. When a control flow is executed, a run profile provides the initial values for all variables. Once those values are set in the run profile, they are in affect for the entire execution of the control flow.

  4. Using the File Export operator, DataFlow1 writes a file, containing updated variable values. A variable assignment operator is then used to assign the values in the file to the appropriate variables. DataFlow2 then has access to the updated variable values.

Answer: D

Question No: 12

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?

  1. Use a File Wait operator with three input ports that checks for the existence of the status files.

  2. Use a File Wait operator that checks for all three status files to be updated.

  3. Use a Parallel Container with three File Wait operators that check for the existence of the status files.

  4. Use a Parallel Container with three File Wait operators that check that the status files do not exist.

Answer: C

Question No: 13

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?

  1. Administrator and Manager

  2. Manager and Operator

  3. Administrator and Operator

  4. Administrator, Manager, and Power User

Answer: A

Question No: 14

What is a benefit of using warehouse based analytics?

  1. It provides more functions in the available calculation set.

  2. It ensures the user response time will always be fast.

  3. It provides end users the ability to add additional calculations at report time.

  4. It provides a common pool of analytic methods to produce consistent answers across all users.

Answer: D

Question No: 15

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

  1. list-based

  2. rule-based

  3. dictionary-based

  4. expression-based

Answer: B

Question No: 16

The administrator has created a data flow that contains a fact table to a dimension table join. Which operators will allow for inserting the output into a permanent database table?

  1. Add a Table Target operator and give the target a table name for output.

  2. Add a Data Station operator and select create suitable table on the output port.

  3. Add a File Export operator and write the data to a file; add a Table Target to load the exported data.

  4. Add a Custom SQL operator and a Table Target operator and connect the output of the Custom SQL to the input of the Table Target.

Answer: B

Question No: 17

In a control flow, the Start operator has an on-failure port. When are any operators linked to that port executed?

  1. If there is an error starting the control flow.

  2. At the end of a control flow, if there were any on-failure actions processed by any control flow operators.

  3. Each time an on-failure action is processed by a control flow operator.

  4. Only after designated control flow operators process on-failure actions.

Answer: B

Question No: 18

Which two functions can the Design Studio perform? (Choose two.)

  1. Run the Optimization Advisor and analyze whether the recommended MQTs will be used given a predefined workload.

  2. Drop cube models from the InfoSphere Warehouse metadata database.

  3. Move and transform data.

  4. Rebuild an OLAP cube#39;s member cache.

  5. Add an OLAP cube to the cube server.

Answer: B,C

Question No: 19

During which installation and configuration process can user groups be mapped to each role?

  1. the installation of InfoSphere Warehouse Server for the Administration node

  2. the installation of InfoSphere Warehouse Server for Data node

  3. the installation of WebSphere Application Server

  4. the execution of the InfoSphere Warehouse Configuration Tool

Answer: D

Question No: 20

When using the Design Studio to define hierarchies for a cube model, you specify the hierarchy type and deployment method. If you were to specify a hierarchy type of quot;balancedquot; and a deployment of quot;standardquot;, what would that imply?

  1. The levels in the hierarchy have a consistent parent-child relationship and levels are logically inconsistent. The data used to define EACH level for a specific branch of the hierarchy is found in a single row in the dimension table.

  2. The levels in the hierarchy have a consistent parent-child relationship and levels are logically inconsistent. The data used to define the members of ALL of the levels for a specific branch of the hierarchy is found in a single row in the dimension table.

  3. The levels in the hierarchy have associated meaning, branches have consistent depth and the parent of any member is found in the level above. The data used to define EACH level for a specific branch of the hierarchy is found in a single row in the dimension table.

  4. The levels in the hierarchy have associated meaning, branches have consistent depth andtheparent of any member is found in the level above. The data used to define the members of ALL of the levels for a specific branch of the hierarchy is found in a single row in the dimension table.

Answer: D

100% Ensurepass Free Download!
Download Free Demo:C2090-719 Demo PDF
100% Ensurepass Free Guaranteed!
C2090-719 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.