GoConqr has a new look! Let us know what you think.

Sign up free

Quiz

Q15

Diocar Cruz 16 questions

Take the quiz

Questions in this quiz (16)

  1. 1One of the primary goals of a relational database is to eliminate data redundancy by recording each piece of data in only one place in the database. What does the elimination of redundancy do for a database?
    1. AReduces disk space requirements
    2. BMakes updating information easier
    3. CImproves information quality
    4. DAll of the THESE ARE CORRECT
  2. 2Why do firms create DW (data warehouses) when they alreay have databases ?
    1. ANumbers and types of operational databases increased as businesses grew
    2. BMany companies had information scattered across multiple systems with different formats
    3. CCompleting reporting requests from numerous operational systems took days or weeks
    4. DAll of these are correct
  3. 3In DW(Datawarehousing) literature, what does ETL refer to?
    1. AIt is a process of entering, tracking, and loading data into a database
    2. BIt is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads(unloads) it into(from) a data warehouse
    3. CIt is a process performed at the end of the data warehouse model prior to putting the information in a cube
    4. DIt is a process performed at the beginning of the data mining model
  4. 4Which of the following contains a subset of data warehouse information?
    1. AData miner
    2. BData mart
    3. CData pool
    4. DData analyzing tool
  5. 5Which of the following refers to the representation of multidimensional information?
    1. ABlock
    2. BSquare
    3. CColumn
    4. DCube
  6. 6Which of the following is not an example of schemata used to provide multidimensionality of DW.
    1. AStar Schema
    2. BConstellation Schema
    3. CCube schema
    4. DSnowflake Schema
  7. 7Which of the following is not a correct statement about DW?
    1. AEnforcing completeness often weakens the accuracy of data
    2. BStar Schema uses nomalized tables as its dimension tables
    3. CSnowflake Schema uses nomalized tables as its dimension tables
    4. DETL is an important process in creating a DW because data extracted from data bases designed for various applications tend to show inconsistencies.
  8. 8Which of the following refers to the process of analyzing data to extract information not offered by the raw data alone?
    1. AData integrity
    2. BData mart analysis
    3. CData mining
    4. DData extraction
  9. 9Often managers have so much data and information that they cannot make a decision based on those. Our textbook author described this new challenge of information overload as_____________.
    1. AData rich, information poor
    2. BData rich, content poor
    3. CData rich, communication poor
    4. DData rich, intelligence
  10. 10Which of the following is not one of the three V's that characterize BIG Data?
    1. AVolumn
    2. BVariance
    3. CVariety
    4. DVelocity

Information

Description
Computer Science Quiz on Q15, created by Diocar Cruz on 09/12/2017.
Language
English
Views
4
Rating
No ratings yet
Rate this quiz
Rate this quiz

Feedback

What is it about?

What do you think of the new look?

How do you like it?