Exam Code: A00-260 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: SAS Data integration Development
Certification Provider: SAS Institute
Free Today! Guaranteed Training- Pass A00-260 Exam.
Q9. SAS Data Integration Studio is dependent on which administration functions?
A. Setting up of SAS Information Map environment.
B. Setting up of SAS Web and SAS Portal environments.
C. Setting up of SAS Application Servers.
D. Setting up of SAS Libraries definitions.
Answer: C
Q10. The Platform Process Manager server is part of the Platform Suite for SAS. Which statement is
FALSE regarding the Platform Process Manager server?
A. The server enables you to schedule jobs using a variety of recurrence criteria and dependencies on other jobs, time events, or file events.
B. The server enables you to schedule jobs using a variety of recurrence criteria but does NOT allow you to specify any type of dependencies.
C. The Flow Manager application (part of the Platform Suite for SAS) can be used to manage already scheduled jobs.
D. Metadata for the Platform Process Manager server must be defined and must include the network address or host name of a machine as well as the port number for the server.
Answer: B
Q11. The SAS platform application that can surface the different types of business and analytic content such as information maps, stored processes, and reports on the web browser is:
A. SAS Information Delivery Portal
B. SAS Information Map Studio
C. SAS Web Report Studio
D. SAS OLAP Cube Studio
Answer: A
Q12. You want to create a table containing all customers from Italy. Assume that global customer order information is available in a single table. Identify the SAS Data Integration Studio transformation that will help you perform the task easily.
A. Append
B. Extract
C. Lookup
D. Mining Results
Answer: B
Q13. Which action is required for enabling performance statistics on the executing SAS Workspace Server?
A. Define alogfile for output.
B. Define Collect Diagnostics for the SAS Data Integration Studio job.
C. Define Collect Runtime statistics for the SAS Data Integration Studio job.
D. Enable the logging facility of the SAS Workspace Server.
Answer: D
Q14. In SAS Data Integration Studio, which statement is FALSE regarding status handling?
A. When a job is executed in SAS Data Integration Studio, a return code for each transformation in the job is captured in a macro variable. The return code for the job is set to the least successful transformation in the job. SAS Data Integration Studio enables you to associate a return code condition, such as Successful, with an action, such as Send Email.
B. If status handling has been defined for a transformation or the job, a macro definition (and a call to it) will be added to the generated code to check for the specified condition(s).
C. Only one Condition/Action pair can be defined for a single transformation or for a job.
D. The available Condition/Action pairs for transformations and jobs will vary - that is, different Condition/Action pairs may exist for the SQL Join transformation versus the Table Loader transformation.
Answer: C
Q15. When writing postcode in the Precode and Postcode tab of the Transpose transformation in SAS Data Integration Studio, which symbol allows you to reference the transformation output table regardless of the actual physical name for that target table?
A. &syslast
B. syslast
C. &target
D. %target
Answer: A
Q16. Assume that you have completed the Register Tables wizard in SAS Data Integration Studio. Which statement is true?
A. The physical table(s) selectedare copied to the application server specified in the library.
B. The physical table(s) selectedare copied to the SAS Folders location specified in the wizard.
C. Metadata for the physical table(s) selected is stored on the application server specified in the library.
D. Metadata for the physical table(s) selected is stored in the SAS Folders location specified in the wizard.
Answer: D