IBM C1000-065 Exam Practice Test Instant Access

Question 1

Which technique is most likely to improve query performance?

ASet the auto-sort property to maximum.

BSet the detail aggregation to 'Calculated' for measures.

CAvoid functions in filters.

DAdd more joins between queries.

Answer : B

Question 2

When developing a report, which two should be defined for a JOIN query?

Aa reference to two queries

Bonly cached results

Can expression editor

Dan intersection of two queries

Ea relationship defining cardinality

Answer : A, D

Question 3

In a report, which of the following is true when enabling the local cache property on a query?

ALocal cache is only supported on batch re|

BData is cached and may improve performance.

CA complete result set is cached for all queries in the model.

DThe scalability of a report is negatively impacted.

Answer : A

Question 4

Which two items can the opposite edge Crosstab in a report?

AThe value of a member

BA selected measure

CMember caption

DNode member

ECrosstab intersection

Answer : C, E

Question 5

Which statement is true when formatting text in a dashboard crosstab or table?

ATable summary row may be formatted with a different color.

BColumn formatting gets inherited for the table/crosstab summary row.

CColumn titles may be individually formatted in any font/color/size.

DThe default object does not wrap text, but it is an option.

Answer : D

Question 6

Which is true about creating a context filter for a crosstab report using a dimensional data source?

Ait changes the measure values and the items in the rows and columns

Bit is applied after aggregation and changes the rows and columns

Cit changes the measure values and suppresses zeros

Dit filters only the measure values, not the items in the rows and columns

Answer : C

Question 7

To create a Layout Component Reference in a report, which object property needs to be provided?

AConditional Reference

BLabel

CName

DRender Variable

Answer : C

IBM C1000-065 IBM Cognos Analytics Developer V11.1.x Exam Practice Test