EGMP2201 practice question 10 of 15
AGIS data administrator needs to migrate the enterprise geodatabase to another server and wants to have the following changes: • New enterprise geodatabase name • Changed Repository tables owner from SDE to DBO Which migration workflow should be used?
Full set: 65 questionsThe required changes—a new geodatabase name and altering the repository owner from SDE to DBO—are fundamental configuration settings established during the geodatabase's initial creation. The only workflow that accommodates these specific changes is to create a new, empty enterprise geodatabase on the target server. During this process, the administrator can define the new name and use the "Enable Enterprise Geodatabase" tool to specify 'DBO' as the geodatabase administrator, which in turn creates the repository tables in the DBO schema. After the new geodatabase is correctly configured, data from the old geodatabase can be migrated into it using methods like XML workspace documents or copy/paste operations.
A. Restore a database backup: This method creates an exact replica of the source database, preserving the original geodatabase name and the 'SDE' schema owner. It does not allow for reconfiguration during the migration.
C. Migrate Storage geoprocessing tool: This tool is designed to change the underlying data storage format (e.g., from SDEBINARY to Geometry) for individual tables within an existing geodatabase, not to migrate the entire geodatabase or change its core properties. ---
1. Esri ArcGIS Pro Documentation, "Enable an enterprise geodatabase in SQL Server": This document outlines the process of creating a geodatabase. It explicitly states, "If the geodatabase administrator is the dbo user, the geodatabase system tables, views, functions, and stored procedures are created in the dbo schema." This confirms that specifying the owner is part of the creation/enablement process.
Source: Esri ArcGIS Pro 3.2 Documentation, "Data management" > "Geodatabases" > "Administer" > "Enable an enterprise geodatabase in SQL Server".
2. Esri ArcGIS Pro Documentation, "Geodatabase migration options": This page discusses different strategies for moving a geodatabase. It implicitly supports the "create new and load data" approach for scenarios where the target configuration (like schema or name) must be different from the source, as opposed to a simple backup/restore for identical moves.
Source: Esri ArcGIS Pro 3.2 Documentation, "Data management" > "Geodatabases" > "Administer" > "Geodatabase migration options".
3. Esri ArcGIS Pro Tool Reference, "Migrate Storage (Data Management)": The official tool documentation clearly defines its limited scope. The summary states: "Migrates the storage of a geodatabase table or feature class from one storage type to another." This confirms it is not a tool for migrating an entire geodatabase to a new server or changing its owner.
Source: Esri ArcGIS Pro 3.2 Documentation, "Tool Reference" > "Data Management toolbox" > "Geodatabase Administration toolset" > "Migrate Storage".
Keep practicing
Take the free EGMP2201 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other EGMP2201 practice questions
- Question 1A GIS data administrator needs to restrict access to some fields in a feature class from …
- Question 2A GIS data manager needs to allow editors to see changes made to the default version in t…
- Question 3A GIS data administrator is unable to upgrade the geodatabase while editors have active s…
- Question 4A GIS database administrator needs to identify any performance issues with a nightly load…
- Question 5A GIS analyst needs to visualize a centralized folder of imagery with multiple images in …
- Question 6An editor connects to an enterprise geodatabase to edit a feature class that uses traditi…
