Vendor: IBM
Exam Code: P2090-027
Exam Name: IBM InfoSphere Warehouse Technical Mastery Test v1
QUESTION 1
Which statement about data flows is true?
A. Data flows define the SQL-based data movement and transformation activities that run in a DB2 database.
B. Data flows define the processing logic that is required to run the applications.
C. Data flows operators have success and failure ports.
D. Data flows can have embedded control flows.
Answer: A
QUESTION 2
Which of the following data warehouse schemas cannot be modeled into a Cube Model object?
A. A non-star schema.
B. A star schema that contains a set of fact tables and a set of dimension tables that join the fact tables.
C. A star schema in which all attributes of a dimension are stored in a single dimension table.
D. A star schema in which some of the dimension attributes are stored in the same table where fact attributes are stored.
Answer: A
QUESTION 3
Customers who are looking for a customizable data warehouse solution with the ability to choose their software and hardware should consider:
A. IBM Netezza
B. IBM DB2
C. IBM Smart Analytics System
D. IBM InfoSphere Warehouse
Answer: D
QUESTION 4
The Unstructured Analysis component of InfoSphere Warehouse provides the ability to:
A. create an OLAP cube within the unstructured data.
B. use standard analysis tools to directly access unstructured data.
C. extract knowledge from unstructured data for use by standard analysis tools.
D. None of the above.
Answer: C
QUESTION 5
What is the output of the Cubing Services Optimization Advisor?
A. SQL scripts of MDC definitions which must be executed to take effect.
B. SQL scripts of MQT definitions which must be executed to take effect.
C. SQL scripts that optimize the queries being run against cubing services.
D. SQL scripts of cube definitions which create the cubes on the server.
Answer: B
Pass Your Exam On First Try Real IBM P2090-027 Exam Braindumps
