C2090-719 by IBM Valid Free Exam Practice Test

Question 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. runstats for the MQTs C. create statements for indexes on the fact table D. recommendations for database partitioning E. create statements for MDCs (Multi-dimensional clustered indexes)

Correct Answer: A,B

Question 2

A cube model has been created but one of the dimensions does not have a hierarchy defined.
After right-clicking on the dimension and selecting "Add Hierarchy", which two steps are required to complete the definition of the new hierarchy? (Choose two.)

A. Under the new hierarchy name, right-click on "MDX Calculated Measures" and select
"Add MDX Calculated Measure". B. On the Default Measure page, specify the default measure. C. On the Levels Property page, specify the levels to include in the hierarchy. D. On the General Properties page, specify a hierarchy name. E. On the Calculated Measures page, specify the measures to include in the hierarchy.

Correct Answer: C,D

Question 3

Which statement is true about Rational Data Architect (RDA) integration with the Design Studio for data modeling?

A. Design Studio integrates both logical and physical data modeling capabilities from RDA. B. Design Studio includes the physical data modeling component to help you implement your physical model. C. The full RDA can be installed into the Design Studio platform for logical and physical data modeling. D. Design Studio is based on IBM Data Server Developer Workbench and a full set of RDA components.

Correct Answer: B

Question 4

You work for an insurance company and have been asked to help find a way to detect which health care providers may be submitting fraudulent claims. Which mining method would you employ?

A. sequences B. associations C. regression prediction D. clustering

Correct Answer: D

Question 5

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. Specify a MDC on day and a table partitioning key for month. B. Specify database partitioning on day and a table partitioning key for month. C. Specify database partitioning on month and a table partitioning key for day. D. Specify a MDC for month and a table partitioning key for day.

Correct Answer: A

Question 6

Every night, an InfoSphere Warehouse application updates data in a star schema in the datawarehouse. The update process is taking longer than expected and so management decides to begin the update process at an earlier time each day. Which function of the Admin Console will accomplish this task?

A. Use Manage Processes Schedules Suspend and Update. B. Use Manage Processes Update. C. Use Manage Processes Disable, Update, and Enable. D. Use Manage Processes Schedules Update.

Correct Answer: D

Question 7

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. 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. B. 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. C. 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. D. 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.

Correct Answer: A

Question 8

A logical data model was created in a design tool. It is needed as a reference for a datawarehouse project. How can the logical model be used within Design Studio to create a database model?

A. Use the design tool to create a DDL file then use Design Studio to reverse engineer the model from the DDL file. B. The logical model objects can be reverse engineered directly into the Design Studio. C. The logical data model objects can be exported into metadata format which can be imported into Design Studio using the Data Model Import Wizard. D. The logical data model objects can be imported into Design Studio using the Data Model Import Wizard.

Correct Answer: A

Question 9

For text analytics, the technique that uses a dictionary to do searching is known as which type of information extraction?

A. rule-based B. natural language processing C. regular expression D. list-based

Correct Answer: D

Question 10

A cube has been deployed to cubing services. Due to an increase in the workload accessing the cube, response time has increased. What would allow you to apply additional resources (memory, CPU) to decrease the response time?

A. Add the cube to two different cube servers that are each connected to the same repository. B. Copy the star schema to another database and deploy the cube to both databases in which the star schemas reside. C. Add the cube twice to the same cube server. D. Duplicate the star schema in the same database by copying the data to additional tables and the associate the cube with both star schemas.

Correct Answer: A

IBM InfoSphere Warehouse V9.5 - C2090-719 Exam Practice Test