C1000-065 Online Practice Questions and Answers

After upgrading from Cognos version 10 what needs to be selected in order to create a data module on a data server?

A. Select "Allow web-based modeling" in Cognos Configuration when starting the server

B. Select "Allow web-based modeling" in the Cognos installer when upgrading the server components.

C. Under the Data Server Connection in the Administration Console configuration select "Allow Framework Manager".

D. Under the Data Source Connection in the Administration Console configuration select "Allow web- based modeling".

In an Exploration 'Data relationships' view, what does the thickness of the lines between data items represent?

A. the statistical strength of the relationship between the data items

B. the flow of information between categories, ie. money transfers between countries

C. the cardinality of one data item when grouped by another, ie. thicker signifies more unique values

D. the weighted average of each measure value compared with other measures

To change the text item in a list column title or the data in the column body of a list object in a report, what first needs to happen?

A. Select the cell and change the data format.

B. Click on the Lock Page Objects icon to unlock the report.

C. Select one of the cells and from the menu click Select Columns Style or Select Columns body style.

D. Select the cell and change the Box Type to None.

Which is true about creating a context filter for a crosstab report using a dimensional data source?

A. it changes the measure values and the items in the rows and columns

B. it is applied after aggregation and changes the rows and columns

C. it changes the measure values and suppresses zeros

D. it filters only the measure values, not the items in the rows and columns

In a Data Module a developer creates a joined view from two tables (a and b) and then joins this to another table (c). What would be the execution logic in the database?

A. All queries are collapsed and a standard join across all three tables (a, b, c) is performed.

B. The columns used in table (c) are are joined on the key to table (b) first and then the results are post-joined to table (a).

C. It makes no difference to the execution as a joined view is only used to group data items in a logical manner to help the business user find their data.

D. The joined view (a and b) is evaluated and all results are then post-joined to the other table (c).

When should a dimensional function be used in a report's Query calculation?

A. when the data source is a dimensional or dimensionally-modeled data source

B. to allow relative date functions to be performed against a non-dimensional data source

C. to convert a non-dimensional data source into a dimensionally-modeled data source

D. to allow drill up and down on a non-dimensional data source

Which of the following is a reason to use a Conditional block on a report?

A. to allow users to select values that will filter the report for certain data types

B. to allow a report to run during certain blocks of time based on conditions set by the user

C. to show or hide report objects based on prompt selections a user made at run time

D. to block defined groups of users from accessing a folder of reports based on a condition

Which statement is true regarding Custom Sorts in dashboards?

A. A user can create a custom sort on any type of data.

B. Custom sorts cannot be created on measures.

C. Custom sorts may only be created in a Data Module.

D. Custom sorts may be created by selecting a field in the source pane and going to properties.

Which two items can the opposite edge Crosstab in a report?

A. The value of a member

B. A selected measure

C. Member caption

D. Node member

E. Crosstab intersection

Which of the following is done for a report to use a Data set as a data source?

A. Ask the administrator to add the file as an external data source.

B. Add the Data set to a Data Module.

C. Add the Data set to a Framework Manager package.

D. Add the Data set as a source on the report.