All mock tests are FREE till 31 December — register to save your progress
Paper 2 CS · UNIT 04 · MOCK TEST

Mock 10 – Data Warehousing, Mining & Big Data

Unit 4: Database Management Systems · 13 questions · about 15 minutes. Press End Mock any time to see your score and the correct answers.

All 11 topic-wise mocks in this unit
0 / 13 answered 00:00
Q1. Consider the following statements:
A. Data transformation is involved in the Data mining process.
B. Online database is used in Data warehouse.
C. Classification is a measure of accuracy.
D. K-means clustering algorithm is based on the concept of minimizing the within-cluster variance.
E. Pattern evaluation is a process to identify knowledge based on interestingness measure.
Choose the correct answer from the options given below:
Q2. Which of the following tables contains the primary information in a data warehouse?
Q3. Match List I with List II
List IList II
A. Hadoop Distributed File SystemI. Trust
B. VeracityII. Facebook
C. Apache PigIII. Name-Node
D. Apache HiveIV. Yahoo
Q4. Match List I with List II.
Choose the correct answer from the options given below:
List IList II
a. Apache KafkaI. Platform for constructing data flows for extract, transform and load (ETL) processing and analysis of large datasets
b. PigII. General-purpose computing model and runtime system for distributed data analytics
c. Apache MahoutIII. Open-source platform that was created by LinkedIn
d. MapReduceIV. Open-source platform used for creating scalable machine learning algorithms
Q5. Select the correct order of the DBSCAN algorithm.
I. Recursively find all density-connected points and assign them to the same cluster as the core point.
II. Find all neighbour points within eps and identify the core points with more than MinPts neighbours.
III. Iterate through the remaining unvisited points in the dataset.
IV. For each core point, if it is not already assigned to a cluster, create a new cluster.
Q6. In reference to Big Data, consider the following databases:
(A) Memcached
(B) CouchDB
(C) InfiniteGraph
Choose the most appropriate answer from the options given below:
Q7. Consider the following statements about UNIX file permissions:
(A) UNIX provides three permission types — Read, Write and Execute.
(B) UNIX provides three permission sets — Owner, Group and Others.
Which of the above statement(s) is/are true?
Q8.

Match List I and List II

Figure
Q9.

In reference to big data, consider the following databases: (A) Memcached (B) CouchDB (C) InfiniteGraph.

Q10.

The data node and name node in HADOOP are

Q11.

Hadoop (a big data tool) works with number of related tools. Choose from the following, the common tools included into Hadoop :

Q12.

Data warehouse contains _____ data that is never found in the operational environment.

Q13.

Which of the following statements is/are true?

(i) Facebook has the world's largest Hadoop cluster.

(ii) Hadoop 2.0 allows live stream processing of real-time data.