Discussion
Home ‣ Database ‣ Data Warehousing Comments
- Question
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
- Correct Answer
- Data in which changes to existing records cause the previous version of the records to be eliminated
- 1. 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
- 2. 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
- 3. The generic two-level data warehouse architecture includes which of the following?
Options- A. At least one data mart
- B. Data that can extracted from numerous internal and external sources
- C. Near real-time updates
- D. All of the above. Discuss
- 4. 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 Discuss
- 5. A data warehouse is which of the following?
Options- A. Can be updated by end users.
- B. Contains numerous naming conventions and formats.
- C. Organized around important subject areas.
- D. Contains only current data. Discuss
- 6. 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
- 7. 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
- 8. 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 Discuss
- 9. 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
- 10. 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
Data Warehousing problems
Search Results
Correct Answer: One-to-many
Correct Answer: A process to upgrade the quality of data before it is moved into a data warehouse
Correct Answer: Data that can extracted from numerous internal and external sources
Correct Answer: A process to change data from a detailed level to a summary level
Correct Answer: Organized around important subject areas.
Correct Answer: Current data intended to be the single source for all decision support systems.
Correct Answer: A process to load the data in the data warehouse and to create the necessary indexes
Correct Answer: All of the above
Correct Answer: The same DBMS is at each node and each DBMS works independently.
Correct Answer: All of the above.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.