C2020-605 IBM Cognos 10 Controller Developer

Test information:
Number of questions: 94
Time allowed in minutes: 120
Required passing score: 65%
Test languages: English

Related certifications:
IBM Certified Developer – Cognos 10 Controller

This test will certify that the successful candidate has important knowledge and skills necessary to set up a Controller application by creating account and company structures, and set up the consolidation processes such as currency conversion, intercompany transactions, and investments in subsidiaries. The successful candidate must also be able to design and generate financial reports used for financial analysis.

Create Company Structures (5%)
Distinguish between the company types
Describe how consolidation types settings affect the company structures

Create Account Structures (12%)
Describe how reconciliation between accounts settings handles reconciliation of opening balances
Describe the effect of entering an investment code for an account
Describe a scenario for using movement accounts
Identify how to generate movement accounts
Describe the effect of using statistical and non-statistical account types for movement accounts
Identify how integrated and non-integrated movement accounts affect reconciliation
Describe the benefits of connecting extended dimensions to accounts

Set up General Configuration (14%)
Distinguish between weekly/daily actualities and linked actualities
Describe the effect of enabling the advance account view setting
Describe the benefits of using multiple submission
Describe the effect of enabling Set Status for Submission to Ready After Reconciliation
Distinguish between reconciliation made by Journal Type and Closing Version
Describe how the reporting status is affected by reconciliation settings Total Difference and Difference per Row
Using Method 1, distinguish between currency conversion differences account1 and currency conversion differences account2
Describe the impact of main settings and the reserves
Explain the impact of changing account type settings

Enable Data Entry and Data Import (19%)
Distinguish between different form types
Describe the purpose of forms sets
Describe the impact of using multiple submissions with form sets
Describe any of the functions of the Form Properties
Describe how to use linked structures to limit data entry view
Distinguish between using the data entry view and the Excel link to add data
Describe the process of adding movement accounts to forms
Describe a scenario for creating a link between forms
Identify the different structures that can be imported and the process
Identify the different ways that data can be imported into Controller
Describe the process of creating an import specification

Create Journals and Closing Versions (5%)
Define the relationship between journal type and closing version
Identify the two ways to enter data into company journals
Describe scenarios for copying journals from one period to another
Determine impact of adjusting data on group journals versus company journals

Prepare for Currency Conversion (11%)
Identify when rules for currency conversion are defined
Identify the workflow for converting foreign currency
Using currency conversion Method 1, identify the commonly used currency codes for P&L accounts, Balance Sheet accounts, and Equity accounts
Distinguish between the currency register and the historical register
Describe a scenario for entering historical rates when a company rolls up to several group currencies
Distinguish between currency conversion codes C and I when converting values for a company journal

Configure the Control Tables (9%)
Explain the purpose of acquisition control tables
Explain the purpose of intercompany elimination control tables
Identify the process for enabling automatic journal entries
Identify the impact of the offset account in control tables

Eliminate and Reconcile Intercompany transactions and acquisitions (10%)
Identify when counter dimensions are used
Identify the ways intercompany balances can be eliminated
Identify the effect of storing intercompany adjustments as group journals
Identify how to enter data in the investment register for subsidiaries and associated companies
Explain scenarios when no balance control would be used in the investment register
Describe the importance of defining a start period for acquisition calculations
Describe the ways to run reports for reconciling data reported as intercompany balances
Identify the impact of using Use Online Matching

Consolidate a Group’s Reported Values (5%)
Distinguish between consolidating by steps and consolidating by status
Identify the reports needed to analyze consolidation

Secure the Application and the Data (4%)
Describe the benefits of creating security groups
Describe the benefits of creating user rights
Describe how using period locking at a company level affects the closing version
Distinguish between locking the period for data entry only and locking the period entirely

Create Reports to Analyze Data (6%)
Identify the performance considerations when creating reports
Distinguish the benefits between creating a Report Generator report and an Excel Link report
Describe the Report Conversion functionality when creating user-defined reports in Controller

QUESTION 2
How can an administrator validate company structures to ensure that they meet the application’s
rules?

A. Verify Structures menu
B. Verify Companies menu
C. Company structure log file
D. Consolidation structures log file

Answer: A

Explanation:

QUESTION 3
An administrator created a company journal. The administrator then added several transactions to
the journal. The accounts in these transactions use currency conversion code I. By default, if there
is no amount for the previous year (no local amount or converted amount), what rate is used to
convert the local amount for the current year?

A. The previous year’s closing rate
B. The previous year’s opening rate
C. The previous year’s average rate
D. The previous year’s data is not used

Answer: A

Explanation:

QUESTION 4
What is the difference between currency conversion codes I and C?

A. Code I uses no currency conversion for the opening balance; code C copies prior year’s average rate.
B. Code C copies prior year’s average rate for opening balance; code I calculates prior year’s closing rate
C. Code I calculates opening balance rate, code C copies the opening balance amount.
D. Code C copies prior year’s average rate; code I uses prior year’s closing rate for opening balance.

Answer: C

Explanation:

Click here to view complete Q&A of C2020-605 exam
Certkingdom Review