SAP Certified Application Associate - Crystal Reports 2008 (C-BOCR-08) Free Practice Test

Question 1

You are creating a report and you open the Field Explorer. The field names are random alphanumeric values. Which database option should you enable to see an alternative to the field names?

A. Show Name

B. Show Distinguished Name

C. Show Description

D. Show Aliases

Correct Answer: C

Question 2

You want to display total sales amounts greater than $5000 in purple with a silver background and bold text. Which two features should you use to meet the requirements? (Choose two.)

A. Conditional formatting

B. The Format Painter

C. The Section Expert

D. The Highlighting Expert

Correct Answer: A,D

Question 3

A Dynamic Recipient Data Provider is a:

A. Report or row set that lists data about publication recipients

B. Dynamic database connection that is used to migrate reports between environments

C. Report or row set that contains metadata about the report

D. Database connection that provides information for dynamic cascading prompts

Correct Answer: A

Question 4

The Sales department has a report listing the two sales channels, Direct and Indirect. There is a grand total for all sales at the end of the report. There is however also a requirement for a grand total for each channel.
Which method should you use to provide the total for each channel?

A. Create 2 running totals, evaluating on the relevant channel, and place them in the report footer.

B. Create 2 running totals, evaluating on the relevant channel, and place them in the report header.

C. Create 2 running totals, evaluating on the relevant channel, and place them in the group footer.

D. Create 2 running totals, evaluating on the relevant channel, and place them in the group header.

Correct Answer: A

Question 5

You have a date parameter in a Crystal Reports 2008 report. You want to give users the ability to view the report date parameter online. Which parameter option should you use?

A. Allow Custom Values

B. Editable

C. Allow Range Values

D. Show on Viewer Panel

E. Optional Prompt

Correct Answer: D

Question 6

What is the primary benefit of Web Services in Crystal Reports 2008?

A. Interoperability

B. Access to restricted data sources

C. Ease of use

D. Scalability

Correct Answer: A

Question 7

Which three statements describe characteristics of a subreport? (Choose three.)

A. Can have its own record selection

B. Can be inserted in any section of a primary report

C. Does not contain a Page Header or Page Footer section

D. Can contain subreports

Correct Answer: A,B,C

Question 8

Your Sales Manager asks you to create a simple Crystal report listing all customers around the world in alphabetical order with no grouping. He wants total sales by country. You begin by creating running total fields to sum sales for each country. Which section should you place the running total fields in the report?

A. Page Header

B. Report Header

C. Report Footer

D. Page Footer

Correct Answer: C

Question 9

Which method can you use to resize a section when working in the Design window of Crystal Reports?

A. Insert a Subsection Line.

B. Drag and drop the corner of the section window.

C. Select Zoom In/Out from the View menu.

D. Move the section boundary.

Correct Answer: D

Question 10

Your report contains two formulas that use the same global variable, nOverBudget. The first formula, @Increment, is located in a Group Footer and increments the variable by one if the group total exceeds 200,000. The second formula, @Display, is located in the Report Footer and displays the number of groups that have exceeded 200,000. Which function can you use in @Display to ensure that the second formula returns the correct total count?

A. EvaluateAfter ({@Evaluate});

B. EvaluateAfter ({@Increment});

C. GroupSum ({@Evaluate, 200000});

D. GroupSum ({@Increment, 200000});

Correct Answer: B

Question 11

Which method can you use to display a field when specific criteria are met?

A. Conditionally format the field in the Field Editor.

B. Conditionally format the field in the Section Expert.

C. Conditionally format the field in the Format Editor.

D. Conditionally format the field in the Select Expert.

Correct Answer: C

Question 12

Which two statements are true regarding hyperlinking in Crystal Reports 2008? (Choose two.)

A. The hyperlinking GUI will automatically pick up parameters in the target report.

B. Only Boolean parameters are allowed when linking a source report to a target report.

C. The report developer can define a constant as the input to a target report parameter.

D. The source and target report parameter lists must be identical.

Correct Answer: A,C

Question 13

What method should you use to enable dynamic sorting of a report field in Crystal Reports 2008?

A. Insert Sort Control on Field Heading

B. Insert Sort Control on Field Data

C. Bind Sort Control to Field Data

D. Bind Sort Control to Field Heading

Correct Answer: D

Question 14

Which two actions require you to use the Database Expert? (Choose two.)

A. Migrating data

B. Adding tables

C. Linking tables

D. Verifying the database structure

Correct Answer: B,C

Question 15

Which two statements are true limitations of the Crystal formula anguage? (Choose two.)

A. The maximum size of an array is 1,000 elements.

B. The maximum number of loop condition evaluations per evaluation of a formula is 100,000.

C. The minimum size of an array is zero.

D. The maximum length of a string constant is 12,256 characters.

Correct Answer: A,B

Welcome to TestSimulate

SAP Certified Application Associate - Crystal Reports 2008 (C-BOCR-08) Free Practice Test