Pass the SAS Institute Data Integration Developer A00-260 Questions and answers with CertsForce

Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions
Questions # 1:

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?

Options:

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.


Expert Solution
Questions # 2:

Which statements are true regarding columns when using SAS Data Integration Studio's New Tables wizard? 1. You can access metadata for any column from any table already registered in metadata but cannot change it. 2. You can access metadata for any column from any table already registered in metadata and can override the imported information. 3. You can define new columns for the table. 4. You cannot define new columns.

Options:

A.

1 and 2


B.

1 and 3


C.

2 and 3


D.

2 and 4


Expert Solution
Questions # 3:

Which statement is true regarding SAS packages created in SAS Data Integration Studio?

Options:

A.

SAS packages are used to import and export SAS applications.


B.

SAS packages are used to import and export stand-alone SAS programs.


C.

SAS packages are used to import and export third-party metadata.


D.

SAS packages are used to import and export SAS metadata.


Expert Solution
Questions # 4:

Which statement correctly defines a System DSN?

Options:

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.


Expert Solution
Questions # 5:

After creating a stored process from a SAS Data Integration Studio job, how can you test the stored process to make sure it runs correctly?

Options:

A.

Execute the stored process in SAS Data Integration Studio.


B.

Execute the stored process in SAS Management Console.


C.

Execute the stored process using the SAS Add-In for Microsoft Office or SAS Enterprise Guide.


D.

Execute the stored process using SAS Display Manager's Stored Process Test window.


Expert Solution
Questions # 6:

Which action is required for enabling performance statistics on the executing SAS Workspace Server?

Options:

A.

Define a logfile for output.


B.

Define Collect Diagnostics for the SAS Data Integration Studio job.


C.

Define Collect Runtime statistics for the SAS Data Integration Studio job.


D.

Enable the logging facility of the SAS Workspace Server.


Expert Solution
Questions # 7:

SAS Data Integration Studio is dependent on which administration functions?

Options:

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.


Expert Solution
Questions # 8:

When using the SCD Type 2 load method in SAS Data Integration Studio, which statement is true when a change is detected?

Options:

A.

the old record is deleted and the changed record is added


B.

the old record is updated with the new values from the changed record


C.

the old record is flagged and the changed record is added


D.

the old record is merged with the changed record


Expert Solution
Questions # 9:

A user needs to find out who has the SAS Data Integration Studio job "Create Tables" checked out. What action should the user perform?

Options:

A.

They need to select the "Properties" menu option and then the "Advanced" tab for the SAS Data Integration

Studio job "Create Tables" within Data Integration studio.


B.

They need to select the History menu option for the SAS Data Integration Studio job "Create Tables" once it

has been checked in.


C.

They need to select the History menu option for the SAS Data Integration Studio job "Create Tables".


D.

They are not able to find out who has the SAS Data Integration Studio job "Create Tables" in checked out

status because they are not an administrator.


Expert Solution
Questions # 10:

Assume that a SAS Data Integration Studio job is populating a table, and the table has metadata definitions for two simple indexes. Which of the following is NOT a valid location for viewing which columns are indexed?

Options:

A.

the Load Technique tab in the Table Loader transformation properties window


B.

the Indexes tab in the table properties window


C.

the Columns tab in the table properties window


D.

the Columns tab in the Details panel of the open job, with the table selected in the job flow


Expert Solution
Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions