Question 1

The _____ method for accessing files is effective when a large number of records are processed less frequently, perhaps on a quarterly or yearly basis.

Accepted Answer

A)  sequential access file structure
B)  random access file structure
C)  indexed sequential access
D)  physical view accessE) C) and D)
F) A) and B)

Question 2

The use of the OR operator in a query form, when using query by example (QBE), means that all conditions must be met.

Accepted Answer

A) True 
 B)False

Question 3

Briefly explain the role of business analytics (BA)in decision making and compare it to business intelligence (BI).

Accepted Answer

Answers will vary. BA uses data and stat...

Question 4

Consolidating information from different departments or functional areas is easier in data marts than in data warehouses.

Accepted Answer

A) True 
 B)False

Question 5

In a relational database model, a _____ is a field in a relational table that matches the primary key column of another table.

Accepted Answer

A)  secondary key
B)  foreign key
C)  serial key
D)  domain keyE) A) and D)
F) B) and D)

Question 6

Discuss the advantages of a database over a flat file system.

Accepted Answer

Answers will vary. A database has the fo...

Question 7

In the context of the data administration component of a database management system (DBMS) , the acronym CRUD stands for _____.

Accepted Answer

A)  create, read, update, and delete
B)  copy, revise, undo, and define
C)  create, repeat, undo, and develop
D)  copy, read, update, and defineE) None of the above
F) A) and B)

Question 8

In a relational database model, which operation pares down a table by eliminating columns according to certain criteria?

Accepted Answer

A)  project operation
B)  join operation
C)  find operation
D)  insert operationE) B) and D)
F) A) and B)

Question 9

In the context of business analytics, prescriptive analytics recommends a precise course of action that a decision maker should follow and shows the likely outcome of each decision.

Accepted Answer

A) True 
 B)False

Question 10

_____ is a component of a data model that defines the boundaries of a database, such as maximum and minimum values allowed for a field, constraints, and access methods.

Accepted Answer

A)  Data structure
B)  Schema diagrams
C)  Integrity rules
D)  File procedureE) A) and C)
F) A) and B)

Question 11

Unlike data in databases, data in data warehouses is:

Accepted Answer

A)  function oriented.
B)  raw transaction data.
C)  collected from a single source.
D)  used for analytical purposes.E) A) and B)
F) B) and D)

Question 12

Database marketing works by using multivariate analysis, data segmentation, and automated tools to transform marketing from a proactive to a reactive process.

Accepted Answer

A) True 
 B)False

Question 13

A _____  converts logical requests from users into their physical equivalents by interacting with other components of the database management system (DBMS) .

Accepted Answer

A)  database engine
B)  data-driven site
C)  static site
D)  database mineE) A) and B)
F) A) and C)

Question 14

List and describe the features of data in a data warehouse in contrast to data in a database.

Accepted Answer

Answers will vary. Data in a data wareho...

Question 15

Conventional computing methods are able to efficiently process and manage big data.

Accepted Answer

A) True 
 B)False

Question 16

For each database, there:

Accepted Answer

A)  is only one physical view of data.
B)  are only two logical views of data.
C)  are multiple physical views of data.
D)  is only one logical view of data.E) None of the above
F) All of the above

Question 17

Which statement is true of big data?

Accepted Answer

A)  It eliminates unethical actions based on interpretations.
B)  It can be efficiently processed and managed by conventional computing methods.
C)  It has three dimensions, which are value, density, and uniformity.
D)  It is the result of the exponential growth of data in both public and private organizations.E) A) and D)
F) C) and D)

Question 18

_____  tools are capable of "drilling up," proceeding from the smallest unit of data to higher levels.

Accepted Answer

A)  Online analytical processing
B)  Online transaction processing
C)  Extraction, transformation, and loading
D)  Business analyticsE) None of the above
F) B) and D)

Question 19

In comparison with flat file systems, databases:

Accepted Answer

A)  minimize data redundancy.
B)  are easier to design.
C)  have less sophisticated security measures.
D)  require more storage space.E) A) and B)
F) A) and C)

Question 20

The _____ dimension of big data refers to the sheer quantity of transactions, measured in petabytes or exabytes.

Accepted Answer

A)  velocity
B)  volume
C)  area
D)  timeE) All of the above
F) B) and D)

Exam 3: Data and Business Intelligence

For each database, there:

Correct AnswerverifiedShow Answer

Briefly explain the role of business analytics (BA)in decision making and compare it to business intelligence (BI).

Correct AnswerverifiedAnswers will vary. BA uses data and stat...View AnswerShow Answer

List and describe the features of data in a data warehouse in contrast to data in a database.

Correct AnswerverifiedAnswers will vary. Data in a data wareho...View AnswerShow Answer

In the context of the data administration component of a database management system (DBMS) , the acronym CRUD stands for _____.

Correct AnswerverifiedShow Answer

The use of the OR operator in a query form, when using query by example (QBE), means that all conditions must be met.

Correct AnswerverifiedShow Answer

_____ tools are capable of "drilling up," proceeding from the smallest unit of data to higher levels.

Correct AnswerverifiedShow Answer

Consolidating information from different departments or functional areas is easier in data marts than in data warehouses.

Correct AnswerverifiedShow Answer

The _____ dimension of big data refers to the sheer quantity of transactions, measured in petabytes or exabytes.

Correct AnswerverifiedShow Answer

Database marketing works by using multivariate analysis, data segmentation, and automated tools to transform marketing from a proactive to a reactive process.

Correct AnswerverifiedShow Answer

Discuss the advantages of a database over a flat file system.

Correct AnswerverifiedAnswers will vary. A database has the fo...View AnswerShow Answer

In comparison with flat file systems, databases:

Correct AnswerverifiedShow Answer

The _____ method for accessing files is effective when a large number of records are processed less frequently, perhaps on a quarterly or yearly basis.

Correct AnswerverifiedShow Answer

Which statement is true of big data?

Correct AnswerverifiedShow Answer

Unlike data in databases, data in data warehouses is:

Correct AnswerverifiedShow Answer

In a relational database model, a _____ is a field in a relational table that matches the primary key column of another table.

Correct AnswerverifiedShow Answer

A _____ converts logical requests from users into their physical equivalents by interacting with other components of the database management system (DBMS) .

Correct AnswerverifiedShow Answer

In a relational database model, which operation pares down a table by eliminating columns according to certain criteria?

Correct AnswerverifiedShow Answer

In the context of business analytics, prescriptive analytics recommends a precise course of action that a decision maker should follow and shows the likely outcome of each decision.

Correct AnswerverifiedShow Answer

Conventional computing methods are able to efficiently process and manage big data.

Correct AnswerverifiedShow Answer

_____ is a component of a data model that defines the boundaries of a database, such as maximum and minimum values allowed for a field, constraints, and access methods.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
Answers will vary. BA uses data and stat...
View Answer

Correct Answer
verified
Answers will vary. Data in a data wareho...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Answers will vary. A database has the fo...
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