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.) Sc
...
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.
[Show More]