DP Computer Science Questionbank

Outline why data warehousing is time dependent.

Outline one reason why ZCC uses a data warehouse.

Outline why transformation of the data is necessary prior to it being loaded into the data warehouse.

Compare cluster analysis and classification as techniques for discovering patterns in ZCC's data.

Describe how the process of deviation detection can be applied to identify customers who are likely to miss the payment deadline for their purchases from ZCC.

ZCC is aware that other data mining and detection techniques will allow more informed marketing decisions to be made.

Explain how database segmentation and link analysis can be used by ZCC to improve their marketing strategies.

Define a spatial database.

Explain one benefit of database segmentation to the telecommunication company.

Distinguish between the use of association and sequential patterns as data mining techniques.

Explain how ETL processes could be used in data preparation.

Describe how deviation detection could be used to detect fraud at the telecommunications company.

Customers who decide to leave the telecommunication company for a competitor may result in huge losses for the telecommunications company.

Explain with the use of an example, how predictive modelling could be used to optimize information sent to existing customers.

Evaluate the use of an object-oriented database as opposed to a relational database.

Outline two differences between a data warehouse and database.

Outline one ethical problem that may result from data mining.

Explain how cluster analysis can be used to improve the advertising strategy of the tourism companies.

Identify four sources of information that could be incorporated in the data warehouse.

Explain how the Extract, Transform, Load (ETL) processes can be used to address the problems related to data migration.

Explain the importance of link analysis in exploring patterns in data mining.

Explain two advantages of using a relational database rather than an object-oriented database.

State two characteristics of a data warehouse.

Once data has been loaded into a data warehouse it can be mined. The use of data analytics is believed to have been important to the outcome of the US election campaign.

Discuss whether the advantages of data mining techniques in this scenario outweigh the disadvantages.

Outline why data needs to be transformed before it can be loaded into the data warehouse.

Outline why opinion poll data and other election data are timestamped when added to the data warehouse.

Outline why analytics companies use deviation detection.

Outline why analytics companies use link analysis.

Outline why data warehouses tend to use unnormalized data sets.

Outline why data warehousing is time dependent.

Explain why Basking Coats could use association analysis to improve the marketing of its products.

Identify three precautions to be taken before extraction is carried out on the database.

Explain how cluster analysis can be used to achieve the aims of the system that is described above.

Describe how deviation detection can be used to analyse this data.

Basking Coats has decided to use an object-oriented database rather than a relational database to store its data.

Explain why Basking Coats would use an object-oriented database rather than a relational database to store its data.