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 questions
Answer options
A: The physical table(s) selected are copied to the application server specified in the library.
B: The physical table(s) selected are copied to the SAS Folders location specified in the wizard.
C: Metadata for the physical table(s) selected is stored on the application server specified in the library.
D: Metadata for the physical table(s) selected is stored in the SAS Folders location specified in the wizard. Correct answer
Correct Answer:
D. Metadata for the physical table(s) selected is stored in the SAS Folders location specified in the wizard.
Explanation

The "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.

Why Incorrect

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.

References

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.

Scroll to Top