Question 1

In terms of the data relationships found by data mining, 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)  classification when no groups have yet been defined. 
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)  classification when no groups have yet been defined. C

Question 2

Which of the following is the most prominent data manipulation language today?

Accepted Answer

A)  Access 
B)  DB2 
C)  SQL 
D)  Crystal Reports 
E)  Hadoop 
A)  Access 
B)  DB2 
C)  SQL 
D)  Crystal Reports 
E)  Hadoop C

Question 3

A(n) ________ is a structured survey of the accuracy and level of completeness of the data in an information system.

Accepted Answer

A)  data quality audit 
B)  systems analysis 
C)  systems audit 
D)  data analysis 
E)  data overview 
A)  data quality audit 
B)  systems analysis 
C)  systems audit 
D)  data analysis 
E)  data overview A

Question 4

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:

Accepted Answer

A)  normalization. 
B)  data scrubbing. 
C)  data cleansing. 
D)  data administration. 
E)  data management. 
A)  normalization. 
B)  data scrubbing. 
C)  data cleansing. 
D)  data administration. 
E)  data management.

Question 5

A data warehouse extracts current and historical data from multiple operational systems in an organization.

Accepted Answer

A) True 
 B)False

Question 6

The small publishing company you work for wants to create a new database for storing information about all of their author contracts. What difficulties do you anticipate?

Accepted Answer

Data accuracy when the new data is input

Question 7

List at least two ways that a business's data can become redundant or inconsistent.

Accepted Answer

Data redundancy and inconsistency can oc

Question 8

In terms of the data relationships found by data mining, sequences 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)  classifications when no groups have yet been defined. 
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)  classifications when no groups have yet been defined.

Question 9

Why might you receive multiple pieces of the same piece of mail, or multiple emails featuring the same promotion?

Accepted Answer

These events often occur because of redu

Question 10

The logical view of a database:

Accepted Answer

A)  shows how data are organized and structured on the storage media. 
B)  presents an entry screen to the user. 
C)  allows the creation of supplementary reports. 
D)  presents data as they would be perceived by end users. 
E)  shows the relationships between entities and attributes. 
A)  shows how data are organized and structured on the storage media. 
B)  presents an entry screen to the user. 
C)  allows the creation of supplementary reports. 
D)  presents data as they would be perceived by end users. 
E)  shows the relationships between entities and attributes.

Question 11

Describe the process of querying and reporting in a database using DBMS.

Accepted Answer

DBMS include tools for accessing and man

Question 12

You are working in the IT department of a small paper supply company and planning a new database that monitors employee benefits and productivity. What would be the relationship you need to establish between Employee_ID in the Employee table and Parking_spot_number in the Perks table?

Accepted Answer

A)  One-to-many 
B)  One-to-one 
C)  Many-to-many 
D)  Many-to-one 
E)  One-to-all 
A)  One-to-many 
B)  One-to-one 
C)  Many-to-many 
D)  Many-to-one 
E)  One-to-all

Question 13

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

Accepted Answer

A DBMS includes capabilities and tools f

Question 14

In a business relational database, tables contain:

Accepted Answer

A)  one table for each entity. 
B)  relations among entities. 
C)  bytes. 
D)  three-dimensional relations. 
E)  links to other tables. 
A)  one table for each entity. 
B)  relations among entities. 
C)  bytes. 
D)  three-dimensional relations. 
E)  links to other tables.

Question 15

Pre-configured hardware-software systems that use both relational and non-relational technology optimized for analyzing large data sets are referred to as:

Accepted Answer

A)  hybrid DBMS. 
B)  Hadoop. 
C)  BI. 
D)  analytic platforms. 
E)  data marts. 
A)  hybrid DBMS. 
B)  Hadoop. 
C)  BI. 
D)  analytic platforms. 
E)  data marts.

Question 16

Which of the following best describes the importance of creating an accurate data model for your business's database?

Accepted Answer

A)  It is not essential, as the data model itself is modified by the database continuously. 
B)  It is critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve. 
C)  It is essential, as table relationships cannot be created without an accurate data model. 
D)  It is somewhat important, as the type of data model will define what kinds of data will be stored. 
E)  It is unnecessary, as a well-designed database should not require one. 
A)  It is not essential, as the data model itself is modified by the database continuously. 
B)  It is critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve. 
C)  It is essential, as table relationships cannot be created without an accurate data model. 
D)  It is somewhat important, as the type of data model will define what kinds of data will be stored. 
E)  It is unnecessary, as a well-designed database should not require one.

Question 17

The project operation:

Accepted Answer

A)  combines relational tables to provide the user with more information than is otherwise available. 
B)  creates a subset consisting of columns in a table. 
C)  organizes elements into segments. 
D)  identifies the table from which the columns will be selected. 
E)  stores definitions of data elements. 
A)  combines relational tables to provide the user with more information than is otherwise available. 
B)  creates a subset consisting of columns in a table. 
C)  organizes elements into segments. 
D)  identifies the table from which the columns will be selected. 
E)  stores definitions of data elements.

Question 18

Big data refers to any database that:

Accepted Answer

A)  contains more than one petabyte of data. 
B)  discovers patterns in data. 
C)  has a large volume and variety of data. 
D)  includes data from thousands of websites. 
E)  stores data in rows and columns. 
A)  contains more than one petabyte of data. 
B)  discovers patterns in data. 
C)  has a large volume and variety of data. 
D)  includes data from thousands of websites. 
E)  stores data in rows and columns.

Question 19

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

Accepted Answer

The select operation creates a subset co

Question 20

Which of the following database types would be best suited for storing multimedia?

Accepted Answer

A)  SQL DBMS 
B)  Open source DBMS 
C)  Non-relational DBMS 
D)  Cloud-based database 
E)  NoSQL DBMS. 
A)  SQL DBMS 
B)  Open source DBMS 
C)  Non-relational DBMS 
D)  Cloud-based database 
E)  NoSQL DBMS.

In terms of the data relationships found by data mining, associations refers to:

Which of the following is the most prominent data manipulation language today?

A(n) ________ is a structured survey of the accuracy and level of completeness of the data in an information system.

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:

A data warehouse extracts current and historical data from multiple operational systems in an organization.

The small publishing company you work for wants to create a new database for storing information about all of their author contracts. What difficulties do you anticipate?

List at least two ways that a business's data can become redundant or inconsistent.

In terms of the data relationships found by data mining, sequences refers to:

Why might you receive multiple pieces of the same piece of mail, or multiple emails featuring the same promotion?

The logical view of a database:

Describe the process of querying and reporting in a database using DBMS.

You are working in the IT department of a small paper supply company and planning a new database that monitors employee benefits and productivity. What would be the relationship you need to establish between Employee_ID in the Employee table and Parking_spot_number in the Perks table?

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

In a business relational database, tables contain:

Pre-configured hardware-software systems that use both relational and non-relational technology optimized for analyzing large data sets are referred to as:

Which of the following best describes the importance of creating an accurate data model for your business's database?

The project operation:

Big data refers to any database that:

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

Which of the following database types would be best suited for storing multimedia?

Business Information Systems in Your Career

Global E-Business and Collaboration

Achieving Competitive Advantage With Information Systems

Ethical and Social Issues in Information Systems

It Infrastructure: Hardware and Software

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy: Enterprise Applications

E-Commerce: Digital Markets, Digital Goods

Improving Decision Making and Managing Knowledge

Building Information Systems and Managing Projects

Filters

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

In terms of the data relationships found by data mining, associations refers to:

Which of the following is the most prominent data manipulation language today?

A(n) ________ is a structured survey of the accuracy and level of completeness of the data in an information system.

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:

A data warehouse extracts current and historical data from multiple operational systems in an organization.

The small publishing company you work for wants to create a new database for storing information about all of their author contracts. What difficulties do you anticipate?

List at least two ways that a business's data can become redundant or inconsistent.

In terms of the data relationships found by data mining, sequences refers to:

Why might you receive multiple pieces of the same piece of mail, or multiple emails featuring the same promotion?

The logical view of a database:

Describe the process of querying and reporting in a database using DBMS.

You are working in the IT department of a small paper supply company and planning a new database that monitors employee benefits and productivity. What would be the relationship you need to establish between Employee_ID in the Employee table and Parking_spot_number in the Perks table?

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

In a business relational database, tables contain:

Pre-configured hardware-software systems that use both relational and non-relational technology optimized for analyzing large data sets are referred to as:

Which of the following best describes the importance of creating an accurate data model for your business's database?

The project operation:

Big data refers to any database that:

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

Which of the following database types would be best suited for storing multimedia?

Business Information Systems in Your Career

Global E-Business and Collaboration

Achieving Competitive Advantage With Information Systems

Ethical and Social Issues in Information Systems

It Infrastructure: Hardware and Software

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy: Enterprise Applications

E-Commerce: Digital Markets, Digital Goods

Improving Decision Making and Managing Knowledge

Building Information Systems and Managing Projects

Filters