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 and Operator
B. Administrator, Manager, and Power User
C. Administrator and Manager
D. Manager and Operator
正解:C
質問 2:
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. work class with an associated service class and an appropriate threshold
B. workload with an associated work action and an appropriate threshold
C. workload with an associated service class and an appropriate threshold
D. work class with an associated work action and an appropriate threshold
正解:D
質問 3:
If you roll-in daily and roll-out monthly, which approach reduces the number of table partitions and eases the DBA administrative tasks?
A. Specify a MDC on day and a table partition key for month.
B. Specify a MDC on month and a table partition key for month.
C. Specify a MDC on day and a table partition key for day.
D. Specify a MDC on month and a table partition key for day.
正解:A
質問 4:
What does a Data Design Project within Design Studio contain?
A. data mining flows
B. logical data model
C. SQW work flows
D. physical data model
正解:D
質問 5:
An XML file that contains cube model and cube metadata is imported into the Design Studio which is connected to the cubing services repository. Which statement is true regarding adding the cube to a cube server?
A. Choose to deploy the cube directly from the Design Studio.
B. Do nothing, the cube was defined in the repository when the XML file was imported into theDesign Studio.
C. Export the cube model metadata out of the Design Studio and import it into the database that contains the star schema.
D. Export the cube model metadata out of the Design Studio and import it into the cube server.
正解:B
質問 6:
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?
A. sequences
B. regression prediction
C. associations
D. classification prediction
正解:A
質問 7:
You manage a store and want to increase the sales of some high profit items. One way to do this is by placing these items close to other products that are often purchased with the high profit items.
You have a year's history of all sales, including all the items that were purchased in each sale. To determine optimal product placement for the high profit items, which mining method should be used to analyze your data?
A. Association
B. Clustering
C. Classification
D. Regression
正解:A
質問 8:
Click the Exhibit button.
In the exhibit, three workloads are created in the order shown from the specified DDL. You are a member of the FINANCE group, you submit a COGNOS job and your DB2 role is MANAGER.
To which workload will your work activity be assigned?
A. RPTGR
B. RPT
C. the default workload
D. RPTG
正解:D
Tamaki -
C2090-719自習効果は高いと思います。
予備試験の答案も奇をてらわない無難な構成のものが掲載されており、Pass4Test高印象です。