WGU C175 – PA Questions and Answers
Already Passed
What is a broad definition of data?
A) Numbers that are captured on digital media
B) Raw facts that are captured on printed or digital media
C) Alphanumeric combinations that can be captured on media that a computer can read
D) Any information that can be transferred from print to digital ✔✔Raw facts that are captured on
printed or digital media
What are data?
A) Facts that have been organized in a meaningful way
B) Facts that are the result of a query of a database system
C) Facts that are collected and stored in a database system
D) 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?
A) It does not allow copying and pasting.
B) It is easy to query and retrieve by business applications.
C) It does not follow a data model.
D) It is stored in rows and columns. ✔✔It does not follow a data model
Refer to this diagram.
Inputs:
A. Training Video Content
B. SQL tables of training instructors
Output:
C. Relational database for training tracking
,Backup:
D. Training database backup
Which item represents unstructured data?
A) A
B) B
C) C
D) D ✔✔A
Which is true about flat files?
A) They contain no internal hierarchical organization.
B) They have a limit of 256 records.
C) They can only contain two-dimensional data.
D) They are always encrypted. ✔✔They contain no internal hierarchical organization
Which technology has no internal hierarchy?
A) Flat files
B) Heap files
C) Hashed tables
D) Relational databases ✔✔Flat files
How were data retrieved before database management systems?
A) Randomly from linked files
B) Sequentially from simple files
C) Using set operations on complex files
D) Using relationships between logical entities ✔✔Sequentially from simple files
, What is the uniquely identifiable element about which data can be categorized in an entity-
relationship diagram?
A) Entity types
B) Primary keys
C) Unary relationships
D) Intersection data points ✔✔Entity types
Refer to this diagram.
{{ Crow's Foot
One or more "Salesperson" sells "Quantity" of one or more "One Product"
"Quantity" of one or more "One product" sold by one or more "Salesperson"
}}
Which classification is correct for the box marked "Quantity" in the given entity-relationship
diagram?
A) Quantity data
B) Modality data
C) Intersection data
D) Product sales data ✔✔Intersection data
Which data classification is an entity?
A) Event
B) Duration
C) Directions
D) Attendance ✔✔Event
Refer to this diagram.
Already Passed
What is a broad definition of data?
A) Numbers that are captured on digital media
B) Raw facts that are captured on printed or digital media
C) Alphanumeric combinations that can be captured on media that a computer can read
D) Any information that can be transferred from print to digital ✔✔Raw facts that are captured on
printed or digital media
What are data?
A) Facts that have been organized in a meaningful way
B) Facts that are the result of a query of a database system
C) Facts that are collected and stored in a database system
D) 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?
A) It does not allow copying and pasting.
B) It is easy to query and retrieve by business applications.
C) It does not follow a data model.
D) It is stored in rows and columns. ✔✔It does not follow a data model
Refer to this diagram.
Inputs:
A. Training Video Content
B. SQL tables of training instructors
Output:
C. Relational database for training tracking
,Backup:
D. Training database backup
Which item represents unstructured data?
A) A
B) B
C) C
D) D ✔✔A
Which is true about flat files?
A) They contain no internal hierarchical organization.
B) They have a limit of 256 records.
C) They can only contain two-dimensional data.
D) They are always encrypted. ✔✔They contain no internal hierarchical organization
Which technology has no internal hierarchy?
A) Flat files
B) Heap files
C) Hashed tables
D) Relational databases ✔✔Flat files
How were data retrieved before database management systems?
A) Randomly from linked files
B) Sequentially from simple files
C) Using set operations on complex files
D) Using relationships between logical entities ✔✔Sequentially from simple files
, What is the uniquely identifiable element about which data can be categorized in an entity-
relationship diagram?
A) Entity types
B) Primary keys
C) Unary relationships
D) Intersection data points ✔✔Entity types
Refer to this diagram.
{{ Crow's Foot
One or more "Salesperson" sells "Quantity" of one or more "One Product"
"Quantity" of one or more "One product" sold by one or more "Salesperson"
}}
Which classification is correct for the box marked "Quantity" in the given entity-relationship
diagram?
A) Quantity data
B) Modality data
C) Intersection data
D) Product sales data ✔✔Intersection data
Which data classification is an entity?
A) Event
B) Duration
C) Directions
D) Attendance ✔✔Event
Refer to this diagram.
