What Top Quality Data-Architecture-And-Management-Designer Pdf Exam Is

NEW QUESTION 1
Universal Container has a Sales Cloud implementation for a sales team and an enterprise resource planning (ERP) as a customer master Sales team are complaining about duplicate account and data quality issues with account data.
Which two solution should a data architect recommend to resolve the complaints?

• A. Build a nightly batch job to de-dupe data, and merge account records.
• B. Integrate Salesforce with ERP, and make ERP as system of truth.
• C. Build a nightly sync job from ERP to Salesforce.
• D. Implement a de-dupe solution and establish account ownership in Salesforce

Answer: BD

NEW QUESTION 2
NTO has a loyalty program to reward repeat customers. The following conditions exists: 1.Reward levels are earned based on the amount spent during the previous 12 months.
2. The program will track every item a customer has bought and grant them points for discount. 3.The program generates 100 million records each month.
NTO customer support would like to see a summary of a customer’s recent transaction and reward level(s) they have attained.
Which solution should the data architect use to provide the information within the salesforce for the customer support agents?

• A. Create a custom object in salesforce to capture and store all reward progra
• B. Populate nightly from the point-of-scale system, and present on the customer record.
• C. Capture the reward program data in an external data store and present the 12 months trailing summary in salesforce using salesforce connect and then external object.
• D. Provide a button so that the agent can quickly open the point of sales system displaying the customer history.
• E. Create a custom big object to capture the reward program data and display it on the contact record and update nightly from the point-of-scale system.

Answer: D

NEW QUESTION 3
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.

Answer: B

NEW QUESTION 4
To address different compliance requirements, such as general data protection regulation (GDPR), personally identifiable information (PII), of health insurance Portability and Accountability Act (HIPPA) and others, a SF customer decided to categorize each data element in SF with the following:
Data owner
Security Level, such as confidential
Compliance types such as GDPR, PII, HIPPA
A compliance audit would require SF admins to generate reports to manage compliance.
What should a data architect recommend to address this requirement?

• A. Use metadata API, to extract field attribute information and use the extract to classify and build reports
• B. Use field metadata attributes for compliance categorization, data owner, and data sensitivity level.
• C. Create a custom object and field to capture necessary compliance information and build custom reports.
• D. Build reports for field information, then export the information to classify and report for Audits.

Answer: B

NEW QUESTION 5
A customer wishes to migrate 700,000 Account records in a single migration into Salesforce. What is the recommended solution to migrate these records while minimizing migration time?

• A. Use Salesforce Soap API in parallel mode.
• B. Use Salesforce Bulk API in serial mode.
• C. Use Salesforce Bulk API in parallel mode.
• D. Use Salesforce Soap API in serial mode.

Answer: C

NEW QUESTION 6
Universal Containers (UC) has an open sharing model for its Salesforce users to allow all its Salesforce internal users to edit all contacts, regardless of who owns the contact. However, UC management wants to allow only the owner of a contact record to delete that contact. If a user does not own the contact, then the user should not be allowed to delete the record. How should the architect approach the project so that the requirements are met?

• A. Create a "before delete" trigger to check if the current user is not the owner.
• B. Set the Sharing settings as Public Read Only for the Contact object.
• C. Set the profile of the users to remove delete permission from the Contact object.
• D. Create a validation rule on the Contact object to check if the current user is not the owner.

Answer: A

NEW QUESTION 7
Universal containers is implementing Salesforce lead management. UC Precure lead data from multiple sources and would like to make sure lead data as company profile and location information. Which solution should a data architect recommend to make sure lead data has both profile and location information? Option

• A. Ask sales people to search for populating company profile and location data
• B. Run reports to identify records which does not have company profile and location data
• C. Leverage external data providers populate company profile and location data
• D. Export data out of Salesforce and send to another team to populate company profile and location data

Answer: B

NEW QUESTION 8
Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called "Order c"; this has about 50 fields. UC is expecting a growth of 10% year -over -year. What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object? Choose 2 answers

• A. Use SOQL queries without WHERE conditions.
• B. Work with Salesforce Support to enable Skinny Tables.
• C. Reduce the number of triggers on Order _c object.
• D. Make the queries more selective using indexed fields.

Answer: BD

NEW QUESTION 9
Salesforce is being deployed in Ursa Major Solar's disparate, multi-system ERP environment. Ursa major Solar wants to maintain data synchronization between systems.
Which two techniques should be used to achieve this goal? (Choose two.)

• A. Integrate Salesforce with the ERP environment.
• B. Utilize workbench to update files within systems.
• C. Utilize an MDM strategy to outline a single source of truth.
• D. Build synchronization reports and dashboards.

Answer: AC

NEW QUESTION 10
For a production cutover, a large number of Account records will be loaded into Salesforce from a legacy system. The legacy system does not have enough information to determine the Ownership for these Accounts upon initial load. Which two recommended options assign Account ownership to mitigate potential performance problems?

• A. Let a “system user” own all the Account records without assigning any role to this user in Role Hierarchy.
• B. Let a “system user” own the Account records and assign this user to the lowest-level role in the Role Hierarchy.
• C. Let the VP of the Sales department, who will report directly to the senior VP, own all the Account records.
• D. Let a “system user” own all the Account records and make this user part of the highest-level role in the Role Hierarchy.

Answer: AB

NEW QUESTION 11
UC has multiple SF orgs that are distributed across regional branches. Each branch stores local customer data inside its org’s Account and Contact objects. This creates a scenario where UC is unable to view customers across all orgs.
UC has an initiative to create a 360-degree view of the customer, as UC would like to see Account and Contact data from all orgs in one place.
What should a data architect suggest to achieve this 360-degree view of the customer?

• A. Consolidate the data from each org into a centralized datastore
• B. Use Salesforce Connect’s cross-org adapter.
• C. Build a bidirectional integration between all orgs.
• D. Use an ETL tool to migrate gap Accounts and Contacts into each org.

Answer: A

NEW QUESTION 12
Universal Containers (UC) has implemented Sales Cloud and it has been noticed that Sales reps are not entering enough data to run insightful reports and dashboards. UC executives would like to monitor and measure data quality metrics. What solution addresses this requirement?

• A. Use third-party AppExchange tools to monitor and measure data quality.
• B. Generate reports to view the quality of sample data.
• C. Use custom objects and fields to calculate data quality.
• D. Export the data to an enterprise data warehouse and use BI tools for data quality.

Answer: A

NEW QUESTION 13
UC is rolling out Sales App globally to bring sales teams together on one platform. UC expects millions of opportunities and accounts to be creates and is concerned about the performance of the application.
Which 3 recommendations should the data architect make to avoid the data skew? Choose 3 answers.

• A. Use picklist fields rather than lookup to custom object.
• B. Limit assigning one user 10000 records ownership.
• C. Assign 10000 opportunities to one account.
• D. Limit associating 10000 opportunities to one account.
• E. Limit associating 10000 records looking up to same records.

Answer: BD

NEW QUESTION 14
What 2 data management policies does the data classification feature allow customers to classify in salesforce? Choose 2 answers:

• A. Reference data policy.
• B. Data governance policy.
• C. Data sensitivity policy.
• D. Compliance categorization policy.

Answer: CD

NEW QUESTION 15
What makes Skinny tables fast? Choose three answers.

• A. They do not include soft-deleted records
• B. They avoid resource intensive joins
• C. Their tables are kept in sync with their source tables when the source tables are modified
• D. They can contain fields from other objects
• E. They support up to a max of 100 of columns

Answer: ABC

NEW QUESTION 16
Universal Containers is setting up an external Business Intelligence (BI) system and wants to extract 1,000,000 Contact records. What should be recommended to avoid timeouts during the export process?

• A. Use the SOAP API to export data.
• B. Utilize the Bulk API to export the data.
• C. Use GZIP compression to export the data.
• D. Schedule a Batch Apex job to export the data.

Answer: C

NEW QUESTION 17
Universal Containers (UC) has over 10 million accounts with an average of 20 opportunities with each account. A Sales Executive at UC needs to generate a daily report for all opportunities in a specific opportunity stage.
Which two key considerations should be made to make sure the performance of the report is not degraded due to large data volume?

• A. Number of queries running at a time.
• B. Number of joins used in report query.
• C. Number of records returned by report query.
• D. Number of characters in report query.

Answer: BC

NEW QUESTION 18
Northern trail Outfitters (NTO) runs its entire out of an enterprise data warehouse (EDW), NTD’s sales team starting to use Salesforce after a recent implementation, but currently lacks data required to advanced and opportunity to the next stage.
NTO’s management has research Salesforce Connect and would like to use It to virtualize and report on data from the EDW within Salesforce. NTO will be running thousands of reports per day across 10 to 15 external objects.
What should a data architect consider before implementing Salesforce Connect for reporting?

• A. Maximum number for records returned
• B. OData callout limits per day
• C. Maximum page size for server-driven paging
• D. Maximum external objects per org

Answer: B

NEW QUESTION 19
Universal Containers (UC) has an Application custom object, which has tens of millions of records created in the past 5 years. UC needs the last 5 years of data to exist in Salesforce at all times for reporting and queries. UC is currently encountering performance issues when reporting and running queries on this Object using date ranges as filters. Which two options can be used to improve report performance?

• A. Ask support to create a skinny table for Application with the necessary reporting fields.
• B. Add custom indexes to all fields on Application without a standard index.
• C. Run multiple reports to get different pieces of the data and combine them.
• D. Add custom indexes to the Date fields used for filtering the report.

Answer: AD

NEW QUESTION 20
......