BA test 1
Denormalized databases in OLAP systems are:
"read only
Data interpretation skills fall into which three categories?
Data analyst, data scientist, and business user.
What is the difference between data and information?
Data are facts. Information is processed data.
What is the correct order of how data analytics takes us from data to decision?
Data, Information, Knowledge, Wisdom, Decision
Data is?
Raw figures, numbers, or text.
What is the process of searching for information on web pages and then stripping the html tags so the data can be stored in a structured format?
Web scraping
When do update anomalies occur?
When the same data are stored in multiple places
Data scientists are specialists in:
a b and c
Exception reporting is _______ tool for managers and other individuals who are responsible for business activities and results
a common
Which of the following does an ERP system typically NOT integrate?
compeitor data
Flat files are utilized to:
consolidate or synchronize data
What do XML tags denote?
content
In the context of database interactions, CRUD stands for:
create, read, update, delete
Sampling is the act of:
extracting only certain data values from a dataset
What type of data structure can store structured data?
flat file
Exception reporting is _______ tool for managers and other individuals who are responsible for business activities and results
fully integrated
A typical use of social media data is to:
identify consumer buying habits, likes and dislikes
Law enforcement uses data analysis to:
identify patterns of crime
Which of the following is NOT part of the three-tiered architecture?
information tier
Enterprise resource planning (ERP) systems are:
integrated transactional systems that enable all the functional areas of a business to share data.
Relationships are created using what?
keys
Out-of-date computer systems are referred to as:
legacy systems
Demand forecasting is the core of:
manufacturing.
OLTP systems are accessed by:
many, perhaps thousands, of users at the same time
To "map" fields from different databases is to?
match them
The structure of a database is called a data:
model
A data flow diagram (DFD) is used to:
model the flow of data from one object to another.
Which of the following is not a database model?
monarchial model
From the data warehouse, data are pushed to the __________ for data storage
multidimensional model
Which one does not belong to structured data?
needs to be translated
A key characteristic of web services is that they have
no user interface
The federal government collects census data every:
none of the above
The most common model for storing data in a cube for analytics is the:
none of the above
The number of dimensions depends on:
none of the above
Which of the following is not a characteristic of information system?
none of the above
To eliminate anomalies, the database tables need to be:
normalized
What does Data Analytics process not involve?
organize the data to make it useful
We use a _______ table to map the alphanumeric master data primary key to the numeric characteristic.
surrogate ID
Probably the most well-known method for dealing with unstructured data is called:
tagging
All these are types of sensors when talking about data sourcing except?
televisions
Small business owners in particular, need only the data in:
the POS to understand their business; specifically quantity and dollar value of sales for the day.
Which of the following is not a way to process unstructured data?
Astronomical detection and translation
What does CRUD stand for?
Create, Read, Update, Delete
What are the three analytic techniques?
Exploration/Reporting, Knowledge Discovery, Visualization
Data analytics is a process that involves all of the following EXCEPT:
Normalizing the data
Transactional systems are designed to process transactions quickly, reliably, and accurately. What is another term for this process?
Online transaction processing
Data becomes information when?
They reveal the causes or results of the event.
Data provisioning is the process of providing users and systems with _____ to data?
access
Data science is the intersection of ALL of the following EXCEPT
algorithms
NLP reflects the beliefs that:
all of the above
Satellites orbiting the earth provide scientists with data regarding:
all of the above
Social media include social networking such as
all of the above
Structured data is which of the following?
all of the above
The most prominent database management systems for developing relational databases are:
all of the above
Transactional systems are designed to process transactions:
all of the above
Which is a part of visualization?
all of the above
Which of the following fields uses analytics?
all of the above
Which of the following is a/are database interactions?
all of the above
To detect fraud and errors, auditors need to examine:
all of the data within a company's database
Data scientists are specifically trained in?
all of these
Unstructured data comes in what kind of forms:
all of these
When we look at auditing and analysis of internal controls, data from internal systems are used to:
analyze risk
Refers to the development of computer technologies that can reason and otherwise function like humans:
artificial intelligence
Most businesses create forecasts and budgets based on:
b and c
A common business use of spreadsheets is for:
budgeting
One of the most useful aspects of social media is that in addition to analyzing the data:
businesses can evaluate the effectiveness of their marketing strategies.
Where is structured data stored?
cells or fields
Time-dependent hierarchies:
change over time
The definition of the data and their relationships is called:
data modeling
Structured data are based on:
data models
The process of providing users and systems with access to data is called:
data provisioning
Analytics is at the core of_____.
data science
The database management system (DBMS) resides at the:
data services tier
Data for analysis are temporarily stored in a:
data staging area
Sensor data are the data gathered from all of the following devices EXCEPT:
databases
Under manufacturing, a type of data analysis called ___________ is the core of this planning.
demand forecasting
A __________ is an attribute or combination of attributes that can be used uniquely to identify a specific row (record) in a table.
primary key
Transactional data at GBI may include the following except.
products
Which one of these is not a transactional data?
products
Data provisioning is the process of:
providing users and systems with access to data
Of the four interactions, _____ has no impact on the table.
read
Replication ensures that the source data
remain intact
During the provisioning process data from a source system are:
replicated or copied
Web crawlers:
search web sites one page at a time for information.
Which is included in Data Exploration?
slicing and dicing
What does domain knowledge have in common with computer science?
software/tools
The first step in the data warehousing process involves identifying the:
the soure systems
Insert anomalies result when
there is no place within the table to store the new data
Whenever a business event is recorded by an information system, the relevant data are written to and stored in a database as_______________.
transactional data
What does knowledge reveal?
trends and patterns
Statistics is a rigorous branch of mathematics that deals with
understanding data
If a key figure is of type quantity, then it must have a:
uom key
Clickstream analysis is the process of collecting and analyzing data about:
website visitors' mouse clicks
Analysts can collect unstructured data and tag them to derive their meaning for the computer using:
xml or xbrl
