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

To display HTML report output directly in the body of an emailed report, which of the following is required in the delivery options pane?

ASelect 'Attach the report' and leave the email body blank.

BSelect 'Save report'.

CIn the email body, choose 'Display a report' and follow the dialog box instructions

DSelect 'Include a link to the report''

Answer : C

Question 7

The default output Format for a report may be set on which of the following two items?

AQuery

BVisualization

CReport

DReport Folder

EReport View

Answer : A

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