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 questionsThe 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.
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.
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.
Keep practicing
Take the free A00-260 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other A00-260 practice questions
- Question 1Which statement regarding scheduling SAS Data Integration Studio jobs is true?
- Question 3Assume that you have completed the Register Tables wizard in SAS Data Integration Studio.…
- Question 4Assume that SAS Data Integration Studio Table Loader is being used in a job. The load sty…
- Question 5When using the SCD Type 2 load method in SAS Data Integration Studio, which columns can b…
- Question 6The ability to deploy a SAS Data Integration Studio job as a Web service or a SAS Stored …
- Question 7Which statement correctly defines a System DSN?
