IBM Cognos Financial Statement Reporting Developer 認定 C2020-706 試験問題:

1. FSR has numerous ways to bring data into Excel objects into the Database tab.What are three valid methods? (Choose three.)

A) query variables
B) Excel file
C) Account Hierarchy
D) database query
E) OLAP cube

2. What are two ways to optimize report performance when dealing with variables? (Choose two.)

A) Combine multiple validation checks within one ##R validation rule.
B) Use block variables rather than individual cell variables when pulling multiple items from one table.
C) Ensure you are implementing chain linking.
D) Maximize the number of variables used rather than use Excel cell referencing where possible.

3. A company maintains inventory information in a relational database. Which three methods should the company use to extract data into FSR and into the inventory's Excel objects display area? (Choose three.)

A) Use the insert query function
B) Use variables to pass the data from the query results sheet to the display sheet
C) Use Excel cell referencing to pass the data from the query results sheet to the display sheet
D) Use Data Load to load the information
E) Use Query Builder to query the relational database forthe relevant inventories table

4. You want to start page numbers in a footer object after the front page and table of contents sections. How would you adjust the page number in the object to do this?

A) Use the Word Options Advanced field codes feature to adjust the number of pages between the front page and TOC from the page number.
B) Use the object feature to adjust the number of pages between the front page and TOC from the page number.
C) In the TOC, change the footer page number to zero.
D) Use the bookmarks feature to adjust the number of pages between the front page and TOC from the page number.

5. A client is loading data from an Excel spreadsheet but is not certain whether to enable the Allow query variables in the path and sheet name. What do you tell the client?

A) This feature needs to be used to be able to load an Excel sheet; if it is not selected, the user will receive an error when trying to complete the load.
B) This should never be enabled; it is not a supported function in the current version.
C) This feature will enable you to link data across reports.
D) This feature will provide a dynamic link to Excel source files during the rollover process.

質問と回答：