A00-260 practice question 3 of 15
Assume that you have completed the Register Tables wizard in SAS Data Integration Studio. Which statement is true?
Full set: 70 questionsThe "Register Tables" wizard in SAS Data Integration Studio is a metadata creation tool. Its purpose is to create metadata objects that represent existing physical tables. It does not move, copy, or alter the physical data itself. The wizard prompts the user to select a location within the SAS Folders tree, which is a logical structure within the SAS Metadata Repository. The newly created metadata definitions for the selected tables are then saved to this specified folder, making them available for use in SAS Data Integration Studio jobs and other SAS applications.
A. The wizard registers metadata; it does not copy physical tables. The physical data remains in its original location as defined by the library.
B. SAS Folders is a logical hierarchy for storing metadata objects, not a physical file system location for storing copies of data tables.
C. Metadata is stored in the SAS Metadata Repository, which is managed by the SAS Metadata Server, not on the application server where processing occurs.
1. SAS Institute Inc. (2017). SAS Data Integration Studio 4.9: User's Guide.
Chapter 4: Working with Source Data and Target Tables, Section: "Registering Tables from a Source," p. 39. The documentation states, "You can use the Register Tables wizard to create metadata for one or more tables that are available from a SAS library." The steps in the wizard explicitly show selecting a SAS Folder as the destination for the new metadata object.
2. SAS Institute Inc. (2020). SAS 9.4 Intelligence Platform: Overview, Second Edition.
Chapter 2: SAS Intelligence Platform Architecture, Section: "SAS Metadata Server," p. 11. This document clarifies the architecture: "The SAS Metadata Server is a multi-user server that enables centralized control of metadata resources... Metadata is stored in a repository." It distinguishes the metadata server's role from the application server's role.
3. Delwiche, L. D., & Slaughter, S. J. (2012). The Little SAS Book: A Primer, Fifth Edition. SAS Institute.
Chapter 1: Getting Started with SAS, Section: "SAS Libraries," p. 10. While a general reference, this source establishes the fundamental concept that a SAS library is a pointer to a physical location where data is stored. The Register Tables wizard uses this library definition to find the physical table but creates a separate metadata object, reinforcing the distinction between the data's location and the metadata's location.
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 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?
- Question 8Which action is required for enabling performance statistics on the executing SAS Workspa…
