Question 1

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) B) and C)
F) A) and D)

Question 2

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) B) and C)
F) A) and D)

Question 3

A select operation pares down a table in a relational database by eliminating columns according to certain criteria.

Accepted Answer

A) True 
 B)False

Question 4

Explain how information in a database is observed through the physical view and the logical view.

Accepted Answer

Answers will vary.Before designing a dat...

Question 5

A data _____ is the structure and organization of data,which involves fields,records,and files.

Accepted Answer

A)  mine
B)  mart
C)  warehouse
D)  hierarchyE) C) and D)
F) B) and C)

Question 6

Which statement is true of data marts and data warehouses?

Accepted Answer

A)  Consolidating information from different departments is easier in data marts than in data warehouses.
B)  Data marts have more extended scope than data warehouses.
C)  Access to data is often slower in data marts than in data warehouses.
D)  Data marts usually perform the same types of analysis as data warehouses.E) A) and D)
F) None of the above

Question 7

Although a database can consist of only a single file,it is usually a group of files.

Accepted Answer

A) True 
 B)False

Question 8

Which component of a database management system (DBMS) is used to design elements of an application using a database,such as data entry screens,interactive menus,and interfaces with other programming languages?

Accepted Answer

A)  application generation
B)  application definition
C)  application administration
D)  application manipulationE) A) and D)
F) A) and C)

Question 9

Which file structure is similar to a book index that lists page numbers where certain topics can be found?

Accepted Answer

A)  The indexed sequential access method
B)  The indexed network access structure
C)  The indexed random access file structure
D)  The indexed hierarchical access methodE) C) and D)
F) B) and D)

Question 10

Which component of a data model describes methods and calculations that can be performed on data,such as updating and querying data?

Accepted Answer

A)  Data structure
B)  Operations
C)  Integrity rules
D)  File structureE) All of the above
F) B) and C)

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) None of the above

Question 12

In the context of the operators used in a query by example (QBE) form,the _____ is used when only one of the conditions in the QBE form must be met.

Accepted Answer

A)  NOT operator
B)  AND operator
C)  OR operator
D)  NOR operatorE) B) and D)
F) None of the above

Question 13

Briefly explain a relational model.

Accepted Answer

Answers will vary.A relational model use...

Question 14

The data _____ component of a database management system (DBMS) is used to create and maintain the data dictionary.

Accepted Answer

A)  manipulation
B)  generation
C)  definition
D)  administrationE) C) and D)
F) None of the above

Question 15

A network model is similar to a hierarchical data model because in both data models records are organized in the same way.

Accepted Answer

A) True 
 B)False

Question 16

_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

Accepted Answer

A)  Triangulation
B)  Fragmentation
C)  Normalization
D)  EncapsulationE) B) and D)
F) A) and D)

Question 17

In the context of segmentation of customers in database marketing,_____ is a variable that includes gender,age,income,and marital status.

Accepted Answer

A)  strategical information
B)  geographical information
C)  psychographic information
D)  demographic informationE) All of the above
F) A) and D)

Question 18

Briefly explain the types of business analytics (BA)methods.

Accepted Answer

Answers will vary.There are several types of BA methods.Three popular ones are descriptive,predictive,and prescriptive analytics.Descriptive analytics reviews past events,analyzes the data,and provides a report indicating what happened in a given period and how to prepare for the future.Thus,it is a reactive strategy.Predictive analytics,as the name indicates,is a proactive strategy;it prepares a decision maker for future events.As an example,it might indicate that if a current sales trend continues,a company will need a certain number of salespeople in 2018.Prescriptive analytics goes beyond descriptive and predictive analytics by recommending a course of action that a decision maker should follow and showing the likely outcome of each decision.In another words prescriptive analytics is more specific than predictive analytics by recommending a precise course of action.

Question 19

In the context of the input component of a data warehouse,_____ collect,integrate,and process data that can be used by all functional areas in an organization.

Accepted Answer

A)  online analytical processing systems
B)  online transaction management systems
C)  enterprise resource planning systems
D)  data mining analysis systemsE) A) and B)
F) A) and C) C

Question 20

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 statistical methods to gain insight into the data and provide decision makers with information they can act on.BA is increasingly used for data-driven decision making that leverages and explores the data in a database,data warehouse,or data mart system.Compared to BI,BA is more forward looking;it tells the user what is going to happen in the future rather than what has happened in the past.BI can help determine what happened,what the problem is,and what decisions need to be made based on the available data.BA can help determine why this is happening,what it will mean if the sales trend continues,and what actions should be taken.

Exam 3: Database Systems,Data Warehouses,and Data Marts

For each database,there:

Correct Answer
verified

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

Correct Answer
verified

A select operation pares down a table in a relational database by eliminating columns according to certain criteria.

Correct Answer
verified

Explain how information in a database is observed through the physical view and the logical view.

Correct Answer
verified
Answers will vary.Before designing a dat...
View Answer

A data _____ is the structure and organization of data,which involves fields,records,and files.

Correct Answer
verified

Which statement is true of data marts and data warehouses?

Correct Answer
verified

Although a database can consist of only a single file,it is usually a group of files.

Correct Answer
verified

Which component of a database management system (DBMS) is used to design elements of an application using a database,such as data entry screens,interactive menus,and interfaces with other programming languages?

Correct Answer
verified

Which file structure is similar to a book index that lists page numbers where certain topics can be found?

Correct Answer
verified

Which component of a data model describes methods and calculations that can be performed on data,such as updating and querying data?

Correct Answer
verified

Unlike data in databases,data in data warehouses is:

Correct Answer
verified

In the context of the operators used in a query by example (QBE) form,the _____ is used when only one of the conditions in the QBE form must be met.

Correct Answer
verified

Briefly explain a relational model.

Correct Answer
verified
Answers will vary.A relational model use...
View Answer

The data _____ component of a database management system (DBMS) is used to create and maintain the data dictionary.

Correct Answer
verified

A network model is similar to a hierarchical data model because in both data models records are organized in the same way.

Correct Answer
verified

_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

Correct Answer
verified

In the context of segmentation of customers in database marketing,_____ is a variable that includes gender,age,income,and marital status.

Correct Answer
verified

Briefly explain the types of business analytics (BA)methods.

In the context of the input component of a data warehouse,_____ collect,integrate,and process data that can be used by all functional areas in an organization.

Correct Answer
verified
C

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

Exam 3: Database Systems,Data Warehouses,and Data Marts

For each database,there:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A select operation pares down a table in a relational database by eliminating columns according to certain criteria.

Correct AnswerverifiedShow Answer

Explain how information in a database is observed through the physical view and the logical view.

Correct AnswerverifiedAnswers will vary.Before designing a dat...View AnswerShow Answer

A data _____ is the structure and organization of data,which involves fields,records,and files.

Correct AnswerverifiedShow Answer

Which statement is true of data marts and data warehouses?

Correct AnswerverifiedShow Answer

Although a database can consist of only a single file,it is usually a group of files.

Correct AnswerverifiedShow Answer

Which component of a database management system (DBMS) is used to design elements of an application using a database,such as data entry screens,interactive menus,and interfaces with other programming languages?

Correct AnswerverifiedShow Answer

Which file structure is similar to a book index that lists page numbers where certain topics can be found?

Correct AnswerverifiedShow Answer

Which component of a data model describes methods and calculations that can be performed on data,such as updating and querying data?

Correct AnswerverifiedShow Answer

Unlike data in databases,data in data warehouses is:

Correct AnswerverifiedShow Answer

In the context of the operators used in a query by example (QBE) form,the _____ is used when only one of the conditions in the QBE form must be met.

Correct AnswerverifiedShow Answer

Briefly explain a relational model.

Correct AnswerverifiedAnswers will vary.A relational model use...View AnswerShow Answer

The data _____ component of a database management system (DBMS) is used to create and maintain the data dictionary.

Correct AnswerverifiedShow Answer

A network model is similar to a hierarchical data model because in both data models records are organized in the same way.

Correct AnswerverifiedShow Answer

_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

Correct AnswerverifiedShow Answer

In the context of segmentation of customers in database marketing,_____ is a variable that includes gender,age,income,and marital status.

Correct AnswerverifiedShow Answer

Briefly explain the types of business analytics (BA)methods.

In the context of the input component of a data warehouse,_____ collect,integrate,and process data that can be used by all functional areas in an organization.

Correct AnswerverifiedC

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Answers will vary.Before designing a dat...
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
Answers will vary.A relational model use...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
C