front 1 _______ is an interactive website kept constantly updated and
relevant to the needs of its customers using a database. | back 1 C |
front 2 The process of analyzing data to extract information not offered by
the raw data alone. | back 2 D |
front 3 _______ provides details about data | back 3 C |
front 4 _______ stores information about a person, place, thing, transaction,
or event. | back 4 D |
front 5 _______ helps users graphically design the answer to a question
against a database. | back 5 A |
front 6 An example of transactional information would be: | back 6 D |
front 7 The smallest or basic unit of information is referred to as: | back 7 C |
front 8 Fixing or discarding inconsistent or incorrect data is known as:
| back 8 C |
front 9 Revealing the relationship between variables with nature and
frequency of relationship is known as: | back 9 C |
front 10 T/F A representation of multidimensional information can be referred to as a "cube". | back 10 True |
front 11 Multiple Choice: | back 11 D |
front 12 Multiple Choice: | back 12 A |
front 13 Short Answer: | back 13 Answer: (1) The content is easy to manage. (2) It is easy to store large amounts of data. (3) It is easy to eliminate human errors. |
front 14 True/False: | back 14 False |
front 15 Multiple Choice: | back 15 B |
front 16 T/F Data mining is one of the four aspects of Data we need to consider? | back 16 False |
front 17 T/F All Data systems have the same format? | back 17 False |
front 18 Can Databases be linked together and if so what is it called? | back 18 They can be linked together, even multiple databases at a time and this is called a relational database. |
front 19 T/F Metadata is data about data? | back 19 True |
front 20 Companies use ______________ techniques to analyze particular data in
order to compile a complete picture of their operations allowing
identification of trends and improved forecasts. | back 20 A |
front 21 The primary purpose of a data warehouse is to combine information.
| back 21 True |
front 22 If a grocery store is trying to analyze data regarding what
percentage of the time customers buying bread are also buying peanut
butter they would use the data mining technique known as: | back 22 D |
front 23 It is crucial for businesses to understand digest, analyze and filter
high-quality information in order to see growth and success in their
industry. Information that has a primary purpose to support daily
operational tasks is known as _______________. | back 23 B |
front 24 There are common characteristics of high-quality information to make
certain that systems do not suffer from data integrity issues. Which
of these characteristics is not one of them? | back 24 C |
front 25 True/False. Information cleansing or scrubbing is a process that weeds out and fixes or discards incorrect or incomplete information. | back 25 True |
front 26 True/False. Web mining analyzes unstructured data to find trends and patterns in words and sentences. | back 26 False |
front 27 What is a technique used to divide information sets into manually
exclusive groups so that members of each group are close together and
different groups are far away? | back 27 B |
front 28 Text mining: | back 28 D |
front 29 The data warehouse enables business users typically managers, to be
more effective in all these ways EXCEPT: | back 29 A |
front 30 Data governance refers to the overall management of the availability usability, integrity, and security of company data. | back 30 True |
front 31 A data dictionary: | back 31 A |
front 32 A physical view of information focuses on how individual users
logically access information to meet their own particular business
needs | back 32 False |
front 33 Another word for information cleansing is: | back 33 C |
front 34 The three common forms for mining structured and unstructured data
are: | back 34 C |
front 35 Explain the difference between transactional and analytical information. | back 35 Transactional information encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support daily operational tasks. Analytical information encompasses all organizational information, and its purpose is to support the performing of managerial analysis tasks. Analytical information is useful when making important decisions such as whether a company should build a new plant of hire more sales personnel. |
front 36 What is a major pitfall of real-time information? | back 36 A |
front 37 Which of the following is NOT a serious consequence that businesses
face when using low-quality information? | back 37 D |
front 38 Name two defined policies that a company that supports a data governance program specifies. | back 38 2 of these: |
front 39 Columns and fields such as the primary key and foreign key are
examples of what? | back 39 B |
front 40 T/F The four aspects of data are data type data timelines, data quality, and data governance | back 40 True |
front 41 A _____ key is one or more columns that can be used to identify a unique row in a table? | back 41 Primary |
front 42 _____ keys are keys from a different table than the one in which they reside? | back 42 Foreign |
front 43 T/F Market basket analysis is the items people tend to buy separate | back 43 False |
front 44 T/F A statistical analysis requires high quality data a sturdy DBMS, and a solid statistical skills | back 44 True |
front 45 The four primary traits that help determine the value of information
include: | back 45 E |
front 46 Of the five common characteristics of high quality information which
of the following has to do with each transaction and event only being
represented once in the information? | back 46 C |
front 47 Which of the following is not true? | back 47 B |
front 48 List some examples of serious business consequences that can occur due to using low quality information to make decisions. | back 48 -Inability to accurately track customers. |
front 49 Which of the common forms for mining structures and unstructured data
is a technique used to divide information sets into mutually exclusive
groups where members of each group are closely grouped together while
the different groups are as far apart as possible? | back 49 C |
front 50 What are the four aspects of data? | back 50 Type, timeliness, quality, and governance |
front 51 What are the two types of data? | back 51 Transactional and analytical |
front 52 Which of the following is NOT a characteristic of Data quality?
| back 52 E |
front 53 A field that or group of fields that uniquely identifies a given
record in a table is __________. | back 53 B |
front 54 Which of the following is the most inclusive? | back 54 A |
front 55 What are five common characteristics of high-quality information? Name two or three | back 55 Accurate, complete, consistent, timely, unique |
front 56 What is a primary key of one table that appears as an attribute in
another table and acts to provide a logical relationship between the
two? | back 56 B |
front 57 What are some data-driven website advantages? | back 57 - Easy to manage content |
front 58 What is the primary purpose of a data warehouse? | back 58 A |
front 59 Association detection reveals the relationship between variables along with the nature and frequency of the relationships. | back 59 True |
front 60 Data governance refers to the overall management of the availablility usability, integrity, and security of company data. | back 60 True |
front 61 ________ is a process that weeds out and fixes or discards
inconsistent incorrect, or incomplete information. | back 61 C |
front 62 What is data mining? | back 62 The process of analyzing data to extract information not offered by the raw data alone. |
front 63 _______ are predictions based on time-series information. | back 63 C |
front 64 Cluster analysis is a technique used to divide information sets into
mutually exclusive groups such that the members of each group are as
close together as possible to one another and the different groups are
as far apart as possible. | back 64 A |