Category Archives: Data Mining Interview Questions

What are the benefits of User-Defined Functions? | Data Mining Questions

a. Can be used in a number of places without restrictions as compared to stored procedures. b. Code can be made less complex and easier to write. c. Parameters can be passed to the function. d. They can be used … Continue reading

Posted in Data Mining Interview Questions | Leave a comment

Describe how DTS is used to extract, transform and consolidate data. | Data Mining Questions

Data Transformation Services is a set of tools available in SQL server that helps to extract, transform and consolidate data. This data can be from different sources into a single or multiple destinations depending on DTS connectivity. To perform such … Continue reading

Posted in Data Mining Interview Questions | Leave a comment

What are the different ways of moving data/databases between servers and databases in SQL Server? | Data Mining Questions

There are several ways of doing this. One can use any of the following options: – BACKUP/RESTORE, – Dettaching/attaching databases, – Replication, – DTS, – BCP, – logshipping, – INSERT…SELECT, – SELECT…INTO, – creating INSERT scripts to generate data.

Posted in Data Mining Interview Questions | Leave a comment

Explain how to mine an OLAP cube. | Data Mining Questions

A data mining extension can be used to slice the data the source cube in the order as discovered by data mining. When a cube is mined the case table is a dimension.

Posted in Data Mining Interview Questions | Leave a comment

Explain how to use DMX-the data mining query language. | Data Mining Questions

Data mining extension is based on the syntax of SQL. It is based on relational concepts and mainly used to create and manage the data mining models. DMX comprises of two types of statements: Data definition and Data manipulation. Data … Continue reading

Posted in Data Mining Interview Questions | Leave a comment

Explain how to work with the data mining algorithms included in SQL Server data mining. | Data Mining Questions

SQL Server data mining offers Data Mining Add-ins for office 2007 that allows discovering the patterns and relationships of the data. This also helps in an enhanced analysis. The Add-in called as Data Mining client for Excel is used to … Continue reading

Posted in Data Mining Interview Questions | Leave a comment

Explain the concepts and capabilities of data mining. | Data Mining Questions

Data mining is used to examine or explore the data using queries. These queries can be fired on the data warehouse. Explore the data in data mining helps in reporting, planning strategies, finding meaningful patterns etc. it is more commonly … Continue reading

Posted in Data Mining Interview Questions | Leave a comment

What is Sequence clustering algorithm? | Data Mining Questions

Sequence clustering algorithm collects similar or related paths, sequences of data containing events. The data represents a series of events or transitions between states in a dataset like a series of web clicks. The algorithm will examine all probabilities of … Continue reading

Posted in Data Mining Interview Questions | Leave a comment

Explain Association algorithm in Data mining. | Data Mining Questions

Association algorithm is used for recommendation engine that is based on a market based analysis. This engine suggests products to customers based on what they bought earlier. The model is built on a dataset containing identifiers. These identifiers are both … Continue reading

Posted in Data Mining Interview Questions | Leave a comment

What is Time Series algorithm in data mining? | Data Mining Questions

Time series algorithm can be used to predict continuous values of data. Once the algorithm is skilled to predict a series of data, it can predict the outcome of other series. The algorithm generates a model that can predict trends … Continue reading

Posted in Data Mining Interview Questions | Leave a comment