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

Question 1

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

A. Edit the install_location/webapps/p2pd/WEB-INF/services reportservice.xml and increase the async_wait_timeout_ms, save and restart the service.

B. Edit the install_location/bin CQEConfig.xml and change the DB_Connection_Pool value to 120, save and restart the service.

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

D. Increase the JVM heap settings in IBM Cognos Configuration under Services.

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 2

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

A. OLAP, UDA and DMR components reside in the same Query Execution layer.

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

D. OLAP, DMR and Relational components reside in the same Adapters layer.

Correct Answer: C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 3

An administrator wants to ensure that a datasource can be referenced when creating data modules in the IBM Cognos Analytics Portal (New > Data module).
What must be done to accomplish this?

A. Configure the datasource in IBM Cognos Transformer so that it can communicate with the portal.

B. In the web-based modeling tool itself, specify the 'Create Data Modules' access permission for the datasource.

C. Add the datasource to the list of supported datasources in IBM Cognos Configuration.

D. On the Connection tab of the datasource properties, ensure that the 'Allow web-based modeling' check box is selected.

Correct Answer: D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 4

To monitor performance, an administrator has set thresholds on a system metric and notices that over time, the metric score has changed from green, to yellow, to red, and then back to yellow.
Which system metric is the administrator monitoring?

A. ReportService: Process: Number of processes high watermark

B. Dispatcher: JVM: Current heap size

C. BatchReportService: Request: Percentage of successful requests

D. ContentManageService: Request: Number of failed requests

Correct Answer: D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 5

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

A. a package and/or a server group

B. a group or role and/or a server group

C. a package and/or group or role

D. a package and/or group or role and/or a server group

Correct Answer: D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 6

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?

A. Modify the ipfserverconfig.xml.

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

C. Perform a UDA trace.

D. Increase the logging level of the Query service.

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

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

Latest Update

Useful Links

Contact Us