IBM Cognos ICM Essentials 認定 BAS-004 試験問題:

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

A) Data tables are associated with a calendar.
B) Primary keys in a Structural table must be Text box column.
C) Primarykeysareoptional.
D) Other tables can Pick List to a Custom table.

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

A) Join the calendar table to the effective dated table.
B) Join on both effective dates.
C) Join an effective dated table to another effective dated table (not Time).
D) Join start and end date of the effective dated table to a single date.

3. Click the Exhibit button.

In the exhibit, you are creating a calculation to output only the results for the last month of anyquarter from the calculation "QTD Payment". The"Time"table is joined twice at month and quarter level.
Which additional restriction is required on the second join to the Time +- table at the quarter level?

A) "Time (Month)".Name = "Time (Quarter)".Name
B) "Time (Month)".Ending = "Time (Quarter)".Ending
C) "Time (Month)".Starting = "Time (Quarter)".Starting
D) "Time (Month)".Parent = "Time (Quarter)".Name

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

A) They make calculation restrictions easier to define.
B) They prevent changes to data overtime.
C) They provide a better audit trail for the data set.
D) They provide another solution for deleting records.

5. You want to restrict a developer's access to modify table data in the QA environment. What should the QA administrator do?

A) Limit the developer's role to view data.
B) Disable the developer's Web access.
C) Remove the developer from all the Portal Access Groups.
D) Remove the developer from the Payee table.

質問と回答：