WGU C175 EXAM Pack | QUESTIONS & ANSWERS | GRADED A+ | LATEST UPDATE

ad hoc query Ans- A "spur-of-the-moment" question. analytical database Ans- A database focused primarily on storing historical data and business metrics used for tactical or strategic decision making. availability Ans- In the context of data security, it refers to the accessibility of data ...

binary relationship Ans- An ER term for an association (relationship) between two entities. For example, PROFESSOR teaches CLASS. cardinality Ans- A property that assigns a specific value to connectivity and expresses the range of allowed entity occurrences associated with a single occurrence...

business rule Ans- A description of a policy, procedure, or principle within an organization. For example, a pilot cannot be on duty for more than 10 hours during a 24-hour period, or a professor may teach up to four classes during a semester. candidate key Ans- A minimal superkey; that is, a...

3 Vs Ans- Three basic characteristics of Big Data databases: volume, velocity, and variety. abstract data type (ADT) Ans- Data type that describes a set of similar objects with shared and encapsulated data representation and methods. An abstract data type is generally used to describe compl...

alias Ans- An alternative name for a column or table in a SQL statement. ALTER TABLE Ans- The SQL command used to make changes to table structure. When the command is followed by a keyword (ADD or MODIFY), it adds a column or changes column characteristics. AND Ans- The SQL logical operator...

Business intelligence (BI) Ans- A comprehensive, cohesive, and integrated set of tools and processes used to capture, collect, integrate, store, and analyze data with the purpose of generating and presenting information to support business decision making. cube cache Ans- In multidimensional ...