WGU DATA MANAGEMENT - FOUNDATIONS - D426
EXAM QUESTIONS AND ANSWERS 100% SOLVED
ALTER TABLE - CORRECT ANSWERS-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.
American National Standards Institute (ANSI) - CORRECT ANSWERS-The group that
accepted the DBTG recommendations and augmented database standards in 1975
through its SPARC committee.
analytical database - CORRECT ANSWERS-A database focused primarily on storing
historical data and business metrics used for tactical or strategic decision making.
AND - CORRECT ANSWERS-The SQL logical operator used to link multiple conditional
expressions in a WHERE or HAVING clause. It requires that all conditional expressions
evaluate to true.
application programming interface (API) - CORRECT ANSWERS-Software through
which programmers interact with middleware. An ____ allows the use of generic SQL
code, thereby allowing client processes to be database server-independent.
atomic attribute - CORRECT ANSWERS-An attribute that cannot be further subdivided
to produce meaningful components. For example, a person's last name attribute cannot
be meaningfully subdivided.
atomicity - CORRECT ANSWERS-The transaction property that requires all parts of a
transaction to be treated as a single, indivisible, logical unit of work. All parts of a
transaction must be completed or the entire transaction is aborted.
attribute - CORRECT ANSWERS-A characteristic of an entity or object. An attribute has
a name and a data type.
availability - CORRECT ANSWERS-In the context of data security, it refers to the
accessibility of data whenever required by authorized users and for authorized
purposes.
3 Vs - CORRECT ANSWERS-Three basic characteristics of Big Data databases:
volume, velocity, and variety.
,abstract data type (ADT) - CORRECT ANSWERS-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 complex objects. See also class.
ad hoc query - CORRECT ANSWERS-A "spur-of-the-moment" question.
alias - CORRECT ANSWERS-An alternative name for a column or table in a SQL
statement.
AVG - CORRECT ANSWERS-A SQL aggregate function that outputs the mean average
for a specified column or expression.
balancing - CORRECT ANSWERS-Ensuring that the processing load is distributed
evenly among multiple servers.
BETWEEN - CORRECT ANSWERS-In SQL, a special comparison operator used to
check whether a value is within a range of specified values.
Big Data - CORRECT ANSWERS-A movement to find new and better ways to manage
large amounts of web-generated data and derive business insight from it, while
simultaneously providing high performance and scalability at a reasonable cost.
binary relationship - CORRECT ANSWERS-An ER term for an association (relationship)
between two entities. For example, PROFESSOR teaches CLASS.
Boolean algebra - CORRECT ANSWERS-A branch of mathematics that uses the logical
operators OR, AND, and NOT.
Boyce-Codd normal form (BCNF) - CORRECT ANSWERS-A special type of third
normal form (3NF) in which every determinant is a candidate key. A table in BCNF must
be in 3NF. See also determinant.
Business intelligence (BI) - CORRECT ANSWERS-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.
business rule - CORRECT ANSWERS-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 - CORRECT ANSWERS-A minimal superkey; that is, a key that does not
contain a subset of attributes that is itself a superkey. See key.
, cardinality - CORRECT ANSWERS-A property that assigns a specific value to
connectivity and expresses the range of allowed entity occurrences associated with a
single occurrence of the related entity.
cascading order sequence - CORRECT ANSWERS-A nested ordering sequence for a
set of rows, such as a list in which all last names are alphabetically ordered and, within
the last names, all first names are ordered.
class - CORRECT ANSWERS-A collection of similar objects with shared structure
(attributes) and behavior (methods). A _______ encapsulates an object's data
representation and a method's implementation. _______ are organized in a ______
hierarchy.
class diagram notation - CORRECT ANSWERS-The set of symbols used in the creation
of class diagrams in UML object modeling.
class diagrams - CORRECT ANSWERS-A diagram used to represent data and their
relationships in UML object notation.
class hierarchy - CORRECT ANSWERS-The organization of classes in a hierarchical
tree in which each parent class is a superclass and each child class is a subclass. See
also inheritance.
client - CORRECT ANSWERS-Any process that requests specific services from server
processes in a client/server environment.
client node - CORRECT ANSWERS-One of three types of nodes used in the Hadoop
Distributed File System (HDFS). The ______ acts as the interface between the user
application and the HDFS. See also name node and data node.
cloud database - CORRECT ANSWERS-A database that is created and maintained
using cloud services, such as Microsoft Azure or Amazon AWS.
COMMIT - CORRECT ANSWERS-The SQL command that permanently writes data
changes to a database.
complex object - CORRECT ANSWERS-An object formed by several different objects in
complex relationships. See also abstract data types.
composite attribute - CORRECT ANSWERS-An attribute that can be further subdivided
to yield additional attributes. For example, a phone number such as 615-898-2368 may
be divided into an area code (615), an exchange number (898), and a four-digit code
(2368). Compare to simple attribute.
EXAM QUESTIONS AND ANSWERS 100% SOLVED
ALTER TABLE - CORRECT ANSWERS-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.
American National Standards Institute (ANSI) - CORRECT ANSWERS-The group that
accepted the DBTG recommendations and augmented database standards in 1975
through its SPARC committee.
analytical database - CORRECT ANSWERS-A database focused primarily on storing
historical data and business metrics used for tactical or strategic decision making.
AND - CORRECT ANSWERS-The SQL logical operator used to link multiple conditional
expressions in a WHERE or HAVING clause. It requires that all conditional expressions
evaluate to true.
application programming interface (API) - CORRECT ANSWERS-Software through
which programmers interact with middleware. An ____ allows the use of generic SQL
code, thereby allowing client processes to be database server-independent.
atomic attribute - CORRECT ANSWERS-An attribute that cannot be further subdivided
to produce meaningful components. For example, a person's last name attribute cannot
be meaningfully subdivided.
atomicity - CORRECT ANSWERS-The transaction property that requires all parts of a
transaction to be treated as a single, indivisible, logical unit of work. All parts of a
transaction must be completed or the entire transaction is aborted.
attribute - CORRECT ANSWERS-A characteristic of an entity or object. An attribute has
a name and a data type.
availability - CORRECT ANSWERS-In the context of data security, it refers to the
accessibility of data whenever required by authorized users and for authorized
purposes.
3 Vs - CORRECT ANSWERS-Three basic characteristics of Big Data databases:
volume, velocity, and variety.
,abstract data type (ADT) - CORRECT ANSWERS-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 complex objects. See also class.
ad hoc query - CORRECT ANSWERS-A "spur-of-the-moment" question.
alias - CORRECT ANSWERS-An alternative name for a column or table in a SQL
statement.
AVG - CORRECT ANSWERS-A SQL aggregate function that outputs the mean average
for a specified column or expression.
balancing - CORRECT ANSWERS-Ensuring that the processing load is distributed
evenly among multiple servers.
BETWEEN - CORRECT ANSWERS-In SQL, a special comparison operator used to
check whether a value is within a range of specified values.
Big Data - CORRECT ANSWERS-A movement to find new and better ways to manage
large amounts of web-generated data and derive business insight from it, while
simultaneously providing high performance and scalability at a reasonable cost.
binary relationship - CORRECT ANSWERS-An ER term for an association (relationship)
between two entities. For example, PROFESSOR teaches CLASS.
Boolean algebra - CORRECT ANSWERS-A branch of mathematics that uses the logical
operators OR, AND, and NOT.
Boyce-Codd normal form (BCNF) - CORRECT ANSWERS-A special type of third
normal form (3NF) in which every determinant is a candidate key. A table in BCNF must
be in 3NF. See also determinant.
Business intelligence (BI) - CORRECT ANSWERS-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.
business rule - CORRECT ANSWERS-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 - CORRECT ANSWERS-A minimal superkey; that is, a key that does not
contain a subset of attributes that is itself a superkey. See key.
, cardinality - CORRECT ANSWERS-A property that assigns a specific value to
connectivity and expresses the range of allowed entity occurrences associated with a
single occurrence of the related entity.
cascading order sequence - CORRECT ANSWERS-A nested ordering sequence for a
set of rows, such as a list in which all last names are alphabetically ordered and, within
the last names, all first names are ordered.
class - CORRECT ANSWERS-A collection of similar objects with shared structure
(attributes) and behavior (methods). A _______ encapsulates an object's data
representation and a method's implementation. _______ are organized in a ______
hierarchy.
class diagram notation - CORRECT ANSWERS-The set of symbols used in the creation
of class diagrams in UML object modeling.
class diagrams - CORRECT ANSWERS-A diagram used to represent data and their
relationships in UML object notation.
class hierarchy - CORRECT ANSWERS-The organization of classes in a hierarchical
tree in which each parent class is a superclass and each child class is a subclass. See
also inheritance.
client - CORRECT ANSWERS-Any process that requests specific services from server
processes in a client/server environment.
client node - CORRECT ANSWERS-One of three types of nodes used in the Hadoop
Distributed File System (HDFS). The ______ acts as the interface between the user
application and the HDFS. See also name node and data node.
cloud database - CORRECT ANSWERS-A database that is created and maintained
using cloud services, such as Microsoft Azure or Amazon AWS.
COMMIT - CORRECT ANSWERS-The SQL command that permanently writes data
changes to a database.
complex object - CORRECT ANSWERS-An object formed by several different objects in
complex relationships. See also abstract data types.
composite attribute - CORRECT ANSWERS-An attribute that can be further subdivided
to yield additional attributes. For example, a phone number such as 615-898-2368 may
be divided into an area code (615), an exchange number (898), and a four-digit code
(2368). Compare to simple attribute.
