Free IBM C2020-706 Exam Dumps Questions & Answers

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.  Excel cell reference
• B.  ##S/##D
• C.  Import
• D.  ##SL

To use a workflow rule, which two variables are required to be set up? (Choose two.)

• A.  ##WR
• B.  ##WRI
• C.  ##IRS
• D.  ##WS

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 ##R variable for the quarter to Q3.
• B.  Update the value of the quarter field in the OLAP connection to Q3.
• C.  Change the value for the quarter query variable from Q2 to Q3.
• D.  Change the ##S variable for the quarter to Q3.

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

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

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.  Use the bookmarks feature to adjust the number of pages between the front page and TOC from the page number.
• D.  In the TOC, change the footer page number to zero.