Question 1

Which of the following is a grouping of characters into a word,a group of words,or a complete number?

Accepted Answer

A)  File
B)  Table
C)  Entity
D)  Field
E)  TupleF) A) and B)
G) A) and E)

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

The term big data is used to describe da...

Question 4

In-memory computing relies primarily on a computer (RAM)for data storage.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following best illustrates the relationship between entities and attributes?

Accepted Answer

A)  The entity CUSTOMER with the attribute PRODUCT
B)  The entity CUSTOMER with the attribute PURCHASE
C)  The entity PRODUCT with the attribute PURCHASE
D)  The entity PRODUCT with the attribute CUSTOMER
E)  The entity PURCHASE with the attribute CUSTOMERF) B) and C)
G) A) and E)

Question 6

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

A)  Text mining tools
B)  Sentiment analysis software
C)  Web mining technologies
D)  Data mining software
E)  Data governance softwareF) A) and D)
G) None of the above

Question 7

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)  unique ID.
E)  primary entity.F) C) and E)
G) C) and D)

Question 8

Which of the following is a DBMS for desktop computers?

Accepted Answer

A)  DB2
B)  Oracle Database
C)  Microsoft SQL Server
D)  Microsoft Access
E)  Microsoft ExchangeF) B) and E)
G) A) and E)

Question 9

Microsoft SQL Server is a(n) :

Accepted Answer

A)  DBMS for both desktops and mobile devices.
B)  Internet DBMS.
C)  desktop relational DBMS.
D)  DBMS for midrange computers.
E)  DBMS for mobile devices.F) A) and B)
G) None of the above

Question 10

Which of the following occurs when the same attribute in related data files has different values?

Accepted Answer

A)  Data redundancy
B)  Data duplication
C)  Data dependence
D)  Data discrepancy
E)  Data inconsistencyF) A) and C)
G) A) and B)

Question 11

A schematic of the entire database that describes the relationships in a database is called a(n) :

Accepted Answer

A)  data dictionary.
B)  intersection relationship diagram.
C)  entity-relationship diagram.
D)  data definition diagram.
E)  data analysis table.F) A) and B)
G) A) and C)

Question 12

In a relational database,a record is referred to in technical terms as a(n) :

Accepted Answer

A)  tuple.
B)  table.
C)  entity.
D)  field.
E)  key.F) B) and D)
G) All of the above

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

You can use OLAP to perform multidimensional data analysis.

Accepted Answer

A) True 
 B)False

Question 15

Data mining allows users to:

Accepted Answer

A)  quickly compare transaction data gathered over many years.
B)  find hidden relationships in data.
C)  obtain online answers to ad-hoc questions in a rapid amount of time.
D)  summarize massive amounts of data into much smaller,traditional reports.
E)  access the vast amounts of data in a data warehouse.F) None of the above
G) C) and E)

Question 16

In data mining,which of the following involves events linked over time?

Accepted Answer

A)  Associations
B)  Sequences
C)  Classifications
D)  Clustering
E)  ForecastingF) A) and B)
G) C) and D)

Question 17

OLAP is unable to manage and handle queries with very large sets of data.

Accepted Answer

A) True 
 B)False

Question 18

High-speed analytic platforms use both relational and non-relational tools to analyze large datasets.

Accepted Answer

A) True 
 B)False

Question 19

List at least three conditions that contribute to data redundancy and inconsistency.

Accepted Answer

Data redundancy occurs when different di...

Question 20

Which of the following enables you to create a script that allows a web server to communicate with a back-end database?

Accepted Answer

A)  CGI
B)  HTML
C)  Java
D)  SQL
E)  NoSQLF) All of the above
G) B) and E)

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

In-memory computing relies primarily on a computer (RAM)for data storage.

Correct AnswerverifiedShow Answer

In a relational database,a record is referred to in technical terms as a(n) :

Correct AnswerverifiedShow Answer

You can use OLAP to perform multidimensional data analysis.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In data mining,which of the following involves events linked over time?

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

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

Correct AnswerverifiedShow Answer

A schematic of the entire database that describes the relationships in a database is called a(n) :

Correct AnswerverifiedShow Answer

High-speed analytic platforms use both relational and non-relational tools to analyze large datasets.

Correct AnswerverifiedShow Answer

Microsoft SQL Server is a(n) :

Correct AnswerverifiedShow Answer

List at least three conditions that contribute to data redundancy and inconsistency.

Correct AnswerverifiedData redundancy occurs when different di...View AnswerShow Answer

OLAP is unable to manage and handle queries with very large sets of data.

Correct AnswerverifiedShow Answer

Which of the following occurs when the same attribute in related data files has different values?

Correct AnswerverifiedShow Answer

Which of the following best illustrates the relationship between entities and attributes?

Correct AnswerverifiedShow Answer

Which of the following is a grouping of characters into a word,a group of words,or a complete number?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedThe term big data is used to describe da...View AnswerShow Answer

Which of the following is a DBMS for desktop computers?

Correct AnswerverifiedShow Answer

Data mining allows users to:

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

Which of the following enables you to create a script that allows a web server to communicate with a back-end database?

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
Data redundancy occurs when different di...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The term big data is used to describe da...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified