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
Annmarie
3 days ago
I think C is the best choice for versioned data.
upvoted 0 times
...
Maryann
8 days ago
Option B seems right since it combines both data types.
upvoted 0 times
...
Estrella
13 days ago
B is the best option, it covers all the requirements nicely!
upvoted 0 times
...
Gabriele
18 days ago
I disagree, A seems too limiting with just feature class and repository tables.
upvoted 0 times
...
Nenita
23 days ago
Wait, can you really create a view from a child version? Sounds tricky!
upvoted 0 times
...
Felicidad
29 days ago
I think C is the way to go, versioned views are crucial here.
upvoted 0 times
...
Lera
1 month ago
Definitely B, combining feature class and nonspatial table makes sense.
upvoted 0 times
...
Margo
1 month ago
I recall that combining data from a feature class and a nonspatial table is common, but I can't remember if it should be done on the versioned view or not.
upvoted 0 times
...
Becky
1 month ago
I practiced a similar question where we had to consider dynamic updates. I think that might lean towards option C, but I'm not completely sure.
upvoted 0 times
...
Jaime
2 months ago
I'm a bit unsure, but I feel like the versioned view might be important since we're working with a child version.
upvoted 0 times
...
Noel
2 months ago
I think we need to focus on how the data is combined. I remember something about using the feature class and nonspatial table together.
upvoted 0 times
...

Save Cancel