A GIS data administrator receives a request to create a database view that meets the following criteria:
* Data is combined from feature class and nonspatial table
* Source feature class is versioned
* Source is from a child version
* Needs to be dynamically updated
How should the view be created?
Understanding the Scenario:
The request involves creating a view that dynamically combines data from a versioned feature class and a nonspatial table.
The data needs to be from a child version and updated dynamically.
Key Considerations:
Versioned Feature Class: Standard feature classes in versioned geodatabases store edits in delta tables (adds and deletes). Accessing data from a specific version requires using the versioned view, which includes these edits.
Dynamic Updates: Views created on the versioned view ensure that the data reflects the most current version edits.
Steps to Create the View:
Identify the versioned view for the feature class (created automatically during versioning).
Create a SQL query to join the versioned view and the nonspatial table on the appropriate key(s).
Save the SQL query as a database view.
Reference:
Esri Documentation: Versioned Views.
Creating Views with Versioned Data: Guidelines for joining versioned views with other tables in SQL.
Why the Correct Answer is C: Using the versioned view ensures that data reflects edits from the specified child version. Joining this view with the nonspatial table meets the requirement for dynamic updates. Options A and B would not provide data from the versioned child version dynamically.
Currently there are no comments in this discussion, be the first to comment!