COG-706 Exam Questions

What are two functions of a user role? (Choose two.)

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 use a workflow rule, which two variables are required to be set up? (Choose two.)

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?

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 an...

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...

A user is creating a chart in FSR and referencing it using a bookmark. What is the naming convention for the bookmark?

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?

What are two section level variables available in FSR? (Choose two.)

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

Why would the Query Builder be used in FSR?

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 conten...

When a user is in the process of creating a report, there is an option to "Copy Report". What does this do?

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 ha...

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...

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...

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 happe...

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...

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 E...

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.)

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?

When setting up a Word object, what are three document types? (Choose three.)

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...

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 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 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...

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 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?

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.)

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 en...

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 user has certain objects tagged as custom group "Q1", but they should be tagged as "Q2/Q3" only. How can this be resolved?

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...

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

How would the variable CASH be declared in a PPT file for an export from an Excel object?

In FSR, what are two purposes of Query Variables? (Choose two.)

An individual requests more information on the Account Hierarchy. Which statement is correct?

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, h...

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 customer wants to use Word macros in FSR for reporting purposes. What are two ways to do this? (Choose two.)

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, af...

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 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?

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?

When sourcing data using Excel data sources, which two methods should you use? (Choose two.)

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 re...

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...

A company is preparing a presentation in PowerPoint. Which three can be exported to PowerPoint? (Choose three.)

Why are OLAP variables used in FSR?

A user needs to create a chart for the company's annual report. Which statement is correct?