IBM C1000-065 Exam Practice Test Instant Access

Question 1

In a Data Module a developer creates a joined view from two tables (a and b) and then joins this to another table (c). What would be the execution logic in the database?

AAll queries are collapsed and a standard join across all three tables (a, b, c) is performed.

BThe columns used in table (c) are are joined on the key to table (b) first and then the results are post-joined to table (a).

CIt makes no difference to the execution as a joined view is only used to group data items in a logical manner to help the business user find their data.

DThe joined view (a and b) is evaluated and all results are then post-joined to the other table (c).

Answer : D

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

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

In which two ways can a specific visualization in a dashboard be filtered?

AA developer can only keep or exclude data points within an axis.

BA developer can create a Calculation within the dashboard that will filter a specific visualization.

CA developer can also add a local filter to filter a column or to define a filter condition.

DA developer can build an embedded filter in a data module.

EA developer can keep or exclude a few data points in the visualization.

Answer : A, B

Question 6

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 7

Where does a developer change which package is marked as the default package in a report?

Aon the package properties

Bon the query properties

Con the context menu for a package

Don the report properties

Answer : D

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