BA test 1

Ace your homework & exams now with Quizwiz!

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


Related study sets

Interest-Sensitive Life Products

View Set

Chapter 4 Cascading Style Sheets Basics

View Set

Fast, Slow and Intermediate Fibers

View Set

Chapter 11: Congress: Balancing National Goals and Local Interests

View Set