COG-310 Online Practice Questions and Answers

Which of the following is the best location to calculate a formula once a month, when the data is updated?

A. Rule

B. Hierarchy

C. Turbo Integrator

D. Relational Database

Which of the following functions can be used in rules to share data across cubes?

A. IF

B. DB

C. Continue

D. STET

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.

Which of the following rules should be fed?

A. []=C:'Price'*'Cost';

B. []=N:'Price'*'Cost';

C. []=S:'Price*Cost';

D. []=C:'Price'/'Cost';

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

When creating a drill assignment rule, what kind of rule must it be?

A. String

B. Simple

C. Consolidated

D. Leaf

Which of the following spreading methods may use a lookup cube as the basis for the spread?

A. Proportional

B. Repeat

C. Percent change

D. Relative proportional

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.

Why would an application developer use multiple time dimensions in a cube?

A. Users need to forecast sales for the next quarter.

B. Users need to estimate future inventory needs for the year.

C. Users need to anticipate units sold of a new product line.

D. Users need to create financial statements for last year.

Which of the following scripts should be used to create a new dimension?

A. Metadata

B. Data

C. Parameters

D. 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

Why would an application developer create a formula in a variable?

A. To write data to a data source.

B. To delete data from a data source.

C. To combine two columns from the source.

D. To remove two columns from the source.

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.

Why would an application developer apply a numeric attribute to an element?

A. To store a numeric code for the color of a product.

B. To display the account number instead of the account name.

C. To display the values in an alternate format.

D. To store the square footage of a store for capacity planning.

Data is loaded into cells in a cube. A cell is identified by the intersection of items from which of the following objects?

A. Attribute

B. Subset

C. Dimension

D. Slice