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

In a three node configuration, which two servers can contain InfoSphere Warehouse Intelligent Miner components? (Choose two.)

  1. Data Server

  2. Mining Server

  3. Client

  4. Web Server

  5. WebSphere Administration Server

Answer: A,C

Question No: 32

What is the reason for creating a subprocess?

  1. to make a data flow easier to understand

  2. to improve the performance of a control flow

  3. to allow the subprocess to be re-used as needed in other control flows and ubprocesses

  4. to order data flows that will run in parallel

Answer: C

Question No: 33

Relational database and a database model that is often a star or snowflake schema are characteristics of which engine storage structure?

  1. MOLAP

  2. ROLAP

  3. Multidimensional cubing

  4. Proprietary

Answer: B

Question No: 34

Which statement is true about iterator operators?

  1. They can be controlled by either variable values or file input.

  2. They are used in data flows where a number of tables are combined.

  3. They are needed for processing tables that contain slowly changing dimensions.

  4. They are used as the first step in application development.

Answer: A

Question No: 35

You can use the Admin Console to add, remove, start, stop, or restart cubes. For which other purpose can the Admin Console be used?

  1. to rebuild a cube member cache

  2. to empty the member cache for a cube

  3. to populate the member cache using a specified MDX query

  4. to delete the files on the file system that are holding the member cache data

Answer: A

Question No: 36

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

  1. business processes such as secure command and secure FTP

  2. range partitioning for staging tables

  3. filtering and sorting for operator properties such as table columns

  4. operators for row compression, roll-in, and roll-out

  5. parallel process execution

Answer: B,C

Question No: 37

Click the Exhibit button.

The diagram in the exhibit illustrates which SQW flows? (Choose two.)

Ensurepass 2018 PDF and VCE

  1. data flow

  2. mining flow

  3. control flow

  4. subprocess

  5. subflow

Answer: B,E

Question No: 38

A customer adds transactional data daily and rolls off historical transactional data monthly to archive. Which partitioning strategy should they use to accomplish this time-cyclical data management for their warehouse data?

  1. Specify a MDC for month and a table partitioning key for day.

  2. Specify database partitioning on day and a table partitioning key for month.

  3. Specify database partitioning on month and a table partitioning key for day.

  4. Specify a MDC on day and a table partitioning key for month.

Answer: D

Question No: 39

A customer wants to include analysis of product sales for their locations at various levels of their product lines and various levels of their geography. Which two schema considerations are necessary to satisfy the requirement? (Choose two.)

  1. a product dimension with location attributes

  2. a product dimension with product line hierarchies

  3. a location dimension with product attributes

  4. a location dimension with geography hierarchies

  5. a product dimension with geography hierarchies

Answer: B,D

Question No: 40

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

  1. rule-based

  2. list-based

  3. regular expression

  4. natural language processing

Answer: B

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.