We're so confident of our products that we provide no hassle product exchange.
IBM Cognos Financial Statement Reporting Developer Sample Questions:
1. When setting up a Word object, what are three document types? (Choose three.)
A) Normal
B) Image
C) Footer
D) Table
E) Header
2. A user sets up a section with two objects. The first Word object is a footnote and the second object is an Excel table. Upon generation of the report, the Excel table appears right after the footnote. What should the user do to move the Excel table to a new page?
A) Change Break Type to New Page and set # Pages to 1.
B) Insert a Page Break at the end of the footnote 1 Word object.
C) Change Break Type to Blank Rows and set # Rows to 0.
D) Change Break Type to New Page and set # Pages to 0.
3. A client is ready to use the "Load Data" function and bring in data with a direct link to their source files. What are the data load menu options to do this?
A) OLAP Cube, Word File, Account Hierarchy, Excel File
B) Query Builder, OLAP Cube, and Relational Database
C) Query Builder, Account Hierarchy, Word File
D) OLAP Cube, Excel File, and Account Hierarchy
4. You want to connect to an external Excel file using the data load method.Which two selections should you perform to accomplish this? (Choose two.)
A) The range should contain links to multiple Excel spreadsheets and multiple workbook sheets outside of FSR.
B) The range selected should only contain what is needed for the report.
C) The range of numbers should be rounded at the source Excel file externally from FSR if possible.
D) The ranges should contain as many V-Lookup formulas as possible.
5. What are two ways to optimize report performance when dealing with variables? (Choose two.)
A) Use block variables rather than individual cell variables when pulling multiple items from one table.
B) Maximize the number of variables used rather than use Excel cell referencing where possible.
C) Ensure you are implementing chain linking.
D) Combine multiple validation checks within one ##R validation rule.
Solutions:
| Question # 1 Answer: A,C,E | Question # 2 Answer: A | Question # 3 Answer: D | Question # 4 Answer: B,C | Question # 5 Answer: A,D |
By Cornelia
