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