100% Correct
What roles are a database administrator expected to fill? (Select all that apply)
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 - ANSWER A. Create database security settings
which reflect 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 GIS web 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 - ANSWER B. GIS services sometimes transmit
large images
Leveraging GIS to support an enterprise environment can be best accomplished 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 required for the
enterprise - ANSWER C. Geospatial data served as map services and web maps
Which of these types of online information could NOT be referenced in a hyperlink 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 - ANSWER C. City name for
municipal 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 best approach to this project?
, (Choose the best response)
A. You and your team should study the county and develop the database for them
based on your expert knowledge of GIS
B. You and your team should interview end-users at the county to learn how this
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 data and
convert it into the Local
Government Information Model (LGIM). Delivery of this end-product will setup the
county for their long-term needs
D. Both a and c are equally correct. - ANSWER B. You and your team should
interview end-users at the county to learn how this enterprise functions and then design
a database 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 attribute table may
contain numerous fields (attributes)
C. The database will contain many GIS layers, each with an attribute table. The attribute
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 table
may contain numerous fields (attributes). - ANSWER 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 table may 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 respective State. This can be accomplished using which of the
following workflows? (Choose the best response)
A. Clip the Counties polygon layer with the State polygon layer. Then check if the
counties layer changed. If so, it is understood that the Counties layer was larger than
the State layer, thus requiring further action.
B. Apply a topology rule to the Geodatabase feature dataset containing County and
State polygon feature classes and determine if the State feature class is covered by the
Counties feature class
C. Apply a topology rule to the folder containing County and State shapefiles and
determine if the State feature class is covered by the Counties feature class