DATA-ARCHITECTURE-AND-MANAGEMENT-DESIGNER Online Practice Questions and Answers

A Customer is migrating 10 million order and 30 million order lines into Salesforce using Bulk API. The

Engineer is experiencing time-out errors or long delays querying parents order IDs in Salesforce before

importing related order line items.

What is the recommended solution?

A. Query only indexed ID field values on the imported order to import related order lines.

B. Leverage an External ID from source system orders to import related order lines.

C. Leverage Batch Apex to update order ID on related order lines after import.

D. Leverage a sequence of numbers on the imported orders to import related order lines.

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

1.

Accounts

2.

Contacts

3.

Opportunities

4.

Orders

5.

Order Line Items

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

A. Custom report types CANNOT contain Opportunity data.

B. Salesforce does NOT support Orders or Order Line Items.

C. Salesforce does NOT allow more than four objects in a single report type.

D. A report CANNOT contain data from Accounts and Contacts.

Ursa Major Solar has defined a new Data Quality Plan for their Salesforce data. Which two approaches should an Architect recommend to enforce the plan throughout the organization? (Choose two.)

A. Ensure all data is stored in an external system and set up an integration to Salesforce for view-only access.

B. Schedule reports that will automatically catch duplicates and merge or delete the records every week.

C. Enforce critical business processes by using Workflow, Validation Rules, and Apex code.

D. Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.

NTO would like to retrieve their SF orgs meta data programmatically for backup within a various external. Which API is the best fit for accomplishing this task?

A. Metadata API

B. Tooling API

C. Bulk API in serial mode

D. SOAP API

Universal Containers (UC) has the following systems:

1.

Billing system

2.

Customer support system

3.

CRM system

UC has been having trouble with business intelligence across the different systems. Recently UC implemented a master data management (MDM) solution that will be the system of truth for the customer records.

Which MDM data element is needed to allow reporting across these systems?

A. Global unique customer number.

B. Email address.

C. Phone number.

D. Full name.

Universal Containers (UC) has built a B2C ecommerce site on Heroku that shares customer and order data with a Heroku Postgres database. UC is currently utilizing Postgres as the Single Source of Truth for both customers and orders. UC has asked a data architect to replicate this data into Salesforce so that Salesforce can now act as the System of Record.

What are the three considerations that a data architect should weigh before implementing this requirement? (Choose three.)

A. Consider whether the data is required for sales reports, dashboards and KPI's.

B. Determine if the data is driver of key process implemented within salesforce.

C. Ensure there is a tight relationship between order data and an enterprise resource plaining (ERP) application.

D. Ensure the data is CRM center and able to populate standard of custom objects.

E. A selection of the tool required to replicate the data.

F. -Heroku Connect is required but this is confusing

Universal Containers needs to load a large volume of leads into Salesforce on a weekly basis. During this process the validation rules are disabled.

What should a data architect recommend to ensure data quality is maintained in Salesforce?

A. Activate validation rules once the leads are loaded into salesforce to maintain quality.

B. Allow validation rules to be activated during the load of leads into salesforce.

C. Develop custom APEX batch process to improve quality once the load is completed.

D. Ensure the lead data is preprocessed for quality before loading into salesforce.

Universal Container (UC) has accumulated data over years and has never deleted data from its Salesforce org. UC is now exceeding the storage allocations in the org. UC is now looking for option to delete unused from the org. Which three recommendations should a data architect make is order to reduce the number of records from the org? Choose 3 answers

A. Use hard delete in Bulk API to permanently delete records from Salesforce.

B. Use hard delete in batch Apex to permanently delete records from Salesforce.

C. Identify records in objects that have not been modified or used In last 3 years.

D. Use Rest API to permanently delete records from the Salesforce org.

E. Archive the records in enterprise data warehouse (EDW) before deleting from Salesforce.

Universal Containers (UC) is implementing Salesforce and will be using Salesforce to track customer complaints, provide white papers on products, and provide subscription (fee)-based support.

Which license type will UC users need to fulfill UC's requirements?

A. Salesforce License

B. Lightning Platform Starter License

C. Service Cloud License

D. Sales Cloud License

Cloud Kicks plans on setting up an external Business Intelligence (BI) system and will extract 1.5 million Contact records. The company wants to avoid timeouts during the export process.

What should an Architect recommend to fulfill this request?

A. Utilize the SOAP API to export data.

B. Utilize the Bulk API to export the data.

C. Schedule a Batch Apex job to export the data.

D. Utilize GZIP compression to export the data.