IBM C2090-621 Exam Questions Instant Access

Question 1

A report author has applied one style in specific cells, and another style for the overall report.

Which style will be applied?

AThe style on the specific cell is applied.

BThe style on the overall report is applied.

CThe last style in the Conditional styles property is applied.

DThe first style in the Conditional styles property is applied.

Answer : C

Question 2

A report author would like to create multiple variable connections in a report that contains one control and two Lists in order to compare data.

Which statement is true?

AIt is not possible to create two connections unless there are two different controls and two Lists.

BThe report author should be able to create two connections only if the values have the same data type.

CThe report author should be able to create one or more connections but the variable's Behavior should be the same.

DThe report author should be able to create multiple connections on one control by creating new connections, both variables can also show different Behavior.

Answer : D

Question 3

A report contains multiple queries that are joined to form the report, resulting in poor performance. The company's policy prohibits the use of user-defined SQL statements within reports.

What should be done to improve report performance?

AConvert the report to use Native SQL statements.

BMove the appropriate filters to the underling queries.

CChange the Cross Product allowed property to be ''Deny''.

DModify the Query Execution method to Concurrent to ensure that the underlying queries run at the same time.

Answer : D

Question 4

A business manager wants to set the current Dashboard as the home page.

Which mode allows this task?

ARun

BView

CPriority

DReview

Answer : B

Question 5

A report author is using the Quantity fact data item multiple times in a list report. The desired outcome is to prevent double counting and provide predictable results.

From which location should the additional Quantity fact data be selected?

AQuery tab

BSource tab

CData Items tab

DPage explorer tab

Answer : C

Question 6

When using a SQL object, what is the property SQL syntax by default?

ANative

BIBM Cognos

CLimited Local

DPass-Through

Answer : A

Question 7

What can be done when using a SQL object when not using a stored procedure?

AUpdate a database.

BInsert rows into database.

CDelete rows in a database.

DSelect rows from a database.

Answer : A

IBM Cognos Analytics Author V11 C2090-621 Exam Questions