Filters
Question type

Study Flashcards

A data warehouse is a _________ collection of information,gathered from many different ___________ databases,that supports business analysis activities and decision-making tasks.


A) Logical,operational
B) Physical,operational
C) Logical,transactional
D) Physical,transactional

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

Correct Answer

verifed

verified

Many organizations find themselves in the position of being data rich and information poor.Even in today's electronic world,managers struggle with the challenge of turning their business data into business intelligence.

A) True
B) False

Correct Answer

verifed

verified

What is the process of analyzing data to extract information not offered by the raw data alone?


A) Data integrity
B) Data mart analysis
C) Data mining
D) Data extraction

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

Correct Answer

verifed

verified

The three primary data models for organizing information in a DBMS are 1- hierarchical,2- network,and 3- metadata.

A) True
B) False

Correct Answer

verifed

verified

A ____________ rule defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.Stating that merchandise returns are allowed within 10 days of purchase is an example of a business rule.

Correct Answer

verifed

verified

Which of the following is a valid type of integrity constraint?


A) Relational-critical integrity constraint
B) Business integrity constraint
C) Relational integrity constraint
D) Business-critical integrity constraint

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

Correct Answer

verifed

verified

Which of the following would not be considered part of the timely characteristic of high-quality information?


A) Is the zip code missing in the address?
B) Is the information current with respect to business needs?
C) Is the customer address current?
D) Is the information updated weekly or hourly?

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

Correct Answer

verifed

verified

What can help uncover correlations and trends in data that would otherwise go unrecognized?


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

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

Correct Answer

verifed

verified

Which of the following occurs when the same data element has different values?


A) Data modeling issue
B) Data mining issue
C) Data governance issue
D) Information inconsistency issue

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

Correct Answer

verifed

verified

Static information includes data that change based on user actions.

A) True
B) False

Correct Answer

verifed

verified

A business rule defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.Stating that merchandise returns are allowed within 10 days of purchase is an example of a business rule.

A) True
B) False

Correct Answer

verifed

verified

Dynamic __________ information is stored in a dynamic catalog ,or an area of a website that stores information about products in a database.

Correct Answer

verifed

verified

The primary purpose of a data warehouse is to perform transactional processes.

A) True
B) False

Correct Answer

verifed

verified

_________ information includes fixed data incapable of change in the event of a user action.

Correct Answer

verifed

verified

The primary purpose of a data warehouse is to _____________.


A) Combine strategic information
B) Organize departments
C) Interface between the computer and employees
D) All of the above

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

Correct Answer

verifed

verified

What maintains information about various types of objects,events,people,and places?


A) Database
B) Data model
C) Data mining
D) Data intelligence

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

Correct Answer

verifed

verified

Which of the following represents the different information levels?


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

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

Correct Answer

verifed

verified

Two of the challenges businesses faced before data warehouses were lack of data standards and poor data _________.

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

MMSDB creates,reads,updates,and deletes data in a database while controlling access and security.

A) True
B) False

Correct Answer

verifed

verified

Showing 261 - 280 of 286

Related Exams

Show Answer