Question 1

Briefly explain the responsibilities of a database administrator (DBA).

Accepted Answer

Answers will vary. A DBA's responsibilities include the following: 
a. Designing and setting up a database 
b. Establishing security measures to determine users' access rights 
c. Developing recovery procedures in case data is lost or corrupted 
d. Evaluating database performance 
e. Adding and fine-tuning database functions

Question 2

In the context of big data, velocity is _________.

Accepted Answer

A) the speed with which the data has to be gathered and processed 
B) the trustworthiness and accuracy of the data 
C) the value that the collected data brings to the decision-making process 
D) the quantity of transactions, measured in petabytes or exabytes 
A) the speed with which the data has to be gathered and processed 
B) the trustworthiness and accuracy of the data 
C) the value that the collected data brings to the decision-making process 
D) the quantity of transactions, measured in petabytes or exabytes A

Question 3

Data in a database is used for analytical purposes, whereas data in a data warehouse is used for capturing and managing transactions.

Accepted Answer

A) True 
 B)False  False

Question 4

Discuss some examples of sources for external data.

Accepted Answer

Answers will vary. The following are exa

Question 5

_____ can be described as using an organization's database of customers and potential customers in order to promote products or services that an organization offers.

Accepted Answer

A) Database mining 
B) Database marketing 
C) Data encapsulation 
D) Data normalization 
A) Database mining 
B) Database marketing 
C) Data encapsulation 
D) Data normalization

Question 6

Explain key features and uses of Tableau in the context of business intelligence and data visualization.

Accepted Answer

Answers will vary. Tableau is a data vis

Question 7

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 8

Tableau can utilize data from various sources including data files, relational databases, and big data sources.

Accepted Answer

A) True 
 B)False

Question 9

Which is a key factor that has contributed to the growth and popularity of big data?

Accepted Answer

A) Implosion in data growth 
B) Brick and mortar businesses 
C) Mobile and wireless technology 
D) Exponential decay of organizational data 
A) Implosion in data growth 
B) Brick and mortar businesses 
C) Mobile and wireless technology 
D) Exponential decay of organizational data

Question 10

In a(n)_____, each record can have multiple parent and child records.

Accepted Answer

A) network model 
B) hierarchical model 
C) object-oriented model 
D) relational model 
A) network model 
B) hierarchical model 
C) object-oriented model 
D) relational model

Question 11

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

Accepted Answer

Answers will vary. There are several typ

Question 12

Advertising and marketing analytics, in-app analytics, and performance analytics are three popular types of ________ analytics.

Accepted Answer

A) data 
B) prescriptive 
C) Web 
D) mobile 
A) data 
B) prescriptive 
C) Web 
D) mobile

Question 13

Which approach to set up a distributed database management system (DDBMS)combines the fragmentation approach and the replication approach?

Accepted Answer

A) optimization 
B) allocation 
C) encapsulation 
D) normalization 
A) optimization 
B) allocation 
C) encapsulation 
D) normalization

Question 14

In a(n)_____ , records in files are organized and processed in numerical order.

Accepted Answer

A) sequential access file structure 
B) random access file structure 
C) indexed access file structure 
D) direct access file structure 
A) sequential access file structure 
B) random access file structure 
C) indexed access file structure 
D) direct access file structure

Question 15

In a relational database model, the rows are called _____.

Accepted Answer

A) tuples 
B) attributes 
C) branches 
D) roots 
A) tuples 
B) attributes 
C) branches 
D) roots

Question 16

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 operator 
A) NOT operator 
B) AND operator 
C) OR operator 
D) NOR operator

Question 17

Apache Hadoop is the most commonly used platform for big data analytics.

Accepted Answer

A) True 
 B)False

Question 18

In data warehouses, _____ is information about data-its content, quality, condition, origin, and other characteristics.

Accepted Answer

A) metadata 
B) big data 
C) summary data 
D) raw data 
A) metadata 
B) big data 
C) summary data 
D) raw data

Question 19

Which of the following is not an advantage that data marts have over data warehouses?

Accepted Answer

A) Access to data is often faster because of their smaller size. 
B) They are less expensive. 
C) Response time for users is improved. 
D) They are larger and often more complex. 
A) Access to data is often faster because of their smaller size. 
B) They are less expensive. 
C) Response time for users is improved. 
D) They are larger and often more complex.

Question 20

Which of the following are two popular data visualization platforms?

Accepted Answer

A) Excel and PowerPoint 
B) Apache and Cassandra 
C) OLTP and OLAP 
D) Power BI and Tableau 
A) Excel and PowerPoint 
B) Apache and Cassandra 
C) OLTP and OLAP 
D) Power BI and Tableau

Briefly explain the responsibilities of a database administrator (DBA).

In the context of big data, velocity is _________.

Data in a database is used for analytical purposes, whereas data in a data warehouse is used for capturing and managing transactions.

Discuss some examples of sources for external data.

_____ can be described as using an organization's database of customers and potential customers in order to promote products or services that an organization offers.

Explain key features and uses of Tableau in the context of business intelligence and data visualization.

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

Tableau can utilize data from various sources including data files, relational databases, and big data sources.

Which is a key factor that has contributed to the growth and popularity of big data?

In a(n)_____, each record can have multiple parent and child records.

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

Advertising and marketing analytics, in-app analytics, and performance analytics are three popular types of ________ analytics.

Which approach to set up a distributed database management system (DDBMS)combines the fragmentation approach and the replication approach?

In a(n)_____ , records in files are organized and processed in numerical order.

In a relational database model, the rows are called _____.

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.

Apache Hadoop is the most commonly used platform for big data analytics.

In data warehouses, _____ is information about data-its content, quality, condition, origin, and other characteristics.

Which of the following is not an advantage that data marts have over data warehouses?

Which of the following are two popular data visualization platforms?

Information Systems in Business

Computers and Their Business Applications

Personal, Legal, Ethical, and Organizational Issues

Protecting Information Resources

Data Communication: Delivering Information Anywhere and Anytime

A Connected World

E-Commerce

Global Information Systems

Building Successful Information Systems

Enterprise Systems

Supporting Decisions and Processes

Artificial Intelligence and Automation

Emerging Trends, Technologies, and Applications

Filters

Exam 3: Data and Business Intelligence

Briefly explain the responsibilities of a database administrator (DBA).

In the context of big data, velocity is _________.

Data in a database is used for analytical purposes, whereas data in a data warehouse is used for capturing and managing transactions.

Discuss some examples of sources for external data.

_____ can be described as using an organization's database of customers and potential customers in order to promote products or services that an organization offers.

Explain key features and uses of Tableau in the context of business intelligence and data visualization.

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

Tableau can utilize data from various sources including data files, relational databases, and big data sources.

Which is a key factor that has contributed to the growth and popularity of big data?

In a(n)_____, each record can have multiple parent and child records.

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

Advertising and marketing analytics, in-app analytics, and performance analytics are three popular types of ________ analytics.

Which approach to set up a distributed database management system (DDBMS)combines the fragmentation approach and the replication approach?

In a(n)_____ , records in files are organized and processed in numerical order.

In a relational database model, the rows are called _____.

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.

Apache Hadoop is the most commonly used platform for big data analytics.

In data warehouses, _____ is information about data-its content, quality, condition, origin, and other characteristics.

Which of the following is not an advantage that data marts have over data warehouses?

Which of the following are two popular data visualization platforms?

Information Systems in Business

Computers and Their Business Applications

Personal, Legal, Ethical, and Organizational Issues

Protecting Information Resources

Data Communication: Delivering Information Anywhere and Anytime

A Connected World

E-Commerce

Global Information Systems

Building Successful Information Systems

Enterprise Systems

Supporting Decisions and Processes

Artificial Intelligence and Automation

Emerging Trends, Technologies, and Applications

Filters