C1000-065 Online Practice Questions and Answers

A Framework Manager model may be designed to incorporate Dimensionally Modeled Relational (DMR) objects, designed to offer the end user OLAP behavior when navigating dat

A. Which of the following statements is valid when designing DMR structures in Framework Manager?

B. Measures and Dimensions can reside in the same query subject.

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

D. The order of the Determinants drives the hierarchy levels.

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

After upgrading from Cognos version 10 what needs to be selected in order to create a data module on a data server?

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

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

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

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

When Insights are turned on what are all of the generated outcomes, depending on the visualization selected ?

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

B. Average, Standard Deviation, Best Fit values

C. Average, Max and Min values

D. Top five and Bottom Five values

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

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

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

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

D. There is no advantage and multidimensional query constructs should be avoided.

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.

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

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

A dashboard developer notices that Age is available in the sourced data module. A request has been made to 'bucket' those age values into 5 groups, Ages 0-6, 7-12, 13-21, 22-55, and 55 and over. How would one define this logic in the source data module?

A. set range values in the data module

B. use the Create new table feature

C. select the Age column, and select Create data group

D. define a Case..When calculated attribute in the dashboard

After adding a prompt to a relational sourced report it is decided that the consumers require multi- select functionality instead of a single-select. What two modifications must be made to the report?

A. Change the Filter property Multi-select to Yes

B. Change the Cascade source property of the Prompt to represent more than one value.

C. Change the Prompt property Usage to Select-many.

D. Change the Filter expression of the Query from "=" to use "in".

E. Change the Prompt property Multi-select to Yes.

Which dashboard formatting option would be used to take several images and text objects and combine them into one object to enable ease of movement and/or alignment?

A. Group objects

B. Layer objects

C. Combine objects

D. Pack objects

How might a report output type of PDF be secured?

A. by setting a password in the schedule PDF options

B. by giving the PDF a name that starts with "confidential'

C. by selecting the "Secure this Report" option in the report properties

D. by specifying a PDF encryption code in the schedule settings

How does Dynamic Query Analyzer assist in troubleshooting?

A. troubleshooting Data Modules

B. analyzing Dynamic Reports

C. analyzing packages that have Dynamic Queries

D. providing graphical representations for the query logs produced by DQM queries

A developer has nested two non-measures in a Column visualization in a dashboard. How would the developer manually order the columns to get the column order to show properly?

A. Use automatic sorting.

B. Uncheck sort automatically, and drag the columns to the correct order.

C. Select Sort remaining items by Auto.

D. Use custom sorting.

Which statement is true when formatting text in a dashboard crosstab or table?

A. Table summary row may be formatted with a different color.

B. Column formatting gets inherited for the table/crosstab summary row.

C. Column titles may be individually formatted in any font/color/size.

D. The default object does not wrap text, but it is an option.

Which two items can the opposite edge Crosstab in a report?

A. The value of a member

B. A selected measure

C. Member caption

D. Node member

E. Crosstab intersection

Which technique is most likely to improve query performance?

A. Set the auto-sort property to maximum.

B. Set the detail aggregation to 'Calculated' for measures.

C. Avoid functions in filters.

D. Add more joins between queries.

A developer may improve the look and feel of a dashboard or story by adding images and shapes from the Widgets panel. Which statement is true when adding widgets to a dashboard?

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

B. Images may only be made available by URL reference.

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

D. Text widgets may only be positioned vertically or horizontally.