Homework 6

1.Which of the following tasks cannot be performed in a Pivot Table?

a.

b. Validate Data

c.

d.

2.What is the best slice and dice technique use to do the following: Display the average salaries by position for all teams or an individual team from excel table of professional baseball player data considering of team name, player name, position, and salary.

a. Create a crosstab using MIN function?

b. Create a crosstab using SUM function

c. Create a crosstab using the AVG function

d. Create a crosstab using the MAX function

3.If you sort table data from the most recent purchase to the oldest purchase date, in what order have you sorted?

b. descending order

4.Jan is entering hundreds of temperature values into a excel worksheet for a climate research project, and she wants to save time on data entry by leaving freezing point values as blanks rather than typing zeros. Will this cause complication if she later tries to calculate an average temperature from her data values?

b. Yes because she does want to include zero temperatures in her answer

5.Which of the following statements about OLTP (transactional) and OLAP (analytical) systems is correct?

b. Systems performance is an extremely important issue in OLTP systems, but not as important in OLAP systems

6.Multi-dimesensional analysis tools include slice and dice techniques that allow you to view multidimensional information from different perspective.

TRUE

7.If you were working for a large pharmaceutical company and building a sales report on the current prescription writing habits of doctors, what type of information repository would you be most likely working with?

c. Data Mart

8.What type of formula would be best suited calculating a percentage?c. Division

9.Which of the following is a typical decision made primarily by using data in OLAP (analytical) systems versus data from OLTP (transactional) systems?

Trying to decide if a new product line is to be marketed.

Deciding to expand the production facilities of the company.

Determining from which universities the company should recruit potential employees.

All of the above.

None of the above.

d. None of the above

10.A senior manager who analyzes internal and external information to analyze marketing campaigns and their effect on customer buying habits is using which type of application?

a. Online Analytical Processing (OLAP)

11.A list of college students includes a code to indicate the students gender (male or female) and a field to identify the students major. Would you use a filter or pivot table to create a list of all females majoring in history?

a. filter

b. pivot table

12.Data warehouse do not support transactional processing. TRUE

13. Data warehouse exists to support

a. Online transaction processing (OLTP)

b. Online analytical processing (OLAP)

c. Relational database administration

d. Records management

14.Whta would be the result of =AVERAGE (A1:A3), if A1=10, A2=20, and A3=30?

a.20

b.30

c.15

d.40

15.Orco Corp would like to determine advertising strategies for customer who buy high-priced priced products. It would be using OLTP on its data warehouse to accomplish this task. (T/F)

16.Alsit of college students includes a code to indicate the students gender 9male/female) and a field to identify the students major. Would you use a filter or pivot table to count the number of males and females in each major?

a. filter

b. pivot table

17.What is the best slice and dice technique to use to do the following: Display a list of Economic majors with a GPA less than 2.5 from excel table with records for 1000 students.

a. filter

b. pivot table

18.There is a need for two major different information systems, one an OLTP (transactional) system and the other an OLAP (analytical) system because

a. The performance of the OLAP system is degraded if all the data was stored there

b. The performance of the OLAP system is degraded if none of the data was stored there

c. The performance of the OLTP system is degraded if all the data was stored there

d. The performance of the OLTP system is degraded if none of the data was stored there

19.What would be the result of =MAX(A1,B2,C1,C2), if A1=10, B2=20,C1=10,and C2=30?

a.30

b.15

c.40

d.5

20.Which of the following is a typical decision made primarily by using data in an OLTP (transactional) system versus data from an OLAP (analytical) system?

a. To control and run processes

b. Smaller due to existence of aggregation structures

c. Typically very slow

d. None of the above