4250 Exam 2 Learning Checks

A data type of ______ is used for elements that can contain a specific number of alphanumeric characters Char Numeric Varchar Text

char

When creating process specifications, what needs to be done for manual tasks? Create well-defined procedures for employees performing the tasks Replace them with automated processes Outline the decisions using a decision tree Nothing, they are not part of processing specification

Create well-defined procedures for employees performing tasks

Which of these is not important with respect to output? Removal of all sources of bias Creating flexible output Interactive design Informing those concerned with output's bias

Removal of all sources of bias

Which is not one of the four basic symbols used to chart data movement on data flow diagrams? Triangle Arrow Circle or rectangle with rounded corners Open-ended rectangle

Triangle

A CRUD matrix is used to show: Places in the system where data is inaccurate Where records are updated, added, deleted or viewed Which web pages are placed on a secure server The partitioning of data flow diagrams in a client/server environment

Where records are updated, added, deleted, or viewed

A primitive process is: A process not exploded into a child diagram The central process on a context level diagram A process that requires two or more data flows into it A process that has only base elements flowing in or out of it

A process not exploded into a child diagram

Data structures are described using _____ notation Relational Metadatic Geometric Algebraic

Algebraic

Which of the following is a flaw in the system design that is detected by analyzing the data dictionary entries? All derived elements on an output flow must be present on an input data flow The data store may contain elements that are not present on any data flow to or from the data store All base elements on an output data flow must be present on a data flow into the process All elements that are discrete must have a table of codes definition

All base elements on an output data flow must be present on a data flow into the process

Process logic may be represented as Structured English A decision table A decision tree All of these

All of these

The data dictionary may be used when coding: Screens Reports Forms All of these

All of these

Which of these sorting procedures can guide decision making or introduce bias into output? Alphabetical Chronological Cost All of these None of these

All of these

Which of the following is not a type of bias introduced unintentionally during output presentations? How information is sorted Choice of fonts Choice of graphics Setting of acceptable limits

Choice of fonts

A(n) _____ element is one that has a smooth range of values Absolute Discrete Variable Continuous

Continuous

What become(s) important for large systems that involve several thousand data elements requiring cataloging and cross-referencing? Use cases Structured analysis Data flow diagrams Data dictionary Design

Data dictionary

Which graphically characterize(s) data process and flows through a business system? Data dictionary Data flow diagrams Structured analysis Design

Data flow diagrams

_____ depict system inputs, processes and outputs Data flow diagrams Databases Entity-relationship diagrams Flow charts

Data flow diagrams

Which of the following is not contained in a data dictionary? Data structures Data elements Data logic Data flows

Data logic

In order to build decision tables what does the analyst not need to do? Eliminate any impossible situations Simplify the table as much as possible Determine the minimum size of the table Eliminate inconsistencies

Determine the minimum size of the table

The sales department needs to see the total orders and each order by a customer for the preceding 365 days. What type of output is this? Fixed format Variable format Fixed values Dynamic values

Dynamic values

What does this symbol [] represent? Either/or situation Optional Iteration Selection

Either/or situation

Which of these reports is only produced when certain conditions occur? Detailed Exception Historical Summary

Exception

When determining the length for elements: Look at what the current length of data is and use that value Use values that other corporations have for similar elements Figure the amount of a numeric element and add characters for reasonable expansion Keep the value for the length small to save file space

Figure the amount of a numeric element and add characters for reasonable expansion

Physical data flow diagrams: Include processes for adding, updating, changing, and deleting records Are used to implement business events along with their input and output Enable the analyst to better understand the business Include no interface data flow in or out of processes

Include processes for adding, updating, changing, and deleting records

A data flow that contains data moving between two processes is called: Internal Derived Base Iterative

Internal

Output which stays within the business is called Internal output External output Private output Public output

Internal output

Which of the following is not one of the three basic constructs use to code computer programs? Sequence Selection Iteration Invention

Invention

A logical data flow diagram: Identifies the types of processing, such as online or batch Is a model of how the system will be implemented Does not include any primitive processes Is a model of how the business operates

Is a model of how the business operates

A varchar data type: Is used to represent elements for which the analyst needs to determine the length Is an element that contains a check digit Is used to represent a floating point number with an indeterminate number of decimal positions Is used for data that can contain any number of characters (up to database limit)

Is used for data that can contain any number of characters (up to database limit)

A goal of producing process specifications is to Reduce process interactions Build technical specifications for a specific computer language Make the system design concrete Design database input and output processes

Make the system design concrete

Since a single data flow may only show part of the collective data The data store may be linked to several external structures defining the different data flows Many data flows may have to be examined to determine the contents of a data store Data stores must contain multiple redundant elements within repeating groups indicated by braces {} An alias must be used

Many data flows may have to be examined to determine the contents of a data store

Process specifications are sometimes called _____ because they are a small portion of the total project specifications Designs Data flows Information nodes Mini specs

Mini specs

What is not a characteristic of the ideal data dictionary? Comprehensive Minimalist Structured Online

Minimalist

Elements on a data flow going into or out from a data store: Must be created by the process linking to the data store Must be base elements Must be on a data flow that is input to the process that creates the output that is going to the data store Must be contained in the data store

Must be contained in the data store

Which of the following is not an error when drawing a data flow diagram? Only data flowing into a process, not out Data flow from an internal entity to an external entity Data flow from a data store to an external entity Placing more than one process on a data flow diagram

Placing more than one process on a data flow diagram

What does the text within the process symbol indicate? Process sequence Identifying number Process description Process implementation

Process description

Process specifications are not produced for Processes that use decision trees Processes for which prewritten code already exists Processes that involve complex decision criteria All of these

Processes for which prewritten code already exists

Which of the following is not part of a business rule? Logical decision processes Mathematical derivations Programming language IF statements Definitions of business terms

Programming language IF statements

Which of these is not a design criteria for designing output? Choose the most effective output method Design output to serve a specific purpose Provide the output on time Provide as much information as possible

Provide as much information as possible

Displaying only the values that triggered exceptions in an exception report Range setting Sorting Grouping Closure

Range setting

In a decision tables, contradictions occur when An important condition is omitted When the situation cannot occur because there are two or more conditions that cannot occur at the same time Identical sets of alternatives require the same action Rules suggest different actions but satisfy the same conditions

Rules suggest different actions but satisfy the same conditions

The data flow in and out of a parent process _____ the data flow in and out of a child flow diagram Are a primitive process of Are a disordered pair of Are a logical data flow for Should match

Should match

Which of the following is not relevant to an output user story? I need to estimate daily demand for each type of bread I am a Blimpie store manager The Blimpie clerk should record customer orders exactly I need to be sure that the store doesn't run out of any type of bread

The Blimpie clerk should record customer orders exactly

Which of these is not a guideline for a display screen output? Captions should be in closer proximity to their values than they are toother captions or values Groups of information that should be equally weighted should have a similar appearance If a large quantity of data needs to be scanned there should be a visible flow from left to right and top to bottom The company logo should be prominently displayed in the top left corner

The company logo should be prominently displayed in the top left corner

In a situation where multiple measurements might be relevant to decision making, which of the following would not help a decision maker focus on all of them equally when creating a dashboard for screen display? The rows and columns in a table that shows whether each department is above or below their seasonal sales average are close to each other but the table is separated from other elements on the dashboard The first rows each have 2 square dashboard elements while the third row's element is a table that spans two columns A graph that compares this year's sales by season to last year's sales by season has a black border around it If there are elements off the bottom of the screen, the elements at the bottom are cut off and a down arrow is shown

The first two rows have 2 square dashboard elements while the third row's element is a table that spans two columns

When drawing a decision tree, systems analyst do not have to identify All outcomes All criteria The order of criteria All conditions

The order of criteria

Which of these is a characteristic of managing display screen output? The output has mass The output has volume The output's values are always fixed as of the time the report was printed The output must be secured if it contains confidential information

The output must be secured if it contains confidential information

In a monthly report, the values that are below the average by more than 80% are highlighted in a red typeface. All other values are shown in a black typeface. According to Gestalt theory what bias will this cause? The user's eye will be drawn down the left side of the report The user's perception will be that all the red items are grouped into the same set Each row will be grouped with the row above and below it When the user's eye reaches a red item, their information search will stop

The user's perception will be that all the red items are grouped into the same set

Which of the following is not a problem when creating decision tables? Impossible situations Too many criteria Redundancy Contradictions

Too many criteria

Which is not the correct choice? Use decision tables when not every criteria is relevant to every action Use structured English for sequences of process steps Use decision trees when the sequence of conditions and actions is critical Use decision tables when there are few outcomes

Use decision trees when the sequence of conditions and actions is critical

In order to use English, which convention is not advisable? Express all logic in terms of sequential structures, decision structures, case structures, or iterations Use nested indent blocks of several levels of conditional statements Use and capitalize accepted keywords such as IF, THEN Be careful when using "and" and "or"

Use nested indent blocks of several levels of conditional statements

The advantage of building data flow diagrams based on triggering events is that: Events are small scale and easy to analyze of input and output Users are familiar with the events within their business and know how the events drive other activities Events fall into one of four categories: read, update, create, delete Events are predictable and lend a high degree of stability to the data flow diagram

Users are familiar with the events within their business and know how the events drive other activities