IBM Cognos 10 Planning Application (COG-700) Free Practice Test

Question 1

An administrator has created an access table in the Contributor Administration Console and an access level of NO DATA has been specified for several D-List and e.List item combinations. What effect will this access level have?

A. The D-List items will be deleted from the Contributor slice for the specified e.List items.

B. The D-List items will be downloaded to the Contributor Web grid but will be read-only.

C. The D-List items will be downloaded to the Contributor Web grid and will be available to all users.

D. The D-List items will be downloaded to the Contributor Web grid but will not be visible to users.

Correct Answer: A

Question 2

An application has multiple Access Tables that use different dimensions. The dimensions apply to the same cube. When the Access Tables are resolved, what level of access will the planner get?

A. Multiple Access Tables cannot be applied to the same cube.

B. The most restrictive level of access defined amongst all the Access Tables.

C. The access level will be determined by the order of the Access Tables.

D. The least restrictive level of access defined amongst all the Access Tables.

Correct Answer: B

Question 3

A D-Cube calculates monthly revenue by product. Revenue for a product is equal to the unit sale price multiplied by the quantity sold. If the modeler is applying a weighted average to the Unit Sale Price item, which should be used for the weighting?

A. Number of products

B. Number of months

C. Revenue

D. Quantity sold

Correct Answer: D

Question 4

Which of the following statements concerning the configuration of Attached Documents, and when it takes effect, is true?

A. The Development area of a specific application under Web Client Configuration, Application Options and does require a GTP in order to take effect.

B. The Web Client Settings tab in the System Settings area and does require a GTP in order to take effect.

C. The Production area of a specific application under maintenance, Commentary and does not require a GTP in order to take effect.

D. The Web Client Settings tab in the System Settings area and does not require a GTP in order to take effect.

Correct Answer: C

Question 5

The items in the Products D-List contain product names with their respective codes (such as 012 Star Dome). The file used to create this D-List has been updated to include new names for some of the products (such as 012 Solar Dome). When running the import link, which settings must the modeler define to replace old names in the D-List with new names while retaining manually entered subtotals and existing D-Cube data?

A. Use the Append import mode and select "remove obsolete items"

B. Use the Update import mode and select "remove obsolete items"

C. Use the Append import mode and define unique names

D. Use the Update import mode and define unique names

Correct Answer: D

Question 6

A modeler wants to create a D-List that contains all of the sales channels used by the company. These sales channels are currently listed in a Report Studio report that is available to all users. What is the most efficient way for the modeler to create this D-List?

A. Import from ODBC

B. Import from Another D-List

C. Import from Mapped Ascii-files

D. Import from IBM Cognos package

Correct Answer: D

Question 7

What will happen if a user clicks the Transpose button on the toolbar when a D-Cube is open in Analyst?

A. All D-Lists are reoriented to appear as they did when first opened

B. The D-List on columns is exchanged with the first D-List on pages

C. The D-List on rows is exchanged with the D-List on columns

D. The D-List on rows is exchanged with the first D-List on pages

Correct Answer: C

Question 8

Why would an administrator publish data to a table-only layout, instead of a view layout?

A. The administrator wants to publish the data to an Oracle database.

B. The administrator wants to publish only detail (non-calculated) plan data.

C. The administrator wants to publish the data to a SQL Server database.

D. The administrator wants to use the published data with the Publish to Cognos Metrics Manager extension.

Correct Answer: B

Question 9

A modeler wants to create a macro for a complex process that includes many different tasks. How should the macro be created if the modeler wants to notice errors right away?

A. Use the Macro Wizard option

B. Use the Trace Macro option

C. Use the Macro Run option

D. Use the Macro Record option

Correct Answer: D

Welcome to TestSimulate

IBM Cognos 10 Planning Application (COG-700) Free Practice Test