Data-Architecture-And-Management-Designer Exam Dumps – Our Features

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?

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

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?

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

A shipping and logistics company has created a large number of reports within Sales Cloud since Salesforce was introduced. Some of these reports analyze large amounts of data regarding the whereabouts of the company's containers, and they are starting to time out when users are trying to run the reports. What is a recommended approach to avoid these time-out issues?

• Improve reporting performance by creating a custom Visualforce report that is using a cache of the records in the report.
• Improve reporting performance by replacing the existing reports in Sales Cloud with new reports based on Analytics Cloud.
• Improve reporting performance by creating an Apex trigger for the Report object that will pre-fetch data before the report is run.
• Improve reporting performance by creating a dashboard that is scheduled to run the reports only once per day.

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?

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

A large retail B2C customer wants to build a 360 view of its customer for its call center agents. The customer interaction is currently maintained in the following system: 1. Salesforce CRM2. Custom billing solution3. Customer Master Data management (MDM)4. Contract Management system5. Marketing solutionWhat should a data architect recommend that would help upgrade uniquely identify customer across multiple systems:

• Store the salesforce id in all the solutions to identify the customer.
• Create a custom object that will serve as a cross reference for the customer id.
• Create a customer data base and use this id in all systems.
• Create a custom field as external id to maintain the customer Id from the MDM solution.

Cloud Kicks stores Invoice records in a custom object. Invoice records are being sent to the Accounting department with missing States and incorrectly formatted Postal Codes.Which two actions should Cloud Kicks take to improve data quality? (Choose two.)

• Change each address field to required on the Page Layout.
• Write an Apex Trigger to require all fields to be populated.
• Utilize a Validation Rule with a REGEX operator on Postal Code.
• Utilize a Validation Rule with a CONTAINS operator on address fields.

How can an architect find information about who is creating, changing, or deleting certain fields within the past two months?

• Remove 'customize application' permissions from everyone else.
• Export the metadata and search it for the fields in question.
• Create a field history report for the fields in question.
• Export the setup audit trail and find the fields in question.

UC has one SF org (Org A) and recently acquired a secondary company with its own Salesforce org (Org B). UC has decided to keep the orgs running separately but would like to bidirectionally share opportunities between the orgs in near-real time.Which 3 options should a data architect recommend to share data between Org A and Org B?Choose 3 answers.

• Leverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities.
• Install a 3rd party AppExchange tool to handle the data sharing
• Develop an Apex class that pushes opportunity data between orgs daily via the Apex schedule.
• Leverage middleware tools to bidirectionally send Opportunity data across orgs.
• Use Salesforce Connect and the cross-org adapter to visualize Opportunities into external objects

UC has large amount of orders coming in from its online portal. Historically all order are assigned to a generic user.Which 2 measures should data architect recommend to avoid any performance issues while working with large number of order records? Choose 2 answers:

• Clear the role field in the generic user record.
• Salesforce handles the assignment of orders automatically and there is no performance impact.
• Create a role at top of role hierarchy and assign the role to the generic user.
• Create a pool of generic users and distribute the assignment of memory to the pool of users.

A large Automobile company has implemented SF for its Sales Associates. Leads flow from its website to SF using a batch integration in SF. The Batch job connects the leads to Accounts in SF. Customer visiting their retail stores are also created in SF as Accounts.The company has noticed a large number of duplicate accounts in SF. On analysis, it was found that certain customers could interact with its website and also visit the store. The Sales associates use Global Search to search for customers in Salesforce before they create the customers.Which scalable option should a data Architect choose to implement to avoid duplicates?

• Create duplicate rules in SF to validate duplicates during the account creation process
• Implement a MDM solution to validate the customer information before creating Accounts in SF.
• Build Custom search based on fields on Accounts which can be matched with customer when they visit the store
• Customize Account creation process to search if customer exists before creating an Account.