Question 1

Briefly explain the types of business analytics (BA)methods.

Accepted Answer

Answers will vary.There are several types of BA methods.Three popular ones are descriptive,predictive,and prescriptive analytics.Descriptive analytics reviews past events,analyzes the data,and provides a report indicating what happened in a given period and how to prepare for the future.Thus,it is a reactive strategy.Predictive analytics,as the name indicates,is a proactive strategy;it prepares a decision maker for future events.As an example,it might indicate that if a current sales trend continues,a company will need a certain number of salespeople in 2018.Prescriptive analytics goes beyond descriptive and predictive analytics by recommending a course of action that a decision maker should follow and showing the likely outcome of each decision.In another words prescriptive analytics is more specific than predictive analytics by recommending a precise course of action.

Question 2

Briefly explain the role of business analytics (BA)in decision making and compare it to business intelligence (BI).

Accepted Answer

Answers will vary.BA uses data and statistical methods to gain insight into the data and provide decision makers with information they can act on.BA is increasingly used for data-driven decision making that leverages and explores the data in a database,data warehouse,or data mart system.Compared to BI,BA is more forward looking;it tells the user what is going to happen in the future rather than what has happened in the past.BI can help determine what happened,what the problem is,and what decisions need to be made based on the available data.BA can help determine why this is happening,what it will mean if the sales trend continues,and what actions should be taken.

Question 3

In the context of the input component of a data warehouse,_____ collect,integrate,and process data that can be used by all functional areas in an organization.

Accepted Answer

A) online analytical processing systems 
B) online transaction management systems 
C) enterprise resource planning systems 
D) data mining analysis systems 
A) online analytical processing systems 
B) online transaction management systems 
C) enterprise resource planning systems 
D) data mining analysis systems C

Question 4

Which component of a database management system (DBMS)is used to design elements of an application using a database,such as data entry screens,interactive menus,and interfaces with other programming languages?

Accepted Answer

A) application generation 
B) application definition 
C) application administration 
D) application manipulation 
A) application generation 
B) application definition 
C) application administration 
D) application manipulation

Question 5

The data _____ component of a database management system (DBMS)is used to create and maintain the data dictionary.

Accepted Answer

A) manipulation 
B) generation 
C) definition 
D) administration 
A) manipulation 
B) generation 
C) definition 
D) administration

Question 6

Which component of a data model describes methods and calculations that can be performed on data,such as updating and querying data?

Accepted Answer

A) Data structure 
B) Operations 
C) Integrity rules 
D) File structure 
A) Data structure 
B) Operations 
C) Integrity rules 
D) File structure

Question 7

Which file structure is similar to a book index that lists page numbers where certain topics can be found?

Accepted Answer

A) The indexed sequential access method 
B) The indexed network access structure 
C) The indexed random access file structure 
D) The indexed hierarchical access method 
A) The indexed sequential access method 
B) The indexed network access structure 
C) The indexed random access file structure 
D) The indexed hierarchical access method

Question 8

In the context of the operators used in a query by example (QBE)form,the _____ is used when only one of the conditions in the QBE form must be met.

Accepted Answer

A) NOT operator 
B) AND operator 
C) OR operator 
D) NOR operator 
A) NOT operator 
B) AND operator 
C) OR operator 
D) NOR operator

Question 9

_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

Accepted Answer

A) Triangulation 
B) Fragmentation 
C) Normalization 
D) Encapsulation 
A) Triangulation 
B) Fragmentation 
C) Normalization 
D) Encapsulation

Question 10

Explain how information in a database is observed through the physical view and the logical view.

Accepted Answer

Answers will vary.Before designing a dat

Question 11

Briefly explain a relational model.

Accepted Answer

Answers will vary.A relational model use

Question 12

For each database,there:

Accepted Answer

A) is only one physical view of data. 
B) are only two logical views of data. 
C) are multiple physical views of data. 
D) is only one logical view of data. 
A) is only one physical view of data. 
B) are only two logical views of data. 
C) are multiple physical views of data. 
D) is only one logical view of data.

Question 13

Although a database can consist of only a single file,it is usually a group of files.

Accepted Answer

A) True 
 B)False

Question 14

Unlike data in databases,data in data warehouses is:

Accepted Answer

A) function oriented. 
B) raw transaction data. 
C) collected from a single source. 
D) used for analytical purposes. 
A) function oriented. 
B) raw transaction data. 
C) collected from a single source. 
D) used for analytical purposes.

Question 15

A select operation pares down a table in a relational database by eliminating columns according to certain criteria.

Accepted Answer

A) True 
 B)False

Question 16

A data _____ is the structure and organization of data,which involves fields,records,and files.

Accepted Answer

A) mine 
B) mart 
C) warehouse 
D) hierarchy 
A) mine 
B) mart 
C) warehouse 
D) hierarchy

Question 17

Which statement is true of data marts and data warehouses?

Accepted Answer

A) Consolidating information from different departments is easier in data marts than in data warehouses. 
B) Data marts have more extended scope than data warehouses. 
C) Access to data is often slower in data marts than in data warehouses. 
D) Data marts usually perform the same types of analysis as data warehouses. 
A) Consolidating information from different departments is easier in data marts than in data warehouses. 
B) Data marts have more extended scope than data warehouses. 
C) Access to data is often slower in data marts than in data warehouses. 
D) Data marts usually perform the same types of analysis as data warehouses.

Question 18

In the context of segmentation of customers in database marketing,_____ is a variable that includes gender,age,income,and marital status.

Accepted Answer

A) strategical information 
B) geographical information 
C) psychographic information 
D) demographic information 
A) strategical information 
B) geographical information 
C) psychographic information 
D) demographic information

Question 19

The _____ dimension of big data refers to the sheer quantity of transactions,measured in petabytes or exabytes.

Accepted Answer

A) velocity 
B) volume 
C) area 
D) time 
A) velocity 
B) volume 
C) area 
D) time

Question 20

A network model is similar to a hierarchical data model because in both data models records are organized in the same way.

Accepted Answer

A) True 
 B)False

Briefly explain the types of business analytics (BA)methods.

Briefly explain the role of business analytics (BA)in decision making and compare it to business intelligence (BI).

In the context of the input component of a data warehouse,_____ collect,integrate,and process data that can be used by all functional areas in an organization.

Which component of a database management system (DBMS)is used to design elements of an application using a database,such as data entry screens,interactive menus,and interfaces with other programming languages?

The data _____ component of a database management system (DBMS)is used to create and maintain the data dictionary.

Which component of a data model describes methods and calculations that can be performed on data,such as updating and querying data?

Which file structure is similar to a book index that lists page numbers where certain topics can be found?

In the context of the operators used in a query by example (QBE)form,the _____ is used when only one of the conditions in the QBE form must be met.

_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

Explain how information in a database is observed through the physical view and the logical view.

Briefly explain a relational model.

For each database,there:

Although a database can consist of only a single file,it is usually a group of files.

Unlike data in databases,data in data warehouses is:

A select operation pares down a table in a relational database by eliminating columns according to certain criteria.

A data _____ is the structure and organization of data,which involves fields,records,and files.

Which statement is true of data marts and data warehouses?

In the context of segmentation of customers in database marketing,_____ is a variable that includes gender,age,income,and marital status.

The _____ dimension of big data refers to the sheer quantity of transactions,measured in petabytes or exabytes.

A network model is similar to a hierarchical data model because in both data models records are organized in the same way.

Information Systems: An Overview

Computers: The Machines Behind Computing

Personal,Legal,Ethical,and Organizational Issues of Information Systems

Protecting Information Resources

Data Communication: Delivering Information Anywhere and Anytime

The Internet,Intranets,and Extranets

E-Commerce

Global Information Systems

Building Successful Information Systems

Enterprise Systems

Management Support Systems

Intelligent Information Systems

Emerging Trends,Technologies,and Applications

Filters

Exam 3: Database Systems,Data Warehouses,and Data Marts

Briefly explain the types of business analytics (BA)methods.

Briefly explain the role of business analytics (BA)in decision making and compare it to business intelligence (BI).

In the context of the input component of a data warehouse,_____ collect,integrate,and process data that can be used by all functional areas in an organization.

Which component of a database management system (DBMS)is used to design elements of an application using a database,such as data entry screens,interactive menus,and interfaces with other programming languages?

The data _____ component of a database management system (DBMS)is used to create and maintain the data dictionary.

Which component of a data model describes methods and calculations that can be performed on data,such as updating and querying data?

Which file structure is similar to a book index that lists page numbers where certain topics can be found?

In the context of the operators used in a query by example (QBE)form,the _____ is used when only one of the conditions in the QBE form must be met.

_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

Explain how information in a database is observed through the physical view and the logical view.

Briefly explain a relational model.

For each database,there:

Although a database can consist of only a single file,it is usually a group of files.

Unlike data in databases,data in data warehouses is:

A select operation pares down a table in a relational database by eliminating columns according to certain criteria.

A data _____ is the structure and organization of data,which involves fields,records,and files.

Which statement is true of data marts and data warehouses?

In the context of segmentation of customers in database marketing,_____ is a variable that includes gender,age,income,and marital status.

The _____ dimension of big data refers to the sheer quantity of transactions,measured in petabytes or exabytes.

A network model is similar to a hierarchical data model because in both data models records are organized in the same way.

Information Systems: An Overview

Computers: The Machines Behind Computing

Personal,Legal,Ethical,and Organizational Issues of Information Systems

Protecting Information Resources

Data Communication: Delivering Information Anywhere and Anytime

The Internet,Intranets,and Extranets

E-Commerce

Global Information Systems

Building Successful Information Systems

Enterprise Systems

Management Support Systems

Intelligent Information Systems

Emerging Trends,Technologies,and Applications

Filters