IBM C2020-635 Online Practice Questions and Exam Preparation

IBM C2020-635 Online Questions & Answers

• Question 1:

  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.
  A. Set up a lunar time period.

• Question 2:

  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.
  B. Separate structural and transactional information in multiple data sources.

• Question 3:

  What does a unique move ensure when applied to a level in a dimension map?

  A. The measure values are not rolled up to the new path of the moved categories.
  B. The category can bemoved to another level.
  C. The developer must manually restructure the categories in the dimension.
  D. The category moved within the level has its data history moved with it.
  D. The category moved within the level has its data history moved with it.

• Question 4:

  What can be done if a regular time dimension is added to a model, and the levels Year, Quarter,and Month are not automatically generated?

  A. Set the date input format for the time dimension.
  B. Set the data class of the source category to Date.
  C. Change the numeric time sequence for each level.
  D. Create a non-standard time dimension with thenew levels.
  B. Set the data class of the source category to Date.

• Question 5:

  How can a developer rebuild an incrementally updated cube?

  A. Enabletime-based partitioning and rebuild the cube.
  B. Clean house and rebuild the cube.
  C. Save the model, and revert to the backup .mdl file.
  D. Delete the old .mdc file and recreate the entire cube.
  D. Delete the old .mdc file and recreate the entire cube.

• Question 6:

  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.
  A. Define the security for each member cube.

• Question 7:

  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.
  A. Disable the data source's ability to set the current time period.

• Question 8:

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

  A. Suppress
  B. Summarize
  C. Apex
  D. Cloak
  C. Apex

• Question 9:

  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.
  C. Publish the PowerCube as a data source and a package.

• Question 10:

  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
  B. Exception dimension