C_BOCR_08無料問題集「SAP Certified Application Associate

質問 1

You design a Crystal report for the Sales department. It lists customer orders received year-todate and is grouped and subtotaled monthly by order date. It contains the selection formula: Sum ({Orders.Order Amount}, {Orders.Order Date}, "monthly") > $200000. What is the highest stage of processing that this report requires?

（A）Pre-pass 3

（B）Pass 3

（C）Pass 1

（D）Pre-pass 2

（E）Pass 2

正解：E 解答を投票する

質問 2

How do you insert a graphic into a report so that the graphic is automatically updated?

（A）Store the graphic on your system with a reference to the source file.

（B）Add the graphic from the Web Folders.

（C）Store the graphic in the network cache.

（D）Add the graphic from the repository.

正解：D 解答を投票する

質問 3

You want to use a Cross-Tab to see the difference in Canada's sales versus USA's sales. Which method should you use in Crystal Reports 2008 if the field does not exist?

（A）Use a parameter field within the Cross-Tab.

（B）Insert a custom group as a Cross-Tab member.

（C）Use a calculated member.

（D）Insert a Sum summary for Canada's sales.

正解：C 解答を投票する

質問 4

Which action should you perform to update a report to reflect a change to the database structure?

（A）From the Database Menu, select Set Datasource Location.

（B）From the Report Menu, select Check Dependencies.

（C）From the Report Menu, select Refresh Report Data.

（D）From the Database Menu, select Verify Database.

正解：D 解答を投票する

質問 5

Sales Managers use a weekly sales report that includes the following columns: Sales Person, Weekly Sales and Quota. The Sales Managers would like the ability to retrieve additional non-sales related information on their personnel by clicking on a hyperlink. Which type of report should you create?

（A）Unlinked subreport based on manager ID

（B）Unlinked subreport based on employee ID

（C）On-Demand subreport based on manager ID

（D）Linked On-Demand subreport based on employee ID

正解：D 解答を投票する

質問 6

Your company purchases a new sales contact list and imports the records into the database. Some of the new records contain NULL values. The database record count is different than the number of rows returned in your report. What can you do to solve the record count inconsistency?

（A）Suppress formulas that check for NULL values.

（B）Modify the record selection formula to exclude NULL values.

（C）Modify the group selection formula to exclude NULL values.

（D）Suppress sections based on the NULL values.

正解：B 解答を投票する

質問 7

You want to ensure that your Accounts Receivable listing report displays only those customers with invoices. Which join type must you specifies when you link the Customer and Invoice tables using the Customer ID field?

（A）Inner Join

（B）Enforced Both Join

（C）Equal Join

（D）Full Inner Join

正解：A 解答を投票する

質問 8

Where is the transform information stored?

（A）In the temp file

（B）In the report

（C）In the global options

（D）In the XML_Export.INI file

正解：B 解答を投票する

質問 9

When should you use parameters?

（A）When creating conditional Top N reports.

（B）When identifying trends in data.

（C）When creating dynamic groups.

（D）When identifying the data source location.

正解：C 解答を投票する

質問 10

When is data not returned to a report? (Choose two.)

（A）A new field is added to the report in design view.

（B）A new table is added to the report from the database expert.

（C）The report is exported to MS Excel.

（D）The report is previewed.

正解：A、B 解答を投票する

質問 11

You create a variable in a subreport to pass back the following formula, called @SKUcalc, to the main report:
WhilePrintingRecords; Numbervar SKU; SKU:=maximum(Part.PartID); In the main report, you create a formula called @SKUdisplay to display the SKU number: WhilePrintingRecords; Numbervar SKU; SKU When the report is run @SKUdisplay returns a NULL value. Which statement explains why the result of the formula is NULL?

（A）You did not re-declare the variable in the main report.

（B）You did not declare the variable as a shared variable.

（C）You did not declare the variable as a global variable.

（D）Only local variables can pass values from a subreport to a report.

正解：B 解答を投票する

質問 12

When using the Database Expert in Crystal Reports, which two methods can you use to move database tables from the Available Data Sources area to the Selected Tables list? (Choose two.)

（A）Click and drag the table name onto the Selected Tables list

（B）Click the table name and choose Upload to Report

（C）Click the > arrow between the two areas

（D）Right-click the table name, select Move

正解：A、C 解答を投票する

質問 13

Which item should you select to view SQL statements generated by Crystal Reports?

（A）SQL Expression from the Formula Workshop

（B）Show SQL Query from the Database menu

（C）Section Expert from the Report menu

（D）Check Dependencies from the Report menu

正解：B 解答を投票する

質問 14

: 174
Which three conditions might cause an error when you save a custom function? (Choose three.)

（A）You used a summary field.

（B）You used a local variable.

（C）You used a Print State function.

（D）You used a User Function Library (UFL).

正解：A、C、D 解答を投票する

C_BOCR_08 無料問題集「SAP Certified Application Associate - Crystal Reports 2008」

弊社を連絡する

関連リンク

トップ試験