WGU C175- D426 DATA MANAGEMENT

• | P a g e

WGU C175- D426 DATA MANAGEMENT

FOUNDATIONS OA EXAM REAL EXAM 2

LATEST VERSION 2024 ALL 300 QUESTIONS

AND CORRECT VERIFIED ANSWERS WITH

RATIONALES (LATEST ANSWERS ) (NEW!!)

VERSION 1

What is a broad definition of data?

• Numbers that are captured on digital media
• Raw facts that are captured on printed or digital media
• Alphanumeric combinations that can be captured on media that a computer

can read

• Any information that can be transferred from print to digital

Raw facts that are captured on printed or digital media What are data?

• Facts that have been organized in a meaningful way
• Facts that are the result of a query of a database system
• Facts that are collected and stored in a database system
• Facts that have been processed and used for decision making

Facts that are collected and stored in a database system What is a determining characteristic of unstructured data?

• It does not allow copying and pasting.
• It is easy to query and retrieve by business applications.
• It does not follow a data model.
• It is stored in rows and columns.

It does not follow a data model. 1 / 4

• | P a g e

Which is true about flat files?

• They contain no internal hierarchical organization.
• They have a limit of 256 records.
• They can only contain two-dimensional data.
• They are always encrypted.

They contain no internal hierarchical organization.Which technology has no internal hierarchy?

• Flat files
• Heap files
• Hashed tables
• Relational databases

Flat files How were data retrieved before database management systems?

• Randomly from linked files
• Sequentially from simple files
• Using set operations on complex files
• Using relationships between logical entities

Sequentially from simple files In which two ways does a database management system environment increase effectiveness in working with data?

• It enables data sharing.
• It duplicates redundant data for security.
• It permits storage of vast volumes of data.
• It increases the complexity rules by which data is organized.

It enables data sharing.It permits storage of vast volumes of data. 2 / 4

• | P a g e

What is the uniquely identifiable element about which data can be categorized in an entity-relationship diagram?

• Entity types
• Primary keys
• Unary relationships
• Intersection data points

Entity types Which classification is correct for the box marked "Quantity" in the given entity- relationship diagram?

• Quantity data
• Modality data
• Intersection data
• Product sales data

Intersection data Which data classification is an entity?

• Event
• Duration
• Directions
• Attendance

Event A salesperson is authorized to sell 12 products; a product can be sold by 10 salespersons.

Which kind of binary relationship is described in this example?

• One-to-one
• One-to-many
• Many-to-many
• Associative 3 / 4

• | P a g e

Many-to-many Which three kinds of rules for referential integrity are provided by modern relational database management systems?

• Sort
• Insert
• Query
• Delete
• Update
• Retrieve

Insert, Delete, Update What is an important aspect of "referential integrity"?

• Primary keys refer to data in particular relation.
• Reference points are placed by the database in each record during backups.
• The relationships between entities and attributes are called referrals.
• Reference to data in one relation is based on values in another relation.

Reference to data in one relation is based on values in another relation.Sales data, detailing the customer names, products sold, and salespersons, is kept in a database.The Entity-Relationship (E-R) model is _____.

• a diagramming technique that describes record structures (i.e. the fields that

make up the records of a file)

• an alternative to indexing and hashing as a means for providing direct access

in files

• a diagramming technique that describes entities, their attributes, and the

relationships between them

• / 4