Data Warehousing (May – 2018) [IDOL - Revsied Course | Question Paper]

Data Warehousing (May - 2018) [IDOL - Revsied Course | Question Paper]

DOWNLOAD @
☛ PDF
☛ Text
☛ SlideShare
☛ GitHub
☛ G-Drive
☛ Torrent
☛ Pinterest
☛ YouTube

Time: 3 Hours

Total Marks: 100

NOTES:

(1) All Question are Compulsory.

(2) Make suitable assumptions wherever necessary and state the assumptions made.

(3) Answers to the same question must be written together.

(4) Numbers to the right indicate marks.

(5) Draw neat labeled diagrams wherever necessary.

Q.1 Attempt any two of the following: (10 Marks)

(A) Write a short note on database management system.

(B) How transaction processing can be parallelized?

(C) Write a short note on ETL mapping.

(D) Write a short note on building the metadata infrastructure.

Q.2 Attempt any three of the following: (15 Marks)

(A) Write a short note on star schema.

(B) Write a short note on interactive sector.

(C) Explain data warehouse with respect to referential integrity.

(D) Write a short note on meta data.

(E) Differentiate between structured and unstructured data.

(F) Write a short note on lifecycle of Data Warehouse.

Q.3 Attempt any three of the following: (15 Marks)

(A) Differentiate between active and passive repositories.

(B) Briefly explain internal and external taxonomy.

(C) Explain spiral model methodology in brief.

(D) What is statistical processing with respect to data warehousing?

(E) Define data marts and exploration facility.

(F) What is project based data?

Q.4 Attempt any three of the following: (15 Marks)

(A) Explain in brief ETL data quality monitor.

(B) What is a granular data?

(C) Explain the importance of encryption process.

(D) How data access can be protected in DW?

(E) Explain in brief how to monitor DW environment.

(F) Write a short note on attack sensing.

Q.5 Attempt any three of the following: (15 Marks)

(A) Briefly explain discrete data.

(B) Explain audit trail with respect to ETL.

(C) Write a short note on time variant data.

(D) Define role of ETL in brief.

(E) Explain exception flow of data.

(F) Explain ETL in batch mode.

Q.6 Attempt any three of the following: (15 Marks)

(A) Write a short note on homegrown versus third party granularity manager.

(B) Define analytical response time.

(C) How transactions can be separated into classes?

(D) Write a short note on creating enterprise metadata.

(E) What are service level agreements? Explain in brief.

(F) Write a short note on data partitioning.

Q.7 Attempt any three of the following: (15 Marks)

(A) Explain in brief physical design process.

(B) Explain process of DW implementation.

(C) Explain data warehouse deployment.

(D) Define DW maintenance.

(E) Write a short note on data warehouse.

(F) Write a short note on growth of DW.