SAP C_BODI_20 問題集

質問 1：
Your source table contains sales data for multiple countries. You need to calculate sales tax differently for each specific country. The sales tax for some countries requires multiple steps to calculate. What is the recommended method you should use?
A. Use the SQL transform and specify the sales tax calculation in the SQL statement.
B. Use a Query transform and the Decode ( ) function to apply the sales tax calculations
C. Use a Validation transform to create the sales tax calculations
D. Use a Case transform to separate the countries, then apply the Sales Tax Calculation Using Query transforms.
正解：D

質問 2：
Which two data integrator objects/operations support load balancing in a server Group based architecture? (Choose two.)
A. Lookup_ext
B. Job
C. While loop
D. Script
正解：A,B

質問 3：
You are developing a data warehouse as part of a large development team (ten plus developers) Way should you recommend a multi-user configuration? (Choose two)
A. Track the version history history of objects(audit trrail)
B. Attach documentation based on object history
C. Ensure only one developer is working on a specific set of objects
D. Store table column and relationship profile data including history
正解：A,C

質問 4：
When is a template table created in the database?
A. You execute a Job
B. You right-click and select "Create" on a template table
C. You right-click and select "Import" a template table to a permanent table
D. You create a template table on the Data Flow
正解：A

質問 5：
Which two rules must you following to deploy a Server Group architecture? (Choose two)
A. Each computer can only contribute one Job server to a server group
B. A maximum of four servers can be added to a server group
C. All Job servers in a server group must be active for the server group to function
D. All the Job servers in the server group must be associated with the same repository
正解：A,D

質問 6：
Your data integrator environment interprets year values greater than 15 as 1915 instead of 2015. you must ensure data integrator interprets any date from "00 to 90" as "2000 to 2090" without making direct modifications to the underlying data flow. Which method should you use to accomplish this task?
A. Open the web administration tool and select management l requisiteness edit the production requsitury and modify the "Century change year to 90".
B. Log into the designer and select tools l Options l data l General and modify the "Century change year" to 90.
C. Open the server manger and select edit job server config and modify the "Century change year to 90".
D. Configure the source database to interpret the two digit dates appropriately.
E. On the job server, open the windows l control panel l regional settings l Customize data and modify the two digit year interpretation to 90.
正解：B

質問 7：
Where do you specify the error file to capture flat file format errors?
A. Properties of the Data Flow
B. Trace Options of the Job
C. File Format Editor
D. Server Manager Tool
正解：C