Final Exam

Question 1

1: The top level version of the geodatabase is:
A ) Editor
B ) Parent
C ) Default
D ) Primary

Answer 1

C) Default

Question 2

2: What can’t you do when doing non-versioned editing?
A ) Edit tables
B ) Undo single operations
C ) Use other applications to access data
D ) Have multiple users

Answer 2

D) Have multiple users

Question 3

3: Which table(s) contain(s) information on records added, deleted or updated in versioned editing?
A ) Add and Delete
B ) Spatial Index and Geometry Index
C ) Business
D ) Layers

Answer 3

A) Add and Delete

Question 4

4: Geodatabase Replication can be:
A ) Check in/Check out
B ) One way
C ) Two way
D ) All of the above

Answer 4

D) All of the above

Question 5

5: Versioned editing with the option to move edits to base means:
A ) all changes are saved in the Add and Delete tables
B ) the database doesn’t have to be compressed
C ) 3rd party applications can’t see your changes
D ) you never reconcile to the Default version

Answer 5

B) the database doesn’t have to be compressed

Question 6

6: You can load data into an SDE Enterprise geodatabase using:
A ) Python commands
B ) ArcToolbox tools
C ) An ArcGIS Desktop Model or script
D ) FME
E ) All of the above

Answer 6

E) All of the above

Question 7

7: What should always be done after loading data in an SDE Enterprise Geodatabase?
A ) Add geodatabase behaviour
B ) Create attribute indexes
C ) Build database statistics with Analyze
D ) Grant privileges to other users
E ) All of the above

Answer 7

E) All of the above

Question 8

8: Which “Best Practice” is only done by the SDE Administrator?
A ) update database statistics
B ) compress database
C ) delete old versions
D ) rebuild attribute indexes

Answer 8

B) compress database

Question 9

9: Your Oracle 11G user account has the following permissions:
A ) SDE Administrator
B ) GIS User
C ) select, insert, update, delete
D ) connect, resource, create table, select any dictionary

Answer 9

D) connect, resource, create table, select any dictionary

Question 10

10: Which configuration keyword defines the storage of system tables?

A ) Data_Dictionary

B ) BLOB

C ) ST_Geometry

D ) Defaults

Answer 10

A) Data_Dictionary

Question 11

11: Which type of Raster compression would you use on images you wish to use in analysis?
A ) LZ77
B ) JPEG
C ) Cubic Convolution
D ) JPEG2000

Answer 11

A) LZ77

Question 12

12: Of the five tables used to store a raster, four of them are named using the:
A) layer_id

B) rasterband_id

C) raster_column_id

D) registration_id

Answer 12

C) raster_column_id

Question 13

13: Which raster table stores metadata about the raster bands?
A ) BLK
B ) RAS
C ) AUX
D ) BND

Answer 13

D) BND

Question 14

14: A mosiac consists of multiple rasters merged into a single image.
A ) True
B ) False

Answer 14

A) True

Question 15

15: Which interpolation method should be used to create pyramids from continuous raster data?
A ) nearest neighbour
B ) cubic convolution
C ) kriging
D ) aggregation
E ) bilinear interpolation

Answer 15

B) cubic convolution

Question 16

16: Describe a scenario where it would be preferable to do non-versioned editing of an Enterprise Enabled ArcSDE geodatabase.

Answer 16

Non versioned editing would be done in a scenario where:
A. Replication/Archiving is not required
B. No Complex Data (Networks or Topology)
C. Edit Session Isolation and Conflict Resolution Unecissary
D. The Edits need to be displayed rapidly.

Question 17

17: Describe Archiving in and ArcSDE Enterprise Geodatabase.

Answer 17

Archiving allows all changes within the database to be tracked in Archive Tables. This tracks the date and time at which the change was made.

Question 18

18: Describe the reconcile and post process of a versioned editing environment.

Answer 18

When edits have been completed within a version of the database, those records are reconciled first to resolve any conflicts between edits made in a separate version of the database. Once the records are reconciled, they are then posted to the target database (QA/QC or default). This process allows for quality control of the data before it is posted for public display.