100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
WGU - C175 - Data Management – Foundations Exam Questions & Answers 100% Correct $10.99
Add to cart
Quickly navigate to
Preview
  2.  
  3. WGU - C175
  4.  
  5. WGU - C175

Exam (elaborations)

WGU - C175 - Data Management – Foundations Exam Questions & Answers 100% Correct
 0 purchase
  • Course
  • WGU - C175
  • Institution
  • WGU - C175

abstract data type (ADT) - ANSWER-Data type that describes a set of similar objects with shared and encapsulated data representation and methods. A(n)___ is generally used to describe complex objects. See also class. ad hoc query - ANSWER-A "spur-of-the-moment" question. alias - ANSWER-An alt...

[Show more]

Preview 3 out of 19  pages

Document information

  • November 24, 2023
  • 19
  • 2023/2024
  • Exam (elaborations)
  • Questions & answers

Subjects

  • wgu c175 data management foundations exam qu
  • wgu c175 data management stuvia
  • 3 vs answer three basic characteristics of big d

Written for

  • WGU - C175
  • WGU - C175

Seller

avatar-seller
IMORA

Reviews received

Content preview

WGU - C175 - Data Management –
Foundations Exam Questions &
Answers 100% Correct
3 Vs - ANSWER-Three basic characteristics of Big Data databases: volume, velocity,
and variety.

abstract data type (ADT) - ANSWER-Data type that describes a set of similar objects
with shared and encapsulated data representation and methods. A(n)___ is generally
used to describe complex objects. See also class.

ad hoc query - ANSWER-A "spur-of-the-moment" question.

alias - ANSWER-An alternative name for a column or table in a SQL statement.

ALTER TABLE - ANSWER-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) - ANSWER-The group that accepted the
DBTG recommendations and augmented database standards in 1975 through its
SPARC committee.

analytical database - ANSWER-A database focused primarily on storing historical data
and business metrics used for tactical or strategic decision making.

AND - ANSWER-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) - ANSWER-Software through which
programmers interact with middleware. A(n)___ allows the use of generic SQL code,
thereby allowing client processes to be database server-independent.

atomic attribute - ANSWER-An attribute that cannot be further subdivided to produce
meaningful components. For example, a person's last name attribute cannot be
meaningfully subdivided.

atomicity - ANSWER-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 - ANSWER-A characteristic of an entity or object. A(n)___ has a name and a
data type.

availability - ANSWER-In the context of data security, it refers to the accessibility of data
whenever required by authorized users and for authorized purposes.

AVG - ANSWER-A SQL aggregate function that outputs the mean average for a
specified column or expression.

balancing - ANSWER-Ensuring that the processing load is distributed evenly among
multiple servers.

BETWEEN - ANSWER-In SQL, a special comparison operator used to check whether a
value is within a range of specified values.

Big Data - ANSWER-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 - ANSWER-An ER term for an association (relationship) between two
entities. For example, PROFESSOR teaches CLASS.

Boolean algebra - ANSWER-A branch of mathematics that uses the logical operators
OR, AND, and NOT.

Boyce-Codd normal form (BCNF) - ANSWER-A special type of third normal form (3NF)
in which every determinant is a candidate key. A table in ___ must be in 3NF. See also
determinant.

Business intelligence (BI) - ANSWER-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 - ANSWER-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 - ANSWER-A minimal superkey; that is, a key that does not contain a
subset of attributes that is itself a superkey. See key.

cardinality - ANSWER-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 - ANSWER-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 - ANSWER-A collection of similar objects with shared structure (attributes) and
behavior (methods). A(n)___ encapsulates an object's data representation and a
method's implementation. ___ are organized in a class hierarchy.

class diagram notation - ANSWER-The set of symbols used in the creation of class
diagrams in UML object modeling.

class diagrams - ANSWER-A diagram used to represent data and their relationships in
UML object notation.

class hierarchy - ANSWER-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 - ANSWER-Any process that requests specific services from server processes in
a client/server environment.

client node - ANSWER-One of three types of nodes used in the Hadoop Distributed File
System (HDFS). A(n)___ acts as the interface between the user application and the
HDFS. See also name node and data node.

cloud database - ANSWER-A database that is created and maintained using cloud
services, such as Microsoft Azure or Amazon AWS.

COMMIT - ANSWER-The SQL command that permanently writes data changes to a
database.

complex object - ANSWER-An object formed by several different objects in complex
relationships. See also abstract data types.

composite attribute - ANSWER-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.

composite entity - ANSWER-An entity designed to transform an M:N relationship into
two 1:M relationships. A(n)___'s primary key comprises at least the primary keys of the
entities that it connects. Also known as a bridge entity or associative entity. See also
linking table.

composite identifier - ANSWER-In ER modeling, a key composed of more than one
attribute.

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller IMORA. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $10.99. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

67479 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 15 years now

Start selling
$10.99
  • (0)
Add to cart
Added