WGU D355 ACTUAL EXAM PAPER 2026
QUESTIONS WITH ANSWERS GRADED A+
◍ Combines two query results into one table..
Answer: UNION
◍ AKA: Reporting Data or Decision Support Data -Enterprise-wide- Used to
understand, manage, and plan the business- Summary Updated at fixed
intervals and summarized by time period -Combines data from many
business functions -Usually contains current and historic data.
Answer: Analytic Data
◍ Link between tools and query processor.
Answer: Connection
◍ Analytic database of raw, unprocessed data copied from multiple data
sources..
Answer: Data Lake
◍ Specifies tables, columns, and keys. Implements database requirements in a
specific database system. Also called a schema..
Answer: Logical Design
◍ An unordered collection of elements enclosed in braces..
Answer: Set
◍ Adding, deleting, and modifying data - Manipulates data stored in a
database..
Answer: DML
◍ A database offered as a PaaS cloud service..
Answer: Cloud Database
◍ AKA: Multi-tables. Interleave rows of two or more tables in the same
, storage area. They contain cluster keys..
Answer: Table Clusters
◍ Rejects an insert, update, or delete that violates referential integrity..
Answer: RESTRICT
◍ Validity.
Answer: Refers to the degree which the assessment is relevant to the content
and measures what it's supposed measure.
◍ No transitive dependencies (Functional dependencies on non-primary-key
attributes. Called transitive because the primary key is a determinant for
another attribute, which in turn is a determinant for a third. Solution:
Non-key determinant with transitive dependencies goes into a new table;
non-key determinant becomes primary key in the new table and remains as a
foreign key in the old table)..
Answer: Third Normal Form
◍ Retains data blocks from the file system for possible reuse..
Answer: Buffer Manager
◍ Entry for every table block.
Answer: Sparse Index
◍ Single or multi-level index that normally contains pointers to table blocks.
Answer: Physical Index
◍ Interact directly with database users and administrators and send queries to
the query processor. Includes Connectors & APIs, Workbench, and utility
programs..
Answer: Tools
◍ Each index entry is a composite of values from all indexed columns. Behave
exactly like indexes on a single column..
Answer: Multi-Column Index
◍ Volatile- Used to conduct daily business -Changes in real time -Detailed
Designed for specific business function -Concerned primarily with current
, data.
Answer: Operational Data
◍ Converts a SQL query into a sequence of low-level database actions, called
the query execution plan, which specifies precisely how to process a SQL
statement..
Answer: Query Optimizer
◍ Either run under different database systems or have incompatible schema..
Answer: Heterogenous Databases
◍ Candidate Key - Composite Key - Primary Key - Surrogate Key.
Answer: Unique
◍ Unidemensionality.
Answer: One aspect ( standard) measured at a time
◍ Procedural Knowledge.
Answer: BE ABLE TO DO Skills, strategies, processes( act or perform
tasks)
◍ Which operator is considered an equijoin?.
Answer: =
◍ Arranged in hierarchy.
Answer: Multi-tier architecture
◍ A file containing column values, along with pointers to rows containing the
column value..
Answer: Single-Level Index
◍ Grid of bits.
Answer: Bitmap Index
◍ A rule that governs allowable values in a database based on relational and
business rules and implemented with special keywords..
Answer: Constraint
◍ Collection of two or more participating databases under a coordinating
QUESTIONS WITH ANSWERS GRADED A+
◍ Combines two query results into one table..
Answer: UNION
◍ AKA: Reporting Data or Decision Support Data -Enterprise-wide- Used to
understand, manage, and plan the business- Summary Updated at fixed
intervals and summarized by time period -Combines data from many
business functions -Usually contains current and historic data.
Answer: Analytic Data
◍ Link between tools and query processor.
Answer: Connection
◍ Analytic database of raw, unprocessed data copied from multiple data
sources..
Answer: Data Lake
◍ Specifies tables, columns, and keys. Implements database requirements in a
specific database system. Also called a schema..
Answer: Logical Design
◍ An unordered collection of elements enclosed in braces..
Answer: Set
◍ Adding, deleting, and modifying data - Manipulates data stored in a
database..
Answer: DML
◍ A database offered as a PaaS cloud service..
Answer: Cloud Database
◍ AKA: Multi-tables. Interleave rows of two or more tables in the same
, storage area. They contain cluster keys..
Answer: Table Clusters
◍ Rejects an insert, update, or delete that violates referential integrity..
Answer: RESTRICT
◍ Validity.
Answer: Refers to the degree which the assessment is relevant to the content
and measures what it's supposed measure.
◍ No transitive dependencies (Functional dependencies on non-primary-key
attributes. Called transitive because the primary key is a determinant for
another attribute, which in turn is a determinant for a third. Solution:
Non-key determinant with transitive dependencies goes into a new table;
non-key determinant becomes primary key in the new table and remains as a
foreign key in the old table)..
Answer: Third Normal Form
◍ Retains data blocks from the file system for possible reuse..
Answer: Buffer Manager
◍ Entry for every table block.
Answer: Sparse Index
◍ Single or multi-level index that normally contains pointers to table blocks.
Answer: Physical Index
◍ Interact directly with database users and administrators and send queries to
the query processor. Includes Connectors & APIs, Workbench, and utility
programs..
Answer: Tools
◍ Each index entry is a composite of values from all indexed columns. Behave
exactly like indexes on a single column..
Answer: Multi-Column Index
◍ Volatile- Used to conduct daily business -Changes in real time -Detailed
Designed for specific business function -Concerned primarily with current
, data.
Answer: Operational Data
◍ Converts a SQL query into a sequence of low-level database actions, called
the query execution plan, which specifies precisely how to process a SQL
statement..
Answer: Query Optimizer
◍ Either run under different database systems or have incompatible schema..
Answer: Heterogenous Databases
◍ Candidate Key - Composite Key - Primary Key - Surrogate Key.
Answer: Unique
◍ Unidemensionality.
Answer: One aspect ( standard) measured at a time
◍ Procedural Knowledge.
Answer: BE ABLE TO DO Skills, strategies, processes( act or perform
tasks)
◍ Which operator is considered an equijoin?.
Answer: =
◍ Arranged in hierarchy.
Answer: Multi-tier architecture
◍ A file containing column values, along with pointers to rows containing the
column value..
Answer: Single-Level Index
◍ Grid of bits.
Answer: Bitmap Index
◍ A rule that governs allowable values in a database based on relational and
business rules and implemented with special keywords..
Answer: Constraint
◍ Collection of two or more participating databases under a coordinating
