Recent Topics


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
 

Hello Cyberians, We are hiring Global Moderator. Cheers!
Contact Us!
How to allow Copy Quiz VU! Download Chrome Extension!

Online Users

  • 1
  • 2
  • 30
  • 3
  • 2
  • 5
  • 2

2
Online

67
Users

422
Topics

1.2k
Posts

About Us!

Cyberian offers practice exercises, Learning videos, and a Virtual learning dashboard that empower learners to study at their home pace in and outside of the classroom. We tackle math, science, computer programming, Bio, management sciences, history, art history, economics, and more. Our math missions guide learners from kindergarten to calculus using state-of-the-art, adaptive technology that identifies strengths and learning gaps. We've also partnered with institutions like VU, AIOU, Academy of Sciences, and MIT to offer specialised content.
Cyberian Mobile App

Suggested Topics

  • 2
  • 30
  • 1
  • 5
  • 3
  • 2
  • 2
  • 2
| |