Lab Questions

Please record your answers to these questions according to the direction of your instructor. Answers for instructors may be requested here.

Multiple Choice Questions

Lecture

Question
1 Data integration can be defined as…
  1. discovery, cleansing, monitoring, transforming and delivery of data from a variety of sources.
  2. using algebra to find the integral of a numeric attribute.
  3. comparing predicted data to observed data.
  4. using pivot tables/cross tabulation tables to find subtotals of grouped data.
2 What distinguishes FME’s data integration capabilities?
  1. Low computer memory requirements
  2. Multi-language support
  3. Required coding knowledge
  4. Ability to work with spatial data
3 If I add an Excel reader to my workspace, what FME object will correspond to worksheets in the Excel workbook?
  1. Dataset
  2. Workspace
  3. Feature type
  4. Feature
4 In the terminology of FME, a translation…
  1. translates data from one format to another.
  2. translates scripts from one programming language to another.
  3. translates string data from one language to another.
  4. translates the geographic coordinates of data to a different coordinate system.
5 In the terminology of FME, a transformation…
  1. transforms data from one format to another.
  2. transforms data by moving it from one digital storage location to another.
  3. transforms data by showing it on a map.
  4. transforms data by changing the structure or content of the data.
6 The FME Data Inspector is a fully-featured GIS and cartography application. True or false?
  1. True
  2. False
7 What is the difference between transforming a dataset's structure and content?
  1. Structural transformation performs statistical analysis, while content transformation uploads data to a new location on the web.
  2. Structural transformation merges, divides, re-orders, or otherwise changes data structures, while content transformation changes the underlying values in a dataset.
  3. Structural transformation makes long datasets wide and vice versa, while content transformation adds metadata to the dataset.
  4. Structural transformation transforms the data into a different format, while content transformation performs spatial analysis on the data.

Lab

Question
8 In Exercise 1.1, which case type has the most cases in the Downtown local planning area?
  1. Business Planning & Services
  2. ENG - Solid Waste
  3. ENG - Streets
  4. ENG - Transportation
9 In Exercise 2.1, what are listed below the CA18COV1 - Service Request Loca feature type after clicking the arrow to expand it?
  1. Layers
  2. Objects
  3. Features
  4. Attributes
10 In Exercise 2.4, removing the underscores from attribute names is an example of schema mapping. True or false?
  1. True
  2. False
11 In Exercise 3.1, what would happen if we didn't use the Tester?
  1. The workspace would fail with an error.
  2. We would have an incorrect schema on our writer feature type.
  3. We would have features with missing values for the Local_Area attribute.
  4. Our workspace performance would be significantly worse.
12 In Exercise 3.2, we use the online FME Transformer Gallery to find a transformer to find and replace string values in an attribute. What other resources could we use? Check all that apply.
  1. Ask an FME user in person
  2. FME Community Forum
  3. FME Workbench Documentation
  4. FME Quick Translator
  5. FME Knowledge Base
  6. Quick Add
  7. FME Workbench Transformer Gallery
13 Consult this FME Community article. Why do we recommend you use the FeatureJoiner here instead of the FeatureMerger?
  1. The FeatureJoiner has better performance than FeatureMerger.
  2. It is always better to write an SQL statement when conducting a join in FME.
  3. The FeatureJoiner offers more options and is more complex than the FeatureMerger.
  4. The FeatureMerger can only join three or more tables.
14 You can add readers and writers using Quick Add. True or false?
  1. True
  2. False
15 What would you do in the following scenario? The planning department likes the results of Exercise 4.1, but they have requested that you add a layer in the output KML file showing the location of emergency services. Let's say you add a reader feature type of point data to your workspace and call it Emergency Services. How would you integrate it as another layer in the KML file?
  1. Connect your Emergency Services feature type directly to the 311-local-areas KML writer feature type.
  2. Open your output KML file in a text editor and paste in the emergency services data.
  3. Connect your Emergency Services feature type directly to the 311-requests KML writer feature type.
  4. Add a writer feature type to your KML writer and connect your Emergency Services reader feature type to it.
16 There is not one correct way to use annotation and bookmarks best practice to document the workspace in Exercise 4.2a/b. True or false?
  1. True
  2. False

Data Integration Scenario

Question
17 What percentage of Vancouver public art installations are located in the downtown neighborhood?
  1. 84%
  2. 47%
  3. 66%
  4. 62%
18 Which neighborhood has the longest total bike path length?
  1. Downtown
  2. Fairview
  3. Kitsilano
  4. Mount Pleasant
  5. Stanley Park
  6. Strathcona
  7. West End
19 Why do the Bike Paths and Public Art Installation reader feature types have their names displayed as <All>?
  1. The readers are in Merge Feature Type mode, reading all features in the dataset as a single feature type
  2. The readers are reading all the files in the specified folder
  3. The readers are set up to read all SHP and XLS files in the C:\FMEData2019\Data folder
  4. We changed the name of the feature types on purpose to read <All>
20 How many public art installations are in the Mount Pleasant neighborhood?
  1. 12
  2. 13
  3. 14
  4. 16

Report Question

Write a 500 word report on the data integration solution you created.

  • Include the brainstorming diagram or outline you created before carrying out the walkthrough analysis. How close were you? What did you not anticipate?
  • Which additional dataset did you use?
  • What problem or question does your solution address?
  • What analysis steps did you carry out?
  • Provide a deliverable of some kind to show the value of your project. This could be a map (screenshot of Data Inspector is ok), a table, or a description of a new organizational process made possible by the solution.

results matching ""

    No results matching ""