Question 1

Relational DBMSs use key field rules to ensure that relationships between coupled tables remain consistent.

Accepted Answer

The answer of Relational DBMSs use key field rules to...

Question 2

List and describe three main capabilities or tools of a DBMS.

Accepted Answer

The answer of List and describe three main capabilities or...

Question 3

All of the following are technologies used to analyze and manage big data except:

Accepted Answer

Cloud computing is a technology used for delivering various services over the Internet, including storage, databases, servers, and networking, among others. While it can support big data analytics by providing the infrastructure and computational power needed, it is not a technology specifically designed to analyze and manage big data. Technologies like NoSQL, in-memory computing, analytic platforms, and Hadoop are directly involved in the processing, management, and analysis of big data.

Question 4

OLAP enables:

Accepted Answer

OLAP (Online Analytical Processing) is designed to facilitate complex data analysis and support business intelligence. It empowers users to obtain quick, ad-hoc answers to their queries. OLAP technology is built on a multidimensional data model, which can handle large volumes of data effectively and speedily. It enables users to slice and dice large data sets and view them from various perspectives. OLAP allows users to generate summary reports on the fly, compare data across different time periods, explore data hierarchies, filter and sort data, and perform other data manipulation tasks in real-time. While OLAP does offer logical and physical views of data, it is primarily a tool for interactive data analysis and reporting, rather than data modeling or programming.

Question 5

A distributed database:

Accepted Answer

A distributed database is a database in which different parts of the database are stored in multiple physical locations. This allows for faster access to data and reduces the risk of a single point of failure in the system. It does not necessarily use predictive analysis, SQL, or Hadoop, and can be distributed across multiple business firms or within a single organization.

Question 6

You work for a car rental agency and want to determine what characteristics are shared among your most loyal customers.To do this,you will want to use the data mining software you are using to do which of the following?

Accepted Answer

The answer of You work for a car rental agency...

Question 7

The small publishing company you work for wants to create a new database for storing information about all of their author contracts.What factors will influence how you design the database?

Accepted Answer

The answer of The small publishing company you work for...

Question 8

A household appliances manufacturer has hired you to help analyze its social media datasets to determine which of its refrigerators are seen as the most reliable.Which of the following tools would you use to analyze this data?

Accepted Answer

The answer of A household appliances manufacturer has hired you...

Question 9

Which of the following technologies would you use to analyze the social media data collected by a major online retailer?

Accepted Answer

Hadoop is the best choice for analyzing large volumes of unstructured social media data, which is typically collected by online retailers. Hadoop can efficiently store, process and analyze large datasets, making it an ideal tool for analyzing social media data. OLAP, data warehouse, data mart, and DBMS are more appropriate for structured data or smaller datasets.

Question 10

A data lake is composed of:

Accepted Answer

A data lake is designed to store large volumes of raw, unstructured, and structured data that has not yet been processed or analyzed.

Question 11

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

Accepted Answer

CGI (Common Gateway Interface) is a protocol that allows web servers to interact with external programs, such as Perl or Python scripts, to generate dynamic web pages. It is not a DBMS programming language used to manipulate data in a database. SQL (Structured Query Language) is the most commonly used language for database management.

Question 12

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

Identifying sequences is the correct approach for analyzing the order of events, such as activities or purchases, that occur before or after buying specific items from the store. This method helps in understanding patterns related to customer behavior over time.

Question 13

Which of the following is not one of the techniques used in web mining?

Accepted Answer

Content mining, structure mining, usage mining, and data mining are all techniques used in web mining. Server mining is not a common technique used in web mining.

Question 14

NoSQL technologies are used to manage sets of data that require the flexibility of tables and relations.

Accepted Answer

NoSQL technologies are actually used to manage unstructured and semi-structured data that do not fit well into the rigid structure of tables and relations in traditional relational database management systems.

Question 15

Complicated groupings of data in a relational database need to be adjusted to eliminate awkward many-to-many relationships.

Accepted Answer

Complicated many-to-many relationships in a relational database can lead to data redundancy and inconsistency. Therefore, adjustments need to be made to eliminate them and ensure efficient data management.

Question 16

DBMS have a data definition capability to specify the structure of the content of the database.

Accepted Answer

DBMS have a data definition language (DDL) which allows users to define the structure of the database, including tables, columns, data types, and relationships.

Question 17

Data mining allows users to:

Accepted Answer

Data mining is the process of finding hidden patterns or relationships in large datasets. It involves using mathematical algorithms and statistical techniques to analyze data and discover insights that might not be apparent from simply looking at the data. The other answer choices describe some aspects of data analysis, but they do not specifically relate to data mining as a technique for uncovering hidden relationships.

Question 18

The term big data refers to all of the following except:

Accepted Answer

The term big data usually refers to datasets with billions or even trillions of records. Therefore, datasets with fewer than a billion records would not be considered as big data.

Question 19

Identify and describe three basic operations used to extract useful sets of data from a relational database.

Accepted Answer

The answer of Identify and describe three basic operations used...

Question 20

A physical view shows data as it is actually organized and structured on the data storage media.

Accepted Answer

A physical view of data includes information on how data is stored on the physical media, such as the location of each byte or block. This is in contrast to a logical view, which shows how data is organized conceptually.

Quiz 6: Foundations of Business Intelligence: