DATA 2100 EXAM QUESTIONS WITH
CORRECT ANSWERS
What are Data Ecosystems - ANSWER Operational databases conected to data
warehouses and data marts with ETL and bi tools and analytics are used to
understand them.
Operational Databases - ANSWER Databases that interact with users and
transactional systems in real time
data warehouse - ANSWER a place where databases are stored so that they are
available when needed
What are ETLs? - ANSWER The process of moving data
What are the three steps to ETLs - ANSWER 1.extract data from one data
bases
2. Transforming it in someway
3. Loafing it in another database
What are data marts? - ANSWER Subsets of data warehouse that typically
focus on single subject or a line of business
What are Bi tools and analytics - ANSWER Anything that helps you
understand and organize data bases
What is purchased or private data - ANSWER Data that is owned by someone
or company
public data - ANSWER Data that is available to anyone. It might be in
brochures, in press releases, or on web sites. ~
What is loose data - ANSWER Data that is in a company but not in databases
or warehouses
, What is a flowchart - ANSWER a diagram that graphically depicts the steps
that take place in a program
What are the 4 electronic processes - ANSWER Actions
Inputs
outputs
Decision pionts
When are flowcharts used - ANSWER In process development and designing
new processes
Process inprovment - ANSWER Efficiency and quality
Where is the start piont in flowcharting - ANSWER Top left
Where is the end piont in flowcharting - ANSWER Bottom right
What symbol is a flow line - ANSWER An arrow
What does a flow like do - ANSWER It connects elements of the electronic
processes in a flowchart
What shape is a terminator - ANSWER Pill shaped
What is a terminator used for - ANSWER Starting and stopping a flow
How many flow lines does a terminator have - ANSWER Start. End
In=0. In=1
Out= 1. Out =0
What shape is an action - ANSWER Rectangle
What does an action do - ANSWER It changes the state of the process
Such as a math equation or formula or function or changing a variable value
based on programming command.
How many flow lines are in a action - ANSWER In=1
Out =1
CORRECT ANSWERS
What are Data Ecosystems - ANSWER Operational databases conected to data
warehouses and data marts with ETL and bi tools and analytics are used to
understand them.
Operational Databases - ANSWER Databases that interact with users and
transactional systems in real time
data warehouse - ANSWER a place where databases are stored so that they are
available when needed
What are ETLs? - ANSWER The process of moving data
What are the three steps to ETLs - ANSWER 1.extract data from one data
bases
2. Transforming it in someway
3. Loafing it in another database
What are data marts? - ANSWER Subsets of data warehouse that typically
focus on single subject or a line of business
What are Bi tools and analytics - ANSWER Anything that helps you
understand and organize data bases
What is purchased or private data - ANSWER Data that is owned by someone
or company
public data - ANSWER Data that is available to anyone. It might be in
brochures, in press releases, or on web sites. ~
What is loose data - ANSWER Data that is in a company but not in databases
or warehouses
, What is a flowchart - ANSWER a diagram that graphically depicts the steps
that take place in a program
What are the 4 electronic processes - ANSWER Actions
Inputs
outputs
Decision pionts
When are flowcharts used - ANSWER In process development and designing
new processes
Process inprovment - ANSWER Efficiency and quality
Where is the start piont in flowcharting - ANSWER Top left
Where is the end piont in flowcharting - ANSWER Bottom right
What symbol is a flow line - ANSWER An arrow
What does a flow like do - ANSWER It connects elements of the electronic
processes in a flowchart
What shape is a terminator - ANSWER Pill shaped
What is a terminator used for - ANSWER Starting and stopping a flow
How many flow lines does a terminator have - ANSWER Start. End
In=0. In=1
Out= 1. Out =0
What shape is an action - ANSWER Rectangle
What does an action do - ANSWER It changes the state of the process
Such as a math equation or formula or function or changing a variable value
based on programming command.
How many flow lines are in a action - ANSWER In=1
Out =1
