Real SASInstitute A00-260 (SAS Data Integration Development) exam Q&As free download

1.Assume that you have completed the Register Tables wizard in SAS Data Integration Studio. Which
statement is true?
A. The physical table(s) selectedare copied to the application server specified in the library.
B. The physical table(s) selectedare copied to the SAS Folders location specified in the wizard.
C. Metadata for the physical table(s) selected is stored on the application server specified in the library.
D. Metadata for the physical table(s) selected is stored in the SAS Folders location specified in the wizard.
Answer: D
2.You want to register an external file with the following structure: first line contains Customer First and
Last Name second line is address1 third line is address 2 fourth line contains the phone number What
action should you take to read this file?
A. Use the New User Written External File wizard.
B. Use the New Fixed Width External File wizard.
C. Use the New Delimited External File wizard.
D. Use the New COBOL Copybook wizard.
Answer: A
3.Registering metadata for an ODBC data source involves registering:
A. a library that will use a SAS/ACCESS engine to a specific database
B. only an ODBC data source definition
C. a server definition that points to the ODBC data source and a library accessing this server definition
D. a table pointing directly to the ODBC data source
Answer: C
4.SAS Data Integration Studio is dependent on which administration functions?
A. Setting up of SAS Information Map environment.
B. Setting up of SAS Web and SAS Portal environments.
C. Setting up of SAS Application Servers.
D. Setting up of SAS Libraries definitions.
Answer: C
5.The ability to deploy a SAS Data Integration Studio job as a Web service or a SAS Stored Process
requires additional set up that is performed in which client application?
A. SAS Data Integration Studio
B. SAS Enterprise Guide
C. SAS Job Deployment Studio
D. SAS Management Console
Answer: D
6.Which of the following is NOT defined as part of the New Library Wizard?
A. the type of library
B. the metadata name for the library
C. the location of the library
D. the metadata for the library tables
Answer: D
7.Within SAS Data Integration Studio, which one of the following is NOT an option available from the
File-> New menu choice under External File grouping?
A. Delimited
B. Fixed Width
C. User Written
D. COBOL Copybook
Answer: D
8.Which statement correctly defines a System DSN?
A. Not specific to an individual user. Anyone with permission to access the data source can use it.
B. Specific to an individual user. It is available only to the user who creates it.
C. Not specific to an individual user. It can be shared among users even though it is created locally.
D. Specific to an individual user. But it can be shared among users.
Answer: A
if you need more exam question,u can leave ur mailbox,or like my facebook page http://www.facebook.com/pages/Free-It-certification-exam-Real-QAs-such-as-ccna-mcse-comptia/159996837383933