1Z0-242 | What Pinpoint 1Z0-242 braindumps Is?
Q1. - (Topic 0)
You are receiving a FIXED formatted file from an outside vendor. You want to import the file data into your PeopleSoft system. However, the description field on the file has commas inserted and you want to eliminate them before populating your system tables. Which are the five steps you need to perform to create the file layout on your system to import the data and eliminate the extraneous characters in a field? (Choose five.)
A. Write the application engine program to export the data.
B. Provide the import data in a correctly formatted flat file.
C. Create a file layout to match the record and field structure of the data.
D. Set the file layout properties to specify the file layout format of FIXED.
E. On the Preview tab, enter a comma as the strip character on the description field.
F. Set the File Record ID on the File Layout segment properties.
G. Preview and troubleshoot the input data format and content.
H. On the Preview tab, enter a comma as the field qualifier on the description field.
Answer: B,C,D,E,G
Q2. - (Topic 0)
You use a PeopleCode program to build a dynamic SQL Select statement for an
Application Engine program. Where would you place the PeopleCode program?
A. In a SQL action.
B. In a SQL definition.
C. In a PreBuild event.
D. In a Do While action.
E. In a Do Select action.
F. In a PeopleCode action.
Answer: F
Q3. - (Topic 0)
You add a button to a page to run an Application Engine program in synchronous mode. How do you configure the button?
A. Associate the button with a run control record that passes parameters to Process Scheduler to schedule the process.
B. Associate the button with FieldChange PeopleCode that uses a Process Request object to schedule the process.
C. Associate the button with FieldChange PeopleCode that uses a CallAppEngine function to launch the program.
D. Associate the button with an Application Engine PeopleCode action that passes parameters to a Call Section action.
E. Associate the button with OnExecute PeopleCode that uses a PSAE command to launch the program.
Answer: C
Q4. - (Topic 0)
A Process Scheduler process is configured to run an Application Engine program. You need to modify the process to use parameters entered by the user at run time. Which four additional steps do you need to take? (Choose four.)
A. Create a process type for the new process.
B. Add bind variables to the command-line parameters.
C. Write a PeopleCode program to pass the parameters.
D. Create a state record with fields to pass input parameters.
E. Create a run control page with fields to enter the input parameters.
F. Create a run control record with fields to store the input parameters.
G. Modify the Application Engine program to retrieve the input parameters.
Answer: D,E,F,G
Q5. - (Topic 0)
You want to examine the component buffer for the Customer Orders (PSU_CUST_ORDER ) component. Which four steps are necessary? (Choose four.)
A. Start the PeopleCode Debugger and set a breakpoint.
B. Access the Structure view on the PSU_CUST_ORDER component.
C. In Application Designer, select Component Buffers.
D. Access the Customer Orders component in the browser and trigger the breakpoint. Return to PeopleSoft Application Designer when the breakpoint triggers.
E. Open, or create, a PeopleCode program that will execute while Customer Orders is running in the browser.
F. Drill down through the component hierarchy in the Structure view on the PSU_CUST_ORDER component.
G. In Application Designer, select Debug, View Component Buffers.
Answer: A,D,E,G
Q6. - (Topic 0)
An Application Engine program incorporates PeopleCode and SQL. Which three statements are correct? (Choose three.)
A. All SQL statements are executed using SQL actions.
B. All PeopleCode is executed using PeopleCode actions.
C. SQL Select statements can be used to control program flow.
D. Steps are the smallest unit of work that can be committed within a program.
E. If a program executes a step with a SQL Insert or Update statement, it must also execute a step with a Commit action before completion.
Answer: B,C,D
Q7. - (Topic 0)
When you created a new component interface, you selected "Accept Default Values".
Which two things are automatically added to the component interface? (Choose two.)
A. Keys are created based on the component search record.
B. No fields or records are added to the component interface view.
C. Only Find keys and Get keys are created for the component interface.
D. All primary fields and records are exposed in the component interface.
E. Only Create keys and Get keys are created for the component interface.
Answer: A,D
Q8. - (Topic 0)
View the Exhibit.
A PeopleCode program at level 0 checks the values for Percent Available (PCT_AVAILABLE) at level 1.
Analyze this code snippet.
Local Rowset &RS_Level0, &RS_Level1;
Local Row &Row_Level0, &Row_Level1;
Local Record &Rec_TaskRsrc;
Local Field & Fld_PctAvail ;
&RS_Level0 = GetLevel0();
&Row_Level0 = &RS_Level0.GetRow(1);
&RS_Level1 = &Row_Level0.GetRowset(Scroll.PSU_TASK_RSRC);
&Row_Level1 = &RS_Level1.GetRow(1);
&Rec_TaskRsrc = &Row_Level1.GetRecord(Record.PSU_Task_RSRC);
&Fld_PctAvail = &Rec_TaskRsrc.GetField(Field.PCT_AVAILABLE);
&Pct = &Fld_PctAvail.Value;
Select the correct option.
A. The program will produce the expected results.
B. The program is missing a loop to process each row in the level 1 rowset.
C. The program is missing a loop to process each rowset in the level 1 row.
D. The program can be simplified to:
&Pct = &RS_Level0.PSU_Task_RSRC.PCT_AVAILABLE.Value;
E. This line of code is not needed:
&RS_Level1 = &Row_Level0.GetRowset(Scroll.PSU_TASK_RSRC);
F. The &RS_Level0 = GetLevel0(); function is missing the Level 0 scroll name.
Answer: B
Q9. - (Topic 0)
Which three URLs must be defined before you can create messages and schemas? (Choose three.)
A. Inquiry URL
B. Publish URL
C. Target location
D. Service namespace
E. Schema namespace
Answer: C,D,E
Q10. - (Topic 0)
View the Exhibit.
Note the Prompt Table field.
Select the correct statement.
A. %EDITTABLE allows a user to override standard system edits.
B. %EDITTABLE allows the user select a prompt table at run time.
C. %EDITTABLE is used to assign a prompt table based on a value in another field on the page.
D. %EDITTABLE is meta-SQL that is used to filter prompt table values based on run-time values.
E. %EDITTABLE is a system variable that resolves to a language-specific translate table at run time.
Answer: C