C-BOCR-08 Exam Training Practice Tests (SAP Certified Application Associate

Question 1

Each employee in your organization has a unique employee ID. The fifth character of the employee ID represents the department code. Which control structure in the Crystal Reports Formula Editor will enable you to use the employee ID to group the employees by department?

A. Else B. Subscript C. Count D. Select Case

Correct Answer: D

Question 2

You design a Crystal summary report that is grouped by Region then by Customer Name. The Details section is hidden. The report includes a bar chart that displays total orders by Customer Name for each Region group. Which procedure will display the chart beside the sections that show Customer Name and Total Sales?

A. Place the chart in the Group Footer #2 section and format the section to suppress if duplicated. B. Place the chart in the Group Footer #2 section and format the section to Underlay Following Sections. C. Place the chart in the Group Header #1 section and format the section to Underlay Following Sections. D. Place the chart in the Details section and format the section to suppress if duplicated.

Correct Answer: C

Question 3

What two settings should you select to enable server-side grouping on a Crystal report? (Choose two.)

A. Perform Query Asynchronously B. Perform Grouping on Server C. Use Indexes or Server for Speed D. Always Sort Remotely

Correct Answer: B,C

Question 4

Which three options can you use to export a Crystal report to a file type that maintains conditional formatting? (Choose three.)

A. Acrobat Format (PDF) B. XML C. MS Excel 97-2003 D. Rich Text Format

Correct Answer: A,C,D

Question 5

You create a complex report that features drill down by Country, then by Region and then by City. You need to create a different Page Header section for each drill down level in order to describethe contents correctly and enable Show All Headers on Drill Down. Which conditional formatting formula will show Page Header bin the Country drill down but not the Region and the City drill downs?

A. DrillDownGroupLevel <> 0 B. DrillDownGroupLevel = 1 C. DrillDownGroupLevel = 0 D. DrillDownGroupLevel <> 1

Correct Answer: D

Question 6

You must ensure that your Customer listing report displays all customers, whether or not they have an order. Which type of join must you specify when you link the Customer and Order tables using the Customer ID field?

A. Left Inner Join B. Left Outer Join C. Right Inner Join D. Right Outer Join

Correct Answer: B

Question 7

You must use a formula in a new Crystal report that creates an account number for each customer. The account number consists of the first five alphabetical characters from the Customer Name field and the first five numeric characters from the Phone field. All records contain at least five characters of the correct type in each field. Which process would you use to create the account number?

A. Use nested If-Then-Else statements to return every possible result for each field. Create a formula to extract the required characters from the If-Then-Else results then display the concatenated data. B. Create a formula that uses a SELECT statement that is processed on the database server that concatenates the first five alphabetical characters from the Customer Name field with the first five numerical characters from the Phone field. The last line displays the ten-character result. C. Use If-Then-Else statements to return every possible result for each field. Create formulas to extract the required characters from the Customer Name and Phone fields and assign the results to global variables. Use a third formula to concatenate the results and display the account number. D. Create a formula with two While Do loops. The first extracts the first five alphabetical characters from the Customer Name field and the second extracts the first five numerical characters from the Phone field and concatenates them to the five alphabetical characters. The last line displays the ten-character result.

Correct Answer: D

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. Report Footer B. Page Footer C. Report Header D. Page Header

Correct Answer: A

Question 9

Which method should you use to create an ODBC connection to a Microsoft SQL Server database that is visible to all users on a specific computer?

A. Use the Microsoft ODBC Data Source Administrator to create a User DSN. B. Use the Crystal Data Source Administrator to create a User DSN. C. Use the Microsoft ODBC Data Source Administrator to create a System DSN. D. Use the Crystal Data Source Administrator to create a System DSN.

Correct Answer: C

Question 10

Which method could you use to create a new formula in your report?

A. Select the New Formula option from the Insert menu. B. Right-click on the Formula Fields category in the Report Explorer and choose the New option. C. Right-click on the Formula Fields category in the Field Explorer and choose the New option. D. Select the New Formula option from the Format menu.

Correct Answer: C

Question 11

Which three units of measure can you use to define the page size? (Choose three.)

A. Pixel B. Centimeter C. Inch D. Twip

Correct Answer: A,B,C

SAP Certified Application Associate - Crystal Reports 2008 - C-BOCR-08 Exam Practice Test