WGU D426 Data Management Foundations Exam (Latest 2023\/ 2023 Update) | Questions and Verified Answers|100% Correct| Grade A<\/p>\n\n\n\n
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<\/p>\n\n\n\n
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<\/p>\n\n\n\n
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<\/p>\n\n\n\n
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
Powered by https:\/\/learnexams.com\/search\/study?query=<\/a><\/p>\n\n\n\n