DAWIT

You work for a retail clothing chain whose primary outlets are in shopping malls, and you are conducting an analysis of your customers and their preferences. You wish to find out if there are any particular activities that your customers engage in, or the types of purchases made in the month before or after purchasing select items from your store. To do this, you will want to use data mining software that is capable of

• Identifying associations

• Identifying clusters

• Identifying sequences

• Classification

ou work for a national car rental agency and want to determine what characteristics are shared among your most loyal customers. To do this, you will want to use data mining software that is capable of

• Identifying associations

• Identifying clusters

• Identifying sequences

• Classification

A DBMS makes the

• 1. physical database available for different logical views.

• 1. logical database available for different analytical views.

• 1. physical database available for different analytical views.

• logical database available for different physical views.

A data warehouse is composed of

• historical data from legacy systems

• current data

• internal and external data

• historic and current internal data

A nationwide magazine publisher has hired you to help analyze their social media datasets to determine which of their news publications are seen as the most trustworthy. Which of the following tools would you use to analyze this data?

• text mining tools

• sentiment analysis software

• web usage mining technologies

• data mining software for identifying associations

Data mining is a tool for allowing users to

• Quickly compare transaction data gathered over many years

• Find hidden relationships in data

• Obtain answer to ad-hoc questions in a rapid amount of time

• Summarize massive amounts of data into much smaller, traditional reports

Answer explanation

Data cleansing not only corrects errors but also

• Establishes logical relationships between data

• Structures data

• Normalizes

• Enforces consistency among different sets data

The special organizational function whose responsibilities include physical database design and maintenance, is called

• data adminsitration

• database administration

• information policy administration

• data auditing

You have been hired by a worldwide non-profit agency to implement a system to handle their donations. The system must be able to handle and record telephone, sms, and Internet donations, provide up-to-the-minute reports, and create highly customizable mailing lists. In addition, event fundraisers need to be able to quickly access a donor's information and history. Which of the following systems will best meet these needs?

• TPS

• TPS with DSS capabilities

• TPS with MIS capabilities

• TPS with ESS capabilities

The score of students in a subject is inserted in B2 cell and the passing score for the subject is 60. Which of these functions will you insert in C2 cell to check if the student has passed or failed?

• =IF(B2>=60, "Pass", "Fail")

• =OR(B2>=60, "Pass", "Fail")

• =AND(B2>=60, "Pass", "Fail")

• =NOT(OR((B2>=60, "Pass", "Fail"))