logo

CuriousTab

CuriousTab

Discussion


Home Database Data Warehousing Comments

  • Question
  • A multifield transformation does which of the following?


  • Options
  • A. Converts data from one field into multiple fields
  • B. Converts data from multiple fields into one field
  • C. Converts data from multiple fields into multiple fields
  • D. All of the above

  • Correct Answer
  • All of the above 


  • Data Warehousing problems


    Search Results


    • 1. The load and index is which of the following?

    • Options
    • A. A process to reject data from the data warehouse and to create the necessary indexes
    • B. A process to load the data in the data warehouse and to create the necessary indexes
    • C. A process to upgrade the quality of data after it is moved into a data warehouse
    • D. A process to upgrade the quality of data before it is moved into a data warehouse
    • Discuss
    • 2. Reconciled data is which of the following?

    • Options
    • A. Data stored in the various operational systems throughout the organization.
    • B. Current data intended to be the single source for all decision support systems.
    • C. Data stored in one operational system in the organization.
    • D. Data that has been selected and formatted for end-user support applications.
    • Discuss
    • 3. Transient data is which of the following?

    • Options
    • A. Data in which changes to existing records cause the previous version of the records to be eliminated
    • B. Data in which changes to existing records do not cause the previous version of the records to be eliminated
    • C. Data that are never altered or deleted once they have been added
    • D. Data that are never deleted once they have been added
    • Discuss
    • 4. A star schema has what type of relationship between a dimension and fact table?

    • Options
    • A. Many-to-many
    • B. One-to-one
    • C. One-to-many
    • D. All of the above.
    • Discuss
    • 5. Data scrubbing is which of the following?

    • Options
    • A. A process to reject data from the data warehouse and to create the necessary indexes
    • B. A process to load the data in the data warehouse and to create the necessary indexes
    • C. A process to upgrade the quality of data after it is moved into a data warehouse
    • D. A process to upgrade the quality of data before it is moved into a data warehouse
    • Discuss
    • 6. An autonomous homogenous environment is which of the following?

    • Options
    • A. The same DBMS is at each node and each DBMS works independently.
    • B. The same DBMS is at each node and a central DBMS coordinates database access.
    • C. A different DBMS is at each node and each DBMS works independently.
    • D. A different DBMS is at each node and a central DBMS coordinates database access.
    • Discuss
    • 7. A transaction manager is which of the following?

    • Options
    • A. Maintains a log of transactions
    • B. Maintains before and after database images
    • C. Maintains appropriate concurrency control
    • D. All of the above.
    • Discuss
    • 8. A distributed database is which of the following?

    • Options
    • A. A single logical database that is spread to multiple locations and is interconnected by a network
    • B. A loose collection of file that is spread to multiple locations and is interconnected by a network
    • C. A single logical database that is limited to one location.
    • D. A loose collection of file that is limited to one location.
    • Discuss
    • 9. Replication should be used when which of the following exist?

    • Options
    • A. When transmission speeds and capacity in a network prohibit frequent refreshing of large tables.
    • B. When using many nodes with different operating systems and DBMSs and database designs.
    • C. The application's data can be somewhat out-of-date.
    • D. All of the above.
    • Discuss
    • 10. Which of the following is a disadvantage of replication?

    • Options
    • A. Reduced network traffic
    • B. If the database fails at one site, a copy can be located at another site.
    • C. Each site must have the same storage capacity.
    • D. Each transaction may proceed without coordination across the network.
    • Discuss


    Comments

    There are no comments.

Enter a new Comment