IBM IBM Certifications C2090-623 Questions & Answers

• Question 21:

  An administrator is creating a datasource for an IBM Cognos PowerCube. On the datasource creation page, the `Configure JDBC connection' check box is played out and cannot be selected.

  What is the reason for this?

  A. The IBM Cognos PowerCube is not optimized.

  B. The execution mode for the dispatcher is not set to 64 bit.

  C. The execution mode for the environment is not set to 64 bit.

  D. JDBC connection is not supported for IBM Cognos PowerCube.

  Correct Answer: B

  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.

  Incorrect Answers:

  D: IBM Cognos PowerCube supports JDBC connections.

  References: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/ com.ibm.swg.ba.cognos.inst_cr_winux.doc/c_rptconnsingle.html

• Question 22:

  An administrator has a requirement to specify system-wide accessibility settings for all entries (reports, jobs and schedules).

  How can this be done?

  A. No action needed as the Administrator has access to all entries by default.

  B. In IBM Cognos Portal select all entries and change owner to Administrator.

  C. In IBM Cognos Administration, on the Deployment tab add a new deployment, select full Content Store and deploy without security and import overriding Source with Administrator user.

  D. In IBM Cognos Administration, click on "configuration" > dispatchers and services > click on "set properties" > click on "settings" > in the Category drop down list box select "Administrator Override".

  Correct Answer: D

  Enable Accessible Report Output Using System-wide Settings Accessible reports contain features, such as alternate text, that allow users with disabilities to access report content using assistive technologies, such as screen readers. In IBM Cognos Administration, you can specify system-wide settings for accessible report output that apply to all entries, including reports, jobs, and scheduled entries. Accessibility settings in the user preferences and report properties can overwrite the system-wide settings in IBM Cognos Administration.

  Steps

  1.

  Start IBM Cognos Connection.

  2.

  In the upper-right corner, click Launch, IBM Cognos Administration.

  3.

  On the Configuration tab, click Dispatchers and Services.

  4.

  From the toolbar in the upper-right corner of the page, click the set properties button .

  5.

  Click the Settings tab.

  6.

  Under Category, click Administrator Override.

  7.

  For the Administrator Override category, next to Accessibility support for reports, in the Value column, click Edit.

  8.

  In the Accessibility support for reports page, select one of the following options:

  

  References: IBM Cognos Administration Version 10.1.0, Administration and Security Guide, page 189

• Question 23:

  Where can a report or dashboard be saved?

  A. folder, package, My content

  B. data module, package, folder

  C. hidden folder, My content, data module

  D. Top Level of Team content, folder, package

  Correct Answer: A

  While you are working on your custom dashboard, save it locally in the My content folder. When you finish creating your dashboard, you can make it available to users with the WCM Report User role by copying it to your custom dashboard folder in Team Content. When you finish creating your dashboard, you can make it available to users with the WCM Report User role by copying it to your custom dashboard folder in Team Content.

  References: https://www.ibm.com/support/knowledgecenter/en/SSRMV7/com.ibm.iwcm.doc/care/ t_reporting_create_dashboards.html

• Question 24:

  An administrator is operating in a hybrid operating systems environment, trying to establish a datasource connection. The compatible portion succeeds, however, the JDBC portion failed with following error: XQEJDB-0004 A problem occurred finding the driver class "com.microsoft.sqlserver.jdbc.SQLServerDriver". What is the possible cause for this error?

  A. 32-bit client driver installed

  B. 64-bit client driver installed

  C. missing gateway URI configuration

  D. unsupported driver version installed

  Correct Answer: C

• Question 25:

  What is the role of Cognos Access Manager (CAM)?

  A. To serve as the relational database that stores user data.

  B. To implement authentication, authorization, and encryption.

  C. To start all services that have been enabled and configured.

  D. To route requests from the gateway to local services for execution.

  Correct Answer: B

  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

• Question 26:

  An administrator deleted a group inadvertently then recreated it, but now the access permissions based on that group no longer work.

  What must be done?

  A. Re-implement all the access permissions.

  B. On the group properties, select "Apply to all children".

  C. Make sure that it has the exact same spelling as before.

  D. Restore from a backup selecting only the access permissions.

  Correct Answer: D

  Incorrect Answers:

  C: When you delete a Cognos group or role, access permissions based on it are also deleted. You cannot restore them by creating a new group or role with the same name because this entry has a different internal ID.

  References: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.0/ com.ibm.swg.ba.cognos.ug_cra.10.2.0.doc/c_accesspermissions.html

• Question 27:

  The following distributed environment has been configured:

  

  The administrator wants to limit writes to the audit database connection from the Content Manager server

  only.

  What needs to be configured?

  A. The Content Store configuration has to be set up on the application tiers servers.

  B. In advanced settings, add the parameter RSVP.logging.databasecontrol with the value :.

  C. An advanced routing has to be configured in Cognos Administration audit requests from application tiers routed to Content Manager server.

  D. On the Content Manager server configure the audit database, on the application tier servers create a Remote log server configuration to the Content Manager log server.

  Correct Answer: C

  If a request should be subject to Advanced Routing, then the client which send the request is responsible for calling CM to evaluate Routing Rules and put the Server Group Information into the request passed to a Dispatcher.

  References: https://www.ibm.com/developerworks/data/library/cognos/infrastructure/cognos_specific/ page510.html

• Question 28:

  An administrator is attempting to import a backup of the entire Content Store into an existing Content

  Store.

  What is an instance of when an object will be kept by the default conflict resolution rule?

  A. There are not any conflict resolution rules applied when importing the entire Content Store. All objects will be replaced.

  B. When the object is OUTPUT, GRAPHIC or PAGE and the CM.DEPLOYMENTKEEPERREPORTOUTPUT parameter is set to True.

  C. When the object is OUTPUT, GRAPHIC or PAGE and the CM.DEPLOYMENTUSERREPORTOUTPUT parameter is set to True.

  D. When the object is CACHEOUTPUT, SESSION or REPORTCACHE, REPORTMETADATACACHE or DEPLOYMENTDETAIL.

  Correct Answer: D

  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_cra.10.2.2.doc/ c_ruleswhendeployingtheentirecontentstore.html#RulesWhenDeployingtheEntireContentStore

• Question 29:

  Why would an administrator use IPF (Indication Processing Facility) logging?

  A. As a wrapper tool for gateway related errors.

  B. To process the audit logging data and write it to the audit database.

  C. As a wrapper for log4j to configure what information is written to log files.

  D. For tracing performance and communication between XQE and the BIBus.

  Correct Answer: C

  Some error messages may contain sensitive information, such as server names. By default, error message details in IBM Cognos software are routed to IPF log files, and the secure error message option is enabled. The information presented to users indicates only the occurrence of an error, without any details.

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

• Question 30:

  An administrator is managing authentication namespaces and needs to delete a namespace.

  Which statement is true?

  A. To recreate a namespace that was previously deleted in IBM Cognos Configuration, a unique ID must be used.

  B. After a namespace has been deleted in IBM Cognos Configuration, it no longer appears in the directory tool.

  C. An inactive namespace in the directory tool is one that was configured, but later deleted in IBM Cognos Configuration.

  D. If a namespace is deleted in IBM Cognos Configuration and is no longer required, any authenticated member of the namespace can delete in permanently in the directory tool.

  Correct Answer: D

  When you delete a namespace, you can no longer log on to the namespace. Security data for the namespace remains in Content Manager until you permanently delete it in the portal.

  References: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/ com.ibm.swg.ba.cognos.inst_cr_winux.doc/t_deleteanauthenticationprovider.html