최신IBM InfoSphere Warehouse V9.5 - C2090-719무료샘플문제
문제1
A customer is having performance issues with a query against a cube they built using Cube Services. Examination of EXPLAIN output determines that the query did not usethe MQTs (summary tables). Which situation would cause the Optimizer to bypass the MQTs?
A customer is having performance issues with a query against a cube they built using Cube Services. Examination of EXPLAIN output determines that the query did not usethe MQTs (summary tables). Which situation would cause the Optimizer to bypass the MQTs?
정답: D
문제2
When using the Design Studio to define hierarchies for a cube model, you specify the hierarchy type and deployment method. If you were to specify a hierarchy type of
"balanced" and a deployment of "standard", what would that imply?
When using the Design Studio to define hierarchies for a cube model, you specify the hierarchy type and deployment method. If you were to specify a hierarchy type of
"balanced" and a deployment of "standard", what would that imply?
정답: B
문제3
Which two tools should an InfoSphere Warehouse developer use to perform SQL Warehousing design tasks? (Choose two.)
Which two tools should an InfoSphere Warehouse developer use to perform SQL Warehousing design tasks? (Choose two.)
정답: D,E
문제4
You work for an automobile manufacturing company and have been asked to use data mining to determine which part is most likely to fail after a certain amount of time on a particular vehicle model. You have gathered repair history. Which mining method should be used?
You work for an automobile manufacturing company and have been asked to use data mining to determine which part is most likely to fail after a certain amount of time on a particular vehicle model. You have gathered repair history. Which mining method should be used?
정답: D
문제5
Which two statements are true about a hierarchies, levels, and dimensions? (Choose two.)
Which two statements are true about a hierarchies, levels, and dimensions? (Choose two.)
정답: B,D
문제6
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?
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?
정답: B
문제7
A customer wants to evaluate deep data compression in an AIX development environment.
Which edition of InfoSphere Warehouse should they buy?
A customer wants to evaluate deep data compression in an AIX development environment.
Which edition of InfoSphere Warehouse should they buy?
정답: A
문제8
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?
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?
정답: D
문제9
Which components are used to run a Cubing Services Server?
Which components are used to run a Cubing Services Server?
정답: C
문제10
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?
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?
정답: D