Course Hero Logo

Question 3 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 69 - 72 out of 78 pages.

Question3CorrectMark 1.00 out of 1.00Flag questionQuestion textWhich of the following business intelligence tools performs operations on data based on formulas created by the end user?Select one:a. Spreadsheetb. Drill-down analysisc. Online analytical processingd. Data miningFeedbackANS: ARATIONALE: Business managers often import data into a spreadsheet program, which then can perform operations on the databased on formulas created by the end user. Spreadsheets are also used to create useful reports and graphs based on that data.Question4CorrectMark 1.00 out of 1.00Flag questionQuestion textIn-memory databases (IMDBs) have become feasible because of the decrease in _____ capacities.Select one:a. random access memory (RAM)b. read-only memory (ROM)c. random access memory (RAM)d. read-only memory (ROM)FeedbackANS: CRATIONALE: In-memory databases (IMDBs) have become feasible because of the increase in random access memory (RAM)
capacities and a corresponding decrease in RAM costs. In addition, in-memory databases perform best on multiple multicoreprocessors (which have become more common and affordable) that can process parallel requests to the data, further speedingaccess to and processing of large amounts of data.Question5CorrectMark 1.00 out of 1.00Flag questionQuestion textWhich of the following is a special-purpose programming language used for accessing and manipulating data stored in a relationaldatabase?Select one:a. SQLb. FORTRANc. JAVAd. COBOLFeedbackANS: ARATIONALE: SQL is a special-purpose programming language for accessing and manipulating data stored in a relational database.SQL databases conform to ACID properties (atomicity, consistency, isolation, and durability) that guarantee database transactionsare processed reliably and ensure the integrity of data in the database.Question6CorrectMark 1.00 out of 1.00Flag questionQuestion textWhich of the following steps in an extract-transform-load (ETL) process draws desired data from various data sources to update adata warehouse?Select one:a. Extractb. Autorunc. Loadd. TransformFeedback
ANS: 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. During the extract step, the data is also screened for unwanted orerroneous values; data that fails to pass the edits is rejected.Question7CorrectMark 1.00 out of 1.00Flag questionQuestion textA _____ is a database that stores large amounts of historical data in a form that readily supports analysis and management decisionmaking in an organization.Select one:a. data structureb. data warehousec. data profiled. data guardFeedbackANS: BRATIONALE: A data warehouse is a database that stores large amounts of historical data in a form that readily supports analysisand management decision making. Many organizations employ data warehouses to hold the data they need to make key businessdecisions.

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