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?

A. Use Salesforce Object Query Language.

B. Use a data definition language.

C. Use an entity relationship diagram.

D. Use the Salesforce Metadata API.

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?

A. Change integration to let product master systems update product data directly in Salesforce via the Salesforce API.

B. Add custom fields to the Product standard object in Salesforce to store data from the different source systems.

C. Define a data taxonomy for product data and apply the taxonomy to the product data in the data warehouse.

D. Build Apex Triggers in Salesforce that ensure products have the correct names and labels after data is loaded into salesforce.

Northern Trail Outfitters (NTO) has decided to franchise its brand. Upon implementation 1,000 franchisees will be able to access NTO's product information and track large customer sales and opportunities through a portal. The franchisees will also be able to run monthly and quarterly sales reports and projections as well as view the reports in dashboards.

Which license does NTO need to provide these features to the franchisees?

A. Salesforce Sales Cloud license

B. Lightning Platform license

C. Customer Community license

D. Partner Community license

Universal Container (US) is replacing a home grown CRM solution with Salesforce, UC has decided to migrate operational (Open and active) records to Salesforce, while keeping historical records in legacy system, UC would like historical records to be available in Salesforce on an as needed basis. Which solution should a data architect recommend to meet business requirement?

A. Leverage real-time integration to pull records into Salesforce.

B. Bring all data Salesforce, and delete it after a year.

C. Leverage mashup to display historical records in Salesforce.

D. Build a chair solution to go the legacy system and display records.

Northern Trail Outfitters (NTO) need to extract 50 million records from a custom object every day from its Salesforce org. NTO is facing query time-out issues while extracting these records.

What should a data architect recommend in order to get around the time-out issue?

A. Ask Salesforce support to increase the query time-out value

B. Use extract transform tool (ETL) tool for extraction of records

C. Use Rest API to extract data as it automatically chunks records by 200

D. Use custom auto number and formula field and use that to chunk records while extracting data