Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 15 views

    SQL Server 2019

    Uploaded by

    rikor15464
    This document contains questions from an examination on the topic of data warehousing with SQL Server 2012. It covers key concepts related to data warehousing architectures, logical and physical design, ETL processes, data quality management, and business intelligence. Some of the questions ask for definitions or explanations of common data warehousing terms and concepts, while others involve explaining specific aspects of data warehousing such as architectures, processes, or tools.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    SQL Server 2019

    Uploaded by

    rikor15464
    15 views4 pages
    This document contains questions from an examination on the topic of data warehousing with SQL Server 2012. It covers key concepts related to data warehousing architectures, logical and physical design, ETL processes, data quality management, and business intelligence. Some of the questions ask for definitions or explanations of common data warehousing terms and concepts, while others involve explaining specific aspects of data warehousing such as architectures, processes, or tools.

    Original Description:

    It is paper for sql

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains questions from an examination on the topic of data warehousing with SQL Server 2012. It covers key concepts related to data warehousing architectures, logical and physical design, ETL processes, data quality management, and business intelligence. Some of the questions ask for definitions or explanations of common data warehousing terms and concepts, while others involve explaining specific aspects of data warehousing such as architectures, processes, or tools.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    15 views4 pages

    SQL Server 2019

    Uploaded by

    rikor15464
    This document contains questions from an examination on the topic of data warehousing with SQL Server 2012. It covers key concepts related to data warehousing architectures, logical and physical design, ETL processes, data quality management, and business intelligence. Some of the questions ask for definitions or explanations of common data warehousing terms and concepts, while others involve explaining specific aspects of data warehousing such as architectures, processes, or tools.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 4

    11111111111111111111111111I1111111111111111111111111111111111I111111111111111111

    *R1-003-1UJ60C2·

    RY-003-1036002 Seat No. _


    B. C. A. (Sem. VI) (CBCS) (WIF-2016) Examination
    March - 2019
    CS - 32 : Data Warehousing With SQL Server 2012

    Faculty Code 003


    Subject Code 1036002

    Time : Hours] [Total Marks : 70

    1 (A) Attempt the following : 4

    (]) What. is DWH ?

    (2) Give full form of DDS.

    (3) What is a stage in data store ?

    (4) What is third party data?

    (B) Attempt the following : (Any One) 2

    (1) Explain Future trends in Data Warehousing.

    (2) Explain Data warehouse types.

    (C) Attempt the following: (Any One) 3


    (1) Explain Data Flow Architecture.

    (2) Give the advantages of Data warehousing.

    (D) Attempt the following: (Any One) 5


    (1) Explain Data Warehouse Architecture.

    (2) Explain lOT and Cloud in the term of data


    warehousing.

    RY-003-1036002 ) 1 [ Contd ....


    2 (A) Attempt the following : 4

    (1) Give the full form of DID.

    (2) Logical Design Entity known as In


    Physical design.

    (3) What is 'fable space ?

    (4) What is Role playing dimension?

    (B) Attempt the following: (Any One) 2


    (1) Give the steps for Logical design data warehouse.

    (2) Explain types of dimension.

    (C) Attempt the following : (Any One) 3

    (1) Give the difference between Fact table and


    Dimension table.

    (2) Explain Out trigger dimension.

    (D) Attempt the following: (Any One) 5

    (1) Give the difference between Logical design and


    Physical design.

    (2) Explain Fact table and Dimension table with


    diagram.

    ,
    (A) Attempt the following:
    3 4

    (1) Give the full form of ETL.

    (2) Give the full form of SSIS.

    (3) Give the full form of SSDT.

    (4) Give the Full form of DTS.


    RY -003-1036002 ] 2 [ Contd ....
    (B) Attempt the following: (Any One) 2

    (1) Give the list of components of data flow task.

    (2) Give basic steps for creating package.

    (C) Attempt the following : (Any One) 3

    (1) What is meta data ?

    (2) Explain ETL in details.

    (D) Attempt the following: (Any One) 5

    (1) What is Container? Explain its types and purpose.

    (2) Explain Control Flow.

    4 (A) Attempt the following : 4

    (J) Full form of DQS.

    (2) Give the full form of DQAF.

    (3) What is the use of SSIS Script task ?

    (4) is used to generate log messages as well


    as other logics related to packages and SSIS.

    (B) Attempt the following : (Any One) 2

    (1) Draw a diagram for data matching in DQS.

    (2) Explain invalid DQS.

    (C) Attempt the following: (Any One) 3

    (1) Explain interactive process.

    (2) Write the steps for the cycle of Data Quality


    Management.

    RY-003-1036002 ) 3 [ Contd ....


    (D) Attempt the following : (Any One) 5

    (1) Explain computer assisted process.

    (2) Explain DQS matching process benefits.

    5 (A) Attempt the following : 4

    (1) Give the full form of SSDT.

    (2) What is SQL CLR ?

    (8) Give the full form of BIML.

    (4) Give the full form of BIDS.

    (B) Attempt the following : (Any One) 2

    (1) Give the contents of Analysis Service Project


    folder.

    (2) What is the use of Aggregate in SSIS ?

    (C) Attempt the following : (Any One) 3

    (1) Explain Benefits of Report Projects.

    (2) Give the steps to add Reports to a project.

    (D) Attempt the following: (Any One) 5

    (l) Explain deployment process.

    (2) Explain Business Intelligence.

    RY-003-1036002 ] 4 [ 2700/75-45 ]

    You might also like