Exam 6: Data: Business Intelligence

Information granularity occurs when the same data element has different values.

What type of website is an interactive website kept constantly updated and relevant to the needs of its customers using a database?

One of the advantages found in a relational database is increased information redundancy.

What are the rules that help ensure the quality of information?

Data ______________ compiles all of the metadata about the data elements in the data model.

What 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?

Ben works at a top accounting firm in Salt Lake City and his responsibilities include developing individual and departmental goals,and generating financial analysis across departments and the enterprise as a whole for the executive team to review.Ben's duties provide value-added to his company and would be categorized as occurring at the different _____________.

Which of the following asks users to write lines of code to answer questions against a database?

Identify the business advantages of a relational database.

Which of the following provides real-time information in response to requests?

Which of the following is not a primary trait of information?

Within the data warehouse model,the internal databases could include marketing,sales,inventory,and billing.

All of the following are business-critical integrity constraints,except

Extraction,transformation,and ___________ 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.

What is a great example of using cluster analysis in business to create target-marketing strategies?

Data ___________________ describes technologies that allow users to "see" or visualize data to transform information into a business perspective.

What is accessing large amounts of data from different management information systems?

What are the primary differences between a data warehouse and a data mart?

Nestle is one of the companies shown as an example of low-quality information causing problems for the company.Which of the following are some of the errors they found in the data or information?

Companies can gain valuable business knowledge by viewing the data accessed and analyzed from their __________.