Course Hero Logo

Question 8 correct mark 100 out of 100 flag question

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 71 - 74 out of 78 pages.

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

Term
Fall
Professor
NoProfessor
Tags
Data Management, Data Mining, own data requests

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture