Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

GIS 1479 > Test2 > Flashcards

Test2 Flashcards

1
Q

Match the letter in the image below with corresponding description of the entity-relationship model.

Attribute

Value

Entity Set

Entity

A

A. Entity

B. Attribute

C. Value

D. Entity Set

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Match the following letters labeling the elements of an Entity-Relationship Diagram with the corresponding term.

Entity

Key

Relationship

Attribute

A

A. Key

B. Entity

C. Relationship

D. Attribute

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

The ER Diagram is an example of a ___ data model with entities, relationships, entity data types, attributes, and keys.

A

The ER Diagram is an example of a logical data model with entities and relationships; as well as entity data types, attributes, and keys.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Which of the following geospatial physical data models (i.e. GIS data formats) represents vector data?

A

LiDAR data is stored as a point cloud vector model in a *.las file

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Geodatabase Terrain is a ______ data model

A

triangulated

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

A Digital Elevation Model (DEM) and Portable Network Graphic (*.png) are both ____ models.

A

Raster

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What models spatial relationships that describe proximity?

A

Distance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Topological relationships describe _____

A

connectivity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Directional relationships describe ____

A

direction

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Class relationships describe how ___, ___, or ___ relate

A

points, lines, or areas

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What type of data model is illustrated in this diagram?

A

The ER diagram illustrates a Physical Geodatabase Model

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Which of the following is NOT an independent entity?

A

Plat_Subtype is a characteristic entity that describes the Plat_Status attribute for the the independent Parcels entity. Parcles,TaxRecord2019, and LotBoundaries are all independent entities that can stand alone.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What type of attribute is ZIP_Code?

A

ZIP_Code is a LONG INTEGER attribute field in the Parcels feature class.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What type of relationship is modeled between Parcels and TaxRecord2019?

A

Many to Many

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Which of the following is not an acceptable value for the Secondary_Use field?

A

RES is not listed as an acceptable coded value in the Sec_Use_Codes attribute domain assigned to the Secondary_Use field in the Parcels polygonal feature class.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What arere relational tables?

A

Relational tables are based on the entity-relationship model and are a primary function of relational database management systems (RDBMS). Tabbed tables, pivot tables, and A1 Notation tables are all primary functions of a spreadsheet.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Also known as the schema, which of the following database modules list attributes for a table along with their legal values and ranges?

A

Data Dictionary

18
Q

The Data Entry Module enables users to…

A

The Data Entry Module enables users to enter and modify values.

19
Q

The Query Language enables users to

A

submit a question to a table.

20
Q

Report Generator allows users to…

A

Report Generator allows users to create a list of all (or a subset) of values stored in a table.

21
Q

Which of the following best describes the process of decomposing a table with redundant values into a more efficient set of related tables?

Duplication

Replication

Scaling

Normalization

A

Normalization

22
Q

A feature dataset is a geodatabase…..

A

A feature dataset is a geodatabase folder that thematically organizes a collection of feature classes while enforcing a common coordinate system.

23
Q

A feature class is a geodatabase object___

A

A feature class is a geodatabase object with point, line or polygon features with associated values.

24
Q

A Subtype is a geodatabase object that….

A

A Subtype is a geodatabase object that subsets features in a feature class into groups.

25
Q

a relationship class is a geodatabase object that

A

a relationship class is a geodatabase object that stores a persistent relationship between a feature class and/or table.

26
Q

A relate will create temporary __ or __ relationship between a feature class and a standalone table.

A

A relate will create temporary 1:M or M:M relationship between a feature class and a standalone table.

27
Q

A join will create a temporary __ or ___ relationship between a feature class and a standalone table

A

A join will create a temporary 1:1 or M:1 relationship between a feature class and a standalone table

28
Q

A geodatabase relationship class will create a persistent __, __, or ___ relationship between a feature class and a standalone table.

A

A geodatabase relationship class will create a persistent 1:1, 1:M, or M:M relationship between a feature class and a standalone table.

29
Q

___ ___ creates a new feature class where the attributes of one feature class are joined to the features and attributes of another feature class based on their spatial relationship.

A

Spatial Join creates a new feature class where the attributes of one feature class are joined to the features and attributes of another feature class based on their spatial relationship.

30
Q

What does the acronym ETL stand for?

A

Extract, Transform, Load

31
Q

Imagine your using an ETL tool to load NOAA hurricane data into your project geodatabase. As part of the transformation process you are mapping the source fields in the NOAA Basin.NA.ibtracs_all_points.v03r04 feature class to the target fields in your geodatabase Hurricanes feature class. Given the list of NOAA source fields below, match them to the corresponding target fields in your feature class.

Serial_Num

Season

Nature

wmo_wind

A

STORM_ID

YEAR

STORM_TYPE

WIND_SPEED

32
Q

Which of the following functions differentiates Spatial ETL from ETL?

Standardize character sets, values, and NULL values

Map source fields to destination fields

Concatenate, parse, or calculate values

Transform coordinate systems

A

Transform coordinate systems

33
Q

Standardize character sets, values, and NULL values; map (i.e. match) source fields to destination fields; and concatenate, parse, or calculate values are all tabular functions associate with ___.

A

Extract, Transform, Load - ETL

34
Q

Match the following data model with it’s corresponding primitive.

Tabular

Vector

Raster

Triangulated

A

A. Tabular = Values

B. Vector = Points

C. Raster = Cells

D. Triangulated = Triangles

35
Q

What is a feature dataset?

A

A collection of feature classes with the same spatial reference

36
Q

What is a relationship Class?

A

A persistent relationship between a feature class and/or table

37
Q

What is a feature subtype

A

Subset features into groups to apply targeted domains and rules

38
Q

What are attribute domains?

A

Establish a list or range of valid values for attributes

39
Q

A conceptual data model includes only ___ and ___.

A

entities and relationships

40
Q

A ___ data model includes entities and relationships, entity data types, attributes, and keys; as well as data definitions and format.

A

A phsyical data model includes entities and relationships, entity data types, attributes, and keys; as well as data definitions and format.

41
Q

A ____ data model identifies the entity as vector, raster, or triangulated data.

A

geospatial

GIS 1479 (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions