IBM C2090-623 Exam Practice Test Instant Access

Question 1

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?

AElevate the permission of the driver folder.

BCheck the user account for proper logon permission.

CCopy the sqljdbc4 driver to the install location\drivers directory.

DCopy the sqljdbc4 driver to the install location\5dataserver\lib directory.

Answer : C

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 2

A CQM report successfully runs in another environment but fails in IBM Cognos Analytics. Environments are identical except for the versions.

How could the issue be identified?

APerform a UDA trace.

BModify the ipfserverconfig.xml.

CIncrease the logging level of the Query service.

DRestart the IBM Cognos Analytics service to eliminate all remaining BIBus processes.

Answer : B

The method for performing a UDA trace is different in Cognos 10 to previous versions due to the removal of the Cognos Logging Console Program. This is specific to CQM datasources.

Please follow these steps:

This trace records all database activity so should be turned off as soon as the possible.

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

Question 3

Which component stores and retrieves application data, including report specifications, report output, security, and configuration data?

AGateway

BDispatcher

CContent Manager

DPresentation service

Answer : C

The Content Manager service:

To make printers available to users when they distribute reports, you can create entries for printers and save them in the IBM Cognos content store.

Question 4

An administrator needs to add users from multiple authentication providers to a single role.

What needs to be done?

ALog on to each of the namespaces before starting.

BAdd external namespaces to the Cognos namespace manually.

CAdd the users to a Cognos group, then add the group to the Cognos role.

DImport the users to the Cognos namespace first, then add the users to the Cognos role.

Answer : B

In the Cognos Analytics user interface, authentication providers are represented by namespaces.

Cognos Analytics supports the following types of authentication providers:

Authentication providers are configured in IBM Cognos Configuration, under the Security > Authentication category. After the provider namespace is added there, and the IBM Cognos service is restarted, the namespace name is displayed in Manage > Accounts, and users can log on to Cognos Analytics using that namespace.

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

Question 5

An administrator would like to log the activity for a single user.

Which action is required?

ASet the Report service logging to Trace.

BModify the ipfcogconfig.xml file in the bin64 directory.

CUse the Remote Process service for Java Management Extensions (JMX).

DSet the advanced parameter RSVP.REPORTUSER.LOG for the Report service.

Answer : C

You can use logs to diagnose a problem that is occurring for one or more specific users.

You enable and disable logging for specific users by using the Remote Process service for Java Management Extensions (JMX), a technology that supplies tools to manage and monitor applications and service-oriented networks. You connect to the JMX Remote Process service using the jconsole executable that is provided with the Java JDK.

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

Question 6

In a LifeCycle Manager Project, a user can create either a Benchmark task or a Comparison task.

Which statement is INCORRECT when describing the application of Benchmark tasks?

ABenchmark tasks can be used as a benchmark test for any LifeCycle Manager Project.

BBenchmark tasks can be used to create a benchmark test to run Compatible Query Mode (CQM) reports as Dynamic Query (DQ) reports.

CWhen creating a Benchmark task, the administrator can choose whether to validate reports before they are run, and whether to run the reports in Dynamic Query Mode (DQM).

DTo use a previously run Benchmark, select a previously created Benchmark task for the benchmark source and the target Cognos server that you want to compare to the benchmark.

Answer : C

Question 7

An administrator created a Content Store export and included the user account information.

How can a listing of the content be exported?

AWithin the export, ensure the Recording level option is set to Trace.

BBy default when the Content Store is backed up, a full detailed listing is generated and available in the Logs folder.

CModify the Advanced settings on the ContentManagerService by adding the parameter
CM.DeploymentDetailEntireContent with a value of true.

DModify the Advanced settings on the ContentManagerService by adding the parameter
CM.DeploymentIncludeConfiguration with a value of true.

Answer : D

You can specify if configuration objects and their children are included as part of deployment. By default, they are not included.

You can change the default setting using the advanced setting

CM.DEPLOYMENTINCLUDECONFIGURATION.

By default, it is set to False (do not include configuration objects in deployments).

To change the default to include configuration objects and their children, set it to True.

IBM C2090-623 IBM Cognos Analytics Administrator V11 Exam Practice Test