WGU D518 A3 - COLLABORATION
CERTIFICATION SCRIPT 2026 QUESTIONS
WITH SOLUTIONS GRADED A+
◍ Loops.
Answer: Instructions that continually repeat until a certain condition is
reached.
◍ Slicing.
Answer: Creates a subset of the data by reducing the data from multiple
dimensions to one dimension
◍ Integrity.
Answer: Requires that data is correct
◍ Public Key Encryption.
Answer: Uses two keys, a public and private key for performing encryption
and decryption
◍ Classroom Acceptance.
Answer: Encourage collaboration and respect among all students so they
feel valued.
◍ Inclusive Materials.
Answer: Use texts or projects representing diverse authors and perspectives
to reflect students' backgrounds.
◍ Database Interacting Format.
Answer: SELECT fields FROM tables WHERE fields from tables match
criteria
◍ Pilot Conversion.
Answer: Involves starting the conversation with a portion of end users
,◍ Server.
Answer: Computers that have greater hard disk storage, faster response time
and are used to respond to request from other computers on the network
◍ WHERE.
Answer: Used to inform the DBMS of the specific criteria the data should
match to be returned as the output of the query
◍ Bus.
Answer: Permits information to move between each component; electrical
channels that enable communication among the electronic components
◍ I/O Subsystem.
Answer: All peripheral devices where long term storage devices are used.
◍ Data Integrity Efforts.
Answer: 1st - Must include a component that ensures the accuracy of the
collected data2nd - Must be entered into the system accurately3rd - Data
modification must be tracked
◍ SELECT.
Answer: Used to inform the DBMS what fields or attributes are of interest
◍ Information Security Classifications.
Answer: Public - available through public sources; includes names and
addressesSensitive - not considered a threat to a person's privacy if others
learn of it; include email addressesPrivate - information that could be a
threat if disclosed to others; includes social security and credit card
numbersConfidential - information that an organization will keep secret;
includes patentable information and business plans
◍ Server Software.
Answer: Works with hardware to provide a network service
◍ Relational Database.
Answer: Has multiple tables (relations) with interrelated fields; most
common structure for databases
, ◍ Data in DIKW.
Answer: The input directly received by the user (or computer). It is
generally not usable until it has been converted into a relevant form.
◍ Structured Programming.
Answer: Programmer is limited to high level control constructs such as
while loops, for loops, and if/else statements and not allowed to use
primitive GOTO statements
◍ Growth Mindset.
Answer: Struggling is a chance to learn; improvement is not guaranteed by
mindset alone but requires effort.
◍ Domain Name Parts.
Answer: Top level domain (TLD) name and Host name
◍ Vicarious Experience.
Answer: Building confidence by watching a peer successfully solve a
problem.
◍ Utility Programs.
Answer: Programs that allow the user to monitor and improve system
performance.
◍ Interleaving.
Answer: Rotate between different topics or problem types.
◍ Trojan Horse.
Answer: Type of virus that completely replaces an existing application and
takes the name of the taken over file
◍ Rolling up.
Answer: Similar to drilling up but it collapses the data from multiple items
into a single value
◍ Parts of URL (Uniform Resource Locator).
Answer: Protocol, Domain name, Resource/Filename
CERTIFICATION SCRIPT 2026 QUESTIONS
WITH SOLUTIONS GRADED A+
◍ Loops.
Answer: Instructions that continually repeat until a certain condition is
reached.
◍ Slicing.
Answer: Creates a subset of the data by reducing the data from multiple
dimensions to one dimension
◍ Integrity.
Answer: Requires that data is correct
◍ Public Key Encryption.
Answer: Uses two keys, a public and private key for performing encryption
and decryption
◍ Classroom Acceptance.
Answer: Encourage collaboration and respect among all students so they
feel valued.
◍ Inclusive Materials.
Answer: Use texts or projects representing diverse authors and perspectives
to reflect students' backgrounds.
◍ Database Interacting Format.
Answer: SELECT fields FROM tables WHERE fields from tables match
criteria
◍ Pilot Conversion.
Answer: Involves starting the conversation with a portion of end users
,◍ Server.
Answer: Computers that have greater hard disk storage, faster response time
and are used to respond to request from other computers on the network
◍ WHERE.
Answer: Used to inform the DBMS of the specific criteria the data should
match to be returned as the output of the query
◍ Bus.
Answer: Permits information to move between each component; electrical
channels that enable communication among the electronic components
◍ I/O Subsystem.
Answer: All peripheral devices where long term storage devices are used.
◍ Data Integrity Efforts.
Answer: 1st - Must include a component that ensures the accuracy of the
collected data2nd - Must be entered into the system accurately3rd - Data
modification must be tracked
◍ SELECT.
Answer: Used to inform the DBMS what fields or attributes are of interest
◍ Information Security Classifications.
Answer: Public - available through public sources; includes names and
addressesSensitive - not considered a threat to a person's privacy if others
learn of it; include email addressesPrivate - information that could be a
threat if disclosed to others; includes social security and credit card
numbersConfidential - information that an organization will keep secret;
includes patentable information and business plans
◍ Server Software.
Answer: Works with hardware to provide a network service
◍ Relational Database.
Answer: Has multiple tables (relations) with interrelated fields; most
common structure for databases
, ◍ Data in DIKW.
Answer: The input directly received by the user (or computer). It is
generally not usable until it has been converted into a relevant form.
◍ Structured Programming.
Answer: Programmer is limited to high level control constructs such as
while loops, for loops, and if/else statements and not allowed to use
primitive GOTO statements
◍ Growth Mindset.
Answer: Struggling is a chance to learn; improvement is not guaranteed by
mindset alone but requires effort.
◍ Domain Name Parts.
Answer: Top level domain (TLD) name and Host name
◍ Vicarious Experience.
Answer: Building confidence by watching a peer successfully solve a
problem.
◍ Utility Programs.
Answer: Programs that allow the user to monitor and improve system
performance.
◍ Interleaving.
Answer: Rotate between different topics or problem types.
◍ Trojan Horse.
Answer: Type of virus that completely replaces an existing application and
takes the name of the taken over file
◍ Rolling up.
Answer: Similar to drilling up but it collapses the data from multiple items
into a single value
◍ Parts of URL (Uniform Resource Locator).
Answer: Protocol, Domain name, Resource/Filename
