Free Data-Architect Exam Braindumps
Salesforce Certified Data Architect Questions 106–110 (page: 23)

Updated On: 9-Feb-2026

Universal Containers (UC) is a major supplier of office supplies. Some products are produced by UC and some by other manufacturers. Recently, a number of customers have complained that product descriptions on the invoices do not match the descriptions in the online catalog and on some of the order confirmations (e.g., "ballpoint pen" in the catalog and "pen" on the invoice, and item color labels are inconsistent: "what vs. "White" or "blk" vs. "Black"). All product data is consolidated in the company data warehouse and pushed to Salesforce to generate quotes and invoices. The online catalog and webshop is a Salesforce Customer Community solution.
What is a correct technique UC should use to solve the data inconsistency?

  1. Change integration to let product master systems update product data directly in Salesforce via the Salesforce API.
  2. Add custom fields to the Product standard object in Salesforce to store data from the different source systems.
  3. Define a data taxonomy for product data and apply the taxonomy to the product data in the data warehouse.
  4. Build Apex Triggers in Salesforce that ensure products have the correct names and labels after data is loaded into salesforce.

Answer(s): C



What makes Skinny tables fast? Choose three answers.

  1. They do not include soft-deleted records
  2. They avoid resource intensive joins
  3. Their tables are kept in sync with their source tables when the source tables are modified
  4. They can contain fields from other objects
  5. They support up to a max of 100 of columns

Answer(s): A,B,C



Universal Containers is creating a new B2C service offering for consumers to ship goods across continents. This is in addition to their well-established B2B offering. Their current Salesforce org uses the standard Account object to track B2B customers. They are expecting to have over 50,000,000 consumers over the next five years across their 50 business regions. B2C customers will be individuals. Household data is not required to be stored.
What is the recommended data model for consumer account data to be stored in Salesforce?

  1. Use the Account object with Person Accounts and a new B2C page layout.
  2. Use the Account object with a newly created Record Type for B2C customers.
  3. Create a new picklist value for B2C customers on the Account Type field.
  4. Use 50 umbrella Accounts for each region, with customers as associated Contacts.

Answer(s): A



Universal Containers (UC) is implementing a new customer categorization process where customers should be assigned to a Gold, Silver, or Bronze category if they've purchased UC's new support service. Customers are expected to be evenly distributed across all three categories. Currently, UC has around 500,000 customers, and is expecting 1% of existing non-categorized customers to purchase UC's new support service every month over the next five years.
What is the recommended solution to ensure long-term performance, bearing in mind the above requirements?

  1. Implement a new global picklist custom field with Gold, Silver, and Bronze values and enable it in Account.
  2. Implement a new picklist custom field in the Account object with Gold, Silver, and Bronze values.
  3. Implement a new Categories custom object and a master-detail relationship from Account to Category.
  4. Implement a new Categories custom object and create a lookup field from Account to Category.

Answer(s): B



Ursa Major Solar's legacy system has a quarterly accounts receivable report that compiles data from the following:

- Accounts

- Contacts

- Opportunities

- Orders

- Order Line Items

Which issue will an architect have when implementing this in Salesforce?

  1. Custom report types CANNOT contain Opportunity data.
  2. Salesforce does NOT support Orders or Order Line Items.
  3. Salesforce does NOT allow more than four objects in a single report type.
  4. A report CANNOT contain data from Accounts and Contacts.

Answer(s): C



Viewing page 23 of 53
Viewing questions 111 - 115 out of 257 questions


Post your Comments and Discuss Salesforce Data-Architect exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!