Question 1

A content editor is the person responsible for updating and maintaining website content.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following is the common term for the representation of multidimensional information?

Accepted Answer

A)  Block
B)  Square
C)  Column
D)  CubeE) All of the above
F) A) and B)

Question 3

Which of the following is a problem associated with dirty data?

Accepted Answer

A)  Accurate data
B)  Integrated data
C)  Violates business rules
D)  All of the aboveE) B) and D)
F) A) and B)

Question 4

What is the term for the time it takes for data to be stored or retrieved?

Accepted Answer

A)  Data governance.
B)  Data latency.
C)  Data validation.
D)  Data gap analysis.E) A) and D)
F) None of the above

Question 5

What is a data steward responsible for?

Accepted Answer

A)  Acting as a liaison between the MIS department and the business.
B)  Ensuring policies and procedures are implemented across the organization.
C)  Both acting as a liaison between the MIS department and the business and ensuring policies and procedures are implemented across the organization.
D)  None of the above.E) A) and B)
F) All of the above

Question 6

Organizational information has three characteristics including timeliness, quality, and governance.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following would not be considered part of the timely characteristic of high-quality information?

Accepted Answer

A)  Is the zip code missing in the address?
B)  Is the information current with respect to business needs?
C)  Is the customer address current?
D)  Is the information updated weekly or hourly?E) A) and B)
F) A) and C)

Question 8

Which of the following statements is true?

Accepted Answer

A)  The more complete an organization wants to get its information, the less it costs.
B)  The more accurate an organization wants to get its information, the less it costs.
C)  The less accurate an organization wants to get its information, the more it costs.
D)  The more complete and accurate an organization wants to get its information, the more it costs.E) A) and C)
F) C) and D)

Question 9

Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business is now?

Accepted Answer

A)  A historical perspective offers important variables for determining trends and patterns.
B)  Looking at the current business situation allows managers to take effective action to solve issues before they grow out of control.
C)  Setting strategic direction is critical for planning and creating solid business strategies.
D)  None of the above.E) None of the above
F) B) and D)

Question 10

What is data stewardship?

Accepted Answer

A)  The time it takes for data to be stored or retrieved.
B)  The management and oversight of an organization's data assets.
C)  The person responsible for ensuring policies and procedures are implemented across the organization.
D)  When a company examines its data to determine if it can meet business expectations, while identifying possible data gaps.E) None of the above
F) B) and C)

Question 11

In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?

Accepted Answer

A)  Entity
B)  Relationships
C)  Attribute
D)  Foreign KeyE) All of the above
F) A) and B)

Question 12

Why do relational databases use primary keys and foreign keys?

Accepted Answer

A)  To create an entity
B)  To create physical relationships
C)  To create logical relationships
D)  To create an attributeE) A) and B)
F) B) and D)

Question 13

The four primary traits of the value of information include type, timeliness, quality, and governance.

Accepted Answer

A) True 
 B)False

Question 14

Kassandra Young is a business manager at Weith Productions. Although she does not have a background in technology, her job requires her to work with analytical tools to make data-driven decisions. To make her job easier, what can she customize to display data quickly and run custom reports?

Accepted Answer

A)  Data point
B)  Information cleansing
C)  Dashboard
D)  Data setE) None of the above
F) A) and D)

Question 15

What are the two main objectives associated with data mining?

Accepted Answer

A)  Uncovering tactics and plans
B)  Uncovering trends and patterns
C)  Uncovering intelligence and unstructured data issues
D)  Uncovering competitors and market advantagesE) B) and D)
F) A) and C)

Question 16

A data-driven website can help limit the amount of information displayed to customers based on unique search requirements.

Accepted Answer

A) True 
 B)False

Question 17

What is immediate, up-to-date information?

Accepted Answer

A)  Real-time information
B)  Real-time systems
C)  Information granularity
D)  Information governanceE) A) and B)
F) A) and C)

Question 18

Business analysis is difficult from operational databases. Which of the following is a reason why?

Accepted Answer

A)  Every department has its own method for recording data.
B)  Lack of data standards across departments.
C)  The data, if available, were often incorrect or incomplete.
D)  All of the above.E) B) and D)
F) A) and B)

Question 19

What is the primary difference between an entity and an attribute?

Accepted Answer

A)  An attribute is a table, an entity is a column from the attribute table
B)  An entity is specific, where as an attribute is not data at all but brainstorming ideas that take place before the entity is created
C)  An attribute refers to applications, and an entity refers to executives
D)  An entity is a table that stores information about people, places, or events, where as an attribute is a column or specific field of the data elements associated with an entityE) All of the above
F) A) and B)

Question 20

What is big data?

Accepted Answer

A)  A collection of large, complex data sets, including structured and unstructured data, which cannot be analyzed using traditional database methods and tools.
B)  Processes and manages algorithms across many machines in a computing environment.
C)  Focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization.
D)  Extracts knowledge from data by performing statistical analysis, data mining, and advanced analytics on big data to identify trends, market changes, and other relevant information.E) B) and C)
F) A) and B)

Exam 6: Data: Business Intelligence

What is data stewardship?

Correct AnswerverifiedShow Answer

What is the term for the time it takes for data to be stored or retrieved?

Correct AnswerverifiedShow Answer

Kassandra Young is a business manager at Weith Productions. Although she does not have a background in technology, her job requires her to work with analytical tools to make data-driven decisions. To make her job easier, what can she customize to display data quickly and run custom reports?

Correct AnswerverifiedShow Answer

Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business is now?

Correct AnswerverifiedShow Answer

Which of the following is a problem associated with dirty data?

Correct AnswerverifiedShow Answer

Organizational information has three characteristics including timeliness, quality, and governance.

Correct AnswerverifiedShow Answer

Why do relational databases use primary keys and foreign keys?

Correct AnswerverifiedShow Answer

What is a data steward responsible for?

Correct AnswerverifiedShow Answer

Which of the following is the common term for the representation of multidimensional information?

Correct AnswerverifiedShow Answer

What is big data?

Correct AnswerverifiedShow Answer

Business analysis is difficult from operational databases. Which of the following is a reason why?

Correct AnswerverifiedShow Answer

The four primary traits of the value of information include type, timeliness, quality, and governance.

Correct AnswerverifiedShow Answer

Which of the following would not be considered part of the timely characteristic of high-quality information?

Correct AnswerverifiedShow Answer

A content editor is the person responsible for updating and maintaining website content.

Correct AnswerverifiedShow Answer

In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?

Correct AnswerverifiedShow Answer

A data-driven website can help limit the amount of information displayed to customers based on unique search requirements.

Correct AnswerverifiedShow Answer

Which of the following statements is true?

Correct AnswerverifiedShow Answer

What is the primary difference between an entity and an attribute?

Correct AnswerverifiedShow Answer

What is immediate, up-to-date information?

Correct AnswerverifiedShow Answer

What are the two main objectives associated with data mining?

Correct AnswerverifiedShow 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

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