C2090-635 Online Practice Questions and Answers

How can a developer populate a level with a different data source column?

A. Through level properties.

B. Through column properties.

C. Through data source properties.

D. Through data source scope.

How can a developer include a key performance indicator that is unavailable in the Transformer data source?

A. Add a manual category.

B. Add a calculated measure.

C. Create a cube group.

D. Add a measure allocation.

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.

Transformer is unable to locate one of the source files for a data source in the model, and the model update fails. Which type of files can be used to restart the processing at the point of failure?

A. .py?

B. .qy?

C. .mdl

D. .mdx

Which of the following will help improve processing time when Transformer queries the data?

A. Use normalized structural data sources.

B. Separate structural and transactional information in multiple data sources.

C. Combine structural and transactionalinformation into one data source.

D. Define dimensions within a transactional data source with unique values.

What modeling factor affects the auto-partitioningstrategy and causes poor consolidation for partitioned categories?

A. Wide, flat dimensions

B. Well-balanced hierarchical dimensions

C. Allocated measures

D. After rollup calculated measures

How can a cube be built with data volumes that result in a .mdc file larger than 2 GB?

A. Set the MultiFileCubeThreshold value to zero.

B. Enable the creation of multiple local PowerCube files.

C. Remove the auto-partitioning scheme.

D. Use multiple checkpoint files.

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.