2
C175 Newest updated Exam with verified detailed answers
|| || || || || || ||
Unstructured data - ✔✔Data does not exist in a fixed location and can include text
|| || || || || || || || || || || || || || ||
documents, PDFs, voice messages, emails || || || ||
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?
|| || || || || || ||
,2
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
|| || || || || || || || || || || || || ||
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?
|| || || || || || ||
, 2
Randomly from linked files || || ||
||
Sequentially from simple files || || || ||
||
Using set operations on complex files
|| || || || || ||
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? ||
Entity types ||
||
Primary keys || ||
||
Unary relationships || ||
||
Intersection data points - ✔✔Entity types || || || || ||
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.
|| || || || || || || || || || || || || || || ||
C175 Newest updated Exam with verified detailed answers
|| || || || || || ||
Unstructured data - ✔✔Data does not exist in a fixed location and can include text
|| || || || || || || || || || || || || || ||
documents, PDFs, voice messages, emails || || || ||
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?
|| || || || || || ||
,2
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
|| || || || || || || || || || || || || ||
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?
|| || || || || || ||
, 2
Randomly from linked files || || ||
||
Sequentially from simple files || || || ||
||
Using set operations on complex files
|| || || || || ||
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? ||
Entity types ||
||
Primary keys || ||
||
Unary relationships || ||
||
Intersection data points - ✔✔Entity types || || || || ||
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.
|| || || || || || || || || || || || || || || ||
