Question 1

Tableau and Power BI are best described as ____________.

Accepted Answer

A)  Data marts
B)  Data warehouses
C)  Data visualization tools
D)  Data-driven Web sitesE) A) and B)
F) None of the above

Question 2

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

Question 3

Discuss why an organization might choose a distributed database.

Accepted Answer

Answers will vary. A distributed databas...

Question 4

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

Accepted Answer

Answers will vary. The fragmentation app...

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

Question 6

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

Accepted Answer

A)  attributes
B)  tuples
C)  branches
D)  rootsE) All of the above
F) None of the above

Question 7

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

Question 8

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

Question 9

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

Accepted Answer

A)  developer
B)  evaluator
C)  synchronizer
D)  administratorE) A) and B)
F) A) and C)

Question 10

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

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 15

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

Question 16

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 17

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

Accepted Answer

Answers will vary. Data stored in a rela...

Question 18

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)  analyticalE) A) and D)
F) None of the above

Question 19

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 20

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

Exam 3: Data and Business Intelligence

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedAnswers will vary. The fragmentation app...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

The Power BI platform's major components include:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Tableau and Power BI are best described as ____________.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedAnswers will vary. To improve database e...View AnswerShow Answer

Which statement is true of data marts and data warehouses?

Correct AnswerverifiedShow Answer

Which statement is true of a flat file system?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Discuss why an organization might choose a distributed database.

Correct AnswerverifiedAnswers will vary. A distributed databas...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedAnswers will vary. Data stored in a rela...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
Answers will vary. The fragmentation app...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Answers will vary. To improve database e...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Answers will vary. A distributed databas...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Answers will vary. Data stored in a rela...
View Answer

Correct Answer
verified

Correct Answer
verified