Coding Tech Life: Data Warehousing

Showing posts with label Data Warehousing. Show all posts

Data Warehousing - Quiz 3 - BITS WILP - Mtec Software Systems - 2017

Data Warehousing - Quiz 3

BITS WILP - Mtec Software Systems - 2017

1. Which of the following are the characteristic of OLAP.

a)Contains current and historical data

b)Generally read only

c)Very low analytical capabilities

d)Optimization of database for analysis

Choose the correct option

Select one:

a. Only c & d

b. All

c. Only a & b

d. Only a, b & d

Ans: d. Only a, b & d

2.Match the following:

1) B-tree Index a) Data address in each entry

2) Bitmapped Index b) Combined data and index segments

3) Clustered Index c) Data address in each leaf node

Choose the correct option

Select one:

a. 1-c 2-b 3-b

b. 1-b 2-c 3-a

c. 1-c 2-a 3-b

d. 1-b 2-c 3-a

Ans: c. 1-c 2-a 3-b

3. Which of the following is the correct control flow in the case of ROLAP?

Notation: Analytical Server (AS), Desktop Client (DC), RDBMS Server (RS)

Select one:

a. DC -> RS -> AS -> RS -> DC

b. RS -> DC -> AS -> DC -> RS

c. DC -> AS -> RS -> AS -> DC

d. None of the Options

Ans: c. DC -> AS -> RS -> AS -> DC

4. Match the following:

1) ROLAP a) It makes use of Multidimensional Databases

2) MOLAP b) It makes use of Relational Databases

3) HOLAP c) It provides portability to the users

4) DOLAP d) It makes use of both Relational and Multidimensional databases

Choose the correct option

Select one:

a. 1-b 2-c 3-a 4-d

b. 1-c 2-b 3-a 4-d

c. 1-b 2-a 3-d 4-c

d. 1-c 2-d 3-b 4-a

Ans: c. 1-b 2-a 3-d 4-c

5. Which of the following is not an advantage of B-Tree Indexing

Select one:

a. Ease of maintenance

b. Works well with data with low selectivity

c. Simplicity

d. Good speed of data retrieval

Ans: b. Works well with data with low selectivity

6. Deliberate splitting of a large table and its index data into manageable parts is called ______________

Select one:

a. Indexing

b. Clustering

c. Partitioning

d. Aggregation

Ans: c. Partitioning

7. Which of the following is the remedy that needs to be applied to the data warehouse storing data at lowest level of granularity, so that the queries requiring summary data run faster (if memory is available in plenty)?

Select one:

a. Partitioning

b. Aggregation

c. Indexing

d. Clustering

Ans: b. Aggregation

8. Which below operation is the viewing of cross-tab (Single dimensional) with a fixed value of one attribute

Select one:

a. Slicing

b. Pivoting

c. Both A and B

d. Dicing

Ans: a. Slicing

9. The operation of moving from coarser-granularity data to a finer-granularity is called as ________.

Select one:

a. Pivoting

b. Dicing

c. Rollup

d. Drill down

Ans: d. Drill down

10. Which kind of partitioning will result in same number of columns in each partition but may have different number of rows.

Select one:

a. None of the above

b. Horizontal

c. Both a and b

d. Vertical

Ans: b. Horizontal

Data Warehousing Comprehensive Examination Question Paper - 2017 Regular BITS PILANI WILP MTec Software Systems

Data Warehousing

Comprehensive Examination Question Paper - 2017 Regular

BITS PILANI WILP MTec Software Systems

Data Warehousing Mid-semester Examination Question Paper - 2017 Regular BITS PILANI WILP MTec Software Systems

Data Warehousing

Mid-semester Examination Question Paper - 2017 Regular

BITS PILANI WILP MTec Software Systems

Data Warehousing - Quiz 2 BITS WILP - Mtec Software Systems - 2017

Data Warehousing - Quiz 2

BITS WILP - Mtec Software Systems - 2017

1.Dimension table is related to fact-table in which kind of relationship?
Select one:
a. one-to-one.
b. many-to-many.
c. one-to-many.
d. many-to-one.

Ans: b. many-to-many.

2.Snowflake schema is more normalized compared to star schema.
Select one:
a. True
b. False

Ans: a. True

3.In case of Retail Store Database, Customer Dimension is which kind of dimension?
Select one:
a. Junk Dimension
b. Slowly Changing Dimension
c. Rapidly Changing Dimension
d. Miscellaneous Dimension

Ans: b. Slowly Changing Dimension

4.Which of the following is/are not data transformation task(s)?
Select one:
a. Conversion
b. Selection
c. Rearrangement
d. Reduction

Ans: d. Reduction

5.Data loading requires data warehouse to be in offline mode.
Select one:
a. False
b. True

Ans: a. False

6.Which of the following is not one of the principles pertaining to Type-2 change?
Select one:
a. There is a need to preserve history in Data Warehouse.
b. They ae used to compare performance across the transitions.
c. This type of change partitions the history in the Data Warehouse.
d. Every change for the same attribute must be preserved.

Ans: b. They ae used to compare performance across the transitions.

7.In this technique of Data Loading, if primary key of incoming record matches with that of some already existing record, matching target record is updated
Select one:
a. Destructive Merge
b. Load
c. Constructive Merge
d. Append

Ans: a. Destructive Merge

8.Immediate extraction of data using special stored procedures that are fired when certain pre-defined events occur is called _____________
Select one:
a. Capture through Transaction Logs
b. Capture through Database Triggers
c. Capture based on date and timestamp
d. Capture in Source Application

Ans: b. Capture through Database Triggers

9.The type of key that does not have any built-in meaning and is simply system generated sequence numbers is ________________
Select one:
a. Surrogate Key
b. Concatenated Primary Key
c. Primary Key
d. Foreign Key

Ans: a. Surrogate Key

10.Which of the following is NOT a fully additive measure?
Select one:
a. Products returned
b. Percentage of profit
c. Revenue generated in rupees
d. Products ordered

Ans: b. Percentage of profit

Data Warehousing - Quiz 1 - 2017 BITS WILP - Mtec Software Systems

Data Warehousing - Quiz 1

BITS WILP - Mtec Software Systems - 2017

1_________ component involves purging source data that is not useful and separating out source records into new combinations.
Select one:
a. Source Data
b. Data Staging
c. Management and Control
d. Data Storage

Ans : b. Data Staging

2 ______ is the navigational map of the data warehouse.
Select one:
a. Operational Metadata
b. Extraction Metadata
c. End-User Metadata
d. Transformation Metadata

Ans: c. End-User Metadata

3)Strategic information IS NOT used for which for the following purpose?
Select one:
a. formulate the business strategies
b. Increase the customer base
c. process business transactions (e.g., generate invoice, payments, orders, etc.)

Ans: c. process business transactions (e.g., generate invoice, payments, orders, etc.)

4). __________ are either identical or strict mathematical subsets of the most granular, detailed dimension.
Select one:
a. Factless Fact Tables
b. Conformed Facts
c. Conformed Dimensions
d. Degenerate Dimensions

Ans : c. Conformed Dimensions

5)One of the primary benefits of ___________ keys is that they buffer the data warehouse environment from operational changes.
Select one:
a. None of the Options
b. Foreign
c. Natural
d. Surrogate

Ans: d. Surrogate

6).In a dimension table ________ conveys the level of detail associated with the fact table measurements.
Select one:
a. grain
b. attribute
c. dimension
d. metadata

Ans: a. grain

7)The precursors required to load the data into the data warehouse presentation area are:
Select one:
a. Combining data from multiple sources
b. All the options
c. Deduplicating data
d. Cleansing the data

Ans: b. All the options

8)What is / are the feature/ features of Data Warehouse?
Select one:
a. Data Granularity
b. Time - Variant Data
c. Nonvolatile Data
d. All of the Options

Ans: d. All of the Options

9).____________ modeling is a design technique that seeks to remove data redundancies.
Select one:
a. 1NF
b. 3NF
c. 2NF
d. BCNF

Ans: b. 3NF

10) ____________ is a systematic process for capturing, integrating, organising and communicating knowledge accumulated by employees.
Select one:
a. Agent Technology
b. Multidimensional Analysis
c. ERP
d. Knowledge Management

Ans : d. Knowledge Management

Data Warehousing - SSZG515 Comprehensive Question Paper - 2017 Make up BITS PILANI WILP MTec Software Systems

Data Warehousing - SSZG515

Comprehensive Question Paper - 2017 Make up

BITS PILANI WILP MTec Software Systems

Data Warehousing Quiz 3 BITS WILP - Mtec Software Systems

Data Warehousing Quiz 3

BITS WILP - Mtec Software Systems

1. Theoretically, what kind of views we can materialize?
Select one:
a. Any kind of view can be materialized
b. Only involving joins & aggregates
c. Only involving joins
d. Only involving aggregation

Ans: a. Any kind of view can be materialized

2. For partitioning wrt time dimension, which kind of partitioning method is most suitable
Select one:
a. Hash partitioning
b. Composite partitioning
c. Range partitioning
d. List partitioning

Ans: c. Range partitioning

3. User queries and application programs need not be aware of
Select one:
a. Existing partitions only
b. Existing partitions, aggregates, and materialised views
c. Existing aggregates only
d. Existing materialized views only

Ans: b. Existing partitions, aggregates, and materialised views

4. Online aggregation:
Select one:
a. Improves query performance
b. Uses blocking algorithms for evaluating relational operators
c. Does not allow users to prioritise
d. Provides early trends

Ans: d. Provides early trends

5. Size of the bitmap index on a column of a relation R increases with
Select one:
a. An increase in number of attributes of R
b. An increase in column cardinality
c. An increase in the width of the column
d. An increase in number of queries on R

Ans: b. An increase in column cardinality

6. The most generalized term:
Select one:
a. Precomputed joins
b. Precomputed joins with aggregates
c. Precomputed aggregates
d. Materialized views

Ans: c. Precomputed aggregates

7. A query performance enhancing technique that has the least space
overheads:
Select one:
a. View materialization
b. Aggregations
c. Bitmap indices
d. Partitioning

Ans: d. Partitioning

8. Bitmap indexes are:
Select one:
a. Multidimensional indexes
b. Dynamic indexes
c. Multilevel indexes
d. Dense indexes

Ans: a. Multidimensional indexes

9. The aggregate navigation algorithm orders the base and aggregated
fact tables from
Select one:
a. Smallest to the biggest in terms of space requirement
b. Most frequently used to least frequently used
c. Smallest to the biggest in terms of number of tuples
d. 3-way to 2-way to 1-way to base level

Ans: c. Smallest to the biggest in terms of number of tuples

10. Aggregate navigator is a:
Select one:
a. Materialized view generator
b. Middleware
c. End-user tool
d. View maintenance software

Ans: b. Middleware

11. Partitioning wrt time dimension is recommended because:
Select one:
a. It is easier to do as compared to partitioning wrt other dimensions
b. it can be done using range partitioning
c. It facilitates incremental view maintenance
d. It facilitates incremental back up

Ans: c. It facilitates incremental view maintenance
d. It facilitates incremental back up

12. For partitioning wrt product dimension, which kind of partitioning
method is most suitable
Select one:
a. Hash partitioning
b. Composite partitioning
c. Range partitioning
d. List partitioning

Ans: d. List partitioning

13. Which kind of partitioning would create almost equal size partitions:
Select one:
a. Hash partitioning
b. Composite partitioning
c. Range partitioning
d. List partitioning

Ans: a. Hash partitioning

14. Materialized views:
Select one:
a. Store redundant data
b. Always give current data like views
c. Do not need maintenance like views
d. Do not incur space overheads

Ans: a. Store redundant data

15. From the ETL point of view, it is simplest to handle:
Select one:
a. Highly aggregated data
b. Finest granularity data

c. Lightly aggregated data
d. Medium granularity data

Ans: b. Finest granularity data