Question 1

Data cleansing is the same process as data scrubbing.

Accepted Answer

A) True 
 B)False

Question 2

DBMS typically include report-generating tools in order to:

Accepted Answer

A)   retrieve and display data.
B)   display data in tables.
C)   display data in graphs.
D)   perform predictive analysis.
E)   display data in an easier-to-read-format.

Question 3

Which of the following is an example of a company whose business model is based on access to large databases through the web?

Accepted Answer

A)   Gartner
B)   Fortune
C)   IBM
D)   Microsoft
E)   Facebook

Question 4

A field identified in a record as holding the unique identifier for that record is called the:

Accepted Answer

A)   primary key.
B)   key field.
C)   primary field.
D)   foreign key.
E)   identifying field.

Question 5

All of the following are tools or technologies for extracting information from unstructured data sets except:

Accepted Answer

A)   sentiment analysis software.
B)   SQL queries.
C)   Hadoop.
D)   a non-relational DBMS.
E)   text mining.

Question 6

A field identified in a table as holding the unique identifier of the table's records is called the:

Accepted Answer

A)   primary key.
B)   key field.
C)   primary field.
D)   foreign key.
E)   identifying field.

Question 7

Describe the ways in which database technologies could be used by an office stationery supply company to achieve low-cost leadership.

Accepted Answer

Student answers will vary; an example an...

Question 8

A DBMS is special software for creating, storing, organizing, and accessing data from a database.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A DBMS includes capabilities and tools f...

Question 10

A data warehouse may include information from legacy systems.

Accepted Answer

A) True 
 B)False

Question 11

Hadoop can process large quantities of any type of data, including video and Twitter feeds.

Accepted Answer

A) True 
 B)False

Question 12

Relational database systems use ________ to ensure that relationships between coupled tables remain consistent.

Accepted Answer

A)   intersection relations
B)   one-to-one ordering
C)   entity-relationship diagrams
D)   foreign keys
E)   referential integrity rules

Question 13

Which of the following is an example of a pre-digital database?

Accepted Answer

A)   A library's card-catalog
B)   A cash register receipt
C)   A doctor's office invoice
D)   A list of sales totals on a spreadsheet
E)   An SQL database

Question 14

Imagine you are running a growing business with an active presence on social media. How would you better understand what your customers think about your business using these platforms?

Accepted Answer

Text mining and web mining techniques wo...

Question 15

Links pointing to an online document are a sign of:

Accepted Answer

A)   richness or variety of topics covered.
B)   popularity.
C)   data quality.
D)   data usage.
E)   marketing.

Question 16

Access is a:

Accepted Answer

A)   DBMS for mobile devices.
B)   popular open-source DBMS.
C)   DBMS for midrange computers.
D)   DBMS for desktop PC systems.
E)   DBMS for mainframe computers.

Question 17

Every record in a file should contain at least one key field.

Accepted Answer

A) True 
 B)False

Question 18

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.

Question 19

The smallest unit of data a computer can handle is called a:

Accepted Answer

A)   file.
B)   record.
C)   field.
D)   byte.
E)   bit.

Question 20

Both Oracle and Microsoft Access use SQL to retrieve information from a database.

Accepted Answer

A) True 
 B)False

Exam 6: Foundations of Business Intelligence: Databases and

All of the following are tools or technologies for extracting information from unstructured data sets except:

Correct AnswerverifiedShow Answer

The smallest unit of data a computer can handle is called a:

Correct AnswerverifiedShow Answer

Which of the following is an example of a company whose business model is based on access to large databases through the web?

Correct AnswerverifiedShow Answer

Describe the ways in which database technologies could be used by an office stationery supply company to achieve low-cost leadership.

Correct AnswerverifiedStudent answers will vary; an example an...View AnswerShow Answer

A field identified in a record as holding the unique identifier for that record is called the:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Hadoop can process large quantities of any type of data, including video and Twitter feeds.

Correct AnswerverifiedShow Answer

A DBMS is special software for creating, storing, organizing, and accessing data from a database.

Correct AnswerverifiedShow Answer

Which of the following is an example of a pre-digital database?

Correct AnswerverifiedShow Answer

A data warehouse may include information from legacy systems.

Correct AnswerverifiedShow Answer

Relational database systems use ________ to ensure that relationships between coupled tables remain consistent.

Correct AnswerverifiedShow Answer

A field identified in a table as holding the unique identifier of the table's records is called the:

Correct AnswerverifiedShow Answer

Access is a:

Correct AnswerverifiedShow Answer

Links pointing to an online document are a sign of:

Correct AnswerverifiedShow Answer

Both Oracle and Microsoft Access use SQL to retrieve information from a database.

Correct AnswerverifiedShow Answer

Data cleansing is the same process as data scrubbing.

Correct AnswerverifiedShow Answer

Imagine you are running a growing business with an active presence on social media. How would you better understand what your customers think about your business using these platforms?

Correct AnswerverifiedText mining and web mining techniques wo...View AnswerShow Answer

Every record in a file should contain at least one key field.

Correct AnswerverifiedShow Answer

DBMS typically include report-generating tools in order to:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA DBMS includes capabilities and tools f...View AnswerShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Student answers will vary; an example an...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Text mining and web mining techniques wo...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A DBMS includes capabilities and tools f...
View Answer