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: 41

What are two benefits for using an Eclipse-based tool such as Design Studio? (Choose two.)

  1. A broad selection of third-party tools that have already been developed and are available to be installed.

  2. A basic architecture for which tool developers must write numerous services.

  3. A proprietary framework that is used to integrate tools together quickly.

  4. A rich, inclusive, infrastructure for which tool developers must only develop a help system.

  5. A rich infrastructure including such components as a runtime environment, a generic user interface, and a help system.

Answer: A,E

Question No: 42

A cube has been deployed to cubing services. Due to an increase in the workload accessing the cube, response time has increased. What would allow you to apply additional resources (memory, CPU) to decrease the response time?

  1. Copy the star schema to another database and deploy the cube to both databases in which the star schemas reside.

  2. Add the cube to two different cube servers that are each connected to the same repository.

  3. Duplicate the star schema in the same database by copying the data to additional tables and the associate the cube with both star schemas.

  4. Add the cube twice to the same cube server.

Answer: B

Question No: 43

For recovery purposes, it is desired to keep the output of several data flow operators after the execution has ended. This can be done in two different ways. Which two types of operators and properties would you use to keep the output? (Choose two.)

  1. A Data Station operator with a type of file and a file name.

  2. A Data Station operator with a type of view and a view name.

  3. A Data Station operator with a type of persistent table and a table name.

  4. A Data Station operator with a type of temporary table and a table name.

  5. A Data Station operator defined as pass through.

Answer: A,C

Question No: 44

Using InfoSphere Warehouse a physical data model provides the metadata for database objects that are useful for which task?

  1. when designing process flows

  2. when designing work flows

  3. when designing remote flows

  4. when designing data flows

Answer: D

Question No: 45

Your warehouse schema is a snowflake design that has two dimension tables with outboard tables and a third dimension table without an outboard table. Five data flows have been created to load these tables. In your control flow, how would you efficiently process these loads?

  1. Use one parallel container for all five data flows.

  2. Use one parallel container for the outboard tablesquot; data flows which feeds a second parallel container for the three dimension table loads.

  3. Use one parallel container for the three dimension tablesquot; data flows which feeds a second parallel container for the two outboard table loads.

  4. Use one parallel container which contains a parallel container for the outboard tables and a parallel container for the three data loads.

Answer: B

Question No: 46

Certain operators cannot be placed directly into a parallel container. Some of these operators are iterators, variable comparisons, and parallel containers. Which technique

could you use to overcome this restriction?

  1. Place them first in a data flow and then place the data flow in the parallel container.

  2. Place them first in a subflow and then place the subflow in the parallel container.

  3. Place them first in a control flow and then place the control flow in the parallel container.

  4. Place them first in a subprocess and then place the subprocess in the parallel container.

Answer: D

Question No: 47

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

  1. IBM Data Server Client

  2. Intelligent Miner Visualization

  3. WebSphere Application Server

  4. Workload Management plug-in

  5. Design Studio

Answer: A,C

Question No: 48

A customer is having performance issues with a query against a cube they built using Cube Services. Examination of EXPLAIN output determines that the query did not usethe MQTs (summary tables). Which situation would cause the Optimizer to bypass the MQTs?

  1. The query contains functions on the attributes contained in the cube.

  2. The query accesses data that is above the cube slice in the summary table.

  3. The query accesses data that is below the cube slice in the summary table.

  4. The query contains measures which are not included in the cube model but can be calculated from the data in the rows.

Answer: C

Question No: 49

An XML file that contains cube model and cube metadata is imported into the Design

Studio which is connected to the cubing services repository. Which statement is true regarding adding the cube to a cube server?

  1. Do nothing, the cube was defined in the repository when the XML file was imported into theDesign Studio.

  2. Export the cube model metadata out of the Design Studio and import it into the cube server.

  3. Choose to deploy the cube directly from the Design Studio.

  4. Export the cube model metadata out of the Design Studio and import it into the database that contains the star schema.

Answer: A

Question No: 50

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?

  1. Click on the quot;Factquot; table and under the quot;Columnsquot; tab of the quot;Propertiesquot; view, define the Foreign keys.

  2. Click on the quot;Linequot; object on the palette and draw lines from the Fact table to the dimension tables.

  3. Click on each foreign key column of the Fact table and under the quot;Advancedquot; tab of the quot;Propertiesquot; view, define the Foreign key.

  4. Click on a blank space on the editor canvas and select quot;Show Implicit Relationshipsquot;.

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.