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

The folder ''AP'' has reports that can retain output for 12 months. The administrator needs to remove report output that is at least 30 days old from the Content Store, and archive it to an external repository while keeping up to 12 months of run history.

How can this be accomplished without losing any output or run history?

ACreate and run a Content Removal task and set the options of Run history to 12 Months and Output versions to 30 days. Create a Content Archival task for the folder ''AP''.

BCreate and run a Retention Rule task and set the options of Run history to 12 Months and Output versions to 30 days. Create and run a Content Archival task for the folder ''AP''.

CCreate and run a Content Archival task for the folder ''AP''. Create and run a Content Removal task and set the options of Run history to 12 Months and Output versions to 30 days.

DCreate and run a Retention Rule task and set the options of Run history to 12 Months and Output versions to 30 days. Create and run a Content Archival task for the folder ''AP'' and choose the Archival settings of Copy then remove.

Answer : C

Administrators use the retention rule update task to specify the number of reports, queries, analyses, and document objects to keep in the content store. You can specify how long to keep the history and output versions in the content store. Anything that is older than the date you specify is deleted from the content store.

Run this task only after creating and running the content archival task. If you run it before, content that was not marked for archival is permanently deleted from the content store.

References: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.ug_cra.10.2.1.doc/t_creat_retent_rl.html

Question 3

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?

ASet the logging level for the sample report to Minimal.

BCreate a datasource connection to the logging database.

CModify the report so that it can be displayed correctly in HTML and PDF formats.

DImport the Audit.cpf into the Content Store using the IBM Cognos Administration console.

Answer : B

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

Question 4

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

ATo serve as the relational database that stores user data.

BTo implement authentication, authorization, and encryption.

CTo start all services that have been enabled and configured.

DTo route requests from the gateway to local services for execution.

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 5

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?

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

BIn advanced settings, add the parameter RSVP.logging.databasecontrol with the value <Content Manager Server>:<Port>.

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

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

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 6

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

AAs a wrapper tool for gateway related errors.

BTo process the audit logging data and write it to the audit database.

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

DFor tracing performance and communication between XQE and the BIBus.

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 7

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

Which statement is true?

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

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

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

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

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

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