Quiz Discussion

The active data warehouse architecture includes which of the following?

Course Name: SQL -Structured Query Language

  • 1]

    At least one data mart

  • 2]

    Data that can extracted from numerous internal and external sources

  • 3]

    Near real-time updates

  • 4]

    All of the above

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

A data warehouse is which of the following?

  • 1]

    Can be updated by end users

  • 2]

    Contains numerous naming conventions and formats

  • 3]

    Organized around important subject areas

  • 4]

    Contains only current data

Solution
2
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
3
Discuss

A star schema has what type of relationship between a dimension and fact table?

  • 1]

    One-to-one

  • 2]

    Many-to-many

  • 3]

    One-to-many

  • 4]

    All of the above

Solution
4
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
5
Discuss

Transient data is which of the following?

  • 1]

    Data in which changes to existing records cause the previous version of the records to be eliminated

  • 2]

    Data in which changes to existing records do not cause the previous version of the records to be eliminated

  • 3]

    Data that are never altered or deleted once they have been added

  • 4]

    Data that are never deleted once they have been added

Solution
6
Discuss

A multifield transformation does which of the following?

  • 1]

    Converts data from one field into multiple fields

  • 2]

    Converts data from multiple fields into one field

  • 3]

    Converts data from multiple fields into multiple fields

  • 4]

    All of the above

Solution
7
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
8
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
9
Discuss

A database management system (DBMS) is a

  • 1]

    hardware system used to create, maintain and provide controlled access to a database

  • 2]

    a software system used to create, maintain and provide controlled access to a database

  • 3]

    hardware system used to create, maintain, and provide uncontrolled access to a database

  • 4]

    a software system used to create, maintain, and provide uncontrolled access to a database

Solution
10
Discuss

Legacy data is which of the following?

  • 1]

    Data contained in a newly-installed system

  • 2]

    Data contained in a file system

  • 3]

    Data rejected during the installation of a new system

  • 4]

    Data contained by a system used prior to the installation of a new system

Solution
# Quiz