> > Data Warehousing MCQs > Basic Data Warehousing MCQs

Basic Data Warehousing MCQ

1. The purpose of a data warehouse is to ________.

It helps to create a query quickly and easily.

It contains selected information from the data warehouse

Key business information into the hands of more decision makers

It consists of narrow and simple updates and queries

Answer

Correct Answer: Key business information into the hands of more decision makers

Note: This Question is unanswered, help us to find answer for this one

2. A ________ is a data warehouse that is limited in scope.

Data mart

Attribute

Downstream

Data Warehouse

Answer

Correct Answer: Data mart

Note: This Question is unanswered, help us to find answer for this one

3. A _____ is usually a smaller version of a data warehouse, used by a single department or function.

Data dictionary

Data domain

Data mart

Data mine

Answer

Correct Answer: Data mart

Note: This Question is unanswered, help us to find answer for this one

4. Which of the following features are required by OLAP applications?

Multidimensional views of data

Calculation-intensive capabilities

Time intelligence

All of the above

Answer

Correct Answer: All of the above

Note: This Question is unanswered, help us to find answer for this one

5. Which is not a purpose of Data Mining?

Decision Support

Prediction

Forecasting

Estimation

OLTP

Answer

Correct Answer: OLTP

Note: This Question is unanswered, help us to find answer for this one

6. A data warehouse is a "subject-oriented, integrated, time-variant, non-volatile collection of data in support of management"

Users from all departments help to create the database

It contains the data of the enterprise in its entirety

The final product is a fusion of various legacy system information into a cohesive set of information

Every user has access to the data in the warehouse

Answer

Correct Answer: The final product is a fusion of various legacy system information into a cohesive set of information

Note: This Question is unanswered, help us to find answer for this one

7. The applications of Data Mining would not include:

Discovering buying-patterns for cross selling

Financial market prediction

Discovering errors made during data entry

Discovering which customer is most profitable

Credit assessment

Answer

Correct Answer: Discovering errors made during data entry

Note: This Question is unanswered, help us to find answer for this one

8. In the Verification model of Data Mining, the emphasis is on which of the following?

The system automatically discovering important information hidden in the data

The user who is responsible for formulating the hypothesis and issuing the query on the data to affirm or negate the hypothesis

Volume of the data being examined

Timeliness of the data

Speed with which the data is examined

Answer

Correct Answer: The user who is responsible for formulating the hypothesis and issuing the query on the data to affirm or negate the hypothesis

Note: This Question is unanswered, help us to find answer for this one

9. Under OLAP terminology, slice and dice refers to:

The user-initiated process of navigating by calling for page displays interactively, through the specification of slices via rotations and drill down/up

Restricting the view of database objects to a specified subset

A means of extending the data accessible to the end user beyond that which is stored in the OLAP server

Computing all of the data relationships for one or more dimensions

Applying calculations to input data at the time the request for that data is made

Answer

Correct Answer: The user-initiated process of navigating by calling for page displays interactively, through the specification of slices via rotations and drill down/up

Note: This Question is unanswered, help us to find answer for this one

10. Which of the following is an architecture for OLAP?

MOLAP

ROLAP

KOLAP

MOLAP and ROLAP

MOLAP, ROLAP and KOLAP

Answer

Correct Answer: MOLAP

Note: This Question is unanswered, help us to find answer for this one

11. Which of the following is not associated with data warehousing?

Transaction processing

Information retrieval and analysis

Multi-dimensional data model

Query processing

Transformed and summarised data

Answer

Correct Answer: Transaction processing

Note: This Question is unanswered, help us to find answer for this one

12. Which Data Mining technique partitions the database so that each partition or group is similar according to some criteria or metric ?

Clustering and Segmentation

Induction

Neural Networks

Data Visualisation

Linear Regression Analysis

Answer

Correct Answer: Clustering and Segmentation

Note: This Question is unanswered, help us to find answer for this one

13. A multidimensional cube records a set of data derived from:

Fact tables

Pivot tables

Dimensions

Fact tables and Dimensions

Fact tables and Pivot tables

Answer

Correct Answer: Fact tables and Dimensions

Note: This Question is unanswered, help us to find answer for this one

14. Changing the view of the data to a greater level of detail is known as:

Explosion

Drill down

Drill up

Exploration

Aggregation

Answer

Correct Answer: Drill down

Note: This Question is unanswered, help us to find answer for this one

15. Which of the following rules would be considered the central core of OLAP?

Multidimensional Conceptual View

Intuitive Data Manipulation

Accessibility

Batch Extraction vs Interpretative

Transparency

Answer

Correct Answer: Multidimensional Conceptual View

Note: This Question is unanswered, help us to find answer for this one

16. In a star schema, the central table which contains the individual facts being stored in the database is called a:

Fact table

Meta table

Data Dictionary

Pivot table

Dimension table

Answer

Correct Answer: Fact table

Note: This Question is unanswered, help us to find answer for this one

17. In the Discovery model of Data Mining, the emphasis is on which of the following?

The system automatically discovering important information hidden in the data

The user who is responsible for formulating the hypothesis and issuing the query on the data to affirm or negate the hypothesis

Volume of the data being examined

Timeliness of the data

Speed with which the data is examined

Answer

Correct Answer: The system automatically discovering important information hidden in the data

Note: This Question is unanswered, help us to find answer for this one

18. The main objective of Data Mining is:

The safe storage of data

Elimination of errors from the data

Deleting data that is no longer important to the organization

The extraction of implicit, previously unknown, and potentially useful information from data

To help in the generation of reports for the management

Answer

Correct Answer: The extraction of implicit, previously unknown, and potentially useful information from data

Note: This Question is unanswered, help us to find answer for this one

19. Metadata does not include:

The actual data

A description of tables and fields in the warehouse, including data types and the range of acceptable values

A similar description of tables and fields in the source databases, with a mapping of fields from the source to the warehouse

A description of how the data has been transformed, including formulae, formatting, currency conversion, and time aggregation

Information that is needed to support and manage the operation of the data warehouse

Answer

Correct Answer: The actual data

Note: This Question is unanswered, help us to find answer for this one

20. The requirement that the datawarehouse RDBMS server must support hundreds and thousands of concurrent users while maintaining an acceptable query performance is known as:

Terabyte Scalability

Load Performance

Mass User Scalability

Data Quality Management

Query Performance

Answer

Correct Answer: Mass User Scalability

Note: This Question is unanswered, help us to find answer for this one

21. Which of the following type of data is most likely to be stored on some form of mass storage ?

Metadata

Highly summarised data

Lightly summarised data

Current detail data

Older detail data

Answer

Correct Answer: Older detail data

Note: This Question is unanswered, help us to find answer for this one

22. The logical organisation of data in a database is called:

Normalisation

Schema

View

Fact table

Dimension

Answer

Correct Answer: Schema

Note: This Question is unanswered, help us to find answer for this one

23. A means of extending the data accessible to the end user beyond that which is stored in the OLAP server is know as :

Consolidation

Multi Dimensional Analysis

Drill Down

Navigation

Reach through

Answer

Correct Answer: Reach through

Note: This Question is unanswered, help us to find answer for this one

24. In which component of the enterprise is the data re-organised for analysis and information extracted from the data?

The Data Warehouse

The Data Mart

The Data Mine

The operational RDBMS

Metadata

Answer

Correct Answer: The Data Mine

Note: This Question is unanswered, help us to find answer for this one

25. The movement of data from one environment to another is known as:

Data Migration

Normalization

Replication

Data Mining

Data Cleansing

Answer

Correct Answer: Data Migration

Note: This Question is unanswered, help us to find answer for this one

26. Changing the view of the data to a higher level of aggregation is known as:

Implosion

Drill down

Drill up

Synchronisation

Summarisation

Answer

Correct Answer: Drill up

Note: This Question is unanswered, help us to find answer for this one

27. SQL stands for:

Structured Query Language

Systematic Query Language

Structured Query Logic

Structured Queuing Logic

Standard Query Logic

Answer

Correct Answer: Structured Query Language

Note: This Question is unanswered, help us to find answer for this one

28. The main impetus behind data warehousing was:

To discover means to reduce the data volumes

To make OLTP systems work faster

To reduce human interaction with database systems

To access corporate knowledge repositories based on huge databases to make sound business decisions

To standardise the database products used

Answer

Correct Answer: To access corporate knowledge repositories based on huge databases to make sound business decisions

Note: This Question is unanswered, help us to find answer for this one

29. The data warehouse is typically a large database on a high performance SMP system. Here SMP stands for:

Symmetric Multi-Processing

Superior Multi-Processing

Systematic Massive Processing

Symmetric Massive Processing

Systematic Multi-Processing

Answer

Correct Answer: Symmetric Multi-Processing

Note: This Question is unanswered, help us to find answer for this one

30.
Given the following steps between raw data and extracted knowledge, arrange them in the correct order:
1 Data mining
2 Transformation
3 Selection
4 Pre-processing
5 Interpretation and Evaluation

3,4,2,1,5

4,3,2,1,5

4,2,1,3,5

4,1,2,3,5

3,4,1,2,5

Answer

Correct Answer:

3,4,2,1,5

Note: This Question is unanswered, help us to find answer for this one

31. Data Mining is also known as

Data Extraction

Data Archiving

Knowledge Discovery in Databases (KDD)

Data Preservation

Answer

Correct Answer: Knowledge Discovery in Databases (KDD)

Note: This Question is unanswered, help us to find answer for this one

32. The Metadata of the data warehouse should at least contain:

The structure of the data

The algorithm used for summarisation

The mapping from the operational environment to the data warehouse and the algorithm used for summarisation

The structure of the data and the algorithm used for summarisation

The structure of the data, the algorithm used for summarisation and the mapping from the operational environment to the data warehouse and the algorithm used for summarisation

Answer

Correct Answer: The structure of the data, the algorithm used for summarisation and the mapping from the operational environment to the data warehouse and the algorithm used for summarisation

Note: This Question is unanswered, help us to find answer for this one

33. Which of the following stage is concerned with the extraction of patterns from the data?

Selection

Pre-processing

Transformation

Data Mining

Interpretation and Evaluation

Answer

Correct Answer: Data Mining

Note: This Question is unanswered, help us to find answer for this one

34. Data quality management refers to the fact that:

Ad-hoc analysis must not be slowed or inhibited by the performance of the data warehouse RDBMS

The warehouse must ensure local consistency, global consistency, and referential integrity

The RDBMS server must support hundreds, even thousands, of concurrent users while maintaining acceptable query performance

The server must include tools that co-ordinate the movement of subsets of data between warehouses

The RDBMS must provide a complete set of analytic operations including core sequential and statistical operations

Answer

Correct Answer: The warehouse must ensure local consistency, global consistency, and referential integrity

Note: This Question is unanswered, help us to find answer for this one

35. Which of the following is not true regarding the process of Data Mining?

Software techniques are used for finding patterns and regularities in sets of data

It is the computer that is responsible for finding the patterns by identifying the underlying rules and features in the data

Data mining analysis tends to work from the data up

The best techniques are those developed with an orientation towards small volumes of data

The analysis process starts with a set of data, uses a methodology to develop an optimal representation of the structure of the data, during which time knowledge is acquired

Answer

Correct Answer: The best techniques are those developed with an orientation towards small volumes of data

Note: This Question is unanswered, help us to find answer for this one

36. Which of the following would be the only similarity between a datawarehouse and OLTP system?

Purpose

Structure of data

Type of data

Condition of data

Data model

Answer

Correct Answer: Structure of data

Note: This Question is unanswered, help us to find answer for this one

37. Which of the following statements is incorrect regarding Data Mining?

It is the process of turning data into information

It is a collection of many techniques

It is a replacement for OLAP

It is based on machine generated hypothesis

It is used in Decision Support, Prediction, Forecasting and Estimation

Answer

Correct Answer: It is a replacement for OLAP

Note: This Question is unanswered, help us to find answer for this one

38. The modification of data as it is moved into the data warehouse is:

Data Transformation

Replication

Synchronization

Data migration

Normalization

Answer

Correct Answer: Data Transformation

Note: This Question is unanswered, help us to find answer for this one

39. A datawarehouse should be able to implement advanced query functionality. This means :

The RDBMS must provide a complete set of analytic operations including core sequential and statistical operations

The RDBMS must not have any architectural limitations

The RDBMS server must support hundreds, even thousands, of concurrent users while maintaining acceptable query performance

Query performance must not be dependent on the size of the database, but rather on the complexity of the query

The warehouse must ensure local consistency, global consistency, and referential integrity

Answer

Correct Answer: The RDBMS must provide a complete set of analytic operations including core sequential and statistical operations

Note: This Question is unanswered, help us to find answer for this one

40. Which technique of Data Mining involves developing mathematical structures with the ability to learn?

Clustering and Segmentation

Neural Networks

Fuzzy Logic

Linear Regression Analysis

Rule based Analysis

Answer

Correct Answer: Neural Networks

Note: This Question is unanswered, help us to find answer for this one

41. Which Data Mining function/technique is used to analyse a collection of records over a period of time?

Classification

Associations

Sequential/Temporal patterns

Clustering

Segmentation

Answer

Correct Answer: Sequential/Temporal patterns

Note: This Question is unanswered, help us to find answer for this one

42. A structure that stores multi-dimensional information, having one cell for each possible combination of dimensions is known as:

Table

Section

Partition

Cube

Repository

Answer

Correct Answer: Cube

Note: This Question is unanswered, help us to find answer for this one

43. HOLAP stands for:

Hierarchical On-line Analytical Processing

Hybrid On-line Analytical Processing

Horizontal On-line Analytical Processing

Hyper On-line Analytical Processing

HyperCube On-line Analytical Processing

Answer

Correct Answer: Hybrid On-line Analytical Processing

Note: This Question is unanswered, help us to find answer for this one

44. Which of the following would not be an application of Data Mining in the banking field?

Detect patterns of fraudulent credit card use

Ascertaining the number of transactions made in a day

Determine credit card spending by customer groups

Find hidden correlation between different financial indicators

Predict the customers likely to change their credit card affiliation

Answer

Correct Answer: Ascertaining the number of transactions made in a day

Note: This Question is unanswered, help us to find answer for this one

45. In a star schema, a table which contains data about one of the dimensions is called a:

Fact table

Meta table

Data Dictionary

Pivot table

Dimension table

Answer

Correct Answer: Meta table

Note: This Question is unanswered, help us to find answer for this one

46. ROLAP stands for:

Recyclic On-line Analytical Processing

Relational On-line Analytical Processing

Reduced On-line Analytical Processing

Rotated On-line Analytical Processing

Redundant On-line Analytical Processing

Answer

Correct Answer: Relational On-line Analytical Processing

Note: This Question is unanswered, help us to find answer for this one

47. Replication refers to the:

Physical copying of data from one database to another

Cleansing of the data

Integration of data from various sources into the data warehouse

Analysis of the data

Recovery of data

Answer

Correct Answer: Physical copying of data from one database to another

Note: This Question is unanswered, help us to find answer for this one

48. Normalization applied to the dimension tables of a star schema is known as:

Snowflaking

Synchronization

Slicing and Dicing

Replication

Data transformation

Answer

Correct Answer: Snowflaking

Note: This Question is unanswered, help us to find answer for this one

49. A multi-dimensional data set is sparse if:

The data to be analysed is less in volume

If a relatively high percentage of the possible combinations (intersections) of the members from the data set's dimensions contain missing data

If a relatively high percentage of the possible combinations (intersections) of the members from the data set's dimensions contain invalid data

If a relatively high percentage of the possible combinations (intersections) of the members from the data set's dimensions contain valid data

If a relatively high percentage of the possible combinations (intersections) of the members from the data set's dimensions contain outdated data

Answer

Correct Answer: If a relatively high percentage of the possible combinations (intersections) of the members from the data set's dimensions contain missing data

Note: This Question is unanswered, help us to find answer for this one

50. Data Volatility describes:

The degree to which data and data structures change over time

The redundancy of the data

The volume of the data

The compactness of the data

The validity of the data

Answer

Correct Answer: The degree to which data and data structures change over time

Note: This Question is unanswered, help us to find answer for this one

51. Which of the following queries would be correlated with a Data warehouse?

What is the current account balance of this customer?

How many customers have not paid their balances on time?

What is the total number of customers in the middle region?

hich product line sells best in middle region and how does this correlate to demographic data?

Which customer makes the maximum purchases?

Answer

Correct Answer: hich product line sells best in middle region and how does this correlate to demographic data?

Note: This Question is unanswered, help us to find answer for this one

52. Granularity refers to the:

Validity of the data stored in a data warehouse

The level of detail of the facts stored in a data warehouse

The timeliness of the data stored in a data warehouse

The redundancy of the data stored in a data warehouse

Compactness of the data stored in a data warehouse

Answer

Correct Answer: The level of detail of the facts stored in a data warehouse

Note: This Question is unanswered, help us to find answer for this one

53. The main objects used by OLAP programs are:

Multidimensional cubes

Metadata

RDBMS tables

Fact tables

Pivot tables

Answer

Correct Answer: Multidimensional cubes

Note: This Question is unanswered, help us to find answer for this one

54. The term OLAP was coined by:

Date

Codd

IBM

Oracle

Microsoft

Answer

Correct Answer: Codd

Note: This Question is unanswered, help us to find answer for this one

55. Which of the following techniques can be used to improve query performance?

Denormalization

Partitioning

Summarization

Denormalization and Partitioning

Denormalization, Partitioning and Summarization

Answer

Correct Answer: Denormalization, Partitioning and Summarization

Note: This Question is unanswered, help us to find answer for this one

56. A slice is:

A subset of a multi-dimensional array corresponding to a single value for one or more members of the dimensions not in the subset

A subset of a multi-dimensional array corresponding to multiple values for one or more members of the dimensions not in the subset

A subset of a multi-dimensional array corresponding to a single value for one or more members of the dimensions in the subset

A subset of a multi-dimensional array corresponding to multiple values for one or more members of the dimensions in the subset

A subset of a multi-dimensional array not corresponding to a single value for one member of the dimensions not in the subset

Answer

Correct Answer: A subset of a multi-dimensional array corresponding to a single value for one or more members of the dimensions not in the subset

Note: This Question is unanswered, help us to find answer for this one

57. Which of the following would not be considered as a variable affecting the design of an OLAP system?

Query demand

Source of data

Number of dimensions

Atomic data volume

Data volatility

Answer

Correct Answer: Source of data

Note: This Question is unanswered, help us to find answer for this one

58. Normalisation is:

The process of organising data in accordance with the rules of a relational database

The process of cleansing the data

The process of integrating the data into the datawarehouse from legacy systems

The process of compressing the data

The process of eliminating invalid data before it is introduced into the data warehouse

Answer

Correct Answer: The process of organising data in accordance with the rules of a relational database

Note: This Question is unanswered, help us to find answer for this one

59. OLAP queries can be characterised as on-line transactions that do not:

Access small amounts of data

Analyse the relationships between many types of business elements e.g. sales, products, regions, and channels

Compare aggregated data over hierarchical time periods e.g. monthly, quarterly, yearly

Present data in different perspectives e.g. sales by region vs. sales by channels by product within each region

Respond quickly to user requests, so that users can pursue an analytical thought process without being stymied by the system

Answer

Correct Answer: Access small amounts of data

Note: This Question is unanswered, help us to find answer for this one

60. Which of the following are the modes of OLAP?

MOLAP

ROLAP

KOLAP

Answer

Correct Answer: MOLAP
ROLAP

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

61. All else being equal, which of the following elements of a single MDX WHERE clause will evaluate first?

MEMBER [Measures].[A Squared] AS [Measures].[Measure A] * [Measures].[Measure A], SOLVE_ORDER = 2

MEMBER [Measures].[C Less One] AS [Measures].[Measure C] - 1, SOLVE_ORDER = 1

All elements evaluate simultaneously

MEMBER [Measures].[B Twice] AS [Measures].[Measure B] + [Measures].[Measure B], SOLVE_ORDER = 4

Answer

Correct Answer: MEMBER [Measures].[B Twice] AS [Measures].[Measure B] + [Measures].[Measure B], SOLVE_ORDER = 4

Note: This Question is unanswered, help us to find answer for this one

62. Which of the following is a required property of information passed to the Microsoft Sequence Clustering Algorithm?

sequence information stored as a nested table

normalized data with key sequence columns on each dimension table

star schema with key sequence columns on each dimension table

sequence information stored as a flat table

Answer

Correct Answer: sequence information stored as a nested table

Note: This Question is unanswered, help us to find answer for this one

63. Online extraction process falls under which type of data extraction method?

Full Extraction

Logical Extraction

Physical Extraction

Incremental Extraction

Answer

Correct Answer: Physical Extraction

Note: This Question is unanswered, help us to find answer for this one

64. What property do Router Transformations and Filter Transformations have in common?

All of the Above

will not block input rows

single input group transformation

single output group transformation

Answer

Correct Answer: single input group transformation

Note: This Question is unanswered, help us to find answer for this one

65. Where is the OLAP page pool stored in memory in an Oracle Database 10g and later?

Private SQL Area

User Global Area

Program Global Area

SQL Work Area

Answer

Correct Answer: User Global Area

Note: This Question is unanswered, help us to find answer for this one

66. Without deliberate security measures, which of the following MDX clauses is susceptible to injection attack?

FROM

WITH

All of the Above

WHERE

Answer

Correct Answer: WHERE

Note: This Question is unanswered, help us to find answer for this one

67. What is a slice in the context of Amazon Redshift?

A logical partition of the data layer shared between distributed compute nodes

A parallel operation isolating a single layer of a Redshift cube

A partition allowing each of core of a multi-processor node to process the node's workload in parallel

A client-facing partition that isolates different parts of the data warehouse for different types of users in an organization

Answer

Correct Answer: A partition allowing each of core of a multi-processor node to process the node's workload in parallel

Note: This Question is unanswered, help us to find answer for this one

68. Which of the following environments has more indexes?

Data Warehousing env

OLTP

OLAP

Database

Answer

Correct Answer: Data Warehousing env

Note: This Question is unanswered, help us to find answer for this one

69. What is true of querying normalized data in a relational database for the purposes of business analysis?

All of the Above

Aggregating relevant data requires the creation of new primary keys

Aggregating relevant data requires multiple table joins

The data must first be placed into a data warehouse via the ETL process

Answer

Correct Answer: Aggregating relevant data requires multiple table joins

Note: This Question is unanswered, help us to find answer for this one

70. Which of the following is not an advisable implementation of division in MDX?

measures.[Value A]/measures.[Value B]

Divide(measures.[Value A]/measures.[Value B], null)

None of the Above

iff(measures.[Value A]=0, null, measures.[Value A]/measures.[Value B])

Answer

Correct Answer: measures.[Value A]/measures.[Value B]

Note: This Question is unanswered, help us to find answer for this one

71. Which of the following is not TRUE about subject oriented characteristics of a data warehouse?

Data that are never deleted once they have been added

Data should not change once it is entered into the warehouse

Data is manipulated to provide information about a particular subjec

Data warehouse has a defined scope

Answer

Correct Answer: Data should not change once it is entered into the warehouse

Note: This Question is unanswered, help us to find answer for this one

72. Which of the following is an appropriate method for mitigating the database explosion associated with sparse dimensions?

populate the sparse dimension with filler values

apply Type 6 updating to the sparse dimension

isolate the sparse dimension in a separate cube

create a composite to stand-in for the sparse dimension

Answer

Correct Answer: create a composite to stand-in for the sparse dimension

Note: This Question is unanswered, help us to find answer for this one

73. What is the principal disadvantage of Type 3 Slowly Changing Data management?

Does not track historical data

Stores only a finite number of historical changes

Significantly increases storage requirements per record

Updates obsolete data with new values infrequently

Answer

Correct Answer: Stores only a finite number of historical changes

Note: This Question is unanswered, help us to find answer for this one

74. Which of the following is not a property of a perspective?

Can provide business-specific viewpoints of a cube

Can securely restrict access to objects in a cube

Can hide any number of dimensions from a cube

Can display hierarchies from a cube

Answer

Correct Answer: Can securely restrict access to objects in a cube

Note: This Question is unanswered, help us to find answer for this one

75. When is a column-based engine a more appropriate architecture for a Data Warehouse than a row-based engine?

most columns in a table will be required for a query

dynamic, unpredictable query patterns

small number of known indexes to be created, static query patterns

a column-based engine is only appropriate for OLTP applications

Answer

Correct Answer: dynamic, unpredictable query patterns

Note: This Question is unanswered, help us to find answer for this one

76. Which of the following applies to Fact Tables?

Partially denormalized

Completely normalized

Completely denormalized

Partially normalized

Answer

Correct Answer: Completely normalized

Note: This Question is unanswered, help us to find answer for this one

77. Which of the following is the most appropriate data structure for indexing a MOLAP Cube?

Index table

B-Tree

Bitmap index

Huffman encoding

Answer

Correct Answer: Bitmap index

Note: This Question is unanswered, help us to find answer for this one

78. Among the following, which is NOT the objective of clustering?

To cover natural groupings

It facilitates OLAP operations

To find consistent and valid organizations of the data

To initiate hypothesis about the data

Answer

Correct Answer: It facilitates OLAP operations

Note: This Question is unanswered, help us to find answer for this one

79. In order to populate the data warehouse, which of the following set of operations are appropriate?

Query and update

Insert and delete

Refresh and load

Create and edit

Answer

Correct Answer: Query and update

Note: This Question is unanswered, help us to find answer for this one

80. Which of the following operations performs aggregation on a data cube by dimension reduction?

Roll-up

Roll-down

Drill-down

Drill-up

Answer

Correct Answer: Roll-up

Note: This Question is unanswered, help us to find answer for this one

81. In a 3-tier architecture of the data warehouse, the OLAP engine is related to:

The first layer of the architecture

The Second layer of the architecture

The third layer of the architecture

The fourth layer of the architecture

Answer

Correct Answer: The Second layer of the architecture

Note: This Question is unanswered, help us to find answer for this one

82. Which of the following is not a type of OLAP?

Relational

Multidimensional

Hybrid

Analytical

Answer

Correct Answer: Analytical

Note: This Question is unanswered, help us to find answer for this one

83. Which of following stages involve data update in the warehouse for every transaction performed on the source data?

Integrated data warehouse

On time data warehouse

Offline operational data warehouse

Offline data warehouse

Answer

Correct Answer: On time data warehouse

Note: This Question is unanswered, help us to find answer for this one

84. Which of the following is a property of Data Warehouse data?

Read and Write

Read Only

Write Only

Write Deconditional

Answer

Correct Answer: Read Only

Note: This Question is unanswered, help us to find answer for this one

85. What Amazon Reshift compression encodings would be most appropriate for the columns (Date, City, Description), respectively?

Delta, Byte-dictionary, LZO

MOSTLY8, Runlength, Raw

Byte-dictionary, LZO, Delta

LZO, Delta, Raw

Answer

Correct Answer: Delta, Byte-dictionary, LZO

Note: This Question is unanswered, help us to find answer for this one

86. Which operation on a multidimensional database is most equivalent to a relational join?

dice

slice

rotating

drill-across

Answer

Correct Answer: drill-across

Note: This Question is unanswered, help us to find answer for this one

87. Which of the following is true about multidimensional models?

It uses just one level of data storage representation to handle sparse data sets

It uses just one level of data storage representation to handle dense data sets

It uses one level of data storage representation to handle both dense and sparse data sets

It uses two level of data storage representation to handle dense and sparse data sets

Answer

Correct Answer: It uses two level of data storage representation to handle dense and sparse data sets

Note: This Question is unanswered, help us to find answer for this one

88. Which of the following enviroments are in third normal form 3NF?

All of the options are correct

OLAP

Data Warehousing env

OLTP

Answer

Correct Answer: OLTP

Note: This Question is unanswered, help us to find answer for this one

89. Which of the following can present summary data from an OLAP server?

normalization

All of the Above

pivot tables

primary keys

Answer

Correct Answer: pivot tables

Note: This Question is unanswered, help us to find answer for this one

90. What is an OLAP Cube?

an array in which data is stored and characterized by multiple dimensions

None of the Above

a three-dimensional array for Online Analytical Processing

a dimensional-reduction operation that summarizes data

Answer

Correct Answer: an array in which data is stored and characterized by multiple dimensions

Note: This Question is unanswered, help us to find answer for this one

91. Which of the following contains historical data?

OLAP

OLTP

Both OLAP and OLTP

Neither OLAP nor OLTP

Answer

Correct Answer: OLAP

Note: This Question is unanswered, help us to find answer for this one

92. Which of the following operation is performed by introducing new dimensions?

Roll-up

Roll-down

Drill-down

Drill-up

Answer

Correct Answer: Drill-down

Note: This Question is unanswered, help us to find answer for this one

93. Which of the following environments has a higher amount of Joins

Database

OLAP

OLTP

Data Warehousing env

Answer

Correct Answer: OLTP

Note: This Question is unanswered, help us to find answer for this one

94. Which of the following is not a VALID characteristic of data warehouse?

Subject Oriented

Volatile

Nonvolatile

Integrated

Answer

Correct Answer: Volatile

Note: This Question is unanswered, help us to find answer for this one

95. Which of the following would not be a part of the fact table of a star schema representing sales data?

Product name when a Product dimension table exists

Store UID when a Store dimension table exists

Units sold

None of the Above

Answer

Correct Answer: Product name when a Product dimension table exists

Note: This Question is unanswered, help us to find answer for this one

96. Choose the most correct statement:

Star and snowflake schema contains two Fact tables

Snowflake schema contains two Fact tables

Fact Constellation schema contains two Fact tables

Star schema contains two Fact tables

Answer

Correct Answer: Fact Constellation schema contains two Fact tables

Note: This Question is unanswered, help us to find answer for this one

97. What is a Data Mart?

an access layer comprising a subset of a data warehouse

an online, open exchange in which organizations can trade business information

a schema that organizes data into facts and dimensions

a central repository where separate organizations can securely backup data

Answer

Correct Answer: an access layer comprising a subset of a data warehouse

Note: This Question is unanswered, help us to find answer for this one

98. Which line is not a valid MDX comment?

/* this line */

// this line

## this line

-- this line

Answer

Correct Answer: ## this line

Note: This Question is unanswered, help us to find answer for this one

99. Which of the following is true about 'Pivot' operation?

It rotates the data axes in view in order to provide an alternative presentation of data

Two consecutive slice operations in two different dimensions

It is also known as rotation

All of the given options are valid

Answer

Correct Answer: All of the given options are valid

Note: This Question is unanswered, help us to find answer for this one

100. Which of the following is an example of a non-aggregatable measure?

transaction volume

gross profits

costs

probability of default

Answer

Correct Answer: probability of default

Note: This Question is unanswered, help us to find answer for this one

101. Modifying an OLAP Cube to view information from only a single year is an example of which operation?

dice

join

pivot

slice

Answer

Correct Answer: slice

Note: This Question is unanswered, help us to find answer for this one

102. Which language is appropriate for querying a non-relational OLAP database?

Fortran

MDX

SQL

SPSS

Answer

Correct Answer: MDX

Note: This Question is unanswered, help us to find answer for this one

103. Which of the following operations navigate data from less detailed data to highly detailed data?

Drill-up

Roll-down

Roll-up

Drill-down

Answer

Correct Answer: Drill-down

Note: This Question is unanswered, help us to find answer for this one

104. What is the "grain" of a fact table?

the most atomic level at which the facts may be defined

the raw data from which the facts are derived

the direction along which additive measures can be combined

the ratio of facts to dimensions

Answer

Correct Answer: the most atomic level at which the facts may be defined

Note: This Question is unanswered, help us to find answer for this one

105. When is it appropriate to use a Joiner Transformation during ETL?

When the two sources have multiple matching columns

When the two sources have a primary-key to foreign-key relationship

All of the Above

When the two sources are heterogeneous

Answer

Correct Answer: All of the Above

Note: This Question is unanswered, help us to find answer for this one

106. Which system is appropriate for recording customer transactions in real time?

Star Schema

OLTP

OLAP

Snowflake Schema

Answer

Correct Answer: OLTP

Note: This Question is unanswered, help us to find answer for this one

107. Which of the following uses the idea of a data cube to represent the dimensions of data ?

OLTP

Relational Database

ODS

OLAP or Multidimensional Database

Answer

Correct Answer: OLAP or Multidimensional Database

Note: This Question is unanswered, help us to find answer for this one

108. Data Warehouse (OLAP) is based on which of the following?

Star Schema

Snowflake Schema

Fact Constellation Schema

All of given options are valid

Answer

Correct Answer: All of given options are valid

Note: This Question is unanswered, help us to find answer for this one

109. What is the process by which raw data is migrated into a data warehouse?

Extract, Transform, Load

Extract Test Language

Export, Transmit, Load

Export, Translate, Load

Answer

Correct Answer: Extract, Transform, Load

Note: This Question is unanswered, help us to find answer for this one

110. Which of the following is true about Data Warehousing?

All of the given options are true

It is copy of transaction data specifically structured for query and analysis

It is designed to facilitate reporting and analysis

It is a non-volatile time-variant repository

Answer

Correct Answer: All of the given options are true

Note: This Question is unanswered, help us to find answer for this one

111. Which of the following are valid Logical Extraction methods?

Incremental Extraction

Both Full Extraction and Incremental Extraction

Full Extraction

Online extraction

Answer

Correct Answer: Both Full Extraction and Incremental Extraction

Note: This Question is unanswered, help us to find answer for this one

112. Which of the following systems is optimized for multidimensional analysis?

SQL

ETL

OLAP

OLTP

Answer

Correct Answer: OLAP

Note: This Question is unanswered, help us to find answer for this one

113. Which of the following is true about Data mining?

It allows users to analyze data from many different dimensions or angles

All of the given options are valid

It is the process of analyzing data from different perspectives and summarizing it into useful information

It is the process of finding correlations or patterns among various fields

Answer

Correct Answer: All of the given options are valid

Note: This Question is unanswered, help us to find answer for this one

114. Which of the following is VALID about time-variant characteristic of a data warehouse?

All of the given options are valid

Data warehouses contain data that is generally loaded from the operational databases on a regular interval

Time horizon of a data warehouse is significanlty longer than that of operational systems

Data Warehouse maintains both historical and (nearly) current data

Answer

Correct Answer: All of the given options are valid

Note: This Question is unanswered, help us to find answer for this one

115. Which of the following is TRUE about ROLAP?

Can handle large amounts of data

Performance can be slow

All of the given options are valid

Can leverage functionalities inherent in the relational database

Answer

Correct Answer: All of the given options are valid

Note: This Question is unanswered, help us to find answer for this one

116. What table is at the center of a star schema?

fact table

core table

metadata table

dimension table

Answer

Correct Answer: fact table

Note: This Question is unanswered, help us to find answer for this one

117. What is an example of an OLAP dice operation?

specifying a particular year and region

randomizing the year and region

specifying a particular year

randomizing the year

Answer

Correct Answer: specifying a particular year and region

Note: This Question is unanswered, help us to find answer for this one

118. Which of the following is true about Specialized SQL servers?

It uses the two level of data storage representation to handle dense and sparse data sets

It provides advanced query language and query processing support for SQL queries over star and snowflake schemas

It facilitates OLTP operations in SQL

It uses array-based multidimensional storage engines

Answer

Correct Answer: It provides advanced query language and query processing support for SQL queries over star and snowflake schemas

Note: This Question is unanswered, help us to find answer for this one

119. Where does cleansing take place during the ETL phase of data bound for a MOLAP based data warehouse?

ODS

Cleanroom Table

Staging Area

No distinct cleansing phase, data cleansed during MDX queries

Answer

Correct Answer: Staging Area

Note: This Question is unanswered, help us to find answer for this one

120. Which of the following is NOT a benefit of data warehousing?

To maintain data history

To enhance data quality

To collate data from multiple sources into a multiple databases

To integrate data from multiple source systems

Answer

Correct Answer: To collate data from multiple sources into a multiple databases

Note: This Question is unanswered, help us to find answer for this one

121. Operational Database(OLTP) is based on which of the following?

Snowflake Schema

Entity Relationship Model

Star Schema

Fact Constellation Schema

Answer

Correct Answer: Entity Relationship Model

Note: This Question is unanswered, help us to find answer for this one

122. Which of the following is true about Data Scrubbing?

It is same as data validation

Harmonization of data cannot be considered as Data Scrubbing

It involves data cleansing

Standardization of data cannot be considered as Data Scrubbing

Answer

Correct Answer: It involves data cleansing

Note: This Question is unanswered, help us to find answer for this one

123. Which of the following implements Multidimensional OLAP?

Oracle Essbase

IBM TM1

Microsoft SSAS

All of the Above

Answer

Correct Answer: All of the Above

Note: This Question is unanswered, help us to find answer for this one

Data Warehousing MCQs | Topic-wise

MCQ on Basic Data Warehousing

General Data Warehousing MCQs

Data Warehousing Subjects

More Resources

Data Warehousing MCQ

Data Warehousing Skill Assessment

Data Warehousing PDF

Related MCQs

DB2 Administration MCQs

DB2 Programming MCQs

Delphi MCQs

DHTML MCQs

Django MCQs

Basic Data Warehousing MCQ

1. The purpose of a data warehouse is to ________.

2. A ________ is a data warehouse that is limited in scope.

3. A _____ is usually a smaller version of a data warehouse, used by a single department or function.

4. Which of the following features are required by OLAP applications?

5. Which is not a purpose of Data Mining?

6. A data warehouse is a "subject-oriented, integrated, time-variant, non-volatile collection of data in support of management"

7. The applications of Data Mining would not include:

8. In the Verification model of Data Mining, the emphasis is on which of the following?

9. Under OLAP terminology, slice and dice refers to:

10. Which of the following is an architecture for OLAP?

11. Which of the following is not associated with data warehousing?

12. Which Data Mining technique partitions the database so that each partition or group is similar according to some criteria or metric ?

13. A multidimensional cube records a set of data derived from:

14. Changing the view of the data to a greater level of detail is known as:

15. Which of the following rules would be considered the central core of OLAP?

16. In a star schema, the central table which contains the individual facts being stored in the database is called a:

17. In the Discovery model of Data Mining, the emphasis is on which of the following?

18. The main objective of Data Mining is:

19. Metadata does not include:

20. The requirement that the datawarehouse RDBMS server must support hundreds and thousands of concurrent users while maintaining an acceptable query performance is known as:

21. Which of the following type of data is most likely to be stored on some form of mass storage ?

22. The logical organisation of data in a database is called:

23. A means of extending the data accessible to the end user beyond that which is stored in the OLAP server is know as :

24. In which component of the enterprise is the data re-organised for analysis and information extracted from the data?

25. The movement of data from one environment to another is known as:

26. Changing the view of the data to a higher level of aggregation is known as:

27. SQL stands for:

28. The main impetus behind data warehousing was:

29. The data warehouse is typically a large database on a high performance SMP system. Here SMP stands for:

30. Given the following steps between raw data and extracted knowledge, arrange them in the correct order:1 Data mining2 Transformation3 Selection4 Pre-processing5 Interpretation and Evaluation

31. Data Mining is also known as

32. The Metadata of the data warehouse should at least contain:

33. Which of the following stage is concerned with the extraction of patterns from the data?

34. Data quality management refers to the fact that:

35. Which of the following is not true regarding the process of Data Mining?

36. Which of the following would be the only similarity between a datawarehouse and OLTP system?

37. Which of the following statements is incorrect regarding Data Mining?

38. The modification of data as it is moved into the data warehouse is:

39. A datawarehouse should be able to implement advanced query functionality. This means :

40. Which technique of Data Mining involves developing mathematical structures with the ability to learn?

41. Which Data Mining function/technique is used to analyse a collection of records over a period of time?

42. A structure that stores multi-dimensional information, having one cell for each possible combination of dimensions is known as:

43. HOLAP stands for:

44. Which of the following would not be an application of Data Mining in the banking field?

45. In a star schema, a table which contains data about one of the dimensions is called a:

46. ROLAP stands for:

47. Replication refers to the:

48. Normalization applied to the dimension tables of a star schema is known as:

49. A multi-dimensional data set is sparse if:

50. Data Volatility describes:

51. Which of the following queries would be correlated with a Data warehouse?

52. Granularity refers to the:

53. The main objects used by OLAP programs are:

54. The term OLAP was coined by:

55. Which of the following techniques can be used to improve query performance?

56. A slice is:

57. Which of the following would not be considered as a variable affecting the design of an OLAP system?

58. Normalisation is:

59. OLAP queries can be characterised as on-line transactions that do not:

60. Which of the following are the modes of OLAP?

61. All else being equal, which of the following elements of a single MDX WHERE clause will evaluate first?

62. Which of the following is a required property of information passed to the Microsoft Sequence Clustering Algorithm?

63. Online extraction process falls under which type of data extraction method?

64. What property do Router Transformations and Filter Transformations have in common?

65. Where is the OLAP page pool stored in memory in an Oracle Database 10g and later?

66. Without deliberate security measures, which of the following MDX clauses is susceptible to injection attack?

67. What is a slice in the context of Amazon Redshift?

68. Which of the following environments has more indexes?

69. What is true of querying normalized data in a relational database for the purposes of business analysis?

70. Which of the following is not an advisable implementation of division in MDX?

71. Which of the following is not TRUE about subject oriented characteristics of a data warehouse?

72. Which of the following is an appropriate method for mitigating the database explosion associated with sparse dimensions?

73. What is the principal disadvantage of Type 3 Slowly Changing Data management?

74. Which of the following is not a property of a perspective?

75. When is a column-based engine a more appropriate architecture for a Data Warehouse than a row-based engine?

76. Which of the following applies to Fact Tables?

77. Which of the following is the most appropriate data structure for indexing a MOLAP Cube?

78. Among the following, which is NOT the objective of clustering?

79. In order to populate the data warehouse, which of the following set of operations are appropriate?

30.
Given the following steps between raw data and extracted knowledge, arrange them in the correct order:
1 Data mining
2 Transformation
3 Selection
4 Pre-processing
5 Interpretation and Evaluation