A00-250 practice question 12 of 15
Select the method for updating table meta data that provides for the most control over updating features and can be run in batch.
Full set: 65 questionsThe METALIB procedure (PROC METALIB) is a SAS code-based utility for creating and updating metadata for SAS libraries and tables. Because it is executed as SAS code, it offers the most granular control over the update process through its various statements and options (e.g., UPDATERULE=, SELECT=, DELETE). This allows for precise specification of which tables to update, add, or remove from metadata. As a standard SAS procedure, it can be saved in a .sas program file and executed in batch mode, satisfying both requirements of the question.
A. This is a GUI-driven wizard in SAS Management Console. It is designed for interactive use and offers less granular control over the update process compared to code.
B. This is a point-and-click task within SAS Enterprise Guide. It is intended for interactive sessions and lacks the extensive customization and batch-native capabilities of PROC METALIB.
C. This is an interactive wizard within SAS Data Integration Studio. While jobs can be scheduled, this specific function is for interactive development and does not provide the deep control of a procedure. ---
1. SAS Institute Inc. (2020). SAS® 9.4 Language Interfaces to Metadata, Fifth Edition.
Location: Chapter 5, "METALIB Procedure".
Content: This chapter details the syntax and options for PROC METALIB. It explicitly states, "The METALIB procedure enables you to use the SAS language to create and update metadata for SAS libraries and tables... Because PROC METALIB is a SAS procedure, you can incorporate it into a SAS program and run it in batch." The numerous options described, such as UPDATERULE=, SELECT=, and DELETE, demonstrate the high degree of control available.
2. SAS Institute Inc. (2018). SAS® 9.4 Intelligence Platform: System Administration Guide, Fourth Edition.
Location: Chapter 12, "Registering and Updating Tables in SAS Management Console".
Content: This section describes the GUI-based "Update Metadata" wizard for SAS libraries. The process is presented as a series of interactive steps ("In the wizard, select the tables that you want to update..."), which contrasts with the batch-capable, code-driven nature of PROC METALIB.
3. SAS Institute Inc. (2020). SAS® Enterprise Guide® 8.3: User’s Guide.
Location: Chapter 11, "Working with Data," Section "Updating Table Metadata for a Library".
Content: This guide describes the "Update Library Metadata" task as an interactive tool within the SAS Enterprise Guide interface. The user selects a library and clicks a button to invoke a dialog box, confirming its design for interactive use rather than batch processing with fine-tuned control.
Keep practicing
Take the free A00-250 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other A00-250 practice questions
- Question 1A platform administrator needs to restore backup files to a running metadata server. Whic…
- Question 2How many object spawners, at a minimum, need to be defined in the metadata?
- Question 3The passwords for service accounts that occur in some of the configuration files have bee…
- Question 4A platform administrator needs to associate a library with an application server. What pe…
- Question 5What is the correct order in which to start up the SAS servers and spawners?
- Question 6An internal account is used to provide the initial connection to which server?
