Question 1

In a client/server environment,a DBMS is located on a dedicated computer called a web server.

Accepted Answer

In a client/server environment, a DBMS can be located on a dedicated computer called a database server, not a web server. A web server is responsible for serving web pages to clients.

Question 2

You can use OLAP to perform multidimensional data analysis.

Accepted Answer

OLAP stands for Online Analytical Processing, which is specifically designed for multidimensional data analysis. It allows users to analyze and view data from multiple perspectives, enabling decision-makers to better understand complex data relationships and identify trends and patterns.

Question 3

MongoDB and SimpleDB are both examples of:
A)open source databases.
B)SQL databases.
C)NoSQL databases.
D)cloud databases.
E)big data databases.

Accepted Answer

MongoDB and SimpleDB are both NoSQL databases, which means they use non-relational data models and are designed for scalability and flexibility in handling large amounts of unstructured or semi-structured data. They are often used for web and mobile applications, real-time analytics, and other use cases requiring high performance and availability.

Question 4

OLAP is unable to manage and handle queries with very large sets of data.

Accepted Answer

OLAP (Online Analytical Processing) is specifically designed to handle and manage large sets of data, enabling complex queries and analysis efficiently.

Question 5

Implementing a web interface for an organization's internal database usually requires substantial changes to be made to the database.

Accepted Answer

Implementing a web interface for an organization's internal database does not necessarily require substantial changes to be made to the database. However, the web interface may need to be integrated with the existing database and appropriate security measures should be implemented.

Question 6

In data mining,which of the following involves events linked over time?
A)Associations
B)Sequences
C)Classifications
D)Clustering
E)Forecasting

Accepted Answer

Sequences in data mining involve events linked over time, such as transactions or actions that occur in a particular order. Associations involve finding correlations between different events or items, classifications involve predicting the class of a given data point, clustering involves grouping similar data points together, and forecasting involves predicting future trends or patterns.

Question 7

In data mining,which of the following involves recognizing patterns that describe the group to which an item belongs by examining existing items and inferring a set of rules?
A)Associations
B)Sequences
C)Classifications
D)Clustering
E)Forecasting

Accepted Answer

The process described in the question is classification, which involves recognizing patterns and inferring a set of rules to classify new items into existing groups. Associations involve finding relationships between items, sequences involve identifying patterns in ordered data, clustering involves grouping similar items based on their characteristics, and forecasting involves predicting future values based on past trends.

Question 8

Which of the following would you use to find patterns in user interaction data recorded by a web server?
A)Web usage mining
B)Web server mining
C)Web structure mining
D)Web content mining
E)Web protocol mining

Accepted Answer

Web usage mining is the process of discovering patterns and relationships in data generated by user interactions with a website. This is the best choice for finding patterns in user interaction data recorded by a web server. Web server mining, web structure mining, and web content mining are not related to analyzing user interaction data specifically. Web protocol mining is focused on analyzing network protocols for security purposes, and is not relevant for this question.

Question 9

Middleware is an application that transfers information from an organization's internal database to a web server for delivery to a user as part of a web page.

Accepted Answer

Middleware acts as a bridge between a web server and an organization's internal database, allowing for the transfer of information to be delivered to a user via a web page.

Question 10

Multiple data marts are combined and streamlined to create a data warehouse.

Accepted Answer

The answer of Multiple data marts are combined and streamlined...

Question 11

In-memory computing relies primarily on a computer (RAM)for data storage.

Accepted Answer

In-memory computing stores data primarily in computer RAM for faster access and processing.

Question 12

Which of the following is software that handles all application operations between browser-based computers and a company's back-end business applications or databases?
A)Database server software
B)Application server software
C)Web browser software
D)Data mining software
E)Web server software

Accepted Answer

Application server software is designed to handle all application operations between browser-based computers and a company's back-end business applications or databases. It provides a platform for developing and deploying applications, managing application security, and handling transactions. The other options listed do not fit this description.

Question 13

You can use text mining tools to analyze unstructured data,such as memos and legal cases.

Accepted Answer

Text mining tools are specifically designed to analyze unstructured data, which includes text-based documents such as memos and legal cases. These tools use techniques such as natural language processing and machine learning algorithms to extract insights and patterns from large volumes of text data.

Question 14

Associations are occurrences linked to multiple events.

Accepted Answer

The answer of Associations are occurrences linked to multiple events....

Question 15

In data mining,which of the following involves using a series of existing values to determine what other future values will be?
A)Associations
B)Sequences
C)Classifications
D)Clustering
E)Forecasting

Accepted Answer

The process of using a series of existing values to determine what other future values will be is called forecasting. This technique is often used in time series analysis, where previous data points are used to predict future values. Associations involve finding relationships or patterns between variables, sequences involve identifying patterns in ordered data, classifications involve categorizing data into predefined groups, and clustering involves grouping similar data points together.

Question 16

________ tools are used to analyze large unstructured data sets,such as e-mail,memos,and survey responses to discover patterns and relationships.
A)OLAP
B)Text mining
C)In-memory
D)Clustering
E)Classification

Accepted Answer

Text mining tools are specifically designed to analyze unstructured data sets, such as e-mails and survey responses, to discover patterns and relationships. OLAP and in-memory tools are designed for structured data analysis, while clustering and classification can be used for both structured and unstructured data analysis, but not specifically tailored for unstructured data sets.

Question 17

Legacy systems are used to populate and update data warehouses.

Accepted Answer

Legacy systems, such as mainframes or older software applications, are often used to extract and transfer data from operational systems into a data warehouse for analysis and reporting.

Question 18

You can manipulate data on a web server by using a CGI script.

Accepted Answer

CGI (Common Gateway Interface) scripts allow for dynamic content and can manipulate data on a web server by interacting with databases, file systems, and other server-side applications.

Question 19

Which of the following enables you to create a script that allows a web server to communicate with a back-end database?
A)CGI
B)HTML
C)Java
D)SQL
E)NoSQL

Accepted Answer

CGI stands for Common Gateway Interface and it is a protocol that allows web servers to execute scripts or programs on a server. This means that with CGI, a web server can communicate with a back-end database and perform functions like storing and retrieving data.

Question 20

HTML has become the preferred method of communicating with back-end databases because it is a cross-platform language.

Accepted Answer

HTML is not a programming language, but a markup language used for creating web pages. It is not used for communicating with back-end databases. Instead, languages like PHP, Python, Ruby, and JavaScript are commonly used for this purpose.

Quiz 6: Foundations of Business Intelligence: Databases and Information Management

In a client/server environment,a DBMS is located on a dedicated computer called a web server.

You can use OLAP to perform multidimensional data analysis.

MongoDB and SimpleDB are both examples of:

OLAP is unable to manage and handle queries with very large sets of data.

Implementing a web interface for an organization's internal database usually requires substantial changes to be made to the database.

In data mining,which of the following involves events linked over time?

In data mining,which of the following involves recognizing patterns that describe the group to which an item belongs by examining existing items and inferring a set of rules?

Which of the following would you use to find patterns in user interaction data recorded by a web server?

Middleware is an application that transfers information from an organization's internal database to a web server for delivery to a user as part of a web page.

Multiple data marts are combined and streamlined to create a data warehouse.

In-memory computing relies primarily on a computer (RAM)for data storage.

Which of the following is software that handles all application operations between browser-based computers and a company's back-end business applications or databases?

You can use text mining tools to analyze unstructured data,such as memos and legal cases.

Associations are occurrences linked to multiple events.

In data mining,which of the following involves using a series of existing values to determine what other future values will be?

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

Legacy systems are used to populate and update data warehouses.

You can manipulate data on a web server by using a CGI script.

Which of the following enables you to create a script that allows a web server to communicate with a back-end database?

HTML has become the preferred method of communicating with back-end databases because it is a cross-platform language.