CS614 Quiz No. 1 Solution and Discussion

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