Data Mining

Data Mining interview questions and answers

<<Previous  Next>>

Explain the storage models of OLAP. MOLAP Multidimensional Online Analytical processing -  In MOLAP data is stored in form of multidimensional cubes and not in relational databases.................... Read answer Differentiate between Data Mining and Data warehousing. Data warehousing is merely extracting data from different sources, cleaning the data and storing it in the warehouse. Where as data mining aims to examine or explore the data using queries................... Read answer What is Data purging? The process of cleaning junk data is termed as data purging. Purging data would mean getting rid of unnecessary NULL values of columns................. Read answer What are CUBES? A data cube stores data in a summarized version which helps in a faster analysis of data. The data is stored in such a way that it allows reporting easily.................. Read answer What are OLAP and OLTP? OLTP: Online Transaction and Processing helps and manages applications based on transactions involving high volume of data.................. Read answer What are the different problems that “Data mining” can solve? Data mining helps analysts in making faster business decisions which increases revenue with lower costs.............. Read answer What are different stages of “Data mining”? Exploration: This stage involves preparation and collection of data. it also involves data cleaning, transformation. Based on size of data, different tools to analyze the data may be required. This stage helps to determine different variables of the data to determine their behavior................... Read answer What is Discrete and Continuous data in Data mining world? Discreet data can be considered as defined or finite data. E.g. Mobile numbers, gender. Continuous data can be considered as............... Read answer What is MODEL in Data mining world? Models in Data mining help the different algorithms in decision making or pattern matching. The second stage of data mining.................... Read answer How does the data mining and data warehousing work together? Data warehousing can be used for analyzing the business needs by storing data in a meaningful form. Using Data mining,............... Read answer What is a Decision Tree Algorithm? A decision tree is a tree in which every node is either a leaf node or a decision node. This tree takes an input an object and outputs some decision................ Read answer What is Naïve Bayes Algorithm? Naïve Bayes Algorithm is used to generate mining models. These models help to identify relationships between input columns and the predictable columns................ Read answer Explain clustering algorithm. Clustering algorithm is used to group sets of data with similar characteristics also called as clusters...................... Read answer What is Time Series algorithm in data mining? 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.................... Read answer Explain Association algorithm in Data mining 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...................... Read answer What is Sequence clustering algorithm? Sequence clustering algorithm collects similar or related paths, sequences of data containing events....................... Read answer Explain the concepts and capabilities of data mining. 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,.................... Read answer Explain how to work with the data mining algorithms included in SQL Server data mining. SQL Server data mining offers Data Mining Add-ins for office 2007 that allows discovering the patterns and relationships of the data................. Read answer Explain how to use DMX-the data mining query language. 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............................. Read answer Explain how to mine an OLAP cube. A data mining extension can be used to slice the data the source cube in the order as discovered by data mining........................     Read answer <<Previous  Next>> Also read Question: Explain Full-Text Query in SQL Server. Answer - SQL Server supports searches on character string columns using Full-Text Query...... Question: Ex\ plain the phases a transaction has to undergo. Answer - The several phases a transaction has to go through are listed here. Database..... Question: What is XPath? Answer - XPath is a language defined by the W3C, used to select nodes from XML documents. .... Question: Define the rules for designing Files and File groups in SQL Server. Answer - A file or file group can only be used by one database. For example, the files abc.mdf and abc.ndf contains.... Question: What are the Authentication Modes in SQL Server? Answer - SQL Server supports two security (authentication) modes.... Question: Explain Data Definition Language, Data Control Language and Data Manipulation Language. Answer - Data definition language is used to define and manage all attributes and properties of a database..... Differentiate between Data Mining and Data warehousing. Define Data purging. Define Analysis services What are CUBES? What are OLAP and OLTP? Differentiate between Data Mining and Data warehousing. What is Data purging? What are CUBES? What are OLAP and OLTP? What are the different problems that “Data mining” can solve? What are different stages of “Data mining”? What is Discrete and Continuous data in Data mining world? What is MODEL is Data mining world? How does the data mining and data warehousing work together? What is a Decision Tree Algorithm? What is Naïve Bayes Algorithm? Explain clustering algorithm. What is Time Series algorithm in data mining? Explain Association algorithm in Data mining? What is Sequence clustering algorithm? How does data mining and data warehousing work together?