WGU D197 VERSION CONTROL VERSION
CONTROL TEMPLATE 2024
CERTIFICATION TEST SCRIPT 2026 FULL
QUESTIONS AND SOLUTIONS GRADED A+
⩥ Which part of a Uniform Resource Locator identifies the location of
the document on the server? Answer: Resource path id
⩥ Which goal of information Assurance (IA) requires that information is
accessible when needed? Answer: Availability
⩥ Which technique uses all possible combination of letters and numbers
to crack a password? Answer: brute force
⩥ which is a characterisc of high level languages? Answer: language
translator programs are required.
⩥ how does a compiler work? Answer: It requires the components of the
software to be defined from the onset.
⩥ On which tier of the n tier architecture model are user interfaces
developed? Answer: presentation
,⩥ Which component facilitates communication between the other two
components in the MVC architecture model? Answer: controller
⩥ What is the difference between a compiled and interpreted computer
language? Answer: compiler translates an entire program into executable
progam which can be run at a later time, while the interpreter does this
incrementally.
⩥ Which two languages have traditionally been used for automation
rather than software development? Answer: TCL and Python because
they are scripting languages
⩥ Which is true of databases and the application that interact with them?
Answer: Applications are interdependent with the database.
⩥ What is another term for a formula that outlines how to execute a
task? Answer: Algorithm
⩥ What is the role of drivers in facilitating communication between
application and databases? Answer: They allow the ODBC to be used for
interactions with the database and applications.
⩥ Which sql clause is used to inform the database management system
which table should be interrograted by the query? Answer: FROM
, ⩥ Which data type is used to represent product order code that
comprises alphanumeric characters? Answer: String data
⩥ Why is it important to ensure that data support business goals?
Answer: To aid in making strategic decisions.
⩥ In which category of the DIKW hierarchy would business intelligence
be located? Answer: Knowledge
⩥ Which field must contain a unique value in order for a relational
database table to function? Answer: primary key
⩥ What are the three main categories of databases? Answer: Flat file,
relational, and hierarchal
⩥ What is the database administrators role in security? Answer: To
institute protocols to protect the databases from external threats.
⩥ A single chip process developed in 1974 by IBM Answer:
microprocessor
⩥ Over the years, the number of transisters that can be placed on a chip
has increased by how much? Answer: By orders of maginitude rather
than linearly
CONTROL TEMPLATE 2024
CERTIFICATION TEST SCRIPT 2026 FULL
QUESTIONS AND SOLUTIONS GRADED A+
⩥ Which part of a Uniform Resource Locator identifies the location of
the document on the server? Answer: Resource path id
⩥ Which goal of information Assurance (IA) requires that information is
accessible when needed? Answer: Availability
⩥ Which technique uses all possible combination of letters and numbers
to crack a password? Answer: brute force
⩥ which is a characterisc of high level languages? Answer: language
translator programs are required.
⩥ how does a compiler work? Answer: It requires the components of the
software to be defined from the onset.
⩥ On which tier of the n tier architecture model are user interfaces
developed? Answer: presentation
,⩥ Which component facilitates communication between the other two
components in the MVC architecture model? Answer: controller
⩥ What is the difference between a compiled and interpreted computer
language? Answer: compiler translates an entire program into executable
progam which can be run at a later time, while the interpreter does this
incrementally.
⩥ Which two languages have traditionally been used for automation
rather than software development? Answer: TCL and Python because
they are scripting languages
⩥ Which is true of databases and the application that interact with them?
Answer: Applications are interdependent with the database.
⩥ What is another term for a formula that outlines how to execute a
task? Answer: Algorithm
⩥ What is the role of drivers in facilitating communication between
application and databases? Answer: They allow the ODBC to be used for
interactions with the database and applications.
⩥ Which sql clause is used to inform the database management system
which table should be interrograted by the query? Answer: FROM
, ⩥ Which data type is used to represent product order code that
comprises alphanumeric characters? Answer: String data
⩥ Why is it important to ensure that data support business goals?
Answer: To aid in making strategic decisions.
⩥ In which category of the DIKW hierarchy would business intelligence
be located? Answer: Knowledge
⩥ Which field must contain a unique value in order for a relational
database table to function? Answer: primary key
⩥ What are the three main categories of databases? Answer: Flat file,
relational, and hierarchal
⩥ What is the database administrators role in security? Answer: To
institute protocols to protect the databases from external threats.
⩥ A single chip process developed in 1974 by IBM Answer:
microprocessor
⩥ Over the years, the number of transisters that can be placed on a chip
has increased by how much? Answer: By orders of maginitude rather
than linearly
