Labour Day Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: scxmas70

A00-260 Exam Dumps - SAS Data Integration Development

Question # 4

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.

Full Access
Question # 5

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

A.

the Keys tab in the properties of a Table Loader transformation

B.

the Keys tab in the properties for any transformation

C.

the Keys tab in the properties of a table metadata object

D.

the Keys tab in the properties of a job metadata object

Full Access
Question # 6

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

Full Access
Question # 7

Consider the job flow diagram in the display. Which of these objects has parameters defined for it?

A.

Control table

B.

Loop transformation

C.

Inner Job

D.

Loop End

Full Access
Question # 8

Which statement is FALSE regarding foreign keys?

A.

A foreign key is one or more columns that are associated with a primary key or unique key in another table.

B.

A table can have zero or more foreign keys.

C.

A foreign key cannot exist without an associated primary or unique key.

D.

A table can have only one foreign key defined.

Full Access
Question # 9

When using the SCD Type 2 load method in SAS Data Integration Studio, which columns can be selected to check for changed data?

A.

business key columns

B.

Type 1 columns

C.

generated columns

D.

non-key columns

Full Access
Question # 10

Select the valid reasons for using SAS Data Integration Studio's Table Loader transformation. (Choose two.)

A.

Create and replace permanent tables.

B.

Maintain access privileges to permanent tables.

C.

Apply and maintain constraints on permanent tables.

D.

Delete and remove permanent tables.

Full Access