Filters
Question type

Study Flashcards

What type of keys do you need to use to create a relational database model?


A) Primary keys and secondary keys
B) Primary keys and foreign keys
C) Entity keys and attribute keys
D) Relational keys and DBMS keys

E) A) and B)
F) B) and C)

Correct Answer

verifed

verified

Within the data warehouse model,the external databases could include competitor information,industry information and stock market analysis.

A) True
B) False

Correct Answer

verifed

verified

Data visualization tools can help uncover correlations and trends in data that would otherwise go unrecognized.

A) True
B) False

Correct Answer

verifed

verified

What is a foreign key?


A) A field (or group of fields) that uniquely identifies a given entity in a table
B) A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables
C) Characteristics or properties of an entity
D) A field (or group of fields) that uniquely identifies a given attribute in a table

E) A) and B)
F) None of the above

Correct Answer

verifed

verified

What are the three common forms for mining structured and unstructured data?


A) Cluster analysis,association detection,statistical analysis
B) Cluster analysis,association detection,disassociation detection
C) Cluster analysis,statistical detection,statistical analysis
D) Association detection,market-basket analysis,market-basket association

E) B) and C)
F) C) and D)

Correct Answer

verifed

verified

What is data redundancy?


A) Duplication of data
B) Storing the same data in multiple places
C) Storing duplicate data in multiple places
D) All of the above

E) A) and D)
F) A) and C)

Correct Answer

verifed

verified

Within the beginning stage of the data warehouse models process,which of the following are included in the internal databases?


A) Marketing,sales,inventory,and billing
B) Data mart 1,data mart 2,data mart 3
C) Competitor and industry information,mailing lists,& stock market analysis
D) Marketing information,and stock market analysis numbers

E) B) and C)
F) B) and D)

Correct Answer

verifed

verified

Data mining occurs on structured data that are already in a database or a spreadsheet.

A) True
B) False

Correct Answer

verifed

verified

What displays information graphically so it can be easily understood?


A) Informing
B) Infographics
C) Data visualization
D) Business intelligence dashboards

E) A) and D)
F) None of the above

Correct Answer

verifed

verified

_________ information includes data that change based on user actions.

Correct Answer

verifed

verified

What is a real-time system?


A) Provides immediate,up-to-date information
B) Provides real-time information in response to query requests
C) Encompasses all organization information,and its primary purpose is to support the performing of managerial analysis tasks
D) Encompasses all of the information contained within a single business process or unit of work,and its primary purpose is to support the performing of daily operational tasks

E) B) and D)
F) A) and B)

Correct Answer

verifed

verified

What does extraction,transformation,and loading mean?


A) It is a process of entering data,tracking data,and loading it into a database
B) It is a process that extracts information from internal and external databases,transforms it using a common set of enterprise definitions,and loads it into a data warehouse
C) It is a process that is performed at the end of the data warehouse model prior to putting the information in a cube
D) It is a process that is performed at the beginning of the data mining model

E) All of the above
F) B) and C)

Correct Answer

verifed

verified

Association ___________ reveals the relationship between variables along with the nature and frequency of the relationships.

Correct Answer

verifed

verified

Which of the following represents the different information granularities?


A) Detail,summary,aggregate
B) Document,presentation,spreadsheet,database
C) Individual,department,enterprise
D) None of the above

E) All of the above
F) A) and B)

Correct Answer

verifed

verified

Extraction,transformation,and loading is a process that extracts information from internal databases,transforms the information using a common set of enterprise definitions,and loads the information into an external database.

A) True
B) False

Correct Answer

verifed

verified

The five common characteristics of high-quality include accurate,complete,__________,timely and unique.

Correct Answer

verifed

verified

What are the two different categories for information type?


A) Analytical and productive
B) Analytical and analysis
C) Transactional and analytical
D) Transactional and analysis

E) A) and D)
F) A) and C)

Correct Answer

verifed

verified

___________ displays information graphically so it can be easily understood.

Correct Answer

verifed

verified

What describes technologies that allow users to "see" or visualize data to transform information into a business perspective?


A) Informing
B) Infographics
C) Data visualization
D) Business intelligence dashboards

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

What are the two main objectives associated with data mining?


A) Uncovering tactics and plans
B) Uncovering trends and patterns
C) Uncovering intelligence and unstructured data issues
D) Uncovering competitors and market advantages

E) A) and C)
F) B) and D)

Correct Answer

verifed

verified

Showing 221 - 240 of 286

Related Exams

Show Answer