Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

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.

Question 5

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 6

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 7

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 8

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 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 11

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

Accepted Answer

Data redundancy and inconsistency can oc...

Question 12

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

Accepted Answer

A DBMS includes capabilities and tools f...

Question 13

A data warehouse may include information from legacy systems.

Accepted Answer

A) True 
 B)False

Question 14

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 15

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 16

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 17

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 18

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 19

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 20

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

Accepted Answer

A) True 
 B)False

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

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

A DBMS makes the:

Correct AnswerverifiedShow 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

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

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

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

Correct AnswerverifiedShow Answer

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

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

An example of a pre-digital database is a:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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

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

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

A data warehouse may include information from legacy systems.

Correct AnswerverifiedShow Answer

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

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

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

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
There are three types of relationships: ...
View Answer

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

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

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified