IBM InfoSphere Warehouse V9.5

1.

What is meant by Information as a Service?

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

2.

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 balanced and a deployment of standard, what would that imply?

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. 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. The levels in the hierarchy have associated meaning, branches have consistent depth and the parent of anymember 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. The levels in the hierarchy have associated meaning, branches have consistent depth and the parent of anymember 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.

3.

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?

Administrator and Manager Manager and Operator Administrator and Operator Administrator, Manager, and Power User

4.

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

InfoSphere Warehouse Base InfoSphere Warehouse Intermediate InfoSphere Warehouse Advanced InfoSphere Warehouse Developer

5.

What is the Design Studio used for as part of Cubing Services?

to create OLAP metadata to start and stop a cube to create and modify a MDX seed query to rebuild a cube member cache

6.

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

Select Toggle Breakpoint on a node. Select Set Breakpoint on a node. Select Toggle Breakpoint on a connector. Select Set Breakpoint on a connector.

7.

Which data-mining operator can be used to create set-valued XML documents that can be processed by some of the mining algorithms?

Item Aggregator Dictionary Lookup Correlations Extractor Associations

8.

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?

Donothing, the cube was defined in the repository when the XML file was imported into theDesign Studio. Export the cube model metadata out of the Design Studio and import it into the cube server. Choose to deploy the cube directly from the Design Studio. Export the cube model metadata out of the Design Studio and import it into the database that contains thestar schema.

9.

For text analytics, the technique that uses a dictionary to do searching is known as which type of information extraction?

rule-based list-based regular expression natural language processing

10.

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?

Copy the star schema to another database and deploy the cube to both databases in which the star schemas reside. Add the cube to two different cube servers that are each connected to the same repository. Duplicate the star schema in the same database by copying the data to additional tables and the associatethe cube with both star schemas. Add the cube twice to the same cube server.

IBM InfoSphere Warehouse V9.5

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

IBM InfoSphere Warehouse V9.5

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner