C2090-635 Online Practice Questions and Answers

When the model contains two data sources that provide date values, how can the developer avoid ambiguity whenTransformer sets the current time period?

A. Disable the data source's ability to set the current time period.

B. Assign the current date (obtained from the system clock) as the current period.

C. Let Transformer assign the date closest to the model'screation date as the current period.

D. Enter the initial current period and adjust it to match the system date and time.

What must be done to make the cube data available in Analysis Studio?

A. Use the PowerCube Connection Utility to publish thecube.

B. Create a data source connection to the cube in Transformer.

C. Publish the PowerCube as a data source and a package.

D. Generate a package that contains a data source connection to the cube.

Senior Managers need to see total and regional sales figures, but Regional Managers should see relevant figures for only their regions. Where can the developer specify the degree of detail to be included?

A. Ina manual level

B. In a cube group

C. In the PowerCube

D. In a scenario dimension

How can a developer customize the reporting period so that the year has 52 weeks, with 7 days in each week, yielding 364 days?

A. Set up a lunar time period.

B. Set up a time period based on a calendar year.

C. Set up a time period based on fiscal year.

D. Set up a relative time category.

How can the parent-child relationship for each category be established?

A. Verify the model.

B. Insert manual levels.

C. Show category counts.

D. Generate the categories.

The developer notices a decrease in run-time performance in a model that has calculated measures (before rollup). Because auto-partitioning is not used, how can the developer increase performance?

A. Use a duplicates rollup instead of a before rollup setting.

B. Use an external rollup instead of a before rollup setting.

C. Use calculated columns instead of before rollup measures.

D. Use atime state rollup instead of before rollup setting.

Where should fact queries against OLAP sources come from?

A. A flat file

B. An .iqd file

C. A Cognos 10 report

D. A Cognos 10 package

To add dimensional data to an existing model, how can metadata be leveraged from other published OLAP packages?

A. Insert an OLAP package in the data source list.

B. Import a PowerCube as a data source.

C. Add dimensions from an OLAP package in the dimension map.

D. Add a data source query using a Cognos 10 OLAP report.

What could be done if the report does not run after the category codes change?

A. Rebuild the cube and publish a new package.

B. Perform a Clean House.

C. Modifythe report to point to the updated member.

D. Manually change the category codes within the model.

How does a developer associate a custom view with a PowerCube?

A. Update the Powercube properties.

B. Specify the path of the Powercube in the custom view.

C. Specify the packagename in the custom view.

D. Drag the custom view to the appropriate Powercube.

What can be created if the financial analyst wants to look at the data by fiscal year, while the senior manager wants to analyze the data by calendar year?

A. An alternate hierarchy in the time dimension.

B. A subdimension in the time dimension.

C. A special category.

D. A calculated category.

What can a developer set up to analyze actual, planned, and forecasted budget information that do not rollup into a single root category?

A. Scenario dimension

B. Calculated category

C. Special category

D. Exception dimension

A developer created a cube for each regional Sales Manager. Each cube shouldcontain only the transactional details for each Sales Manager's region, as well as the summarized values for other regions. What should be created?

A. Custom view

B. Cube group

C. Apexed view

D. Suppressed view

What can be created to determine the monthly growth showing the percentage of change between Current Month and Last Month for all measures included in the PowerCube?

A. Calculated columns

B. Calculated categories

C. Calculated measure

D. Alternate hierarchies

What can be done in a manual level to keep new data separate until it can be connected to the appropriate parent category?

A. Create an orphanage category.

B. Create a special category.

C. Include categories when needed.

D. Prohibit automatic creation of new categories.