C2090-635 Online Practice Questions and Answers

A developer added a manuallevel in the time dimension. During category generation, the developer gets a warning that Transformer is not able to relate the categories to the parent levels. What must be done to ensure Transformer relates the categories correctly?

A. Specify a date function for each level.

B. Specify date input format.

C. Specify an Invalid Dates category.

D. Specify a time-state rollup.

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.

How can a developer best address valuesthat are being rounded excessively?

A. Adjust the number of decimal places.

B. Create a calculated measure.

C. Modify the rollup operations.

D. Assign scale and precision settings.

For performance reasons, what is thebest parent-child ratio for categories in each level?

A. 1:10 or less

B. 1:11 or more

C. 5:1 or less

D. 10:1 or more

What can the developer specify for the cube build to use multiple directories to generate temporary work files?

A. Log files

B. Model temporary files

C. Operating system page file

D. Data temporary files

As a good practice, what can a developer do to be prepared in case a model develops conflicts or becomes corrupt?

A. Keepa backup .mdl file.

B. Keep a backup .py? file.

C. Keep a backup qy? file.

D. Keep a backup .py? and qy? files.

To control access to content for users that have similar responsibilities and privileges,where should security be applied?

A. Data source

B. Role

C. User

D. Namespace

When there are too many childcategories, what can be created to allow intermediate groupings?

A. A cube group

B. An alternate drill-path

C. A manual level

D. A subdimension

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 provide newinsight into the data if Margin Ranges are defined as Low, Medium, and High, based on a calculated column using the revenue and cost columns?

A. Scenario dimension

B. Exception dimension

C. Special category

D. Calculated category