IBM Cognos ICM Essentials (BAS-004) Free Practice Test

Question 1

Which two column types would be used in the formula of a calculation? (Choose two.)

A. Text

B. Numeric

C. Date

D. Pick List

Correct Answer: B,C

Question 2

When using an effective dated table as a source for a calculation, which two statements are true? (Choose two.)

A. Join an effective dated table to another effective dated table (not Time).

B. Join on both effective dates.

C. Join start and end date of the effective dated table to a single date.

D. Join the calendar table to the effective dated table.

Correct Answer: B,C

Question 3

Which two scenarios will produce a conflict during the migration of a single component? (Choose two.)

A. The component has a calculation in the source model which resides in a different component in the target model.

B. The component has a table that exists in the target model but has been deleted in the source model.

C. The component has a calculation that exists only in the source model.

D. The component has a table with the same name in both models but different number of key columns.

Correct Answer: A,D

Question 4

Which two statements about IBM Cognos ICM tables are correct? (Choose two.)

A. Other tables can Pick List to a Custom table.

B. Primarykeysareoptional.

C. Data tables are associated with a calendar.

D. Primary keys in a Structural table must be Text box column.

Correct Answer: C,D

Question 5

Which table type should be used to store transactional information?

A. View

B. Data

C. Custom

D. Structural

Correct Answer: B

Question 6

Which two statements are benefits of adding effective-dates to tables? (Choose two.)

A. They prevent changes to data overtime.

B. They provide another solution for deleting records.

C. They provide a better audit trail for the data set.

D. They make calculation restrictions easier to define.

Correct Answer: B,C

Welcome to TestSimulate