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

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

WGU D426 Data Management Foundations
Exam (New 2023/ 2023 Update) | Graded A |
Questions and Verified Answers|100%
Correct
QUESTION
Group of nodes connected by a LAN, managed by separate operating system instances. Similar
to a parallel computer.
Answer:
Cluster
QUESTION
Runs on a parallel computer or cluster
Answer:
Parallel Database
QUESTION
Runs on multiple computers connected by a WAN
Answer:
Distributed Database
QUESTION
Updates data on multiple nodes of a distributed database. Two-phase com- mit (nodes receive
notice of update, store update in log, send confirmation, then receive commit). Either all nodes or
no nodes must be successfully updated.
Answer:
Distributed Transactions

QUESTION
Updates data on a single node of a distributed database. Databases that use this are called
“eventually consistent”.
Answer:
Local Transaction
QUESTION
States that a distributed database cannot be Consistent, Available, and Petition-tolerant
simutaneously. Availability refers to individual nodes. Con- sistent database – confirms to all
rules at all times. Network partition – forms when a network error prevents nodes from
communicating. Petition-tolerant

• database that continues to function when a network partition occurs.
  Answer:
  CAP Theorem
  QUESTION
  Maintains two or more replicas on separate storage devices. Advantages: High availability, fast
  concurrent reads, local reads. Disadvantages: Slow or inconsistent updates.
  Answer:
  Replicated database
  QUESTION
  Entire catalog resides on a single node
  Answer:
  Central Catalog
  QUESTION
  Copy of catalog resides on each node
  Answer:

Replicated Catalog
QUESTION
Volatile- Used to conduct daily business -Changes in real time -Detailed Designed for specific
business function -Concerned primarily with current data
Answer:
Operational Data
QUESTION
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
QUESTION
Data warehouse designed for specific business area
Answer:
Data Mart
QUESTION
Analytic database of raw, unprocessed data copied from multiple data sources.
Answer:
Data Lake
QUESTION
Optimized for analytics
Answer:

Data Warehouse
QUESTION
Five-step process – ETL: Extract-Transform Load 1) Extract data 2) Cleanse data 3) Integrate
data 4) Restructure data 5) Load data – Open-source ETL tools: -PowerCenter -SQL Server
Integration Services -Oracle Data IntegratorAnswer:
Data Warehouse Refresh
QUESTION
AKA: Star Schema – Consists of fact and dimension tables. Fact Table – Contains numeric data
used to measure business performance.. Primary key is the composite for all foreign keys
referencing dimension tables. Dimension Table – Contains textual data that describes the fact
data.
Answer:
Dimensional Design
QUESTION
Sequence of columns in which each column has a one-many relationship to the next column.
Answer:
Dimension Hierarchy
QUESTION
A database that stores data in main memory, instead of or in addition to storage media. Ex: SQL
Server In-Memory OLTP – Oracle Database In-Memory

• MySQL
  Answer:
  In-Memory Databases
  Powered by https://learnexams.com/search/study?query=