최신 IBM certifications I C2090-719 무료샘플문제:

1. You need to join three tables together in a data flow. The Table Join operator is placed onto thework area and only has two input ports defined. Which technique should you use to join the three tables?

A) Use the Table Join operator to join two of the tables and then use the properties view to change the generated SQL.
B) Use the Table Join operator to join two of the tables and then use a second Table Joinoperator to outer join the third.
C) Add an additional input port to the Table Join operator.
D) Use the SQL Merge operator to join all three tables.

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

A) to delete the files on the file system that are holding the member cache data
B) to empty the member cache for a cube
C) to populate the member cache using a specified MDX query
D) to rebuild a cube member cache

3. Which statement is true about iterator operators?

A) They are used in data flows where a number of tables are combined.
B) They are used as the first step in application development.
C) They can be controlled by either variable values or file input.
D) They are needed for processing tables that contain slowly changing dimensions.

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

A) InfoSphere Warehouse Developer
B) InfoSphere Warehouse Base
C) InfoSphere Warehouse Intermediate
D) InfoSphere Warehouse Advanced

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

A) MOLAP
B) ROLAP
C) Multidimensional cubing
D) Proprietary

질문과 대답: