WGU D361 PRACTICE EXAMINATION 2026
QUESTIONS WITH ANSWERS GRADED A+
◍ Link between tools and query processor.
Answer: Connection
◍ Standardization.
Answer: Developing a preset procedure.
◍ Refers to the maxima and minima of relationships and attributes..
Answer: Cardinality
◍ Kanban.
Answer: The Japanese word for "card" that is used to signal the need for
more materials or parts at downstream operations; developed by Toyota;
used in pull systems.
◍ A database that is packaged with a programming language. AKA:
In-Process Database (Database Architecture) - SQLite - SQL Server
Compact.
Answer: Embedded Databases
◍ Stores table rows in each bucket.
Answer: Hash Table
◍ Actual Output.
Answer: The effective capacity minus additional factors that reduce
production, such as a fuel stop.
◍ Test Market.
Answer: When a new product in placed in an area that is representative of
the overall market to measure its success; an expensive approach that
usually reports accurate findings.
,◍ Quality Control.
Answer: Ensure that the product fits the customer's perception of fitness for
use.
◍ List of partition expression values using VALUES IN keywords..
Answer: List Partition
◍ Develops an entity-relationship model capturing data requirements while
ignoring implementation details..
Answer: Analysis
◍ All indexed values appear in the bottom level.
Answer: B+Tree
◍ Product Bottleneck.
Answer: When there are insufficient materials to make a product.
◍ Questions for Customers when Improving Products.
Answer: Ask what they value (not just what they want), how do they work,
what makes them happy, and feedback on specific product attributes.
◍ Supply Chain Operations Reference (SCOR) Model.
Answer: A model developed by the Supply Chain Council (SCC) to divide
all supply chain activities into five groups: plan, source, make (how a
product will be made, in what quantities, and where), deliver (through each
supply chain stage), and return (such as warranty costs, repairs, customer
satisfaction, disposal, etc.); SCOR is used as a framework in development
supply chain performance management systems.
◍ Quality Improvement.
Answer: Leadership ought to lead efforts to eliminate waste and errors.
◍ Flexible Manufacturing Systems (FMS).
Answer: Allow the production of low-cost products that need varying
customer requirements; relies upon group technology to build a family of
parts.
◍ Rules for designing tables with less redundancy..
, Answer: Normal Forms
◍ Range of partition expression values (VALUES LESS THAN,
MAXVALUE).
Answer: Range Partition
◍ A partition expression with positive integer values. The partition number for
each row is computed as (partition expression value)modulo
N. .
Answer: Hash Partition
◍ Quality (external).
Answer: How quality is defined by the customer and the product's fitness for
use; meets customer's needs and expectations; subjective.
◍ Black Belts/Green Belts.
Answer: When using Six Sigma, these specialists are developed within an
organization who are experts in specific methods.
◍ Includes CREATE, DROP, ALTER, TRUNCATE, RENAME.
Answer: DDL
◍ Product Layout.
Answer: A process that is characterized by high demand for the same or
similar products; for example, the process of continuously producing paper
along the supply chain; this system often measures output as the number of
items produced per day.
◍ An attribute that can be used to find the value of another attribute in the
relation..
Answer: Determinant
◍ Block or group of blocks containing rows/index entries..
Answer: Bucket
◍ VIRAL.
Answer: Value, Inimitable, rare, aptitude, and lifespan.
◍ Continuous Flow.
, Answer: Where low-variety units are mixed and flow together in a
high-volume continuous stream, such as oil refining or processing checks;
the main scheduling dilemma stems from knowing the best time to switch
from making one product to another.
◍ If an indexed value appears in a higher level of multi-level index, the value
is not repeated at lower levels in _____..
Answer: B-Tree
◍ ABC Analysis.
Answer: Used to determine which inventory items should receive the
highest level of control, through multiplying the dollar value of each item by
its annual usage. Items are ranked by dollar usage, from highest to lowest.
Following the Pareto Principle, the first 20% of the items are assigned to
Class A, characterized as having close control and monitoring through a
perpetual inventory system. Class B items comprise the next 30%, and they
deserve less attention. Class C items are the last 50% of stocked items,
characterized by lowest dollar usage and can be monitored loosely through a
periodic review system.
◍ Reads blocks directly, without accessing an index..
Answer: Table Scan
◍ Tier # Suppliers.
Answer: A manufacturer purchases components from tier 1 suppliers. When
they produce these components, they may purchase components from tier 2
suppliers, and so on.
◍ The number of index entries per block of a multi-level index..
Answer: Fan-Out
◍ Forms when a network error prevents nodes from communicating..
Answer: Network Partition
◍ Retrieves data from the database..
Answer: DQL
QUESTIONS WITH ANSWERS GRADED A+
◍ Link between tools and query processor.
Answer: Connection
◍ Standardization.
Answer: Developing a preset procedure.
◍ Refers to the maxima and minima of relationships and attributes..
Answer: Cardinality
◍ Kanban.
Answer: The Japanese word for "card" that is used to signal the need for
more materials or parts at downstream operations; developed by Toyota;
used in pull systems.
◍ A database that is packaged with a programming language. AKA:
In-Process Database (Database Architecture) - SQLite - SQL Server
Compact.
Answer: Embedded Databases
◍ Stores table rows in each bucket.
Answer: Hash Table
◍ Actual Output.
Answer: The effective capacity minus additional factors that reduce
production, such as a fuel stop.
◍ Test Market.
Answer: When a new product in placed in an area that is representative of
the overall market to measure its success; an expensive approach that
usually reports accurate findings.
,◍ Quality Control.
Answer: Ensure that the product fits the customer's perception of fitness for
use.
◍ List of partition expression values using VALUES IN keywords..
Answer: List Partition
◍ Develops an entity-relationship model capturing data requirements while
ignoring implementation details..
Answer: Analysis
◍ All indexed values appear in the bottom level.
Answer: B+Tree
◍ Product Bottleneck.
Answer: When there are insufficient materials to make a product.
◍ Questions for Customers when Improving Products.
Answer: Ask what they value (not just what they want), how do they work,
what makes them happy, and feedback on specific product attributes.
◍ Supply Chain Operations Reference (SCOR) Model.
Answer: A model developed by the Supply Chain Council (SCC) to divide
all supply chain activities into five groups: plan, source, make (how a
product will be made, in what quantities, and where), deliver (through each
supply chain stage), and return (such as warranty costs, repairs, customer
satisfaction, disposal, etc.); SCOR is used as a framework in development
supply chain performance management systems.
◍ Quality Improvement.
Answer: Leadership ought to lead efforts to eliminate waste and errors.
◍ Flexible Manufacturing Systems (FMS).
Answer: Allow the production of low-cost products that need varying
customer requirements; relies upon group technology to build a family of
parts.
◍ Rules for designing tables with less redundancy..
, Answer: Normal Forms
◍ Range of partition expression values (VALUES LESS THAN,
MAXVALUE).
Answer: Range Partition
◍ A partition expression with positive integer values. The partition number for
each row is computed as (partition expression value)modulo
N. .
Answer: Hash Partition
◍ Quality (external).
Answer: How quality is defined by the customer and the product's fitness for
use; meets customer's needs and expectations; subjective.
◍ Black Belts/Green Belts.
Answer: When using Six Sigma, these specialists are developed within an
organization who are experts in specific methods.
◍ Includes CREATE, DROP, ALTER, TRUNCATE, RENAME.
Answer: DDL
◍ Product Layout.
Answer: A process that is characterized by high demand for the same or
similar products; for example, the process of continuously producing paper
along the supply chain; this system often measures output as the number of
items produced per day.
◍ An attribute that can be used to find the value of another attribute in the
relation..
Answer: Determinant
◍ Block or group of blocks containing rows/index entries..
Answer: Bucket
◍ VIRAL.
Answer: Value, Inimitable, rare, aptitude, and lifespan.
◍ Continuous Flow.
, Answer: Where low-variety units are mixed and flow together in a
high-volume continuous stream, such as oil refining or processing checks;
the main scheduling dilemma stems from knowing the best time to switch
from making one product to another.
◍ If an indexed value appears in a higher level of multi-level index, the value
is not repeated at lower levels in _____..
Answer: B-Tree
◍ ABC Analysis.
Answer: Used to determine which inventory items should receive the
highest level of control, through multiplying the dollar value of each item by
its annual usage. Items are ranked by dollar usage, from highest to lowest.
Following the Pareto Principle, the first 20% of the items are assigned to
Class A, characterized as having close control and monitoring through a
perpetual inventory system. Class B items comprise the next 30%, and they
deserve less attention. Class C items are the last 50% of stocked items,
characterized by lowest dollar usage and can be monitored loosely through a
periodic review system.
◍ Reads blocks directly, without accessing an index..
Answer: Table Scan
◍ Tier # Suppliers.
Answer: A manufacturer purchases components from tier 1 suppliers. When
they produce these components, they may purchase components from tier 2
suppliers, and so on.
◍ The number of index entries per block of a multi-level index..
Answer: Fan-Out
◍ Forms when a network error prevents nodes from communicating..
Answer: Network Partition
◍ Retrieves data from the database..
Answer: DQL
