COG-310 Online Practice Questions and Answers

Why would an application developer assign a negative weight to an element in a dimension?

A. To store credit balances without a negative sign.

B. To provide an alternate drill down path to the dimension.

C. To display data in different formats.

D. To store data in multiple hierarchies.

Which of the following element types identifies the lowest level in a dimension hierarchy?

A. String

B. Attribute

C. Consolidation

D. Simple

The sales report needs to use the current price of cars in the pricing cube in order to calculate the current revenue in the sales cube.

Which of the following should the application developer use to create this calculation so that it is continuously updated?

A. VBA

B. Rules

C. Microsoft Excel

D. Turbo Integrator

Why would an application developer use a DB () function in an internal cube reference?

A. To nest another function into it.

B. To format data in a cube.

C. To clear data in a cube.

D. To display an alias.

Aggregation is automatically applied when building a dimension. Which of the following option is the basis for aggregation?

A. Formats

B. Rules

C. Attributes

D. Hierarchies

An application developer would like to modify a TI process created to build a dimension using an ODBC data source. Logical statements must be added to the Metadata script.

What must be done to this process before modifying the scripts?

A. Copy the statements inside the generated statement area.

B. Copy the statements below the generated statement area.

C. Copy the statements to the Data tab.

D. Copy the statements to the Prolog tab.

When should an application developer turn on Enable Cube Logging in a Turbo Integrator process?

A. When a cube is created.

B. When changes are made to a cube.

C. When changes are made to a script.

D. When a script is created.

Why would an application developer define the contents of a variable as other?

A. Because the variable will not be used in the script.

B. Because the variable will map to a dimension.

C. Because the variable will be used in a function.

D. Because the variable will not be used in a function.

An application developer needs to update dimensions and then load data into a cube during off hours. Which of the following options can be used for this?

A. Chores

B. Rules

C. Conversion

D. Worksheets

Which of the following attributes can be used to display element names in multiple languages?

A. Text

B. String

C. Alias

D. Format