Data Acquisition

Question 1

process of providing users and systems with access to data is called as

Answer 1

data provisioning

Question 2

During data provisioning _________ is performed to ensure the _________ remains intact

Answer 2

replication , source

Question 3

structured data is in the human readable format

true/false

Answer 3

false computer-readable format

Question 4

structured data does not contain inconsistencies, redundancies, ommissions and errors
True/false

Answer 4

false

Question 5

structured data contains data models t/f

Answer 5

true

Question 6

metadata is found in

a) structured data
b) unstructured data

Answer 6

a) structured data

Question 7

values are _______in structured data

Answer 7

Proscribed. each cell contains values of a certain format and specific length a.The data is related to each other

Question 8

VALUE ARE _________ in unstructured data

Answer 8

topical. no size ,unrelated ,varying length & content

Question 9

spreadsheets are error-prone because multiple users can access it t/f

Answer 9

t

Question 10

_______,__________& ____________ are forms of flat files

Answer 10

ASCII,CSV ,other delimited files (tab delimited )

Question 11

Disadvantage of spreadsheets are -

Answer 11

error prone
no security(multiple access)

Question 12

Example of using flat file

Answer 12

1. used to transfer data ,download data in flatfile format from DB and use it to upload in another DB
2. oracle db store scolumn as customer_name ,Mysql as cust_name .in order to map these values we can download db as flatfile ,correct them and load in the DB

Question 13

Flat fie is an example of nonrelational db T/F

Answer 13

T

Question 14

Disadvantage of flat file-multiple rows of same data.

advantage -easy for appendng and sorting

Answer 14

multiple rows of same data.

Question 15

3 types of anaomalies

Answer 15

insert
uodatse
delete

Question 16

Transactional systems are normalized up to _ NF

Answer 16

3

Question 17

Tagged data examples :

Answer 17

XML,XLBR,HTML

Question 18

XBLR ABBR

Answer 18

Extensible Business Reporting Language

Question 19

which is used for financial stmts?

xml or xblr

Answer 19

xblr

Question 20

Email ,social media ,recording is analyzed via NLP

T/F

Answer 20

T

Question 21

WHAT IS JETPAC

Answer 21

Image recognition s/w.analyzes the instagram data to tag the locations in the pictures

Question 22

______data is common source of data for business analysis

Answer 22

Transactional data

Question 23

Characteristics of txn systems

Answer 23

txn systems 
data shud be functionally oriented
should handle business processes
operational 
small uniform txn
maintain level of detail
current 
speed
can be updated
optimized for storage
shud be available all time (6 figure)
concurrent

Question 24

integrated txn systems that connect to , updates all functional areas in business is called the ________

Answer 24

ERP system

Question 25

ERP operates in functional areas such as

Answer 25

Procurement
inventory 
Accounting/budgeting
billing 
human resource
shipping
warehouse

Question 26

A place where data is stored and prepared for analytical processes is called
informational/transactional system

Answer 26

informational

Question 27

txn systems support managerial requirements

T/F

Answer 27

F supports operational requirements

Question 28

webcrawlers are also called_______

Answer 28

info agents /spiders

Question 29

click stream analysis

Answer 29

analysis of the data based on number of customer clicks,

Question 30

clickstream analysis

Answer 30

analysis of the data based on the number of customer clicks,

Question 31

clickstream data is stored as _________data

Answer 31

semistructured