C1000-065 Online Practice Questions and Answers

Which of the following can result in poor report performance?

A. reports with filters

B. models with outer joins and cross joins

C. queries with database only processing

D. an optimized metadata model

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".

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.

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).

A dashboard developer notices that Age is available in the sourced data module. A request has been made to 'bucket' those age values into 5 groups, Ages 0-6, 7-12, 13-21, 22-55, and 55 and over. How would one define this logic in the source data module?

A. set range values in the data module

B. use the Create new table feature

C. select the Age column, and select Create data group

D. define a Case..When calculated attribute in the dashboard

After adding a prompt to a relational sourced report it is decided that the consumers require multi- select functionality instead of a single-select. What two modifications must be made to the report?

A. Change the Filter property Multi-select to Yes

B. Change the Cascade source property of the Prompt to represent more than one value.

C. Change the Prompt property Usage to Select-many.

D. Change the Filter expression of the Query from "=" to use "in".

E. Change the Prompt property Multi-select to Yes.

How might a report output type of PDF be secured?

A. by setting a password in the schedule PDF options

B. by giving the PDF a name that starts with "confidential'

C. by selecting the "Secure this Report" option in the report properties

D. by specifying a PDF encryption code in the schedule settings

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 statement is true when adding a data source in a dashboard?

A. Framework Manager Packages, Data Modules and Data sets are the only three types of data sources that can be used when creating a dashboard.

B. Only data sources that have been added to a Data Module can be used as a data source.

C. Framework Manager Packages, OLAP Packages, Data Modules, Data sets and CSV files can all be used when creating a dashboard.

D. Once a data source has been added it can only be removed by deleting all data sources within the dashboard.

Which two statements are true when creating navigation paths?

A. A data module can have multiple navigation paths.

B. A modeler must delete the navigation path and re-create it to change the path.

C. Columns from different tables cannot be added to a navigation path.

D. A navigation path is a collection of Group Data columns.

E. A navigation path is a collection of non-measure columns.