Summer Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: s2p65

Easiest Solution 2 Pass Your Certification Exams

C2090-623 IBM Cognos Analytics Administrator V1 Free Practice Exam Questions (2025 Updated)

Prepare effectively for your IBM C2090-623 IBM Cognos Analytics Administrator V1 certification with our extensive collection of free, high-quality practice questions. Each question is designed to mirror the actual exam format and objectives, complete with comprehensive answers and detailed explanations. Our materials are regularly updated for 2025, ensuring you have the most current resources to build confidence and succeed on your first attempt.

Page: 1 / 1
Total 60 questions

An administrator needs to setup security for a newly installed environment.

Which of the following is a valid step?

A.

Remove the default authentication provider.

B.

Enable anonymous access for selected users, groups, or roles.

C.

Delete the Everyone group to limit access to the environment for selected users, groups, and roles.

D.

Add trusted users, groups, or roles to the System Administrators role, and then remove the Everyone group from the role.

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.

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.

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.

An administrator needs to exclude users from rendering reports as PDF output.

How can this be enabled?

A.

Modify the permissions for the generate PDF Output capability.

B.

Use Theme Manager to remove the generate PDF Output option.

C.

Create a role name “PDF output”, add the built-in entry group name “Everyone” and set the permission to Deny.

D.

Modify the file located in \templates\ps\system.xml, locate the line ”, and add the following attribute enabled=”false”.

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.

An administrator is attempting to import a backup of the entire Content Store into an existing Content Store.

What is an instance of when an object will be kept by the default conflict resolution rule?

A.

There are not any conflict resolution rules applied when importing the entire Content Store. All objects will be replaced.

B.

When the object is OUTPUT, GRAPHIC or PAGE and the CM.DEPLOYMENTKEEPERREPORTOUTPUT parameter is set to True.

C.

When the object is OUTPUT, GRAPHIC or PAGE and the CM.DEPLOYMENTUSERREPORTOUTPUT parameter is set to True.

D.

When the object is CACHEOUTPUT, SESSION or REPORTCACHE, REPORTMETADATACACHE or DEPLOYMENTDETAIL.

An environment has twenty dispatchers. The administrator wants to change one property to the same value for all dispatchers.

How can that be accomplished?

A.

This can be accomplished if all dispatchers are put inside a folder.

B.

This can be accomplished by changing the desired property for the configuration.

C.

This cannot be accomplished unless the property value is changed for each dispatcher.

D.

This can be accomplished by selecting all dispatchers at once and changing the desired property.

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.

Dispatcher: JVM: Current heap size

B.

ContentManageService: Request: Number of failed requests

C.

ReportService: Process: Number of processes high watermark

D.

BatchReportService: Request: Percentage of successful requests

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.

An administrator is checking the current activities and recognizes one activity with several successful tasks with two still running. The administrator cancels this activity.

Where will this activity be shown?

A.

In the past activities with status canceled.

B.

In the past activities with status succeeded.

C.

In the current activities with status canceled.

D.

It will be automatically rescheduled under upcoming activities.

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.

An administrator is implementing security by managing and working with the Cognos namespace.

Which statement is true?

A.

To gain access to IBM Cognos Analytics, users can log on to the Cognos namespace.

B.

Create domain users in the Cognos namespace to avoid cluttering the existing authentication provider.

C.

User-defined groups and roles must be created in a 3rd-party authentication provider and cannot be created in the Cognos namespace.

D.

Although the use of the predefined and built-in groups and roles within the Cognos namespace is optional, the Cognos namespace cannot be deleted.

Which attribute can an administrator enable to prevent malicious scripts from reading or manipulating the CAM passport cookie during a user’s session with their Web browser?

A.

cc_session

B.

userCapabilities

C.

Secure flag enabled?

D.

Enable CAF validation?

An administrator wants to implement load balancing without using an external load balancing mechanism.

What is one approach that can be used to achieve this?

A.

Set up a standby Content Manager.

B.

Install a gateway on each database server.

C.

Configure dispatchers together with the content stores.

D.

Configure gateways to direct all traffic to a dedicated dispatcher.

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

Which statement is true?

A.

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

B.

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

C.

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

D.

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

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.

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

Page: 1 / 1
Total 60 questions
Copyright © 2014-2025 Solution2Pass. All Rights Reserved