C2090-623 IBM Cognos Analytics Administrator V1 Questions and Answers

Explanaton:

Compatible query mode

To run reports that use the compatible query mode, you must use 32-bit data source client libraries and configure the report server to be 32-bit. The compatible query mode uses native client and ODBC connections to communicate with data sources.

If the data source is 64-bit, ensure that you use the 32-bit client libraries to connect to the data source to use the compatibility query mode.

A routing rule determines, based on user, group, or package, which server group you wish to handle a user request.

There are four routing set rules in Cognos Business Intelligence.

• Routing Keywords for Packages
• Routing Keywords for User Roles or Groups
• Server Group Names for Advanced Dispatcher Routing
• Routing Keywords for Server Groups

References: http://www- 01.ibm.com/support/docview.wss?uid=swg21427147

If your installation includes more than one dispatcher, you can specify the proportion of requests that each dispatcher handles by changing their processing capacity.

This is commonly referred to as load balancing. You typically set the capacity for a dispatcher based on the CPU speed of the computer where it is installed.

For example, a first dispatcher is installed on a 2 GHz computer and a second dispatcher on a 1 GHz computer. You set the processing capacity of the first dispatcher to 2.0 and the second to 1.0. The first dispatcher handles two-thirds of the requests while the second handles one-third of the requests. If you set the capacity of both dispatchers to 1.0, requests are sent to each dispatcher alternately.

The default processing capacity for each dispatcher is 1.0.

References: https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cra.doc/t_balancerequestsamongdispatchers.html#BalanceRequestsAmongDispatchers

Access Manager provides a centralized environment to define, store, and maintain security information for IBM Cognos business information applications.

In one central location, you can set up and maintain secure user access to data, such as cubes and reports, that are created in other IBM Cognos applications. With Access Manager, you can also set up and maintain user signon information and auto-access privileges for the data sources and servers that contain the required data.

References: http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/accman/7.4mr4/accessadm.pdf

In IBM Cognos Analytics, when numerous schedules are added or updated, the content store database can lock if the schedules contain invalid data. If you experience this problem, you can set an advanced property that validates schedule properties and disables invalid schedules.

If the emf.schedule.validation.enabled property is set to true, schedule properties such as start date, end date, data types, and user account credentials are validated. Invalid schedules that are encountered are disabled, and details of the disabled schedules are logged in the log files.

The default for this property is false. To enable schedule validation, set the property to true.

References: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cra.doc/t_ug_cra _validate_schedule_props_adding.html

The default conflict resolution rule for deploying the entire content store is replace.

Exceptions to the default conflict resolution rule are listed in the following table:

Object name: SESSION, CACHEOUTPUT, REPORTCACHE, REPORTMETADATACACHE, DEPLOYMENTDETAIL

Conflict Resolution Rule: Keep

References: https://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_c ra.10.2.2.doc/c_ruleswhendeployingtheentirecontentstore.html#RulesWhenDeployingtheEntireContentStore