Free SASInstitute A00-260 Exam Dumps Questions & Answers

Which statement correctly defines a System DSN?

• A.Specific to an individual user. It is available only to the user who creates it.
• B.Specific to an individual user. But it can be shared among users.
• C.Not specific to an individual user. Anyone with permission to access the data source can use it.
• D.Not specific to an individual user. It can be shared among users even though it is created locally.

When using SAS Data Integration Studio's SQL Join transformation, which SQL join type can be constructed as either an implicit or an explicit join?

• A.Inner
• B.Union
• C.Cross
• D.Full

Within SAS Data Integration Studio's SQL Join transformation, the Validate Expression button is located in:

• A.a Where clause definition
• B.a Subquery definition
• C.a field Expression definition
• D.an Expression Builder window

Which statement is FALSE regarding foreign keys?

• A.A foreign key cannot exist without an associated primary or unique key.
• B.A foreign key is one or more columns that are associated with a primary key or unique key in another table.
• C.A table can have only one foreign key defined.
• D.A table can have zero or more foreign keys.

In SAS Data Integration Studio, surrogate and retained key values are:

• A.copied from dimension tables into source tables
• B.copied from source tables into dimension tables
• C.generated by the Lookup transformation
• D.generated by the SCD Type 2 Loader transformation