WGU D426 Data Management Foundations Exam (Latest 2023/ 2023 Update) | Questions and Verified Answers|100% Correct| Grade A

WGU D426 Data Management Foundations

Exam (Latest 2023/ 2023 Update) | Questions

and Verified Answers|100% Correct| Grade

A

Q: The data about the data. Describes elements such as columns, names, and data type.

Answer:

Metadata

Q: Ordered collection of elements in parentheses.

Answer:

Tuple

Q: % of table rows selected by a query

Answer:

Hit Ration

Q: Reads blocks directly, without accessing an index.

Answer:

Table Scan

Q: Reads index blocks sequentially in order to locate the needed table blocks.

Answer:

Index Scan

Q: Database repeatedly splits the index in two until it finds a match.

Answer:

Binary

Search

Q: Database object that maps one or more tables to a single file.

Answer:

Tablespace

Q: Specifies tables, columns, and keys. Implements database requirements in a specific

database system. Also called a schema.

Answer:

Logical Design

Q: Specifies indexes, table structures, and partitions. Specifies how tables are organized on

storage media.

Answer:

Physical Design

Q: Components of a computer system and the relationships between compo- nents.

Answer:

Architecture

Q: Interact directly with database users and administrators and send queries to the query

processor. Includes Connectors & APIs, Workbench, and utility programs.

Answer:

Tools

Q: Interprets queries. Compiles queries into low-level instructions for the storage engine.

Creates a plan to modify the database or retrieve data, and returns query results to the

application.

Answer:

Query Processor

Q: Link between tools and query processor

Answer:

Connection

Q: Creates connections and manages communication between tools and query parser.

Answer:

Connection Manager

Q: Translates the query processor instructions into low-level file system commands that modify

or retrieve data.

Answer:

Storage Engine

Q: Accesses data on storage media. Data stored on storage media and orga- nized in files.

Contains 3 types of data : - User data (tables & indexes) - Log files (record of any changes) -

Data dictionary (aka: catalog directory of tables, columns, keys, indexes in a relational database).

One row for each database object.

Answer:

File System

Q: Stores reusable information in main memory.

Answer:

Cache Manager

Q: Retains data blocks from the file system for possible reuse.

Answer:

Buffer Manager

Q: Arranged in hierarchy

Answer:

Multi-tier architecture

Q: Multi-tier consisting of web browsers and web servers communicating over the internet.

Answer:

Web architecture

Q: A software layer that emulates a complete, independent computing envi- ronment.

Answer:

Virtual Machine

Q: A database offered as a PaaS cloud service.

Answer:

Cloud Database