CS614 Quiz No. 1 Solution and Discussion


  • Cyberian's

    Change Data Capture (CDC) can be challenging task because:

    • Aggregates don’t change in real time

    • Transformation of extracted data is difficult

    • Identifying the recently modified data may be difficult

    • Source systems may not support extraction of changed aggregates

    e3b9b354-2645-43f7-a151-19524150af55-image.png

    De-normalization is the process of selectively transforming normalized relations into un-normalized physical record specifications, with the aim to:

    • Well structure the data
    • Well model the data
    • Reduce query processing time
    • none

    b9abf341-9b5b-47a5-b7b9-8169293351f5-image.png

    An OLTP system is always good at ___________

    • Evolving data

    • Keeping static data

    bb817890-9163-480e-a1fb-8a9d1862fd20-image.png

    _______ can be used when some columns are rarely accessed rather than other columns or when the table has wide rows or header or both.

    • Horizontal Splitting

    • Pre-joining

    • Vertical

    cdc620a5-64ea-4d5a-a72e-019129e6a1d2-image.png

    In a fully normalized form:

    • To many Joins are required

    • Relationship lose their significance

    • no joins are required

    af1da773-fed6-41d5-b2da-58991f2e5c15-image.png

    _____________ facilitates a mobile computing paradigm.

    • DOLAP

    • HOLAP

    • ROLAP

    • MOLAP

    15e052c1-7697-42dc-b946-7f671fce111f-image.png

    Enrichment is one of the basic tasks in data ___________.

    • Extraction

    *** Transformation**

    • Loading

    • Summarization

    264bdb0a-2340-40c9-a193-28b5b957a246-image.png

    The online high performance transaction processing was evolved in _________

    • 1980
    • 1975
    • 1977
    • 1965

    4b559516-7975-4ee4-985e-fb16dc7e265c-image.png

    The process of converting entity relationship model in to dimensional model comprises of ___ steps:

    • Two

    • Three

    • Four

    • Five

    2f314c3c-8231-426f-a585-0e1db85cea8c-image.png

    Suppose the size of the attribute “Computerized National Identity Card (CNIC) no” is changed in NADRA database. This transformation refers to:

    • Format revision

    • Field splitting

    • Field decoding

    • Calculation of derived value

    1b5e8d44-ff69-4ec3-86bd-09cb0393e26c-image.png



  • Today Quiz Shared by someone (Thanks)
    History is excellent predictor of the __________. CS614

    • History is excellent predictor of the future.
    014f7f4f-3647-4d8e-936b-d8a17bc98757-image.png

    In Extract, Load, Transform (ELT) process, data transformation _____ CS614

    901dd53e-335d-4eb0-ad22-f5865e28c1fc-image.png

    The relation R will be in 2nd Normal Form if CS614
    ff57f5f4-b7a3-4bfa-8e76-6c6b2aa64df1-image.png

    Taken jointly, the extract programs or naturally evolving systems formed a spider web, also known as CS614

    Distributed Systems Architecture
    Legacy Systems Architecture
    Online Systems Architecture
    Intranet Systems Architecture
    120b59eb-6029-4d05-a5b3-93946a3f6a38-image.png

    As dimensions get less detailed (e.g., year vs. day) cubes get ____ CS614

    b855952b-7f69-4220-9040-78601e363b34-image.png

    Suppose the size of the attribute “Computerized National Identity Card (CNIC) no” is changed in NADRA database. This transformation refers to: CS614

    Format revision
    Field splitting
    Field decoding
    Calculation of derived value

    41fb525d-a82d-481c-bfaf-7cabe011560e-image.png

    OLAP is: CS614

    6db35c32-31e1-4376-89fb-b443c0fae800-image.png

    _________ provides a combination of “relational database access” and “cube” data structures within a single framework. CS614

    HOLAP (Page No. 78)
    DOLAP
    MOLAP
    ROLAP

    HOLAP provides a combination of relational database access and “cube” data structures
    within a single framework. The goal is to get the best of both MOLAP and ROLAP:
    scalability (via relational structures) and high performance (via pre-built cubes).

    73337e89-a8a7-4fe3-ba66-c47847a8a5d3-image.png

    The data has to be checked, cleansed and transformed into a ________ format to allow easy and fast access CS614

    The data has to be checked, cleansed and transformed into a unified format to allow easy and fast access.

    unified
    predefi

    0cc063a3-54b0-4f71-8a38-21a97ce84a0f-image.png

    Robotic libraries are needed for ___________ CS614

    Cubes
    Data marts
    Data warehouse
    Aggregates

    8f7b0fb2-dd48-4d8b-a796-571fbdb766b1-image.png


Log in to reply