SASInstitute SAS Data Integration Development - A00-260 FREE EXAM DUMPS QUESTIONS & ANSWERS

A. the Indexes tab in the properties of a job metadata object B. the Indexes tab in the properties of a table metadata object C. the Indexes tab in the properties for any transformation D. the Indexes tab in the properties of a Table Loader transformation

A. Inner B. Union C. Full D. Cross

A. From the source table, matching rows are updated in the target table and new rows are added. B. From the source table, matching rows AND new rows are added, but the original matching row in the target table is marked as inactive. C. A or C, depending on further options chosen. D. From the source table, matching rows are skipped, and new rows are added.

A. in dfPower Profile (Viewer) B. in any text viewer C. in the Reports tab of dfPower Profile (Configurator) D. in any HTML viewer

A. 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. 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 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. 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.

A. only an ODBC data source definition B. a server definition that points to the ODBC data source and a library accessing this server definition C. a table pointing directly to the ODBC data source D. a library that will use a SAS/ACCESS engine to a specific database

A. The options can be tested at any time after adding them to the transformation with the Test Prompt button in the Options window of the New Transformation wizard. B. The transformation has to be used within a job to interactively test the options with the Test Prompt button in the Options window from the properties of the transformation within the job editor. C. The options can be tested after finalizing and saving the transformation with the Test Prompt item on the Tools menu. D. The options can be tested only after adding all options that are assigned to the source code with the Test Prompt button in the Options window of the New Transformation wizard.