A00-260 practice question 13 of 15

Which statements are true regarding columns when using SAS Data Integration Studio’s New Tables wizard? 1. You can access metadata for any column…

Full set: 70 questions
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.
Answer options
A: land2
B: land3
C: 2and3 Correct answer
D: 2and4
Correct Answer:
C. 2and3
Explanation

The New Tables wizard in SAS Data Integration Studio is used to define the metadata for a new table. This wizard provides comprehensive functionality for defining columns. A user can import column definitions from any table already registered in the SAS Metadata Repository. After importing, the user is free to override the properties (e.g., name, type, length, format) of these columns for the new table being created. The wizard also enables the user to define entirely new columns from scratch by manually specifying all their attributes. Therefore, both overriding imported metadata and defining new columns are supported functions.

Why Incorrect

Statement 1: This is incorrect. While you cannot change the metadata of the source table, you can override the imported column properties for the new table you are defining.
Statement 4: This is incorrect. The wizard explicitly provides a function (typically a 'New' or 'Add' button) to create new columns that are not imported from another source.

References

1. SAS Institute Inc. (2017). SAS Data Integration Studio 4.9: User's Guide.

Section: Chapter 12, "Working with Tables" -> "Creating and Registering Tables" -> "Using the New Table Wizard".

Details: The documentation for the "Columns page" of the New Table wizard explicitly describes the "Import" button to bring in columns from an existing registered table and the "New" button to define a new column. The grid displaying the columns allows for the editing of properties like Name, Data Type, and Length, confirming that imported information can be overridden.

2. SAS Institute Inc. (2013). SAS Data Integration Studio 4.6: User's Guide.

Section: Chapter 11, "Working with Tables" -> "Creating and Registering Tables" -> "Using the New Table Wizard".

Details: Similar to the 4.9 guide, this version details the functionality of the Columns page in the wizard. It states, "You can add columns to the new table by importing them from another table or by creating new columns." This directly supports that statements 2 and 3 are the correct descriptions of the wizard's capabilities.

Scroll to Top