SASInstitute SAS Data Integration Development - A00-260 Exam Practice Test

A. a server definition that points to the ODBC data source and a library accessing this server definition

B. only an ODBC data source 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. A SAS table scheme that is generated by SAS.

B. Power scheme that is generated by Data Flux.

C. A third party RDBMS table that has been generated by the SAS system.

D. A comma delimited flat file that contains the field names in the first row.

A. A folder or directory location on a server where the SAS code from a deployed SAS Data integration Studio job is stored.

B. A SAS Folder in the Schedule Manager plug-in within SAS Management Console containing listings of all flows organized by server type.

C. A location in the metadata repository where job flows are deployed.

D. A location in the SAS Management console job directory storing the metadata for jobs that can be added to job flows.

A. Automatic propagation that is set globally or at the job level can be overridden and disabled for a selected transformation.

B. Propagation can only occur in the direction of the job flow diagram (from beginning to end). Propagation from the end to the beginning is not available.

C. Automatic propagation that is set globally can be overridden and disabled within a job.

D. Automatic propagation can be set globally, so every new job will automatically propagate.

A. Data Validation

B. Table Loader

C. Lookup

D. DataFlux IS Job

A. Metadata for the physical table(s) selected is stored in the SAS Folders location specified in the wizard.

B. Metadata for the physical table(s) selected is stored on the application server specified in the library.

C. The physical table(s) selected are copied to the SAS Folders location specified in the wizard.

D. The physical table(s) selected are copied to the application server specified in the library.

A. Delete and remove permanent tables.

B. Create and replace permanent tables.

C. Maintain access privileges to permanent tables.

D. Apply and maintain constraints on permanent tables.