IBM C2090-623 Online Practice Questions and Exam Preparation

IBM C2090-623 Online Questions & Answers

• Question 21:

  An administrator wants to use one of the sample audit reports to view the percentage of successful and failed requests for the current day. What must be done before they can successfully run this report?

  A. Set the logging level for the sample report to Minimal.
  B. Create a datasource connection to the logging database.
  C. Modify the report so that it can be displayed correctly in HTML and PDF formats.
  D. Import the Audit.cpf into the Content Store using the IBM Cognos Administration console.
  B. Create a datasource connection to the logging database.

  ---

  Before you can create audit reports or use the sample audit reports that come with IBM Cognos software, you must set up audit reporting.

  Direct log messages to a database.

  Set up a logging database and configure log messages to be sent to the database.

  Set the logging level for audit reports.

  For audit reporting, set the logging level to Basic (auditing enabled) or Request. If you set the logging level to Minimum, auditing is disabled. Use Full logging and Trace levels only for detailed troubleshooting purposes, under the guidance of

  Customer Support. They may significantly degrade server performance.

  Enable native query logging

  Incorrect Answers:

  A: If you set the logging level to Minimum, auditing is disabled.

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

• Question 22:

  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.
  B. The execution mode for the dispatcher is not set to 64 bit.

  ---

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

  A report author gets the following error message:

  "An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2004-05-25-15:44:11.296-#9."

  How can the administrator get the complete error message?

  A. Open the cogerror.log file using a text editor.
  B. Open the cogserver.log file using a text editor.
  C. Run the user report errors audit report from the samples Audit package.
  D. Run the user session details audit report from the samples Audit package.
  B. Open the cogserver.log file using a text editor.

  ---

  To find out about the actual error though an administrator with file access to the server log (cogserver.log) will need to search that log for the SecureErrorID given in the on-screen message. References: http://www-01.ibm.com/support/docview.wss?uid=swg21344157

• Question 24:

  An environment has two dispatchers with report servers installed on two machines with following configuration:

  Dispatcher 1 on Computer A RAM: 16384 MB CPU: 2 Core 2.0 GHz Storage: 512 GB Dispatcher 2 on Computer B RAM: 32768 MB CPU: 4 Core 3.4 GHz Storage: 1024 GB

  What should the setting of processing capacity for Dispatcher 2 be set to, if the capacity for Dispatcher 1 is set to 1?

  A. 1
  B. 2
  C. 4
  D. 8
  B. 2

  ---

  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

• Question 25:

  After a user added numerous schedules, the Content Store database has been locked because some schedules contain invalid data. What can an administrator do, to prevent the system from being locked in the future?

  A. Restrict the ability to create schedules to the Administrator only.
  B. Select the delivery service inside IBM Cognos Configuration and set the schedule validation property to true.
  C. Make sure that every schedule created by a user will be verifies with the validation button inside the schedule mask.
  D. Go to the Dispatcher options, select Event Manager Service and set the advanced property emf.schedule.validation.enabled to true.
  B. Select the delivery service inside IBM Cognos Configuration and set the schedule validation property to true.

  ---

  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

• Question 26:

  Which statement is true when working with datasource credentials?

  A. Users can view and delete datasource credentials from the My Data Sets page.
  B. Users may be prompted for datasource credentials when they view, run, or open an entry, or when they use a schedule or a job.
  C. When determining appropriate access to a datasource, the system first checks the user's profile to see if they have stored their own datasource credentials.
  D. If a user wants to create a datasource credentials, the administrator must grant Write permissions for the Manage own datasource signons capability for the user.
  D. If a user wants to create a datasource credentials, the administrator must grant Write permissions for the Manage own datasource signons capability for the user.

  ---

  Problem(Abstract)

  When running report user is prompted to enter the signon but the check box "?Remember my user ID and password when connecting to this data source ?is not displayed .

  User has no signon saved in his profile

  Cause

  User capability

  Diagnosing the problem

  Check the user capabilities and persmissions

  Resolving the problem

  Cognos Administrator must grant user/group execute permissions for the Manage own data source signons capability

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

• Question 27:

  An environment has the following routing rules set:

  

  If a report using the `Australia Package' is run by a user belonging to `Australia Group', which server group will the request be sent to?

  A. Group 1
  B. Group 2
  C. The request will be sent to the first available server because there is more than one rule for the Australia Package.
  D. The request would fail because there is more than one rule for the Australia Package and only one for the Australia group.
  B. Group 2

  ---

  Unlike routing keywords, the order in which the routing rules are listed affects how they are applied.

  A rule is matched when properties associated with the package or the group or role involved in the request satisfy the criteria of the rule. The rules are evaluated in order until the first one is matched, and the request is routed to the server

  group named by the first rule that was matched. You can change the order of the rules by clicking Modify the sequence.

  References: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cra.10.2.2.doc/t_asg_set_routing_keywords_server.html

• Question 28:

  An administrator sees that an environment has a long startup time and wants to remedy the issue.

  Which solution should be used?

  A. Set load balancing to cluster compatible.
  B. Check the Fast Startup option under IBM Cognos Configuration.
  C. Increase the size of the JVM heap by selecting Large configuration.
  D. Reduce the size of the Content Store through archiving and removal.
  A. Set load balancing to cluster compatible.

  ---

  If your IBM Cognos servers operate within a load balancing infrastructure, you can turn off the weighted round robin format of load balancing for the dispatcher. Otherwise, load balancing may be duplicated by the cluster and by IBM Cognos

  software, which can degrade performance.

  You can set the dispatcher property named loadBalancingMode either to weightedRoundRobin or clusterCompatible.

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

• Question 29:

  A user needs to create a data module that uses a datasource named MyDatabase. What actions must be taken to enable the user to access this datasource?

  A. Using Manage, click on Data servers, click on + and choose the appropriate database type, name the connection "MyDatabase" and supply the appropriate connection details to connect to the data source.
  B. Using New, click on Data Module, select Data servers, click on the + to add a new data server, choose the appropriate database type, name the connection "MyDatabase" and supply the appropriate connection details to connect to the data source.
  C. Using Manage, click on Administration console, then click on "New Data Source" within the Data Source Connections option under the Configuration tab. Select the appropriate database type, name the data source "MyDatabase" and supply the appropriate connection details to connect to the data source.
  D. Using Manage, click on Administration console, then click on "New Data Server" within the Data Source Connections option under the Configuration tab. Select the appropriate database type, name the data source "MyDatabase" and supply the appropriate connection details to connect to the data source.
  C. Using Manage, click on Administration console, then click on "New Data Source" within the Data Source Connections option under the Configuration tab. Select the appropriate database type, name the data source "MyDatabase" and supply the appropriate connection details to connect to the data source.

  ---

  You can combine multiple sources into one data module. After you add a source, click Add sources (Add a data source.) in Selected sources to add another source. References: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ca_mdlg.doc/c_data_modules.html

• Question 30:

  An environment is configured to use Compatible Query Mode (CQM). Which statement is true about request flow?

  A. OLAP, DMR and Relational components reside in the same Adapters layer.
  B. OLAP, UDA and DMR components reside in the same Query Execution layer.
  C. OLAP, Relational and DMR components reside in the same Query Planning layer.
  D. OLAP, DMR and Relational components reside in the same Query Execution layer.
  C. OLAP, Relational and DMR components reside in the same Query Planning layer.

  ---

  OLAP style queries, like those against SAP BW, Oracle Essbase and IBM Cubing Services type data sources, will go to the OLAP query planner. References: The IBM Cognos 10 Dynamic Query Cookbook (2010), page 7