C2090-719 試験問題を無料オンラインアクセス

As a system administrator, you have defined a cube server, specifying that all cubes are to start automatically, and added a cube to that server. You created a script to start the cube server from the command line. Wanting to make sure that your users have good performance, you want the members of your cube to be cached prior to the first user's access of the cube. What will allow you to accomplish this?

• A.Just execute the cube server startup script.
• B.Add to the cube server startup script a member seed query for the cube.
• C.Use the Admin Console and specify the execution of an MDX seed query when the cube starts.
• D.Use the Admin Console and specify the execution of a member seed query when the cube starts.

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?

• A.Administrator, Manager, and Power User
• B.Administrator and Manager
• C.Administrator and Operator
• D.Manager and Operator

An administrator has created a database connection to the Production transactional relational database. A data mart is desired that extracts data from that database. Taking time and ease into account, how should the database physical model for the input tables be created?

• A.The physical database objects can be imported into Design Studio.
• B.The physical data model must be converted to a logical data model which can be imported intoDesign Studio.
• C.The physical database objects can be reverse engineered in Design Studio.
• D.The physical database must be used to create DDL which is then reverse engineered in Design Studio.

Several operators are defined and linked together in DataFlow1. Another set of operators make up DataFlow2. A control flow is defined and both DataFlow1 and DataFlow2 areused.
You require that DataFlow1 dynamically change the variable values used in DataFlow2.
How can you fulfill this requirement?

• A.When a control flow is executed, a run profile provides the initial values for all variables.
  Once those values are set in the run profile, they are in affect for the entire execution of the control flow.
• B.The inherent design of the SQL Warehouse Tool is that any variable value changed in one data flow is accessible by any other data flow as long as the data flows are defined in the same warehouse project.
• C.Using the File Export operator, DataFlow1 writes a file, containing updated variable values. A variable assignment operator is then used to assign the values in the file to the appropriate variables. DataFlow2 then has access to the updated variable values.
• D.Using the File Export operator, DataFlow1 writes a file that contains updated variable values. DataFlow2 accesses those updated variable values by reading that same file using an Import File operator.

During which installation and configuration process can user groups be mapped to each role?

• A.the installation of WebSphere Application Server
• B.the execution of the InfoSphere Warehouse Configuration Tool
• C.the installation of InfoSphere Warehouse Server for the Administration node
• D.the installation of InfoSphere Warehouse Server for Data node