We provide real A00-260 exam questions and answers braindumps in two formats. Download PDF & Practice Tests. Pass SAS Institute A00-260 Exam quickly & easily. The A00-260 PDF type is available for reading and printing. You can print more and practice many times. With the help of our SAS Institute A00-260 dumps pdf and vce product and material, you can easily pass the A00-260 exam.

Q1. In SAS Data Integration Studio, which component allows the definition of job flows with dependencies between different jobs? 

A. the deployment wizard of SAS Data Integration Studio 

B. the Scheduling Manager plug-in in SAS Management Console 

C. the Scheduling Server triggering it occurred. Which statement describes the situation correctly? 

A. The scheduling server calls the SAS DATA Step Batch Server over the SAS Object Server which spawns the job, getting its source code from the deployment directory, and sends the results directly to the Schedule Manager plug-in of the SAS Management Console. 

B. The scheduling server uses the command obtained from the SAS DATA Step Batch Server and the source code from the deployment directory to run the job. The results from the executing command are directly sent to the scheduling server. 

C. The scheduling server uses the command from the deployed job in the deployment directory and executes it with the SAS DATA Step Batch Server which gets the source code from the Metadata Server. The results are sent back to the deployment directory. 

D. The scheduling server uses the command obtained from the Schedule Manager, the source code from SAS DATA Step Batch Server and executes it. The results are directly sent to the scheduling server. 

Answer: B 


Q2. In the following display, can status handling be enabled for the Extract transformation? 

A. No. The Extract transformation does not have a status handling tab in its Properties window, and the Return Code Check transformation can only provide status handling at the job level. 

B. Yes. The Return Code Check transformation can be added to the END of the job flow - the Status Handling tab in the Return Code Check transformation properties can then establish the desired status handling. 

C. No. The Extract transformation does not have a Status Handling tab in its Properties window, therefore it is not possible to establish status handling for this transformation. 

D. Yes. The Return Code Check transformation can be added to the job flow immediately following the Extract - the Status Handling tab in the Return Code Check transformation properties can then establish the desired status handling. 

Answer: B 


Q3. Consider the job flow diagram in the display. Assume the inner job has a parameter defined specifying a table name. Which statement is FALSE? 

A. The Inner Job can be successfully executed by itself, but only if the defined parameter has been assigned a valid default value. 

B. The Inner Job cannot be successfully executed by itself unless it is disassociated from the loop 

job. 

C. The Control Table column is mapped to the parameter defined for the Inner Job using the Loop transformation properties window. 

D. If the server that executes the job has multiple CPUs, parallel processing can be enabled in the Loop transformation properties window. 

Answer: B 


Q4. and Last Name second line is address1 third line is address 2 fourth line contains the phone number What action should you take to read this file? 

A. Use the New User Written External File wizard. 

B. Use the New Fixed Width External File wizard. 

C. Use the New Delimited External File wizard. 

D. Use the New COBOL Copybook wizard. 

Answer: A 


Q5. In SAS Data Integration Studio, which output format is supported for the default "out-of-the-box" job report? 

A. HTML 

B. PDF 

C. RTF 

D. XML 

Answer: A 


Q6. Within SAS Data Integration Studio, which one of the following is NOT an option available from the File-> New menu choice under External File grouping? 

A. Delimited 

B. Fixed Width 

C. User Written 

D. COBOL Copybook 

Answer: D 


Q7. When using the Table Loader transformation to load an existing target table that contains one or more indexes in SAS Data Integration Studio, which statement is true? 

A. Indexes are removed when the Table Loader executes and must be re-created using the Table Structure transformation. 

C. the Columns tab in the table properties window 

D. the Columns tab in the Details panel of the open job, with the table selected in the job flow 

Answer: A 


Q8. The ability to deploy a SAS Data Integration Studio job as a Web service or a SAS Stored Process requires additional set up that is performed in which client application? 

A. SAS Data Integration Studio 

B. SAS Enterprise Guide 

C. SAS Job Deployment Studio 

D. SAS Management Console 

Answer: D