A00-250 practice question 15 of 15

A platform administrator needs to delete metadata for table definitions with the following characteristics: - the table definitions exist in the metadata repository - the table definitions do not have a corresponding table in the physical library After performing impact analysis, what action should the platform administrator take?

Full set: 65 questions
Answer options
A: delete repository
B: delete physical library
C: delete the table’s metadata folder
D: update table metadata Correct answer
Correct Answer:
D. update table metadata
Explanation

The "Update Table Metadata" utility in SAS Management Console is the designated tool for synchronizing metadata table definitions with their corresponding physical tables. This utility compares registered tables in the metadata repository against the tables physically present in the library's data source. It provides an option to delete the metadata for tables that are found in the metadata but no longer exist physically, which directly and precisely resolves the issue described in the scenario.

Why Incorrect

A. delete repository: This is an excessively destructive action. Deleting the entire repository would remove all metadata for all applications, not just the specific orphaned table definitions.
B. delete physical library: This action is irrelevant and impossible. The question states the corresponding physical table does not exist, so there is nothing to delete from the physical layer.
C. delete the table’s metadata folder: This is not the most precise action. Deleting a folder would remove all objects it contains, potentially including metadata for valid tables, libraries, or other resources.

References

1. SAS® 9.4 Intelligence Platform: System Administration Guide, Fifth Edition.

Location: Chapter 13, "Administering SAS Data," Section: "Synchronizing Metadata for Tables in a Library."

Quote/Content: "The Update Table Metadata utility enables you to update metadata for all of the tables in a library at one time... The utility compares the tables that are registered in the metadata with the tables that are physically present in the library. You can then add metadata for new tables, update metadata for changed tables, and delete metadata for tables that have been removed." This directly supports using the update utility to delete metadata for non-existent tables.

2. SAS® Management Console 9.4: Guide to Users and Administrators.

Location: Chapter 4, "Using the Data Library Manager," Section: "Update Table Metadata."

Quote/Content: "The Update Table Metadata wizard enables you to synchronize the metadata for the tables in a library with the physical tables... If a table exists in the metadata but not in the physical library, you can choose to delete the table's metadata." This confirms the wizard's function to handle the exact scenario.

Scroll to Top