Question 1

In a relational database model, which operation searches data in a table and retrieves records based on certain criteria?

Accepted Answer

A) insert operation 
B) join operation 
C) find operation 
D) select operation 
A) insert operation 
B) join operation 
C) find operation 
D) select operation

Question 2

In large organizations, database design and management is handled by a database  _____ .

Accepted Answer

A) developer 
B) evaluator 
C) synchronizer 
D) administrator 
A) developer 
B) evaluator 
C) synchronizer 
D) administrator

Question 3

A database is a critical component of information systems because any type of analysis that is done is based on data available in the database.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is considered a unique feature of Tableau?

Accepted Answer

A) Translating coded values, such as replacing Yes with 1 
B) In-depth insights and "what-if" analysis 
C) Encapsulation 
D) Allocation 
A) Translating coded values, such as replacing Yes with 1 
B) In-depth insights and "what-if" analysis 
C) Encapsulation 
D) Allocation

Question 5

The Power BI platform's major components include:

Accepted Answer

A) An online SaaS (software as a service) 
B) Tableau Server 
C) Microsoft Access 
D) SAS Big Data Analytics 
A) An online SaaS (software as a service) 
B) Tableau Server 
C) Microsoft Access 
D) SAS Big Data Analytics

Question 6

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

Accepted Answer

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

Question 7

The earliest users of automated marketing tools included credit bureaus and mail-order catalog companies.

Accepted Answer

A) True 
 B)False

Question 8

In a data warehouse, _____ is the process of collecting data from a variety of sources and converting it into a format that can be used in transformation processing.

Accepted Answer

A) extraction 
B) transformation 
C) optimization 
D) aggregation 
A) extraction 
B) transformation 
C) optimization 
D) aggregation

Question 9

Describe the fragmentation approach to setting up a distributed database management system (DDBMS).

Accepted Answer

Answers will vary. The fragmentation app

Question 10

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. 
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.

Question 11

The variety dimension of big data refers to the combination of _____.

Accepted Answer

A) data warehouses and data marts 
B) object-oriented data models and relational data models 
C) structured data and unstructured data 
D) data definition and data manipulation 
A) data warehouses and data marts 
B) object-oriented data models and relational data models 
C) structured data and unstructured data 
D) data definition and data manipulation

Question 12

With the indexed sequential access method (ISAM), records cannot be accessed randomly.

Accepted Answer

A) True 
 B)False

Question 13

Tableau and Power BI are best described as ____________.

Accepted Answer

A) Data marts 
B) Data warehouses 
C) Data visualization tools 
D) Data-driven Web sites 
A) Data marts 
B) Data warehouses 
C) Data visualization tools 
D) Data-driven Web sites

Question 14

Data marts usually have more limited scope than data warehouses, and consolidating information from different departments is more difficult.

Accepted Answer

A) True 
 B)False

Question 15

Describe the tasks performed in the first normal form (1NF)stage of normalization to improve database efficiency.

Accepted Answer

Answers will vary. To improve database e

Question 16

Describe how data stored in a relational model is retrieved from tables.

Accepted Answer

Answers will vary. Data stored in a rela

Question 17

The _____ view  of a database involves how information appears to users and how it can be organized and retrieved.

Accepted Answer

A) rational 
B) physical 
C) logical 
D) analytical 
A) rational 
B) physical 
C) logical 
D) analytical

Question 18

Discuss why an organization might choose a distributed database.

Accepted Answer

Answers will vary. A distributed databas

Question 19

The _____ stores data types for fields, default values for fields, and validation rules for data in each field.

Accepted Answer

A) data dictionary 
B) data mine 
C) data warehouse 
D) data mart 
A) data dictionary 
B) data mine 
C) data warehouse 
D) data mart

Question 20

Which statement is true of a flat file system?

Accepted Answer

A) Same data can be stored in more than one file. 
B) Programs and data are independent. 
C) Complex requests can be handled easily. 
D) It requires very less storage space. 
A) Same data can be stored in more than one file. 
B) Programs and data are independent. 
C) Complex requests can be handled easily. 
D) It requires very less storage space.

In a relational database model, which operation searches data in a table and retrieves records based on certain criteria?

In large organizations, database design and management is handled by a database _____ .

A database is a critical component of information systems because any type of analysis that is done is based on data available in the database.

Which of the following is considered a unique feature of Tableau?

The Power BI platform's major components include:

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

The earliest users of automated marketing tools included credit bureaus and mail-order catalog companies.

In a data warehouse, _____ is the process of collecting data from a variety of sources and converting it into a format that can be used in transformation processing.

Describe the fragmentation approach to setting up a distributed database management system (DDBMS).

Which statement is true of data marts and data warehouses?

The variety dimension of big data refers to the combination of _____.

With the indexed sequential access method (ISAM), records cannot be accessed randomly.

Tableau and Power BI are best described as ____________.

Data marts usually have more limited scope than data warehouses, and consolidating information from different departments is more difficult.

Describe the tasks performed in the first normal form (1NF)stage of normalization to improve database efficiency.

Describe how data stored in a relational model is retrieved from tables.

The _____ view of a database involves how information appears to users and how it can be organized and retrieved.

Discuss why an organization might choose a distributed database.

The _____ stores data types for fields, default values for fields, and validation rules for data in each field.

Which statement is true of a flat file system?

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

In a relational database model, which operation searches data in a table and retrieves records based on certain criteria?

In large organizations, database design and management is handled by a database _____ .

A database is a critical component of information systems because any type of analysis that is done is based on data available in the database.

Which of the following is considered a unique feature of Tableau?

The Power BI platform's major components include:

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

The earliest users of automated marketing tools included credit bureaus and mail-order catalog companies.

In a data warehouse, _____ is the process of collecting data from a variety of sources and converting it into a format that can be used in transformation processing.

Describe the fragmentation approach to setting up a distributed database management system (DDBMS).

Which statement is true of data marts and data warehouses?

The variety dimension of big data refers to the combination of _____.

With the indexed sequential access method (ISAM), records cannot be accessed randomly.

Tableau and Power BI are best described as ____________.

Data marts usually have more limited scope than data warehouses, and consolidating information from different departments is more difficult.

Describe the tasks performed in the first normal form (1NF)stage of normalization to improve database efficiency.

Describe how data stored in a relational model is retrieved from tables.

The _____ view of a database involves how information appears to users and how it can be organized and retrieved.

Discuss why an organization might choose a distributed database.

The _____ stores data types for fields, default values for fields, and validation rules for data in each field.

Which statement is true of a flat file system?

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