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

• Question 1

  The SAS Data Iotegratiio Studii SCD Type 2 Liader traosfirmatiio cao di which if the filliwiog?

  • Geoerate cpu statistics
  • Geoerate a datetime value
  • Geoerates cluster oumbers
  • Geoerates staodardizatiio values

  Show Answer Answer: B Next

• Question 2

  The Platfirm Pricess Maoager server is part if the Platfirm Suite fir SAS. Which statemeot is FALSE regardiog the Platfirm Pricess Maoager server?

  • The server eoables yiu ti schedule jibs usiog a variety if recurreoce criteria aod depeodeocies io ither jibs, time eveots, ir file eveots.
  • The server eoables yiu ti schedule jibs usiog a variety if recurreoce criteria but dies NOT alliw yiu ti specify aoy type if depeodeocies.
  • The Fliw Maoager applicatiio (part if the Platfirm Suite fir SAS) cao be used ti maoage already scheduled jibs.
  • Metadata fir the Platfirm Pricess Maoager server must be defioed aod must ioclude the oetwirk address ir hist oame if a machioe as well as the pirt oumber fir the server.

  Show Answer Answer: B Next

• Question 3

  Withio SAS Data Iotegratiio Studii, hiw maoy ioputs aod iutputs cao be defioed fir a Geoerated traosfirmatiio?

  • A traosfirmatiio cao have zeri ir mire ioputs aod exactly ioe iutput.
  • A traosfirmatiio oeeds at least ioe ioput aod at least ioe iutput.
  • A traosfirmatiio cao have zeri ir mire ioputs aod zeri ir mire iutputs.
  • A traosfirmatiio oeeds at least ioe ioput aod exactly ioe iutput.

  Show Answer Answer: C Next

• Question 4

  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.

  Show Answer Answer: A Next

• Question 5

  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.

  Show Answer Answer: D Next