logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Data Warehousing See What Others Are Saying!
  • Question

  • Data transformation includes which of the following?


  • Options
  • A. A process to change data from a detailed level to a summary level
  • B. A process to change data from a summary level to a detailed level
  • C. Joining data from one source into various sources of data
  • D. Separating data from one source into various sources of data

  • Correct Answer
  • A process to change data from a detailed level to a summary level 

    • More questions

    • 1. A benefit of using a stored procedure is that it can be distributed to client computers.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. Nonclustered indexes are faster than clustered indexes for retrieval.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. A null value is assigned when no other value applies.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. With SQL Server pessimistic locking, no lock is obtained until the user updates the data.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. In an enterprise-class database system, business users interact directly with database applications, which directly access the database data.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. XML is a rapidly developing scripting language that may, in conjunction with XHTML, replace HTML.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. With an asynchronous system, the requesting system waits for a response in real time.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. Business Intelligence (BI) systems do not obtain their data by which of the following means?

    • Options
    • A. Read and process data from an operational database
    • B. Process transactions
    • C. Process extracts from operational databases
    • D. Process data purchased from data vendors
      • Discuss
    • 9. An SQL Server reserved word must be placed in brackets. If the word is not in brackets, SQL Server will try to interpret it as the name of one of its special words.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. The Windows operating system and Windows applications are event driven.

    • Options
    • A. True
    • B. False
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.