IBM C2090-623 Online Practice Questions and Exam Preparation

IBM C2090-623 Online Questions & Answers

• Question 31:

  An administrator is evaluating system status using the Scorecard pane on the Status > System page in the IBM Cognos Administration console. Which statement is true?

  A. If a service is disabled in IBM Cognos Configuration, it is listed in the Scorecard pane.
  B. The status that is displayed for each entry reflects the lowest status for all child entries.
  C. A status of Available is displayed when at least 80% of the child entries have a status of Available.
  D. A status of Unavailable is displayed when at least 80% of the child entries have a status of Unavailable.
  B. The status that is displayed for each entry reflects the lowest status for all child entries.

  ---

  The metric score for each entry is based on the performance of individual child entries. The status that is displayed for each entry is the lowest status of the child entries. For example, if all the metrics for a dispatcher are good, but one service

  on that dispatcher has a poor metric, the metric score shown for the dispatcher is poor.

  Status is one of the following:

  Available if all components are available

  Partially available if at least one component is available and at least one component is unavailable or partially unavailable.

  Unavailable if all components are unavailable

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

• Question 32:

  IBM Cognos Analytics is installed on a non-Windows platform. An administrator receives the following error after setting up a datasource connection:

  "XQE-DS-0014 Unable to logon to the data source. An unexpected error from the JDBC driver "com.microsoft.sqlserver.jdbc.SQLServerDriver":

  "java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.8 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0."

  What should the administrator do to rectify this problem?

  A. Elevate the permission of the driver folder.
  B. Check the user account for proper logon permission.
  C. Copy the sqljdbc4 driver to the install location\drivers directory.
  D. Copy the sqljdbc4 driver to the install location\5dataserver\lib directory.
  C. Copy the sqljdbc4 driver to the install location\drivers directory.

  ---

  Based on the error message that is displayed, it is likely that the JDBC driver is unable to read the correct `.jar' file. When performing an update of the JDBC driver to receive the new `.jar' file, the original `.jar' file is still likely to be stored in the same location as it contains the same file path that is held in the installer of the software.

  Ensure that JDBC drivers are in the correct location. For the IBM Cognos Analytics, the JDBC drivers must be copied to the install_location\drivers directory.

  References: https://developer.ibm.com/answers/questions/292756/the-xqe-ds-0014-error-message-appears-after-carryi-1.html https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.bi_install_faq.doc/c_inst_crit_config.html

• Question 33:

  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: XQE-JDB-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
  C. missing gateway URI configuration

  ---

  Question When testing a JDBC connection to Microsoft SQL Server 2005 / 2008 / 2012 you receive the error XQE-JDB-0004 A problem occurred finding the driver class "com.microsoft.sqlserver.jdbc.SQLServerDriver". Cause The JDBC connector is missing or not properly installed for Cognos Answer You may need to download the .JAR files from Microsoft download center site: http://www.microsoft.com/en-us/download/details.aspx?displaylang=enandid=11774 or search for "Microsoft JDBC Driver for SQL Server" via your favorite search engine. Follow the Microsoft instructions to download and install.

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

• Question 34:

  In a multi-server environment, an administrator wants to ensure that items in the Content Manager Cache service are re-validated every thirty seconds. Which option would accomplish this?

  A. Set the memory limit of the Content Manager Cache service to 30000.
  B. Set the DISP.contentManagerCacheService.accountInactivityTimer property to 30000.
  C. Set the DISP.contentManagerCacheService.cacheValidatorTimetoLive property to 30000.
  D. Set the DISP.contentManagerCacheService.cacheValidatorTimetoLinger property to 30000.
  C. Set the DISP.contentManagerCacheService.cacheValidatorTimetoLive property to 30000.

  ---

  ValidatorTimetoLive determines how long data objects remain in the cache. After the Validator timer expires objects are considered Invalid and have to be fetched from Cm again. Value is in ms, and default is 900000.

  References: https://www.slideshare.net/barnaby1502/cognos-technical-super-session-2012, page 11

• Question 35:

  An administrator wants to control server workload by putting routing rules in place. Which components can be used?

  A. a package and/or group or role
  B. a package and/or a server group
  C. a group or role and/or a server group
  D. a package and/or group or role and/or a server group
  D. a package and/or group or role and/or a server group

  ---

  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

• Question 36:

  An administrator wants to describe the internal architecture and request flow for a Query service of an executed DQM report. How is this done?

  A. A report specification is executed via BIBus which directly queries via RDBMS adapter, and caches then waits for the result and generates the report output.
  B. A report specification is executed via Query service which directly queries via RDBMS adapter, and caches then waits for the result and generates the report output.
  C. A report specification is executed via Query service which parses the request into two trees and executes via RDBMS adapter and caches then waits for the result and generates the report output.
  D. A report specification is executed via BIBus then to Query service which parses the request into two trees and executes via RDBMS adapter and caches then waits for the result and generates the report output.
  B. A report specification is executed via Query service which directly queries via RDBMS adapter, and caches then waits for the result and generates the report output.

  ---

  The SQL engine obtains data directly from the RDBMS Adapter. The Query Execution Engine updates the secure Data Cache with dimensional data for future reuse. Note: A report specification is an executable definition of a report, including query and layout rules, which can be combined with data to produce a report output.

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

• Question 37:

  A high user load and interactive reporting system on a distributed installation is throwing timeout error messages. How is this resolved?

  A. Increase the JVM heap settings in IBM Cognos Configuration under Services.
  B. Edit the install_location/bin CQEConfig.xml and change the DB_Connection_Pool value to 120, save and restart the service.
  C. Edit the install_location/webapps/p2pd/WEB-INF/services reportservice.xml and increase the async_wait_timeout_ms, save and restart the service.
  D. Increase the number of Report Processes under IBM Cognos Administration on the Status tab under System, set properties to equal 2 times the number of total processor cores.
  C. Edit the install_location/webapps/p2pd/WEB-INF/services reportservice.xml and increase the async_wait_timeout_ms, save and restart the service.

  ---

  Increase Asynchronous Timeout in High User Load Environments.

  If you have a high user load (over 165 users) and interactive reports are running continuously in a distributed installation, you may want to increase the asynchronous timeout setting to avoid getting error messages. The default is 30000.

  To resolve this problem, increase the wait timeout. Procedure

  1.

  Go to the following directory:

  2.

  install_locationwebapps/p2pd/WEB-INF/services/.

  3.

  Open the reportservice.xml file in a text editor.

  4.

  Change the async_wait_timeout_ms parameter to 120000.

  5.

  Save the file.

  6.

  Restart the service.

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

• Question 38:

  An administrator wants to start the LifeCycle Manager service. How can this be done?

  A. Open IBM Cognos Configuration and start the service.
  B. Open Administrative tools, Services, and start the LCM service.
  C. Use the lcm_start.bat command from a command prompt window.
  D. Type the URL in a browser, http://server_name:port_number/lcm_servlet/webcontent/app/main.
  C. Use the lcm_start.bat command from a command prompt window.

  ---

  Before users can start working in Cognos LifeCycle Manager, you must start the Cognos LifeCycle Manager web application.

  Procedure

  Start the Cognos LifeCycle Manager server:

  On a Microsoft Windows system, from the Start menu, click LCM Start.

  You can also type the following command in a command prompt window, from the Cognos LifeCycle Manager install location. Depending on where Cognos LifeCycle Manager is installed, you might have to run the command prompt window

  as an administrator.

  lcm_start.bat

  On a Linux system, run the server start script

  install_location/lcm_start.sh

  Start the Cognos LifeCycle Manager web application:

  On a Microsoft Windows system, from the Start menu, click LCM URI.

  Type the following URL in your browser:

  http://server_name:port_number/lcm_servlet/app/main

  Incorrect Answers:

  D: The URL that is used to start the Cognos LifeCycle Manager web application in a browser includes a port number. The port number must match the port number that is specified in the install_location\wlp\usr\servers\lcm\server.xml file.

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

• Question 39:

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

  ---

  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 40:

  An administrator is tuning the Caching services to improve Dynamic cube report performance. At the same time, there is a need to control the memory usage and Clear Cache. How is this done?

  A. Control of the memory usage and scheduling of the Clear Cache is a default setup.
  B. In IBM Cognos Configuration under IBM Cognos Services/IBM Cognos select Query Service and select operation Clear Cache.
  C. In IBM Cognos Administration under System tab from the actions menu, select Query Service and enable the checkbox for Clear Cache.
  D. In IBM Cognos Administration under Configuration tab click Content Administration, click the New Query task button and select Clear Cache.
  B. In IBM Cognos Configuration under IBM Cognos Services/IBM Cognos select Query Service and select operation Clear Cache.

  ---

  To avoid using outdated data that might be stored in the cache, you can clear the cache. You might want to clear the cache manually if your data source metadata changes infrequently or if you want to clear the cache in between automatically scheduled cache clearing. When you clear the cache using the following steps, it clears everything in the cache.

  Steps

  1.

  Start IBM Cognos Connection.

  2.

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

  3.

  On the Configuration tab, click Query Service Caching.

  4.

  Select the server groups for cache clearing.

  5.

  Click Clear cache.

  The status of the Clear cache command is displayed.

  If a cache is being used by one or more pending reports or queries, it is internally flagged as "stale" by this command and is automatically cleared as soon as this usage completes.

  6.

  Click Close.

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