WGU C175 (WGUC175)

WGU C175 Study Notecards, Exam Review Questions and answers, VERIFIED. What are the values of Business Intelligence? - -- Financial value associated w/ increased profitability. - Productivity value associated with increased throughput. - Trust value (customer, employee, supplier satisfaction) as well as increased confidence in forecasting. - Risk value - decreased risk associated with decision making What are the reasons for using the Dimensional Model for Business Intelligence? - -- Sim...

c What is a broad definition of data? A.) Alphanumeric combinations that can be captured on media that a computer can read B.) Any information that can be transferred from print to digital C.) Raw facts that are captured on printed or digital media D.) Numbers that are captured on digital media b What are data? A.) Facts that have been organized in a meaningful way B.) Facts that are collected and stored in a database system C.) Facts that are the result of a query of a database system...

What is a broad definition of data? - -Raw facts that are captured on printed or digital media What are data? - -Facts that are collected and stored in a database system What is a determining characteristic of unstructured data? - -It does not follow a data model. Which is true about flat files? - -They contain no internal hierarchical organization. Which technology has no internal hierarchy? - -Flat files How were data retrieved before database management systems? - -Sequentially from simp...

What is a broad definition of data? - -Raw facts that are captured on printed or digital media What are data? - -Facts that are collected and stored in a database system What is a determining characteristic of unstructured data? - -It does not follow a data model. Which is true about flat files? - -They contain no internal hierarchical organization. Which technology has no internal hierarchy? - -Flat files How were data retrieved before database management systems? - -Sequentially from simp...

Ad Hoc Query "Spur of the moment" question Analytical Database A database focused primarily on storing historical data and business metrics used for tactical or strategic decision making. availability In the context of data security, it refers to the accessibility of data whenever required by authorized users and for authorized purposes. centralized database A database located at a single site. cloud database A database that is created and maintained using cloud services, such as Micros...

Associative Entity An associative entity is an element of the entity-relationship model. All relationships for the associative entity should be many. Attribute An attribute is a property or characteristic of an entity. Binary relationship A binary relationship is a relationship between two entity types. Candidate Key Is any column or a combination of columns that can qualify as unique key in database. Cardinality Cardinality represents the maximum number of entities that can be involved in...

field A _____ is a character or group of characters that has a specific meaning query result set The response of the DBMS to a query is the ______ file A _____ is a collection of related records semistructured Most data that can be encountered are best classified as _____ ad hoc query A(n) ____ is a spur-of-the-moment question data Information is produced by processing ____. information _____ is the result of revealing the meaning of raw facts multiuser A workgroup database is a(n) _____ ...

They can serve as a communication tool between the users and designers. Which of the following is true of business rules? entity A(n) _______ is anything about which data are to be collected and stored. XML/Hybrid data model Oracle 11g is an example of the _______. entity instance Each row in the relational table is known as a(n) relational data model MySQL is an example of the _______. attribute A(n) _______ is the equivalent of a field in a file system. entity relationship The _______ m...

ad hoc query A "spur-of-the-moment" question analytical database A database focused primarily on storing historical data and business metrics used for tactical or strategic decision making availability In the context of data security, it refers to the accessibility of data whenever required by authorized users and for authorized purposes centralized database A database located at a single site cloud database A database that is created and maintained using cloud services, such as Microso...

What is a broad definition of data? Raw facts that are captured on printed or digital media What are data? Facts that are collected and stored in a database system What is a determining characteristic of unstructured data? It does not follow a data model. Which is true about flat files? They contain no internal hierarchical organization. Which technology has no internal hierarchy? Flat files How were data retrieved before database management systems? Sequentially from simple files In which...