We're so confident of our products that we provide no hassle product exchange.
IBM InfoSphere Warehouse V9.5 Sample Questions:
1. You have generated the MQTs suggested by the Cubing Services Optimization Advisor.
How can you verify that the DB2 Optimizer is routing to those MQTs?
A) Extract the MDX queries from the Cubing Services MDX log and do an Explain of those queries. See if any of the queries are rewritten to access the MQTs.
B) Invoke the Summary Table Usage facility in the Admin Console.
C) In the Cubing Services SQL log, look at the SQL queries generated and see if any are accessing your MQTs.
D) Use the generated SQL from queries accessing the star schema as input to the DB2 Design Advisor; then compare the suggested MQTs with the MQTs suggested by the Cubing Services Optimization Advisor.
2. Which statement describes the conceptual data model?
A) The conceptual data model is a high-level business view of the data.
B) The conceptual data model is where the data model actually gets defined.
C) The conceptual data model includes the DDL file for the warehouse.
D) The conceptual data model contains the configuration, keys, indexes selected, and constraints.
3. You are implementing a DB2 Workload Manager (WLM) schema to limit the number of load utilities that can execute concurrently. Which WLM object would be used to accomplish this?
A) workload with an associated service class and an appropriate threshold
B) work class with an associated service class and an appropriate threshold
C) workload with an associated work action and an appropriate threshold
D) work class with an associated work action and an appropriate threshold
4. 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?
A) Click on the "Line" object on the palette and draw lines from the Fact table to the dimension tables.
B) Click on a blank space on the editor canvas and select "Show Implicit Relationships".
C) Click on the "Fact" table and under the "Columns" tab of the "Properties" view, define the Foreign keys.
D) Click on each foreign key column of the Fact table and under the "Advanced" tab of the
"Properties" view, define the Foreign key.
5. A logical data model was created in a design tool. It is needed as a reference for a datawarehouse project. How can the logical model be used within Design Studio to create a database model?
A) The logical data model objects can be imported into Design Studio using the Data Model Import Wizard.
B) Use the design tool to create a DDL file then use Design Studio to reverse engineer the model from the DDL file.
C) The logical model objects can be reverse engineered directly into the Design Studio.
D) The logical data model objects can be exported into metadata format which can be imported into Design Studio using the Data Model Import Wizard.
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: A | Question # 3 Answer: D | Question # 4 Answer: B | Question # 5 Answer: B |
By Eartha
