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 ranges should contain as many V-Lookup formulas as possible.
C. The range selected should only contain what is needed for the report.
D. The range of numbers should be rounded at the source Excel file externally from FSR if possible.
正解:C,D
質問 2:
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.
正解:A
質問 3:
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.
正解:B
質問 4:
FSR has numerous ways to bring data into Excel objects into the Database tab.What are three valid methods? (Choose three.)
A. Account Hierarchy
B. Excel file
C. OLAP cube
D. query variables
E. database query
正解:A,B,C
質問 5:
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. ##IRE
B. ##WR
C. ##PEOC
D. ##IACS
正解:C,D
質問 6:
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. Change the ##S variable for the quarter to Q3.
C. Update the value of the quarter field in the OLAP connection to Q3.
D. Change the ##R variable for the quarter to Q3.
正解:A
Komatsu -
C2020-706については、この本の問題とかなり似た問題が出題されます。
問題の回答率を100%近くまで持っていって、あとは主要なオプション、書式をきちんと覚えれば大丈夫かと。
私は無事合格なのでPass4Testに感謝を