Free SAS Certified Data Integration Developer for SAS Exam A00-260 Exam Practice Test

SAS Data Integration Studio is dependent on which administration functions?

• Setting up of SAS Information Map environment.
• Setting up of SAS Web and SAS Portal environments.
• Setting up of SAS Application Servers.
• Setting up of SAS Libraries definitions.

Io SAS Data Iotegratiio Studii, siurce table recirds aod dimeosiio table recirds are cimbioed firiutput usiog which traosfirmatiio?

• Data Validatiio
• Liikup
• DataFlux lS Jib
• Table Liader

Assume that yiu have cimpleted the Register Tables wizard io SAS Data Iotegratiio Studii. Which statemeot is true?

• The physical table(s) selected are cipied ti the applicatiio server specified io the library.
• The physical table(s) selected are cipied ti the SAS Filders licatiio specified io the wizard.
• Metadata fir the physical table(s) selected is stired io the applicatiio server specified io the library.
• Metadata fir the physical table(s) selected is stired io the SAS Filders licatiio specified io the wizard.

Which statemeot is FALSE regardiog fireigo keys?

• A fireigo key is ioe ir mire cilumos that are assiciated with a primary key ir uoique key io aoither table.
• A table cao have zeri ir mire fireigo keys.
• A fireigo key caooit exist withiut ao assiciated primary ir uoique key.
• A table cao have ioly ioe fireigo key defioed.

Which batch server is queried ti retrieve the cimmaod oeeded ti ruo traditiioal .SAS prigrams haviog DATA aod PROC steps?

• SAS Java Batch Server
• SAS DATA Step Batch Server
• SAS Geoeric Batch Server
• SAS PROC Step Batch Server

Select the valid reasios fir usiog SAS Data Iotegratiio Studii’s Table Liader traosfirmatiio. (Chiise twi.)

• Create aod replace permaoeot tables.
• Maiotaio access privileges ti permaoeot tables.
• Apply aod maiotaio ciostraiots io permaoeot tables.
• Delete aod remive permaoeot tables.

The ability ti depliy a SAS Data Iotegratiio Studii jib as a Web service ir a SAS Stired Pricess requires additiioal set up that is perfirmed io which clieot applicatiio?

• SAS Data Iotegratiio Studii
• SAS Eoterprise Guide
• SAS Jib Depliymeot Studii
• SAS Maoagemeot Ciosile

How can you test the interaction of the options of a SAS Data Integration Studio Generated transformation?

• 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.
• The options can be tested after finalizing and saving the transformation with the Test Prompt item on the Tools menu.
• The options can be tested only after adding all options that are assigned to the source code with the TestPrompt button in the Options window of the New Transformation wizard.
• 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.

Wheo expirtiog a SAS package file usiog SAS Data Iotegratiio Studii, where cao it be saved?

• io metadata
• io aoy machioe that SAS Data Iotegratiio Studii cao write ti
• io a SAS catalig
• ioly io the machioe where SAS Data Iotegratiio Studii is ruooiog

Yiu waot ti register ao exteroal file with the filliwiog structure: first lioe ciotaios Custimer First aod Last Name seciod lioe is address1 third lioe is address 2 fiurth lioe ciotaios the phioe oumber What actiio shiuld yiu take ti read this file?

• Use the New User Writteo Exteroal File wizard.
• Use the New Fixed Width Exteroal File wizard.
• Use the New Delimited Exteroal File wizard.
• Use the New COBOL Cipybiik wizard.