C1000-065 Sample Questions Answers

Select "Allow web-based modeling" in Cognos Configuration when starting the server

Select "Allow web-based modeling" in the Cognos installer when upgrading the server components.

Under the Data Server Connection in the Administration Console configuration select "Allow Framework Manager".

Under the Data Source Connection in the Administration Console configuration select "Allow web-based modeling".

Local cache is only supported on batch re|

Data is cached and may improve performance.

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

The scalability of a report is negatively impacted.

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

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

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

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

Select "Attach the report" and leave the email body blank.

Select "Save report".

In the email body, choose "Display a report" and follow the dialog box instructions

Select "Include a link to the report’’

Ensure Enable bidirectional support is checked

Run with full interactivity is set to No

Enable drill up and drill down in the report output

Guided report layout is checked

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

Add the Data set to a Data Module.

Add the Data set to a Framework Manager package.

Add the Data set as a source on the report.

the ability to export the dashboard to Excel

the ability to generate the HTML to create an iFrame and reference the dashboard

the ability to export the dashboard directly to SharePoint.

the ability to send a notification to a phone

Average, Predictive Strength, Fit Line, Meaningful Difference and most frequent values

Average, Standard Deviation, Best Fit values

Average, Max and Min values

Top five and Bottom Five values

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

The 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).

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

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

Set the auto-sort property to maximum.

Set the detail aggregation to 'Calculated' for measures.

Avoid functions in filters.

Add more joins between queries.

when the data source is a dimensional or dimensionally-modeled data source

to allow relative date functions to be performed against a non-dimensional data source

to convert a non-dimensional data source into a dimensionally-modeled data source

to allow drill up and down on a non-dimensional data source

Measures and Dimensions can reside in the same query subject.

The DMR structures need to resemble the objects in the star schema.

The order of the Determinants drives the hierarchy levels.

Each level in a hierarchy must reference a text-based attribute for its caption.

reports with filters

models with outer joins and cross joins

queries with database only processing

an optimized metadata model

The widgets panel may contain an Image library tab that the administrator made available

Images may only be made available by URL reference.

Images can be uploaded to the Image through the upload option on the widgets panel.

Text widgets may only be positioned vertically or horizontally.

Conditional Reference

Label

Name

Render Variable