Best IBM COG-706 Exam Questions for Free, Download the Latest COG-706 Dumps, Practice Test and Study Guide
Enjoy Free IBM COG-706 Exam Questions. Download the Best COG-706 Cheat-Test Sample Questions.
Version: 8.5 Release Date: May, 2012
Q: 1
The report team finished their first draft of their report and now they would like to send a snapshot
of this report for review. How would a user create a snapshot?
A. Use the "Create Snapshot" icon.
B. Generate the entire report and check the "Save as Snapshot" option.
C. Every time a user saves, FSR will automatically create a new snapshot.
D. Go to Tools > Snapshots, then select the "Save as Snapshot" option.
Answer: B
Q: 2
A user created a snapshot of a report. Now they would like to send this snapshot for approval.
How would a user view the snapshot that was created?
A. Use the "View Snapshot" icon.
B. Go to Tools > Snapshots.
C. Go to Administration > Resources > View Snapshots.
D. Right-click on the Section Pane and select View Snapshots.
Answer: B
Q: 3
You have the administrator role and want to give a user special administrative tasks. Which three
tasks can be granted to the user role by the administrator? (Choose three.)
A. Add query to Excel.
B. Modify properties of an object.
C. Create sections for the report.
D. Audit report.
E. Assign tasks to user.
Answer: A,B,D
Q: 4
The "Select the custom group to display" dropdown list in the Select Report dialog allows a user to
filter the objects that will display when a report is loaded. How can this be enabled for a user?
A. in the Tools > Report Setup window
B. on the user's machine, a configuration key will need to be added to the FSR configuration file
C. in the Task Permissions list in the Users table
D. in the Report Summary node of the report
Answer: B
Q: 5
An administrator is working on a quarterly report and needs to add the new custom group
"Q2/Q3". Where can the administrator add this new group?
A. in the "Customized Group" table under Administration > Resources
B. in the Report Summary node of the report
C. in any FSR object of the report, open the "Set Customized Group" icon and add a new group to
the list
D. the custom group is added to the workflow for the object
Answer: A
Q: 6
A user has certain objects tagged as custom group "Q1", but they should be tagged as "Q2/Q3"
only. How can this be resolved?
A. In the Status by Object table in the Report Summary node, highlight the objects and change the
group from "Q1" to "Q2/Q3".
B. Select the objects in the Section Pane, right-click, and select "Q2/Q3".
C. Navigate to each individual object, click on the "Set Customized Group" icon, deselect "Q1" and
select "Q2/Q3" from the list.
D. Navigate to each individual object, click on the "Set Customized Group" icon and select "Q2/Q3'
from the list.
Answer: C
Q: 7
What are two functions of a user role? (Choose two.)
A. Generate selected sections.
B. Create a workflow.
C. Work on assigned objects.
D. Create a report.
Answer: A,C
Q: 8
A company compiled its 2010 Q2 quarterly report using an OLAP data source and a query variable
for the quarter. They are now performing a rollover from the 2010 Q2 quarterly report to the 2010
Q3 quarterly report. How do you ensure that the OLAP connection for the new Q3 quarterly report
will be updated with data from 2010 Q3?
A. Change the value for the quarter query variable from Q2 to Q3.
B. Update the value of the quarter field in the OLAP connection to Q3.
C. Change the ##S variable for the quarter to Q3.
D. Change the ##R variable for the quarter to Q3.
Answer: A
Q: 9
To use a workflow rule, which two variables are required to be set up? (Choose two.)
A. ##WRI
B. ##IRS
C. ##WR
D. ##WS
Answer: C,D
Q: 10
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 should never be enabled; it is not a supported function in the current version.
B. This feature will provide a dynamic link to Excel source files during the rollover process.
C. This feature will enable you to link data across reports.
D. 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.
Answer: B
Q: 11
Validation rules that are created to reconcile the numbers throughout the report automatically bring
a report validation screen upon the generation of the entire report. What is another way by which a
user can verify the validation of an FSR report?
A. The users can select Tools > Validate Report.
B. The users can navigate to the report setup for the validations.
C. The users can click on Tools > Reference Variables.
D. The users can navigate to the report summary window to validate the report.
Answer: A
Q: 12
Click the Exhibit button.
When using the FSR data load methods for an Excel file the cursor must be within the Database
tab within the Excel object. If an existing data link exists, which selection on the FSR toolbar
shown in the exhibit should be selected to edit this data link completely?
A. A
B. B
C. C
D. D
Answer: D
Q: 13
A user is creating a chart in FSR and referencing it using a bookmark. What is the naming
convention for the bookmark?
A. the WordObjectName and the name of the variable (e.g., WordObjectName_VariableName)
B. the ExcelObjectName and the name of the worksheet (e.g., ExcelObjectName-SheetName)
C. the WordObjectName and the name of the chart (e.g., WordObjectName_ChartName)
D. the ExcelObjectName and the name of the worksheet (e.g., ExcelObjectName_SheetName)
Answer: D
Q: 14
A client has started to load data from an OLAP cube through the "Load Data" function. The client
wants to use query variables in the "Year" dimension. Which statement is correct?
A. Check on the allow query variables, input the variables into the file path.
B. Query variables are automatically added when connecting to an OLAP cube.
C. Query variables are added and edited in the OLAP data wizard.
D. Ensure that the query variables are not checked when selecting data from an OLAP cube.
Answer: C
Q: 15
What are two section level variables available in FSR? (Choose two.)
A. Note Left (##NL)
B. Block Variables
C. Note Variables
D. TOC Heading Variables
Answer: C,D
Q: 16
FSR has numerous ways to bring data into Excel objects into the Database tab.What are three
valid methods? (Choose three.)
A. OLAP cube
B. database query
C. Excel file
D. Account Hierarchy
E. query variables
Answer: A,C,D
Q: 17
A user has created a ##S variable called Netincome for net income in the Statement of Operation
object. In a separate Excel object, ##D was used to retrieve the number. However, after saving the
object, the ##D value is not populated. What are three reasons why this is happening? (Choose
three.)
A. ##D is placed within the ##RS/##RE range.
B. ##D Netincome was used.
C. ##s and ##d were used.
D. The user did not refresh data.
E. ##S Netincome was used at the source.
Answer: A,C,D
Q: 18
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 selected should only contain what is needed for the report.
B. The ranges should contain as many V-Lookup formulas as possible.
C. The range should contain links to multiple Excel spreadsheets and multiple workbook sheets
outside of FSR.
D. The range of numbers should be rounded at the source Excel file externally from FSR if
possible.
Answer: A,D
Q: 19
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, Excel File, and Account Hierarchy
B. Query Builder, OLAP Cube, and Relational Database
C. OLAP Cube, Word File, Account Hierarchy, Excel File
D. Query Builder, Account Hierarchy, Word File
Answer: A
Q: 20
Click the Exhibit button.
You want to edit the source of the data using the data wizard. In the exhibit, which selection on the
FSR toolbar should be selected?
A. A
B. B
C. C
D. D
Answer: D
Q: 21
When sourcing data using Excel data sources, which two methods should you use? (Choose two.)
A. Create a master load Excel object and use block variables to distribute the block variables to
their specific Excel objects.
B. Create a separate data link for each Excel object to an external Excel spreadsheet.
C. Use copy and paste.
D. Manually key in the data.
Answer: A,B
Q: 22
An end-user at a company is concerned about the validity of the amounts throughout the report.
Within FSR, which rule can be used to reconcile the accuracy of the numbers in the report?
A. The user can create a workflow rule to ensure that the numbers match in the report.
B. The user can create a validation rule to verify the accuracy of the amounts in the report.
C. The checks must be performed manually by the user.
D. The user can use the audit trail feature to reconcile the numbers in the report.
Answer: B
Q: 23
A company is using a load data method to access live data from their Excel spreadsheet located
on a network drive. To distribute data throughout the report, which two would be used? (Choose
two.)
A. ##S/##D
B. Import
C. Excel cell reference
D. ##SL
Answer: A,C
Q: 24
A company is preparing a presentation in PowerPoint. Which three can be exported to
PowerPoint? (Choose three.)
A. table
B. reference variables
C. charts
D. section note variables
E. TOC headings
Answer: A,B,C
Q: 25
Why are OLAP variables used in FSR?
A. OLAP variables can be defined globally for a given report and once applied, data loads will be
automated each time Refresh Data is selected.
B. OLAP variables can be defined globally for a given report and once applied, query variables
can fully automate the roll forward process.
C. OLAP variables can be defined locally within a given object and once applied, data loads will be
automated each time Refresh Data is selected.
D. OLAP variables can be defined locally within a given object and once applied, queries can fully
automate the roll forward process.
Answer: B
Q: 26
A user needs to create a chart for the company's annual report. Which statement is correct?
A. Use a PowerPoint object with the chart copied and pasted from an external source.
B. Use an Excel object with the chart and a ##S variable referencing to the chart and a separate
Word object with ##D to retrieve the chart.
C. Use an Excel object with the chart and a Word object with a bookmark referencing the chart.
D. Use an Excel object with the chart using ##RS and ##RE around the chart.
Answer: C
Q: 27
A user is retrieving data from 2009 and 2010 using an OLAP connection. How can the retrieval be
automated so when the report is rolled over to 2011, data from 2011 and 2010 will be retrieved?
A. Set up ##S variables for both the current and prior years and use ##D to retrieve the data.
B. Set up query variables for both the current and prior years.
C. Set up ##GSD variables for both the current and prior years.
D. Set up note variables for both the current and prior years.
Answer: B
Q: 28
What are two ways to optimize report performance when dealing with variables? (Choose two.)
A. Maximize the number of variables used rather than use Excel cell referencing where possible.
B. Combine multiple validation checks within one ##R validation rule.
C. Use block variables rather than individual cell variables when pulling multiple items from one
table.
D. Ensure you are implementing chain linking.
Answer: B,C
Q: 29
How would the variable CASH be declared in a PPT file for an export from an Excel object?
A. <##D>CASH
B. ##D(CASH)
C. ##D{CASH\}
D. ##D
Answer: D
Q: 30
In FSR, what are two purposes of Query Variables? (Choose two.)
A. to query a relational database table for specific information
B. to use in section and object names
C. to query and summarize all object variables throughout the report
D. to use in the file path and sheet name for yearly rollover
Answer: A,D
Q: 31
An individual requests more information on the Account Hierarchy. Which statement is correct?
A. The Account Hierarchy is used to create validation rules for an FSR report.
B. The Account Hierarchy interface is used to create a hierarchical structure of your accounts.
C. The Account Hierarchy is used to track the changes of an FSR report.
D. The Account Hierarchy is used to create workflow rules in an FSR report.
Answer: B
Q: 32
An FSR user would like to export all of the accounts in the Account Hierarchy interface for a
particular set of dimensions. After selecting the dimensions in the Dimensions Pane, how can the
user export these accounts?
A. Right-click on the top Account node and select "Export Accounts".
B. Click the "Export Accounts" button at the top of the Account Hierarchy interface.
C. Click the "Export Journal Entries" button in the Journal Entries pane of the Account Hierarchy
interface.
D. Click the "Refresh" button at the top of the Account Hierarchy interface.
Answer: B
Q: 33
While creating the hierarchy in the Account Hierarchy feature, an end-user realizes that accounts
have not been entered in the correct order. Which statement is correct?
A. FSR empowers users to move the accounts within the hierarchy.
B. The user must delete the hierarchy and start over.
C. The user can use the sort sequence feature to re-position the accounts in the hierarchy.
D. The user can use the query variables to change the order of the accounts.
Answer: A
Q: 34
A customer wants to use Word macros in FSR for reporting purposes. What are two ways to do
this? (Choose two.)
A. while exporting all Excel objects
B. in the Tools > View Macro Definitions window
C. individually at each object level
D. while generating selected sections
Answer: C,D
Q: 35
A user has created a journal entry, but the net difference of the debits and credits is not equal to
zero. How can the user adjust the amounts?
A. Export the journal entries, fix the amount in the generated Excel file and re-import the file.
B. Delete the journal entry and create a new one.
C. Click Edit Journal Entry and edit the debit/credit amount for an entry.
D. Click the Reverse Journal Entry button.
Answer: C
Q: 36
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 Excel cell referencing to pass the data from the query results sheet to the display sheet
B. Use variables to pass the data from the query results sheet to the display sheet
C. Use the insert query function
D. Use Data Load to load the information
E. Use Query Builder to query the relational database forthe relevant inventories table
Answer: A,C,E
Q: 37
Why would the Query Builder be used in FSR?
A. to query a relational database table
B. to query an OLAP database table
C. to query the report for variable declarations
D. to query object variables in the report
Answer: A
Q: 38
FSR was successfully installed at a client site. All users who will be using the application have
been created and are currently using the product. A new user joined the team so a new account
was created and flagged as an FSR user. Now all users are receiving "The number of Clarity FSR
users exceeds the number of licenses you have purchased" message. What is the problem?
A. The new user has not been given any permissions in SQL Server.
B. The user will need to change the FSR registry key to enable FSR access.
C. The client's license is now being exceeded by the new user.
D. The FSR license needs to be re-applied since there is now a new user.
Answer: C
Q: 39
After an installation is completed, a user tries to log in to the FSR database and is successful.
Since the initial database is empty, there are no sample reports to try. During the installation, you
were prompted to enter a Demo database. How can this user gain access to the Demo database
since it does not appear in the dropdown list when logging into FSR?
A. You will manually need to edit the FSR configuration file to add this entry for each user that will
want access to the Demo database.
B. You can only connect to one database at a time; if a second connection is required, you will
need to re-run the client installation.
C. To add another entry, click on the database and server field and enter the new values.
D. The FSR, administrators will have to provide access to the Demo database to this user from the
User Admin tool.
Answer: C
Q: 40
A company has recently purchased the XBRL module to enable them to submit their latest
financial results to the appropriate government financial reporting body. Which two steps need to
be taken to install this module? (Choose two.)
A. Download the latest release of XBRL from Customer Care and install it on the desktop of the
user who will be submitting the reports.
B. Create an XBRL template and assign a user access to this template.
C. Install the updated license key to enable XBRL/XET at the server level.
D. From the User Administration screen, enable the XBRL and XET options for the user who will
be submitting the reports.
Answer: C,D
Q: 41
What are two primary reasons for a client to install the FSR Web Service application?
(Choose two.)
A. The client would like to take some of the processing load off of the database server.
B. The client would like to use a service account for Authentication instead of using Active
Directory groups to grant permissions against the databases.
C. The FSR Web Service is mandatory and must be installed to use the product.
D. The client would like to prevent users from directly accessing the FSR databases using their
Active Directory IDs.
Answer: B,D
Q: 42
After successfully installing the FSR client software on a user's desktop, the user is unable to
generate any reports. Which two prerequisites, if missed, would cause this behavior? (Choose
two.)
A. Microsoft Excel
B. Microsoft Word
C. Microsoft PowerPoint
D. SQL Server client tools
Answer: A,B
Q: 43
A client is attempting to install the FSR databases to use in a testing scenario. Which three
Microsoft SQL versions are currently supported? (Choose three.)
A. SQL Server 2000 original release
B. SQL Server 2008 R2
C. SQL Server 2005
D. SQL Server 2000 SP4
E. SQL Server 7 SP2
Answer: B,C,D
Q: 44
How should you add a Web page reference to a report?
A. Take a screenshot of the Web page; in a Word object, insert a 1x1 table then paste the
screenshot into the table for optimal formatting control.
B. Print the Web page to a PDF file; add an object to the report; set the type to Attached PDF and
add the PDF to the object.
C. Take a screenshot of the Web page and save it as an image; in a Word object, select import
from the FSR toolbar and select the image file saved.
D. Add an object to the report; set the type to Web page and type the URL in the address bar.
Answer: D
Q: 45
A user is creating a report with a 1-inch margin all around for the entire report. Which document
type should be selected?
A. Normal
B. Footer
C. Header
D. Page Setup
Answer: D
Q: 46
An end user is the assigned user in the Page Setup object. The user would like to edit the
margins, but the message, "You don't have permission to save the changes of object content. " is
displayed. What is the reason for this message?
A. The Excel sheet is protected.
B. The user does not have write permissions to the FSR database.
C. In the workflow, the current stage is not set to "Editable".
D. The workflow due date for the object is in the past.
Answer: C
Q: 47
When a user is in the process of creating a report, there is an option to "Copy Report". What does
this do?
A. Copy Report ensures the variables will not be carried over.
B. Copy Report copies the selected report into a new one.
C. Copy Report updates reference variables in a report automatically.
D. Copy Report enables shared objects to work appropriately.
Answer: B
Q: 48
Upon generating the balance sheet Excel object, an end-user realizes that the generated balance
sheet object is not generated with the line items containing zeros. Why does this happen?
A. FSR automatically suppresses the line items with zeros.
B. Dollar ($) signs need to be placed in separate columns.
C. The line items containing zeros need to be merged.
D. The items do not have the ##NL and ##SL in the column.
Answer: A
Q: 49
When selecting automatic note numbering, it is important to use a correct note variable naming
convention. You should choose a note variable name that corresponds to the line item that will
contain the note. For example, if a note will correspond to the line item: receivables from affiliated
parties, you would use ##RAP. Using this logic, which two choices are valid note variables?
(Choose two.)
A. ##IACS
B. ##WR
C. ##PEOC
D. ##IRE
Answer: A,C
Q: 50
An administrator has built a global workflow for eight users. However, 10 users have access to the
FSR application. How can the administrator restrict viewing access of the objects to the two users
that are not part of the global workflow?
A. In the Users table, select the user to restrict; in the "Filter By" dropdown menu, select "None".
B. In the Users table, select the user to restrict; in the "Filter By" dropdown menu, select "By
Visibility".
C. In the Users table, select the user to restrict; in the "Filter By" dropdown menu, select "By
Workflow".
D. In the Tools > Report Setup window make the changes.
Answer: C
Q: 51
A user is creating a new FSR report and they are presented with a screen called "Global
Variables". They have an option to fill in the physical and logical fields. What would happen if
those values are left blank?
A. Users will receive all zero amounts when loading data from a relational database.
B. The report cannot be created.
C. The report will be created properly.
D. Users will not be able to log into the report.
Answer: A
Q: 52
An administrator would like to configure the e-mail notification message in a workflow between two
stages. How can the administrator navigate to the window where the message can be entered?
A. In the workflow, highlight the arrow between the two stages and click the "Edit body of e-mail
sent when workflow status changed" icon.
B. In the FSR toolbar of the object, click on the "Send e-mail to assigned user" icon.
C. Open Outlook outside of FSR, and compose a draft e-mail to the user.
D. In the workflow, highlight the arrow between the two stages and click the "Apply condition when
status changes" icon.
Answer: A
Q: 53
When generating a table, a user notices that the Excel table is generated with extra padding in the
line items. The default Excel padding is set at .8 inches. How can the default Excel padding be
removed?
A. by creating the table in MS Word
B. by putting the ##RS and ##RE tags around the table
C. by using the correct pixel count
D. by placing a zero in the bottom left corner of the table where ##RS and ##RE intersect
Answer: D
Q: 54
You want to define the table of contents heading and must create a TOC heading variable. In
which two areas must you place the TOC heading variable? (Choose two.)
A. the section properties
B. the object properties
C. the page setup Word object
D. the table of contents of a Word or Excel object
Answer: A,D
Q: 55
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 bookmarks feature to adjust the number of pages between the front page and TOC
from the page number.
B. In the TOC, change the footer page number to zero.
C. Use the object feature to adjust the number of pages between the front page and TOC from the
page number.
D. Use the Word Options Advanced field codes feature to adjust the number of pages between the
front page and TOC from the page number.
Answer: D
Q: 56
When setting up a Word object, what are three document types? (Choose three.)
A. Header
B. Image
C. Footer
D. Table
E. Normal
Answer: A,C,E
Q: 57
FSR users at a company are using a 1 inch margin throughout their report. The users want to
maintain a standard margin for all Excel tables. What will the FSR users at the company need to
do?
A. All the objects are created with a standard 625 pixel count.
B. Page Setup margins in each Excel object will need to be manually set to 1 inch.
C. Each Excel object has ##RS and ##RE tags around the print range.
D. All the tables should be created in one Excel object.
Answer: A
Q: 58
After generating the entire report, an FSR user realizes that a few of the tables are missing from
the report. Which two statements are correct? (Choose two.)
A. Print tags ##RS and ##RE are not placed around the printing range.
B. The tables are missing a few line items.
C. The print option for that object is set to not printable.
D. The pixel count is incorrect.
Answer: A,C
Q: 59
A client made a mistake when they shared an object and copied it into a different report. They
would like to unshare it. What should they do?
A. To unshare an object, a user must delete all the objects that are linked to it.
B. Simply unshare the "Share this object" checkbox.
C. Delete the original object since it cannot be unshared and re-create it.
D. Delete the copy of the shared object before you can unshare it.
Answer: A
Q: 60
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 0.
B. Change Break Type to New Page and set # Pages to 1.
C. Insert a Page Break at the end of the footnote 1 Word object.
D. Change Break Type to Blank Rows and set # Rows to 0.
Answer: B
Latest Version: 9.5 Last Update: December, 2012
Need the Latest version of COG-706 Exam Prep Or the other IBM Exam Prep, Visit the Cheat-Test.com Official website.
COG-706,COG-706 exam,COG-706 dumps,COG-706 study guide,COG-706 practice test,IBM COG-706
Comprehensive questions with complete details
