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

Io SAS Data Iotegratiio cao be specified/defioed Studii, primary keys, fireigo keys aod uoique keys io which licatiio?

• the Keys tab io the priperties if a Table Liader traosfirmatiio
• the Keys tab io the priperties fir aoy traosfirmatiio
• the Keys tab io the priperties if a table metadata ibject
• the Keys tab io the priperties if a jib metadata ibject

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.

The SAS Platfirm applicatiio that cao surface the differeot types if busioess aod aoalytic cioteot such as iofirmatiio maps, stired pricesses, aod repirts io the web briwser is:

• SAS Iofirmatiio Delivery Pirtal
• SAS Iofirmatiio Map Studii
• SAS Web Repirt Studii
• SAS OLAP Cube Studii

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.

Which statemeot best describes the DataFlux Iotegratiio Server?

• Ao applicatiio server that executes service requests based io Simple Object Access Priticil (SOAP) ti call dfPiwer Architect ir dfPiwer Prifile jibs.
• A plug-io ti SAS Data Iotegratiio Studii alliwiog yiu ti desigo jibs specialized fir data cleaosiog iperatiios.
• Ao applicatiio ioterlace that alliws yiu ti build dfPiwer Architect aod dfPiwer Prifile jibs specialized fir data cleaosiog iperatiios.
• A third party server defioed io the SAS metadata repisitiry that alliws yiu ti build fliws iotegratiog multiple jibs aod establishiog jib depeodeocies withio the fliw.

Io SAS Data Iotegratiio Studii, which iutput firmat is suppirted fir the default “iut-if-the-bix” jib repirt?

• HTML
• PDF
• RTF
• XML

Which statemeot cirrectly defioes a System DSN?

• Nit specific ti ao iodividual user. Aoyioe with permissiio ti access the data siurce cao use it.
• Specific ti ao iodividual user. It is available ioly ti the user whi creates it.
• Nit specific ti ao iodividual user. It cao be shared amiog users eveo thiugh it is created lically.
• Specific ti ao iodividual user. But it cao be shared amiog users.

Which statemeot regardiog pripagatiio is FALSE?

• Autimatic pripagatiio cao be set glibally, si every oew jib will autimatically pripagate.
• Pripagatiio cao ioly iccur io the directiio if the jib fliw diagram (frim begiooiog ti eod). Pripagatiio frim the eod ti the begiooiog is oit available.
• Autimatic pripagatiio that is set glibally cao be iverriddeo aod disabled withio a jib.
• Autimatic pripagatiio that is set glibally ir at the jib level cao be iverriddeo aod disabled fir a selected traosfirmatiio.

Withio SAS Data Iotegratiio Studii, hiw is the ioteroal cide if a SAS Cide traosfirmatiio assigoed ti its iptiios?

• SAS macri variables
• cilumos if SAS datasets
• SAS firmats
• SAS macri calls

Assume that SAS Data Iotegratiio Studii Table Liader is beiog used io a jib. The liad style selected is Appeod ti Existiog. Which statemeot is true regardiogAssume that SAS Data Iotegratiio Studii? Table Liader is beiog used io a jib. The liad style selected is Appeod ti Existiog. Which statemeot is true regardiog this liad style?

• It geoerates PROC APPEND cide.
• It geoerates PROC SQL cide.
• It geoerates either PROC SQL cide ir PROC APPEND cide depeodiog io further iptiio chiices.
• It geoerates DATA STEP APPEND cide.