IBM C1000-065 Exam Practice Test Instant Access

Question 1

In an Exploration 'Data relationships' view, what does the thickness of the lines between data items represent?

Athe statistical strength of the relationship between the data items

Bthe flow of information between categories, ie. money transfers between countries

Cthe cardinality of one data item when grouped by another, ie. thicker signifies more unique values

Dthe weighted average of each measure value compared with other measures
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ca_explorations.doc/ca_explore_relationship_diagram.html

Answer : A

Question 2

To change the text item in a list column title or the data in the column body of a list object in a report, what first needs to happen?

ASelect the cell and change the data format.

BClick on the Lock Page Objects icon to unlock the report.

CSelect one of the cells and from the menu click Select Columns Style or Select Columns body style.

DSelect the cell and change the Box Type to None.

Answer : C

Question 3

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 4

Which two of the following statements are true when creating a Drill-through for a visualization in a dashboard?

AA developer can create Drill-throughs to a specific story that is created.

BA developer can create a Drill-through to a Webpage.

COne can pass selected data points to the target Drill-through as long as its data source uses the same values.

DA developer can create Drill-throughs to other dashboards and reports.

EEach visualization can only have a single Drill-through.

Answer : C, D

Question 5

A developer can make a Cognos PowerCube available to end users by creating a package and publishing it. From which three components is this possible?

AAdministration console

BPowerPlay Client

CPowerPlay Studio

DFramework Manager

ETransformer

FMicrosoft Studio
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cra.doc/c_powercubes_ds.html

Answer : A, D, E

Question 6

What advantage does multidimensional report writing have on query maintenance for complex queries?

AThere is no need to use calculations as the data source contains all the required data items.

BFewer queries are required and the need for unions of queries is reduced due to the flexibility of MDX.

CUnions and Joins are always required for queries making it easier for a developer to understand the query intent.

DThere is no advantage and multidimensional query constructs should be avoided.

Answer : B

Question 7

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

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