WGU C724 Information Systems Management Unit 4 Module 4 Already Passed

WGU C724 Information Systems Management Unit 4 Module 4 Already Passed 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. Online transaction processing What does OLTP stand for? a.) Online tracking processing b.) Online transcript processing c.) Online transaction processing d.) Offline transaction processing 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 decisions. b.) Database applications enable businesses to store and analyze essential sales data. c.) Database applications enables businesses to develop and market new products.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 Redundancy What is not a benefit of database normalization? a.) Redundancy b.) Organization c.) Flexibility d.) Consistency Structured query language What computer language is used with relational database applications? a.) Javascript b.) Cobol c.) Structured query language Petabytes What is the typical data set size of big data? a.) Petabytes b.) Bytes c.) Terabytes Data warehousing replaces costly ERP systems What is NOT a data warehousing benefit to business?a.) Data warehousing replaces costly ERP systems. b.) Data warehousing improves decision making. c.) Data warehousing delivers business Intelligence. 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. 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. Data mining is the process of analyzing data to gain insight or intelligence 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.