Question8CorrectMark 1.00 out of 1.00Flag questionQuestion textThe effectiveness of a(n) _____ process is essential to ensure the success of a data warehouse.Select one:a. visual basicb. extract-transform-loadc. chamferingd. actuatingFeedback
ANS: BRATIONALE: An extract-transform-load (ETL) process is used to pull data from disparate data sources to populate and maintain thedata warehouse. An effective extract-transform-load (ETL) process is essential to ensure data warehouse success.Question9CorrectMark 1.00 out of 1.00Flag questionQuestion textWhich of the following databases is designed to store and retrieve data without rigidly implementing the ACID (atomicity,consistency, isolation, and durability) conditions associated with the relational database model?Select one:a. NoSQLb. Hadoopc. COBOLd. FlashFeedbackANS: ARATIONALE: A NoSQL database is designed to store and retrieve data in a manner that does not rigidly enforce the ACID(atomicity, consistency, isolation, and durability) conditions associated with the relational database model. The goal of a NoSQLdatabase is to provide very fast performance even as the amount of data that must be processed continues to grow.Question10CorrectMark 1.00 out of 1.00Flag questionQuestion textWhich of the following is a minor version of a data warehouse that is scaled down to meet the specific needs of a business unit?Select one:a. Data cartb. Data martc. Data walletd. Data setFeedback
ANS: BRATIONALE: A data mart is a smaller version of a data warehouse—scaled down to meet the specific needs of a business unit.Some organizations have multiple data marts, each designed to meet the needs of a different part of the organization.PHQ, a graphics firm, decides to filter its employees according to their dates of joining. Which of the following steps in the extract-transform-load (ETL) process should be taken by the firm to accomplish the task?Select one:a. Extractb. Autorunc. Loadd. TransformFeedbackANS: ARATIONALE: The extract step in an extract-transform-load (ETL) process is designed to access the various sources of data and pullfrom each source the data desired to update a data warehouse. For example, the extract process may be designed to pull only acertain subset of orders from the Orders database—such as only those orders shipped after a certain date.Question2CorrectMark 1.00 out of 1.00Flag questionQuestion textWhich of the following databases is designed to store and retrieve data without rigidly implementing the ACID (atomicity,consistency, isolation, and durability) conditions associated with the relational database model?Select one:a. NoSQLb. Hadoopc. COBOLd. FlashFeedbackANS: ARATIONALE: A NoSQL database is designed to store and retrieve data in a manner that does not rigidly enforce the ACID(atomicity, consistency, isolation, and durability) conditions associated with the relational database model. The goal of a NoSQLdatabase is to provide very fast performance even as the amount of data that must be processed continues to grow.
Upload your study docs or become a
Course Hero member to access this document
Upload your study docs or become a
Course Hero member to access this document
End of preview. Want to read all 78 pages?
Upload your study docs or become a
Course Hero member to access this document
