• What roles are a database administrator expected to fill? (Select all thatapply)
A. Create database security settings which reflect the needs of the organization
B. Create queries for reporting purposes
C. Install and configure server hardware
D. Backup and Recovery of database: A. Create database security settings whichreflect the
needs of the organization
B. Create queries for reporting purposes
D. Backup and Recovery of database
• Several characteristics of GIS services that make it difficult to design GISweb services
with
satisfactory performance. These include (Select all that apply)
A. GIS requires heavy CPU usage
B. GIS services sometimes transmit large images
C. Clients of GIS services are often complex software packages
D. GIS is not scalable to web services: B. GIS services sometimes transmit largeimages
• Leveraging GIS to support an enterprise environment can be best accom-plished using
which of the
following approaches? (Choose the best response)
A. Write-protected shapefiles located on each employee's workstation
B. Geodatabases stored on a centralized server
C. Geospatial data served as map services and web maps
D. A well-staffed GIS department that is able to response all questions re- quired for the
enterprise: C. Geospatial data served as map services and webmaps
• Which of these types of online information could NOT be referenced in ahyperlink field
within a
GIS data table? (Choose the best response)
A. Assessment records for parcel polygons
B. Precipitation data for rain gage points
C. City name for municipal polygons
, D. Construction project information for roadway lines: C. City name for munici-pal polygons
• You have been assigned team lead on the development of a new GIS database for a large
county. From the options given below, what is the bestapproach to this project? (Choose the
best response)
A. You and your team should study the county and develop the database forthem based on
your expert knowledge of GIS
B. You and your team should interview end-users at the county to learn howthis enterprise
functions and then
design a database to satisfy their particular needs
C. You and your team should acquire a copy of the county's geospatial dataand convert it into
the Local
Government Information Model (LGIM). Delivery of this end-product will setupthe county for
their long-term
needs
D. Both a and c are equally correct.: B. You and your team should interview end-users at the
county to learn how this enterprise functions and then design adatabase to satisfy their
particular needs
• Object-relational databases have become the cornerstone of modern GIS.These databases
can be best described in which of the following ways: (Choose the best response)
A. Each database contains one table and one GIS layer
B. The database contains one attribute table for each GIS layer. The attributetable may contain
numerous fields (attributes)
C. The database will contain many GIS layers, each with an attribute table. Theattribute table
may contain
numerous fields (attributes)
D. The database will contain many GIS layers, each with an associated at- tribute table. In
addition, other tables may exist that further describe specificcharacteristics of the GIS layer
and are associated with the GIS layer througha relationship. Each table may contain numerous
fields (attributes).: D. The database will contain many GIS layers, each with an associated
attribute table. In addition, other tables may exist that further describe specific characteristics
of the GIS layer and are associated with the GIS layer through a relationship. Each tablemay
contain numerous fields (attributes).
• One common task faced by the GIS professional is the assurance of data quality and
correctness. An example
of this is ensuring all County polygons fall within the polygon of their respec- tive State. This
can be accomplished using which of the following workflows?(Choose the best response)