Question 1

Explain what big data refers to. What benefits does it have, and what challenges does it pose?

Accepted Answer

Big data is datasets with volumes so hug...

Question 2

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.

Question 3

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

Accepted Answer

A)  Hybrid DBMS.
B)  Hadoop.
C)  BI.
D)  Analytic platforms.

Question 4

A firm's information policy lays out who is responsible for updating and maintaining the information in a database system.

Accepted Answer

A) True 
 B)False

Question 5

The two key services of Hadoop are HDFS and in-memory computing.

Accepted Answer

A) True 
 B)False

Question 6

A DBMS makes the:

Accepted Answer

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

Question 7

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

Accepted Answer

A DBMS includes capabilities and tools f...

Question 8

An example of a pre-digital database is a:

Accepted Answer

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

Question 9

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

Accepted Answer

Data redundancy and inconsistency can oc...

Question 10

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)  Critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve
C)  Essential, as table relationships cannot be created without an accurate data model
D)  Somewhat important, as the type of data model will define what kinds of data will be stored

Question 11

The use of different terms for identifying data in a firm's various information systems is an example of redundant data.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

What is the purpose of a DBMS's data definition function?

Accepted Answer

A)  Storing and managing the data in the database
B)  Storing definitions of data elements
C)  Normalizing the database
D)  Structuring the database

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

What types of relationships are possible in a relational database? Describe and give an example of each.

Accepted Answer

There are three types of relationships: ...

Question 16

A data warehouse may include information from legacy systems.

Accepted Answer

A) True 
 B)False

Question 17

Within a corporate information services department, the task of creating the physical database and its logical relations are responsibilities of the ________ function.

Accepted Answer

A)  database administration
B)  data administration
C)  server administration
D)  data modeling

Question 18

Common Gateway Interface is a specification for processing data on a Web server.

Accepted Answer

A) True 
 B)False

Question 19

An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the:

Accepted Answer

A)  data dictionary.
B)  data definition diagram.
C)  entity-relationship diagram.
D)  relationship dictionary.

Question 20

In a relational database, a record is also called a(n) :

Accepted Answer

A)  tuple.
B)  row.
C)  entity.
D)  field.

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

What is the purpose of a DBMS's data definition function?

Correct AnswerverifiedShow Answer

An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the:

Correct AnswerverifiedShow Answer

An example of a pre-digital database is a:

Correct AnswerverifiedShow Answer

A DBMS makes the:

Correct AnswerverifiedShow Answer

The use of different terms for identifying data in a firm's various information systems is an example of redundant data.

Correct AnswerverifiedShow Answer

In a relational database, a record is also called a(n) :

Correct AnswerverifiedShow Answer

The two key services of Hadoop are HDFS and in-memory computing.

Correct AnswerverifiedShow Answer

A data warehouse may include information from legacy systems.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What types of relationships are possible in a relational database? Describe and give an example of each.

Correct AnswerverifiedThere are three types of relationships: ...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

Common Gateway Interface is a specification for processing data on a Web server.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedData redundancy and inconsistency can oc...View AnswerShow Answer

Within a corporate information services department, the task of creating the physical database and its logical relations are responsibilities of the ________ function.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Explain what big data refers to. What benefits does it have, and what challenges does it pose?

Correct AnswerverifiedBig data is datasets with volumes so hug...View AnswerShow Answer

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

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

A firm's information policy lays out who is responsible for updating and maintaining the information in a database system.

Correct AnswerverifiedShow 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
There are three types of relationships: ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Data redundancy and inconsistency can oc...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Big data is datasets with volumes so hug...
View Answer

Correct Answer
verified

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

Correct Answer
verified