C2090-635 Online Practice Questions and Answers

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.

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.

When measures are calculated after rollup, when are the calculations performed?

A. Before time state rollup takes place.

B. After allocated measures are calculated.

C. Before regular rollup takes place on all measures.

D. After relative time calculations.

How can the cube build flexibility and performance be maximized?

A. Enable Consolidation.

B. Enable the AutoSummarize property.

C. Combine Structural and Transactional data into one data source

D. Preprocess the data.

Which of the following can be done to improve performance when dealing with large volumes of data?

A. Include multiple data sources.

B. Use a single large data source.

C. Include transactional and structural data sources of the same type.

D. Use Cognos 10 reports as transactional and structural data sources.

What can be done to apply member-based security if the model contains cube groups?

A. Define the security for each member cube.

B. Inherit the security that was used in the control cube.

C. Create a hierarchical custom view.

D. Create a descendant custom view.

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

The Region dimension is organized by Territory, Country, and City.Which option can be applied to only show data for the United States and its descendants?

A. Suppress

B. Apex

C. Summarize

D. Cloak

A dimension organizes all the regions by Country and City. Disregarding the hierarchicalorganization, how can the five best performing regions be grouped?

A. Create a scenario dimension.

B. Add an alternate drill-down path.

C. Add a special category.

D. Create a subdimension.

Which option decreases cube size by removing data from the cube?

A. Suppress

B. Summarize

C. Apex

D. Cloak