Test2

Question 1

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

Attribute

Value

Entity Set

Entity

Answer 1

A. Entity

B. Attribute

C. Value

D. Entity Set

Question 2

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

Entity

Key

Relationship

Attribute

Answer 2

A. Key

B. Entity

C. Relationship

D. Attribute

Question 3

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

Answer 3

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

Question 4

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

Answer 4

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

Question 5

Geodatabase Terrain is a ______ data model

Answer 5

triangulated

Question 6

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

Answer 6

Raster

Question 7

What models spatial relationships that describe proximity?

Answer 7

Distance

Question 8

Topological relationships describe _____

Answer 8

connectivity

Question 9

Directional relationships describe ____

Answer 9

direction

Question 10

Class relationships describe how ___, ___, or ___ relate

Answer 10

points, lines, or areas

Question 11

What type of data model is illustrated in this diagram?

Answer 11

The ER diagram illustrates a Physical Geodatabase Model

Question 12

Which of the following is NOT an independent entity?

Answer 12

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.

Question 13

What type of attribute is ZIP_Code?

Answer 13

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

Question 14

What type of relationship is modeled between Parcels and TaxRecord2019?

Answer 14

Many to Many

Question 15

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

Answer 15

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.

Question 16

What arere relational tables?

Answer 16

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.

Question 17

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

Answer 17

Data Dictionary

Question 18

The Data Entry Module enables users to…

Answer 18

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

Question 19

The Query Language enables users to

Answer 19

submit a question to a table.

Question 20

Report Generator allows users to…

Answer 20

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

Question 21

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

Answer 21

Normalization

Question 22

A feature dataset is a geodatabase…..

Answer 22

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

Question 23

A feature class is a geodatabase object___

Answer 23

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

Question 24

A Subtype is a geodatabase object that….

Answer 24

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

Question 25

a relationship class is a geodatabase object that

Answer 25

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

Question 26

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

Answer 26

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

Question 27

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

Answer 27

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

Question 28

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

Answer 28

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

Question 29

\_\_\_ ___ 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.

Answer 29

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.

Question 30

What does the acronym ETL stand for?

Answer 30

Extract, Transform, Load

Question 31

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

Answer 31

STORM\_ID YEAR STORM\_TYPE WIND\_SPEED

Question 32

Which of the following functions differentiates Spatial ETL from ETL? ## Footnote Standardize character sets, values, and NULL values Map source fields to destination fields Concatenate, parse, or calculate values Transform coordinate systems

Answer 32

Transform coordinate systems

Question 33

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 \_\_\_.

Answer 33

Extract, Transform, Load - ETL

Question 34

Match the following data model with it's corresponding primitive. Tabular Vector Raster Triangulated

Answer 34

A. Tabular = Values B. Vector = Points C. Raster = Cells D. Triangulated = Triangles

Question 35

What is a feature dataset?

Answer 35

A collection of feature classes with the same spatial reference

Question 36

What is a relationship Class?

Answer 36

A persistent relationship between a feature class and/or table

Question 37

What is a feature subtype

Answer 37

Subset features into groups to apply targeted domains and rules

Question 38

What are attribute domains?

Answer 38

Establish a list or range of valid values for attributes

Question 39

A conceptual data model includes only ___ and \_\_\_.

Answer 39

entities and relationships

Question 40

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

Answer 40

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

Question 41

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

Answer 41

geospatial