A00-260 by SASInstitute Actual Free Exam Q&As

Question 1

Within SAS Data Integration Studio, automatic mappings are disabled for a job. A transformation has defined source columns and defined target columns. One of the source columns, named COL1, is character with a length of 50. One of the target columns, named COL1, is also character but of length 25. What will happen if the COL1 columns are mapped?

A. The COL1 columns are successfully mapped, one-to-one, but a warning occurs. B. The COL1 columns are not mapped because the lengths are different. C. The COL1 columns are successfully mapped, one-to-one, with no warnings. D. The COL1 columns are mapped but an expression is defined for the target COL1 that uses a generic specification of the LENGTH function.

Discussion 0

Correct Answer: A Vote an answer

Question 2

Assume that SAS Data Integration Studio Table Loader is being used in a job. The load style selected is Append to Existing. Which statement is true regardingAssume that SAS Data Integration Studio? Table Loader is being used in a job. The load style selected is
Append to Existing. Which statement is true regarding this load style?

A. It generates PROC APPEND code. B. It generates DATA STEP APPEND code. C. It generates either PROC SQL code or PROC APPEND code depending on further option choices. D. It generates PROC SQL code.

Discussion 0

Correct Answer: C Vote an answer

Question 3

Which statement regarding propagation is FALSE?

A. Automatic propagation can be set globally, so every new job will automatically propagate. B. Propagation can only occur in the direction of the job flow diagram (from beginning to end). Propagation from the end to the beginning is not available. C. Automatic propagation that is set globally can be overridden and disabled within a job. D. Automatic propagation that is set globally or at the job level can be overridden and disabled for a selected transformation.

Discussion 0

Correct Answer: B Vote an answer

Question 4

Which statement defines the characteristics of a SAS Stored Process?

A. A document that stores the steps and locations for building a data mart. B. A SAS program that is stored on the server and described by metadata. C. SAS metadata that describes how to collect and store data sources. D. A user written SAS PROC step.

Discussion 0

Correct Answer: B Vote an answer

Question 5

Within SAS Data Integration Studio, which type of expression can be created using the Expression Builder window in the Where tab of SAS Extract transformation? 1) a SAS expression 2) an SQL expression 3) an XML expression 4) a constant

A. 1 and 2 only B. 1 and 3 only C. 1, 2, 3, and 4 D. 1, 2 and 4 only

Discussion 0

Correct Answer: D Vote an answer

Question 6

In SAS Data Integration Studio, an index can be specified/defined in which location?

A. the Indexes tab in the properties of a job metadata object B. the Indexes tab in the properties of a Table Loader transformation C. the Indexes tab in the properties of a table metadata object D. the Indexes tab in the properties for any transformation

Discussion 0

Correct Answer: C Vote an answer

Question 7

When writing postcode in the Precode and Postcode tab of the Transpose transformation in SAS Data Integration Studio, which symbol allows you to reference the transformation output table regardless of the actual physical name for that target table?

A. &target B. &syslast C. syslast D. %target

Discussion 0

Correct Answer: B Vote an answer

SASInstitute SAS Data Integration Development - A00-260 Exam Practice Test