Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Esri EGMP2201 Exam - Topic 3 Question 32 Discussion

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 updatedHow should the view be created?
C) On the versioned view and nonspatial table
A) On the feature class and repository tables
B) On the feature class and nonspatial table

Esri EGMP2201 Exam - Topic 3 Question 32 Discussion

Actual exam question for Esri's EGMP2201 exam
Question #: 32
Topic #: 3
[All EGMP2201 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: C

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.


Contribute your Thoughts:

0/2000 characters

Currently there are no comments in this discussion, be the first to comment!


Save Cancel