COG-310 Online Practice Questions and Answers

Which of the following examples will apply a rule to a subset of the Month dimension?

A. [{'Jan', 'Feb', 'Mar'\}]

B. ["Jan", "Feb", "Mar"]

C. ['Jan', 'Feb', 'Mar']

D. [('Jan', 'Feb', 'Mar')]

Some users would like to display an account using the account name followed by the account number. Other users would like to display only the account name.

Which option should the application developer use to satisfy both requirements?

A. Create a text attribute for each requirement.

B. Define an alias for each requirement.

C. Define two alternate hierarchies.

D. Create two dimensions that link to each other.

The application developer created a rule to apply to all elements in a dimension yet the result does not appear.

Which of the following would have caused this?

A. A rule impacting this dimension exists above it.

B. A rule impacting elements in this dimension exists above it.

C. A rule impacting this dimension exists below it.

D. A rule impacting elements in this dimension exists below it.

When an application developer adds new rules to a cube, which of the following statements should be added to the rules file to turn the fast consolidation algorithm on?

A. SKIPCHECK

B. STET

C. CONTINUE

D. FEEDERS

Which of the following rules should appear first in a rule file?

A. []

B. ['Gross Margin %']

C. ['Gross Margin %', 'January']

D. ['Gross Margin %', 'Total Year'].

An application developer would like to place a button on a template to run a process to upload data.

Which of the following can be used to do this?

A. Control toolbox

B. Data validation

C. Turbo Integrator

D. Action button

An application developer needs to provide dates in a number of formats in a cube.

Which of the following should be used to do this?

A. Create many time dimensions and use each accordingly.

B. Create a single time dimension with attributes for the formats.

C. Create many time dimensions and use them all in the same cube.

D. Create a single time dimension with rules in cubes to alter the appearance.

An application developer created a script to load data into a cube using the TI tabs. He needs to edit the script that will update the cells of the cube.

Which of the following TI scripts contains this function?

A. Prolog

B. Metadata

C. Data

D. Epilog

An application developer is creating a custom TI script and has selected no data source. Which of the following scripts will be available to the process?

A. Metadata and data

B. Prolog and metadata

C. Metadata and epilog

D. Prolog and epilog

An application developer must create a process to build subsets for a dimension and add elements from an ODBC source.

Which Turbo Integrator script should be used to update the subsets?

A. Epilog

B. Parameters

C. Prolog

D. Metadata

Once the budget is complete, the final version must be moved from the budgeting cube into a read-only reporting cube.

Which of the following data sources should be used in the TI process to move this data?

A. ODBC

B. ODBO

C. Excel Worksheet

D. TM1 View

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.

Which of the following variable types must be defined for a variable to be used for a simple or consolidated element?

A. String

B. Numeric

C. Other

D. Ignore

When using TI to import data, each column in the source is assigned to which of the following?

A. Content

B. Map

C. Formula D. Variable

An application developer needs to know the last time the Sales Forecast cube was updated. The cube file, including the date and time stamp, can be found in which of the following locations?

A. In the data directory.

B. In the data file.

C. On the web server.

D. On the admin server.