WGU C724 Information Systems Management Unit 4 Module 4 COMPLETE SOLUTION

WGU C724 Information Systems Management Unit 4 Module 4 COMPLETE SOLUTION 1. Schema is a planned design of the data organization: What is a database schema? a.) Schema is a planned design of the data organization. b.) Schema are used when referring to foreign key and primary key. c.) Schema is a term used by DBMS and stands for a structured query. 2. Online transaction processing: What does OLTP stand for? a.) Online tracking processing b.) Online transcript processing c.) Online transaction processing d.) Offline transaction processing 3. Database applications enable businesses to store and analyze essential sales data: How can database applications help managers respond to changing market conditions? a.) Database applications arm businesses with big data to make important deci- sions. b.) Database applications enable businesses to store and analyze essential sales data. c.) Database applications enables businesses to develop and market new prod- ucts. 4. Abstract data model: Which of the following is NOT a data model used when mapping business processes, relationships, and data requirements? a.) Physical data model b.) Abstract data model c.) Conceptual data model 5. Redundancy: What is not a benefit of database normalization? a.) Redundancy b.) Organization c.) Flexibility d.) Consistency 6. Structured query language: What computer language is used with relational database applications? a.) Javascript b.) Cobol c.) Structured query language 7. Petabytes: What is the typical data set size of big data? a.) Petabytes b.) Bytes c.) Terabytes 8. Data warehousing replaces costly ERP systems: What is NOT a data ware- housing benefit to business? a.) Data warehousing replaces costly ERP systems. b.) Data warehousing improves decision making. c.) Data warehousing delivers business Intelligence. 9. Extraction means getting data from database sources: What is the best definition for data extraction? a.) Extraction means copying a database to data warehouse. b.) Extraction means backing up the data warehouse. c.) Extraction means getting data from database sources. 10. Partitioning means dividing a database for manageability: What is the definition of a partition in database concepts? a.) Partitioning means distributing a database for availability. b.) Partitioning means dividing a database for manageability. c.) Partitioning means backing up database for business continuity. 11. Data mining is the process of analyzing data to gain insight or intelli- gence: Which of the following best describes the process of data mining? a.) Data mining is the process of organizing data for database design. b.) Data mining is the process of creating intelligent databases. c.) Data mining is the process of analyzing data to gain insight or intelligence. 12. Cut and paste: In online analytical processing applications, which of the following is not a basic analytical operation? a.) Slicing and dicing b.) Consolidation c.) Drilling down d.) Cut and paste 13. DBMS: What application does one use to query and administer databases? a.) DBMS b.) SQL