Online Access Free 1Z0-242 Practice Test

You are expecting a flat file from a third-party system. The file contains information to populate a table on your HCM system. But the data being supplied will contain only a few of the record fields in the PERSON table defined in your HCM system. Further, the file has a control file field that will indicate whether to add, change, or update the information.
The file format is:
999 A /* Indicates the action to take */ 001 1000 Smith,John 123 Easy Street Easy City CA /*Actual Data*/ 999 C
001 1020 Jones, Tom 1024 Hard Life Street Hardknocks NJ
Which are the two choices to define the file layout? (Choose two.)

• A.The File Record ID in the File Layout Segment Properties for the PSCAMA segment will be 999 and no File Record ID is needed for PERSON.
• B.The file layout will contain two segments. One using the record field PSCAMAUDIT_ACTN and the other the record fields from PERSON - EMPLID, NAME, STREET, CITY, and STATE.
• C.The file layout will contain one segment for PSCAMA.AUDIT_ACTN and one child segment for PERSON.
• D.The File Record ID in the File Layout Segment Properties for the PSCAMA segment will be 999 and for PERSON 001.
• E.The File Record ID in the File Layout Segment Properties for the PSCAMA segment will be 001.

Component interface Find keys are mapped to ____.

• A.alternate search key in a component search record
• B.duplicate order keys in a component search record
• C.all keys in a component search record
• D.search keys in a component search record
• E.search and alternate search keys in a component

View the Exhibit.
As the developer, what do you need to do to make this PeopleSoft Application Engine program restartable?

• A.Deselect the Disable Restart check box on the Program Properties page.
• B.Select the Disable Restart check box on the Program Properties page.
• C.Remove all section-level and step-level auto commits.
• D.Nothing more. The Do Select action is set to Restartable.
• E.Set the state record to derived/work.

You have been asked to import a CSV file. You create the file layout definition for the record structure and enter your default file name on the Preview tab. When you preview the file, only the first column of the preview grid is populated. What will you do to correct this problem?

• A.change the file layout format to match the input file
• B.change the definition delimiter to match the one that is used in the input file
• C.specify file record IDs that match the input file records
• D.decrease the start position and adjust the field length to match the input data start position and length
• E.increase the field length to accommodate the input data

An Application Engine program has a Do While action with the following code:
%SELECT (TEMP_FLD)
SELECT 'COUNTER'
FROM PS_INSTALLATION
WHERE %Bind(COUNTER) < 1000;
What will be the result?

• A.The Do While will execute as expected, as long as COUNTER is being incremented in the state record for every loop.
• B.The Do While will execute as expected, as long as COUNTER is being incremented in PS_INSTALLATION for every loop.
• C.The Do While action will go into an infinite loop because the Select statement will always return true.
• D.The actions following the Do While action will never execute because the Select will never return true.
• E.The program will abend because PS_INSTALLATION does not have a COUNTER field.
• F.The Do While will execute at least once, no matter what the result of the Select.