IBM InfoSphere Warehouse V9.5 認定 C2090-719 試験問題:
1. The Optimization Advisor has been run and scripts created and saved. In addition to create statements for MQTs (summary tables), the scripts might contain commands for which two choices? (Choose two.)
A) create statements for indexes on the MQTs
B) create statements for indexes on the fact table
C) runstats for the MQTs
D) recommendations for database partitioning
E) create statements for MDCs (Multi-dimensional clustered indexes)
2. Click the Exhibit button.
Referring to the exhibit, control flow operators can be grouped as subprocesses. Control flows are grouped into warehouse applications. Warehouse applications are deployed to the Admin Console. Once a warehouse application has been deployed, the names of the objects that make up the warehouse application change. Within the Admin Console what is the highest level object that can be scheduled?
A) a process
B) an activity
C) a subprocess
D) a deployed application
3. 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) In the Cubing Services SQL log, look at the SQL queries generated and see if any are accessing your MQTs.
B) 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.
C) 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.
D) Invoke the Summary Table Usage facility in the Admin Console.
4. Which tool should be used to design a mining flow?
A) Use the data flow editor to populate a new data mart from normalized tables in your warehouse or from external sources like flat files.
B) Use the data flow editor to build the mining data mart.
C) Use the data model editor to build the mining data mart.
D) Use the mining editor to analyze existing data for the mining specific tasks in a production database.
5. Your company's business analysts want to analyze ERP data with an OLAP tool. You have decided to build a data warehouse and use Cubing Services to create a cube that the tool will access. What is the process to build the data warehouse from the ERP database and then create the cube?
A) Create a Data Development project to create the data warehouse; create the OLAP metadata and the cube from the data warehouse.
B) Create a Data Warehouse project to create the data warehouse and an OLAP project; create the OLAP metadata and the cube from the data warehouse.
C) Create an OLAP project to build the data warehouse; create the OLAP metadata and the cube.
D) Create a Data Warehouse project to build the data warehouse; create the OLAP metadata andthe cube from the data warehouse.
質問と回答：
| 質問 # 1 正解： A、C | 質問 # 2 正解： A | 質問 # 3 正解： D | 質問 # 4 正解： D | 質問 # 5 正解： B |
1279 お客様のコメント
品質保証JPexamはIT認定試験のシラバスに従って、試験問題の範囲を正確に絞って、的中率が99％の最新問題集を捧げます。
1年間の無料更新サービスJPexamは1年以内に問題集の無料更新サービスを提供し、お客様がいつでも最新版の問題集を持つことを保証いたします。もし試験の内容が変更されたら、弊社は直ちにお客様にお知らせします。それに、弊社の問題集が更新されたら、早速メールで最新バージョンを送付いたします。
全額返金JPexamの問題集を利用すると、短時間で勉強しても試験に合格できるのを保証いたします。試験に不合格になってしまった場合、弊社は全額返金いたします。(
ご購入前のお試しJPexamは問題集のサンプルを無料で提供いたします。ご購入前にサンプルを試用して製品の品質を確認することができます。ご遠慮なく利用してください。
