Question 1

Microsoft SQL Server is a(n):

Accepted Answer

A) DBMS for both desktops and mobile devices. 
B) Internet DBMS. 
C) desktop relational DBMS. 
D) DBMS for midrange computers. 
E) DBMS for mobile devices. 
A) DBMS for both desktops and mobile devices. 
B) Internet DBMS. 
C) desktop relational DBMS. 
D) DBMS for midrange computers. 
E) DBMS for mobile devices.

Question 2

You work for a retail clothing chain whose primary outlets are in shopping malls and are conducting an analysis of your customers and their preferences.You wish to find out if there are any particular activities that your customers engage in,or the types of purchases made in the month before or after purchasing select items from your store.To do this,you will want to use the data mining software you are using to do which of the following?

Accepted Answer

A) Identify associations 
B) Identify clusters 
C) Identify sequences 
D) Classify data 
E) Create a forecast 
A) Identify associations 
B) Identify clusters 
C) Identify sequences 
D) Classify data 
E) Create a forecast

Question 3

All of the following are issues with the traditional file environment except:

Accepted Answer

A) data inconsistency. 
B) inability to develop specialized applications for functional areas. 
C) lack of flexibility in creating ad-hoc reports. 
D) poor security. 
E) data sharing. 
A) data inconsistency. 
B) inability to develop specialized applications for functional areas. 
C) lack of flexibility in creating ad-hoc reports. 
D) poor security. 
E) data sharing.

Question 4

A distributed database:

Accepted Answer

A) uses predictive analysis. 
B) uses SQL. 
C) is a database that is stored in multiple physical locations. 
D) is a database that is distributed across many business firms. 
E) uses Hadoop to process information. 
A) uses predictive analysis. 
B) uses SQL. 
C) is a database that is stored in multiple physical locations. 
D) is a database that is distributed across many business firms. 
E) uses Hadoop to process information.

Question 5

Program-data dependence refers to the coupling of data stored in files and the specific programs required to update and maintain those files such that changes in programs require changes to the data.

Accepted Answer

A) True 
 B)False

Question 6

Spanner is an example of a distributed database.

Accepted Answer

A) True 
 B)False

Question 7

Data ________ occurs when the same data is duplicated in multiple files of a database.

Accepted Answer

A) redundancy 
B) repetition 
C) independence 
D) partitions 
E) discrepancy 
A) redundancy 
B) repetition 
C) independence 
D) partitions 
E) discrepancy

Question 8

A DBMS makes the:

Accepted Answer

A) physical database available for different logical views. 
B) relational database available for different logical views. 
C) physical database available for different analytic views. 
D) relational database available for different analytic views. 
E) logical database available for different analytic views. 
A) physical database available for different logical views. 
B) relational database available for different logical views. 
C) physical database available for different analytic views. 
D) relational database available for different analytic views. 
E) logical database available for different analytic views.

Question 9

________ creates confusion that hampers the creation of information systems that integrate data from different sources.

Accepted Answer

A) Batch processing 
B) Data redundancy 
C) Data independence 
D) Online processing 
E) Data quality 
A) Batch processing 
B) Data redundancy 
C) Data independence 
D) Online processing 
E) Data quality

Question 10

Associations are occurrences linked to multiple events.

Accepted Answer

A) True 
 B)False

Question 11

CGI is a DBMS programming language that end users and programmers use to manipulate data in the database.

Accepted Answer

A) True 
 B)False

Question 12

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

Accepted Answer

Data mining uncovers hidden relationship

Question 13

Which of the following is not one of the benefits of a blockchain database?

Accepted Answer

A) It enables the ability to use relational databases. 
B) It prevents data from being altered retroactively. 
C) It allows administrators to manage data more effectively. 
D) It enables firms to create and verify translations on a network very rapidly. 
E) It provides users with an integrated view of the data. 
A) It enables the ability to use relational databases. 
B) It prevents data from being altered retroactively. 
C) It allows administrators to manage data more effectively. 
D) It enables firms to create and verify translations on a network very rapidly. 
E) It provides users with an integrated view of the data.

Question 14

Data scrubbing is a more intensive corrective process than data cleansing.

Accepted Answer

A) True 
 B)False

Question 15

You have been asked to design a new contracts database for a small publishing company.What fields do you anticipate needing? Which of these fields might be in use in other databases used by the company?

Accepted Answer

Author first name,author last name,autho

Question 16

In the context of data relationships,the term associations refers to:

Accepted Answer

A) events linked over time. 
B) patterns that describe a group to which an item belongs. 
C) occurrences linked to a single event. 
D) undiscovered groupings. 
E) relationships between different customers. 
A) events linked over time. 
B) patterns that describe a group to which an item belongs. 
C) occurrences linked to a single event. 
D) undiscovered groupings. 
E) relationships between different customers.

Question 17

________ tools are used to analyze large unstructured data sets,such as email,memos,and survey responses to discover patterns and relationships.

Accepted Answer

A) OLAP 
B) Text mining 
C) In-memory 
D) Clustering 
E) Classification 
A) OLAP 
B) Text mining 
C) In-memory 
D) Clustering 
E) Classification

Question 18

Data mining allows users to:

Accepted Answer

A) quickly compare transaction data gathered over many years. 
B) find hidden relationships in data. 
C) obtain online answers to ad-hoc questions in a rapid amount of time. 
D) summarize massive amounts of data into much smaller,traditional reports. 
E) access the vast amounts of data in a data warehouse. 
A) quickly compare transaction data gathered over many years. 
B) find hidden relationships in data. 
C) obtain online answers to ad-hoc questions in a rapid amount of time. 
D) summarize massive amounts of data into much smaller,traditional reports. 
E) access the vast amounts of data in a data warehouse.

Question 19

OLAP enables:

Accepted Answer

A) users to obtain online answers to ad-hoc questions in a rapid amount of time. 
B) users to view both logical and physical views of data. 
C) programmers to quickly diagram data relationships. 
D) programmers to normalize data. 
E) users to quickly generate summary reports. 
A) users to obtain online answers to ad-hoc questions in a rapid amount of time. 
B) users to view both logical and physical views of data. 
C) programmers to quickly diagram data relationships. 
D) programmers to normalize data. 
E) users to quickly generate summary reports.

Question 20

The logical view of a database:

Accepted Answer

A) displays the organization and structure of data on the physical storage media. 
B) includes a digital dashboard. 
C) allows the creation of supplementary reports. 
D) enables users to manipulate the logical structure of the database. 
E) presents data as they would be perceived by end users. 
A) displays the organization and structure of data on the physical storage media. 
B) includes a digital dashboard. 
C) allows the creation of supplementary reports. 
D) enables users to manipulate the logical structure of the database. 
E) presents data as they would be perceived by end users.

Microsoft SQL Server is a(n):

All of the following are issues with the traditional file environment except:

A distributed database:

Program-data dependence refers to the coupling of data stored in files and the specific programs required to update and maintain those files such that changes in programs require changes to the data.

Spanner is an example of a distributed database.

Data ________ occurs when the same data is duplicated in multiple files of a database.

A DBMS makes the:

________ creates confusion that hampers the creation of information systems that integrate data from different sources.

Associations are occurrences linked to multiple events.

CGI is a DBMS programming language that end users and programmers use to manipulate data in the database.

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

Which of the following is not one of the benefits of a blockchain database?

Data scrubbing is a more intensive corrective process than data cleansing.

You have been asked to design a new contracts database for a small publishing company.What fields do you anticipate needing? Which of these fields might be in use in other databases used by the company?

In the context of data relationships,the term associations refers to:

________ tools are used to analyze large unstructured data sets,such as email,memos,and survey responses to discover patterns and relationships.

Data mining allows users to:

OLAP enables:

The logical view of a database:

Information Systems in Global Business Today

Global E-Business and Collaboration

Information Systems,organizations,and Strategy

Ethical and Social Issues in Information Systems

It Infrastructure and Emerging Technologies

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy:

E-Commerce: Digital Markets, digital Goods

Managing Knowledge and Artificial Intelligence

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters

Exam 6: Foundations of Business Intelligence:

Microsoft SQL Server is a(n):

All of the following are issues with the traditional file environment except:

A distributed database:

Program-data dependence refers to the coupling of data stored in files and the specific programs required to update and maintain those files such that changes in programs require changes to the data.

Spanner is an example of a distributed database.

Data ________ occurs when the same data is duplicated in multiple files of a database.

A DBMS makes the:

________ creates confusion that hampers the creation of information systems that integrate data from different sources.

Associations are occurrences linked to multiple events.

CGI is a DBMS programming language that end users and programmers use to manipulate data in the database.

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

Which of the following is not one of the benefits of a blockchain database?

Data scrubbing is a more intensive corrective process than data cleansing.

You have been asked to design a new contracts database for a small publishing company.What fields do you anticipate needing? Which of these fields might be in use in other databases used by the company?

In the context of data relationships,the term associations refers to:

________ tools are used to analyze large unstructured data sets,such as email,memos,and survey responses to discover patterns and relationships.

Data mining allows users to:

OLAP enables:

The logical view of a database:

Information Systems in Global Business Today

Global E-Business and Collaboration

Information Systems,organizations,and Strategy

Ethical and Social Issues in Information Systems

It Infrastructure and Emerging Technologies

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy:

E-Commerce: Digital Markets, digital Goods

Managing Knowledge and Artificial Intelligence

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters