SAS A00-260 Practice Questions| TestInsights

Question 1

In SAS Data Integration can be specified/defined Studio, primary keys, foreign keys and unique keys in which location?

Athe Keys tab in the properties of a Table Loader transformation

Bthe Keys tab in the properties for any transformation

Cthe Keys tab in the properties of a table metadata object

Dthe Keys tab in the properties of a job metadata object

Correct : C

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

Athe Keys tab in the properties of a Table Loader transformation

Bthe Keys tab in the properties for any transformation

Cthe Keys tab in the properties of a table metadata object

Dthe Keys tab in the properties of a job metadata object

Question 2

In order to use the SAS Data Integration Studio's Apply Lookup Standardization transformation, Data Quality options must be setup. Select the valid Scheme Repository Types. (Choose two.)

AA comma delimited flat file that contains the field names in the first row.

BPower scheme that is generated by Data Flux.

CA SAS table scheme that is generated by SAS.

DA third party RDBMS table that has been generated by the SAS system.

Correct : A, C

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AA comma delimited flat file that contains the field names in the first row.

BPower scheme that is generated by Data Flux.

CA SAS table scheme that is generated by SAS.

DA third party RDBMS table that has been generated by the SAS system.

Question 3

Which of the following is NOT a feature of SAS Data Integration Studio's Data Validation transformation?

AThe Data Validation transformation can generate match codes to provide de-duplication capabilities.

BThe Data Validation transformation can perform missing-value detection and invalid-value validation in a single pass of the data.

CThe Data Validation transformation provides de-duplication capabilities.

DThe Data Validation transformation provides error-condition handling.

Correct : A

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AThe Data Validation transformation can generate match codes to provide de-duplication capabilities.

BThe Data Validation transformation can perform missing-value detection and invalid-value validation in a single pass of the data.

CThe Data Validation transformation provides de-duplication capabilities.

DThe Data Validation transformation provides error-condition handling.

Question 4

Which statement correctly defines a System DSN?

ANot specific to an individual user. Anyone with permission to access the data source can use it.

BSpecific to an individual user. It is available only to the user who creates it.

CNot specific to an individual user. It can be shared among users even though it is created locally.

DSpecific to an individual user. But it can be shared among users.

Correct : A

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ANot specific to an individual user. Anyone with permission to access the data source can use it.

BSpecific to an individual user. It is available only to the user who creates it.

CNot specific to an individual user. It can be shared among users even though it is created locally.

DSpecific to an individual user. But it can be shared among users.

Question 5

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.

Aland2

Bland3

C2and3

D2and4

Correct : C

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

Aland2

Bland3

C2and3

D2and4

Curious about Actual SAS Certified Data Integration Developer (A00-260) Exam Questions?

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users: