IBM C1000-065 Exam Practice Test Instant Access

Question 1

Which of the following is done for a report to use a Data set as a data source?

AAsk the administrator to add the file as an external data source.

BAdd the Data set to a Data Module.

CAdd the Data set to a Framework Manager package.

DAdd the Data set as a source on the report.

Answer : A

Question 2

What benefit does the Cognos Analytics integration with Jupyter Notebooks provide a developer?

AWeather data can be used from the Jupyter service to enrich information and help identify trends Example: Ice cream sales on sunny days.

BA Developer can augment Cognos Analytics with Python and data science libraries as well as embed output in a dashboard to provide the end user with greater insight.

CA Developer can add notes to content to better describe to an end user what data is available and how calculations work.

DCognos Analytics does not integrate with Jupyter Notebooks.

Answer : D

Question 3

What is the significance of 'Clothes' in the following filter expression of a report query?

[Product Group] = # sq( prompt( 'productgroups', 'token', 'Clothes' ) )#

A'Clothes' is the default text to include in the generated query at runtime.

BThe string 'Clothes' will precede the text of the prompt value selected at runtime.

CThe string 'Clothes' will be appended to the end of the text of the prompt value selected at runtime.

D'Clothes' is a required value to include in the generated query at runtime.

Answer : C

Question 4

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 5

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