Plat-Arch-201 practice question 1 of 10

Universal Containers (UC) wants to capture information on how data entities are stored within the different applications and systems used within the…

Full set: 257 questions
Universal Containers (UC) wants to capture information on how data entities are stored within the different applications and systems used within the company. For that purpose, the architecture team decided to create a data dictionary covering the main business domains within UC. Which two common techniques are used building a data dictionary to store information on how business entities are defined?
Answer options
A: Use Salesforce Object Query Language.
B: Use a data definition language.
C: Use an entity relationship diagram. Correct answer
D: Use the Salesforce Metadata API. Correct answer
Correct Answer:
C. Use an entity relationship diagram.; D. Use the Salesforce Metadata API.
Explanation

A data dictionary documents the metadata, or "data about the data." An Entity Relationship Diagram (ERD) is a fundamental technique used to visually model the business entities, their attributes, and the relationships between them, forming the conceptual and logical basis of the dictionary. The Salesforce Metadata API is a programmatic tool used to retrieve the technical definitions of objects, fields, and other configurations directly from the Salesforce platform. Using the Metadata API allows for the automated extraction of the physical schema to populate and maintain the data dictionary, ensuring it accurately reflects the system's current state.

Why Incorrect

A. Salesforce Object Query Language (SOQL) is used to query and retrieve data records, not to define or describe the structure (metadata) of the data entities.
B. A data definition language (DDL) is the set of commands (e.g., CREATE TABLE) used to build the database structure, not a technique for documenting it in a dictionary.

References

1. Salesforce Developers, Metadata API Developer Guide - Introduction to Metadata API, "You can use Metadata API to retrieve, deploy, create, update, or delete customization information, such as custom object definitions... for your organization."

2. Silberschatz, A., Korth, H. F., & Sudarshan, S. (2019). Database System Concepts (7th ed.). McGraw-Hill. Chapter 7, "Database Design and the E-R Model," explains the use of ERDs for modeling entities and their attributes, which is a core component of a data dictionary's content.

3. Salesforce Architects, Salesforce Well-Architected - Data Architecture: Data Modeling, "Data modeling is the process of creating a visual representation of an information system... Common artifacts include Entity Relationship Diagrams (ERDs)." (https://architect.salesforce.com/well-architected/framework/data/data-modeling)

Scroll to Top