Free Salesforce Data-Architecture-And-Management-Designer Exam Dumps Questions & Answers

Universal Containers (UC) provides shipping services to its customers. They use Opportunities to track customer shipments. At any given time, shipping status can be one of the 10 values. UC has 200,000 Opportunity records. When creating a new field to track shipping status on opportunity, what should the architect do to improve data quality and avoid data skew?

• A.  Create a Master -Detail to custom object ShippingStatus c.
• B.  Create a picklist field, values sorted alphabetically.
• C.  Create a Lookup to custom object ShippingStatus c.
• D.  Create a text field and make it an external ID.

Universal Containers (UC) is migrating from an on-premise homegrown customer relationship management (CRM) system- During analysis, UC users highlight a pain point that there are multiple versions of many customers.
What should the data architect do for a successful migration to mitigate the pain point?

• A.  Have the users manually clean the data in the old system prior to migration.
• B.  Hire an intern manually de-duplicate the records after migrating to Salesforce.
• C.  Migrate the data as is, and use Salesforce's de-duplicating feature.
• D.  Store the data in a staging database, and de-duplicate identical records.

Universal Containers would like to have a Service-Level Agreement (SLA) of 1 day for any data loss due to unintentional or malicious updates of records in Salesforce. What approach should be suggested to address this requirement?

• A.  Evaluate a third-party AppExchange app, such as OwnBackup or Spanning, etc., for backup and archival purposes.
• B.  Schedule a Weekly Extract Service for key objects and extract data in XL sheets to on-premise systems.
• C.  Store all data in shadow custom objects on any updates and deletes, and extract them as needed .
• D.  Build a daily extract job and extract data to on-premise systems for long-term backup and archival purposes.

Universal Containers (UC) has users complaining about reports timing out or simply taking too long to run What two actions should the data architect recommend to improve the reporting experience? Choose 2 answers

• A.  Create one skinny table per report.
• B.  Index key fields used in report criteria.
• C.  Enable Divisions for large data objects.
• D.  Share each report with fewer users.

Universal Containers (UC) is in the process of selling half of its company. As part of this split, UC's main Salesforce org will be divided into two org:org A and org B, UC has delivered these requirements to its data architect
1. The data model for Org B will drastically change with different objects, fields, and picklist values.
2. Three million records will need to be migrated from org A to org B for compliance reasons.
3. The migrate will need occur within the next two month, prior to be split.
Which migrate strategy should a data architect use to successfully migrate the date?

• A.  Use Data Loader for export and Data Import Wizard for import
• B.  Write a script to use the Bulk API
• C.  Use the Salesforces CLI to query, export, and import
• D.  use as ETL tool to orchestrate the migration.