WPC 300 Exam 1 ACTUAL QUESTIONS
AND CORRECT ANSWERS
Anchoring bias - CORRECT ANSWER Over-reliant on the first piece of information is called
Gamblers' fallacy is ____________. - CORRECT ANSWER a clustering illusion
Which of the following is an example of secondary data? - CORRECT ANSWER Firm's
proprietary data
In an agile approach of analytics what is the first step of the process? - CORRECT ANSWER
perform business discovery
Predictive analytics may be applied to __________, which is a set of techniques that use descriptive
data and forecasts to identify the decisions most likely to result in the best performance. - CORRECT
ANSWER Prescriptive analytics
Which of the following data analytics model use optimization techniques? - CORRECT ANSWER
Prescriptive analytics
Which of the following statements is true? - CORRECT ANSWER Experimentation is a way
of analytical thinking
When you keep eating the food you don't like precisely because you already bought the food, you are
committing _____________. - CORRECT ANSWER sunk-cost fallacy
What are the four types of data analytical method? - CORRECT ANSWER Descriptive,
explanatory, predictive and prescriptive
In an ETL process, data is loaded into a final target database such as: - CORRECT ANSWER
Data warehouse
, _______ ensures that related data exist in parent table before allowing an entry into a child table. -
CORRECT ANSWER Referential integrity
Which of the following is not a component of the relational database? - CORRECT ANSWER
Analysis
The SQL code to extract only first_name information for all records of the "Actor" table below is: -
CORRECT ANSWER SELECT first_name FROM Actor;
When you are asked to design a database for the airline ticket reservation system, based on an Entity-
Relationship Data model, which of the following could be an example of "entity"? - CORRECT
ANSWER Traveler
Which of the following tools help in periodic managerial decision-making? - CORRECT ANSWER
OLAP
You are creating a database to store temperature and wind data from various airport. Which of the
following fields is the most likely candidate to use as the basis for a Primary Key in the Airport
Table? - CORRECT ANSWER Airport Code
"Google Doc" is an example of _______ in a could computing environment. - CORRECT ANSWER
SaaS
Which of the following is an important task of a database management system? - CORRECT
ANSWER Provides support such as performing maintenance and routine backups.
When you access information from two different tables connected by an identifier key, the SQL
keyword you should use is _______. - CORRECT ANSWER INNER JOIN
Which of the following is a cloud service provider? - CORRECT ANSWER VMWare
Which of the following statement(s) is (are) true about Excel functions? - CORRECT ANSWER
strings can be added
numbers can be summed
AND CORRECT ANSWERS
Anchoring bias - CORRECT ANSWER Over-reliant on the first piece of information is called
Gamblers' fallacy is ____________. - CORRECT ANSWER a clustering illusion
Which of the following is an example of secondary data? - CORRECT ANSWER Firm's
proprietary data
In an agile approach of analytics what is the first step of the process? - CORRECT ANSWER
perform business discovery
Predictive analytics may be applied to __________, which is a set of techniques that use descriptive
data and forecasts to identify the decisions most likely to result in the best performance. - CORRECT
ANSWER Prescriptive analytics
Which of the following data analytics model use optimization techniques? - CORRECT ANSWER
Prescriptive analytics
Which of the following statements is true? - CORRECT ANSWER Experimentation is a way
of analytical thinking
When you keep eating the food you don't like precisely because you already bought the food, you are
committing _____________. - CORRECT ANSWER sunk-cost fallacy
What are the four types of data analytical method? - CORRECT ANSWER Descriptive,
explanatory, predictive and prescriptive
In an ETL process, data is loaded into a final target database such as: - CORRECT ANSWER
Data warehouse
, _______ ensures that related data exist in parent table before allowing an entry into a child table. -
CORRECT ANSWER Referential integrity
Which of the following is not a component of the relational database? - CORRECT ANSWER
Analysis
The SQL code to extract only first_name information for all records of the "Actor" table below is: -
CORRECT ANSWER SELECT first_name FROM Actor;
When you are asked to design a database for the airline ticket reservation system, based on an Entity-
Relationship Data model, which of the following could be an example of "entity"? - CORRECT
ANSWER Traveler
Which of the following tools help in periodic managerial decision-making? - CORRECT ANSWER
OLAP
You are creating a database to store temperature and wind data from various airport. Which of the
following fields is the most likely candidate to use as the basis for a Primary Key in the Airport
Table? - CORRECT ANSWER Airport Code
"Google Doc" is an example of _______ in a could computing environment. - CORRECT ANSWER
SaaS
Which of the following is an important task of a database management system? - CORRECT
ANSWER Provides support such as performing maintenance and routine backups.
When you access information from two different tables connected by an identifier key, the SQL
keyword you should use is _______. - CORRECT ANSWER INNER JOIN
Which of the following is a cloud service provider? - CORRECT ANSWER VMWare
Which of the following statement(s) is (are) true about Excel functions? - CORRECT ANSWER
strings can be added
numbers can be summed
