WGU C175 COMPLETE AND UPDATED EXAM
QUESTIONS AND ANSWERS FOR DATABASE
FUNDAMENTALS
Which kind of outcomes should a company expect to gain from implementing a
business intelligence system?
Increased profitability and increased throughput
Which issue is dealing with the loading side of extract, transform, load (ETL)?
Track refreshing volume and frequency
In which stage of the extract, transform, load (ETL) procedure are raw data sets
merged?
Transformation
How is prediction distinguished from estimation in data mining?
Prediction classifies objects on the basis of an anticipated future conduct.
Where does affinity grouping occur in data mining?
Between objects
The specification of the way data in a database will be organized is called the
Schema
, A unique value occurs only once in a given column
There is a relationship between two pieces of data in various _____ in the same
_____.tables, database
Which is a good candidate key example?
An employee ID number
How many SQL clauses are there in this query?
SELECT Width,Height FROM Shapes;
2
In a database, what is a relation?
a collection of attributes (columns) that define information about certain
instances (rows) of an entity
You can also refer to the rows as "tuples."
What is the name of a key made up of various fields combined together to serve
as a unique identifier?
composite key
A composite key makes up two or more fields to serve as a unique identifier.
Which ACID step requires that the database must be updated once the
transaction is successfully executed?
Durable
When are associative tables useful?
when there are records which have to be related in many-to-many terms
QUESTIONS AND ANSWERS FOR DATABASE
FUNDAMENTALS
Which kind of outcomes should a company expect to gain from implementing a
business intelligence system?
Increased profitability and increased throughput
Which issue is dealing with the loading side of extract, transform, load (ETL)?
Track refreshing volume and frequency
In which stage of the extract, transform, load (ETL) procedure are raw data sets
merged?
Transformation
How is prediction distinguished from estimation in data mining?
Prediction classifies objects on the basis of an anticipated future conduct.
Where does affinity grouping occur in data mining?
Between objects
The specification of the way data in a database will be organized is called the
Schema
, A unique value occurs only once in a given column
There is a relationship between two pieces of data in various _____ in the same
_____.tables, database
Which is a good candidate key example?
An employee ID number
How many SQL clauses are there in this query?
SELECT Width,Height FROM Shapes;
2
In a database, what is a relation?
a collection of attributes (columns) that define information about certain
instances (rows) of an entity
You can also refer to the rows as "tuples."
What is the name of a key made up of various fields combined together to serve
as a unique identifier?
composite key
A composite key makes up two or more fields to serve as a unique identifier.
Which ACID step requires that the database must be updated once the
transaction is successfully executed?
Durable
When are associative tables useful?
when there are records which have to be related in many-to-many terms
