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 questionsThe "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.
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.
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.
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?
