# Intelligent Data Modeling Assessment Test

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
| By Cripstwick
C
Cripstwick
Community Contributor
Quizzes Created: 693 | Total Attempts: 698,597
Questions: 10 | Attempts: 178

Settings

In software engineering, data modeling is a process in which a data model for an information system is created by applying specific formal techniques. Take this quiz to find out more.

• 1.

### How is data stored in MOLAP?

• A.

Relational databases

• B.

Multidimensional databases

• C.

Single dimensional databases

• D.

Distributed databases

B. Multidimensional databases
Explanation
Data is stored in MOLAP (Multidimensional Online Analytical Processing) using multidimensional databases. Unlike relational databases, which organize data in tables with rows and columns, multidimensional databases store data in a multidimensional structure. This allows for efficient and fast retrieval of data for analytical purposes. The multidimensional structure is designed to represent data in multiple dimensions, such as time, geography, and product, allowing for complex analysis and data slicing. Therefore, the use of multidimensional databases is the most suitable method for storing data in MOLAP.

Rate this question:

• 2.

### Which of the following is described as an extraction of data from different sources?

• A.

Data dredging

• B.

Data begging

• C.

Data merging

• D.

Data mining

D. Data mining
Explanation
Data mining is the correct answer because it involves the process of extracting useful information or patterns from large sets of data collected from various sources. It involves techniques such as data cleaning, data integration, and data transformation to discover insights and make predictions. Data dredging refers to the practice of searching for patterns or relationships in data without a specific hypothesis, while data begging and data merging are not commonly used terms in the context of data extraction.

Rate this question:

• 3.

### Deleting of data from a data warehouse is called...

• A.

Data deletion

• B.

Data booting

• C.

Data purging

• D.

Data merging

C. Data purging
Explanation
Data purging refers to the process of permanently deleting data from a data warehouse. It involves removing unwanted or outdated data that is no longer needed for analysis or reporting purposes. This helps to optimize storage space and improve the performance of the data warehouse. By purging unnecessary data, organizations can ensure that only relevant and up-to-date information is retained, making it easier to retrieve and analyze data effectively.

Rate this question:

• 4.

### Data cubes store data in _____ version.

• A.

Numerical

• B.

Summarized

• C.

Compressed

• D.

Alphabetical

B. Summarized
Explanation
Data cubes store data in a summarized version. Data cubes are multidimensional structures that organize data into dimensions and measures. These dimensions represent different attributes or characteristics of the data, while measures represent the numerical values being analyzed. By summarizing the data, data cubes provide a compact and efficient way to store and analyze large amounts of data, allowing for faster query processing and data analysis.

Rate this question:

• 5.

### Which of the following is an example of discrete data?

• A.

Gender

• B.

Light

• C.

Height

• D.

Opinion

A. Gender
Explanation
Gender is an example of discrete data because it can only take on a limited number of distinct values, such as male or female. Discrete data consists of separate, distinct categories or values that cannot be subdivided further. In this case, gender is a categorical variable with two distinct categories, making it a clear example of discrete data.

Rate this question:

• 6.

### Which of these helps in the pattern matching algorithm?

• A.

OLAP

• B.

MOLAP

• C.

MODEL

• D.

Decision Tree

C. MODEL
Explanation
The correct answer is MODEL. In pattern matching algorithms, a model is used to represent the pattern that needs to be matched. The model contains the characteristics or features of the pattern, which are then compared with the input data to find matches. The other options, OLAP, MOLAP, and Decision Tree, are not directly related to pattern matching algorithms and do not play a role in this process.

Rate this question:

• 7.

### Which of these can be used to predict continuous values of data?

• A.

Nodes

• B.

Time series

• C.

Decision tree

• D.

Leaf

B. Time series
Explanation
Time series can be used to predict continuous values of data. A time series is a sequence of data points collected at regular intervals over time. It represents the behavior of a variable or phenomenon over time and can be used to make predictions based on patterns and trends observed in the historical data. By analyzing the past values, seasonality, and trends in a time series, predictive models can be built to forecast future values. Therefore, time series analysis is a suitable method for predicting continuous values of data.

Rate this question:

• 8.

### Naive Bayes Algorithm is used to...

• A.

• B.

Create decision trees

• C.

Generate mining models

• D.

Change syntaxes

C. Generate mining models
Explanation
Naive Bayes Algorithm is used to generate mining models. This algorithm is a probabilistic classifier that applies Bayes' theorem with strong independence assumptions between the features. It is commonly used in machine learning for text classification, spam filtering, and sentiment analysis. By analyzing the relationships between variables, Naive Bayes can generate mining models that can be used to make predictions or classify new data based on the learned patterns from the training data.

Rate this question:

• 9.

### Which of the following is used to group sets of data with similar characteristics?

• A.

Data mining

• B.

Cluster

• C.

Decision tree

• D.

Database

B. Cluster
Explanation
Cluster is the correct answer because it is a technique used in data analysis to group sets of data with similar characteristics. It helps in identifying patterns and relationships within the data by grouping similar data points together. This allows for easier analysis and understanding of the data, and can be used in various fields such as marketing, finance, and healthcare.

Rate this question:

• 10.

### Which of these algorithms is used for recommendation engine based on market analysis?

• A.

System cluster algorithm

• B.

Association algorithm

• C.

Time series algorithm

• D.

Naive Bayes algorithm

B. Association algorithm
Explanation
The Association algorithm is used for recommendation engines based on market analysis. This algorithm analyzes patterns and associations between different items or products in a dataset to make recommendations. It identifies relationships between items that are frequently purchased together and uses this information to suggest similar or complementary items to customers. By analyzing transaction data and identifying item associations, the Association algorithm helps in making personalized recommendations to customers based on their purchasing behavior.

Rate this question:

Related Topics