click below
click below
Normal Size Small Size show me how
fa6 database
| Question | Answer |
|---|---|
| An OLAP operation that is also known as consolidation, use to summarize operation data along with the dimension. | DRILL-UP |
| The full form of DOLAP acronym is | DESKTOP OLAP |
| An OLAP operation that performs the analysis by taking one level of information for display. | SLICE |
| This strategy is also known delta, where only the data being changed is extracted and update data warehouses. | Partial Extraction (without update notification) |
| An OLAP system that utilizes multi-dimensional database for storing and analyzing information. | MOLAP |
| An ETL loading type that applies ongoing changes as when needed periodically. | INCREMENTAL LOAD |
| Which type of ETL Loading process populates all the data warehouse tables? | INITIAL LOAD |
| Clustering technique is a supervised learning. | False (unsupervised) |
| Classification technique is an unsupervised learning. | False (supervised) |
| Machine Learning refers to the algorithms that can learn from data to make predictions. | True |
| Unsupervised learning is a predictive analysis. | False (descriptive) |
| In the 9-step KDD process, choosing a data mining task is the same as choosing data mining algorithm. | False |
| The phase of CRISP-DM that consists of presenting the results in a useful and understandable manner, and by achieving this, the project should achieve its goals. | DEPLOYMENT |
| A type of data mining algorithm that is used to mine data and provide the latest information on past or recent events. | DESCRIPTIVE ANALYSIS |
| Data mining is applied in _________ websites to offer cross-sells and up-sells through their websites. | E-COMMERCE |
| A DM algorithm that do not require a predefined set of outputs but rather look for patterns or trends without any label or target. | UNSUPERVISED LEARNING |
| The Naïve Bayes algorithm is a _________ data mining. | CLASSIFICATION |
| A ______ is a data structure that allows fast analysis of data according to the multiple dimensions that define a business problem. | OLAP CUBE |
| The ______ operation perform the analysis that can gain a new view of data by rotating the data axes of the cube. | PIVOT |
| An ETL loading type that populates all the data warehouse tables. | INITIAL LOAD |
| The DEPLOYMENT phase of CRISP-DM consists of presenting the results in a useful and understandable manner, and by achieving this, the project should achieve its goals. | True |
| The EVALUATION phase of CRISP-DM that consists of presenting the results in a useful and understandable manner, and by achieving this, the project should achieve its goals. | False (DEPLOYMENT) |
| Decision Tree is an example of a classification algorithm. | True |
| Clustering technique is an unsupervised learning. | True |
| A data mining technique that is used to determine when something is noticeably different from the regular pattern. | ANOMALY DETECTION |
| The ________ is about processing data and identifying patterns and trends in that information so that you can decide or judge. | DATA MINING |
| The _______ analysis provides answers of the future queries that move across using historical data as the chief principle for decisions. | PREDICTIVE |
| What is the full form of the acronym OLAP? | ONLINE ANALYTICAL PROCESSING |
| An OLAP system that utilizes multi-dimensional database for storing and analyzing information. | MOLAP |
| An OLAP operation that performs analysis in deeper among the dimensions of data. | DRILL-DOWN |
| An OLAP system that is created to facilitate management of both spatial and non-spatial data in a Geographic Information system. | SOLAP |
| The descriptive analysis provides answers of the future queries that move across using historical data as the chief principle for decisions. | False (PREDICTIVE) |
| Classification technique is a supervised learning. | True |
| The predictive analysis provides answers of the future queries that move across using historical data as the chief principle for decisions. | True |
| A DM algorithm that has an assumption: Every feature of the data being classified is independent of all other features given the class. | NAIVE BAYES |
| These are algorithms that can learn from data to make predictions. | MACHINE LEARNING |
| What is the 4th step in CRISP-DM? | MODELING |
| OLAP is located in between Front-end tools and _____________. | DATA WAREHOUSE |
| An ETL loading type that erase the contents of one or more tables and reloads with fresh data. | FULL REFRESH LOAD |
| A data mining technique that is used to make predictions based on relationships within the data set. | REGRESSION |
| It refers to the numeric study of data relationships. | STATISTICS |
| Classification technique is a(n) ________ learning. | SUPERVISED |