Quiz Discussion

A data warehouse uses

Course Name: SQL -Structured Query Language

  • 1]

    partial operational data

  • 2]

    future operational data

  • 3]

    historical operational data

  • 4]

    health care data

Solution
No Solution Present Yet

Top 5 Similar Quiz - Based On AI&ML

Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api

# Quiz
1
Discuss

Data transformation includes which of the following?

  • 1]

    A process to change data from a detailed level to a summary level

  • 2]

    Joining data from one source into various sources of data

  • 3]

    A process to change data from a summary level to a detailed level

  • 4]

    Separating data from one source into various sources of data

Solution
2
Discuss

Data scrubbing is which of the following?

  • 1]

    A process to reject data from the data warehouse and to create the necessary indexes

  • 2]

    A process to load the data in the data warehouse and to create the necessary indexes

  • 3]

    A process to upgrade the quality of data after it is moved into a data warehouse

  • 4]

    A process to upgrade the quality of data before it is moved into a data warehouse

Solution
3
Discuss

The extract process is which of the following?

  • 1]

    Capturing all of the data contained in various operational systems

  • 2]

    Capturing a subset of the data contained in various operational systems

  • 3]

    Capturing a subset of the data contained in various decision support systems

  • 4]

    Capturing all of the data contained in various decision support systems

Solution
4
Discuss

A shared database should

  • 1]

    be accurate and available

  • 2]

    be secure

  • 3]

    provide for backup and recovery

  • 4]

    All of the above

Solution
5
Discuss

An enterprise data model is

  • 1]

    a graphical model that shows the high-level entities for an organization

  • 2]

    a graphical model that shows all entities for an organization

  • 3]

    a non-graphical model that shows the high-level entities for an organization

  • 4]

    a non-graphical model that shows all entities for an organization

Solution
6
Discuss

Reconciled data is which of the following?

  • 1]

    Data stored in the various operational systems throughout the organization

  • 2]

    Current data intended to be the single source for all decision support systems

  • 3]

    Data stored in one operational system in the organization

  • 4]

    Data that has been selected and formatted for end-user support applications

Solution
7
Discuss

The generic two-level data warehouse architecture includes which of the following?

  • 1]

    At least one data mart

  • 2]

    Data that can be extracted from numerous internal and external sources

  • 3]

    Near real-time updates

  • 4]

    All of the above

Solution
8
Discuss

An operational system is which of the following?

  • 1]

    A system that is used to run the business in real-time and is based on historical data

  • 2]

    A system that is used to run the business in real-time and is based on current data

  • 3]

    A system that is used to support decision making and is based on current data

  • 4]

    A system that is used to support decision making and is based on historical data

Solution
9
Discuss

An enterprise database is which of the following?

  • 1]

    A database designed to support only users external to an organization

  • 2]

    A database designed to support an entire organization

  • 3]

    A database designed to support a single PC

  • 4]

    A database designed to support a relatively small group

Solution
10
Discuss

A database application can perform which of the following activities?

  • 1]

    Add records

  • 2]

    Update records

  • 3]

    Read records

  • 4]

    All of the above

Solution
# Quiz