Data Architecture and Management Designer Flashcards
“Cosmic Creations uses five different enterprise systems, including Salesforce, to access customer information and run its business. Leaders are complaining that it’s difficult to get a comprehensive picture of the business because there is no single source where key information from the five systems is linked and consolidated. The data architect is designing a Master Data Management strategy for the company. Which of the following considerations should be included in the strategy?↵Choose 3 answers.”
A. Rules should be defined for matching records from different systems.
B. The system of record should be identified for each key data attribute.
C. Salesforce should always be a single source of truth for all the customer data.
D. The most recently updated record in any system should always be a single source of truth.
E. It should be defined how the conflicting data between systems should be resolved.
A, B, E
“Cosmic Tools offers customers an extended warranty and discount on future purchases to customers if they register the tools they have purchased. The company would like to create a portal that customers can use to register all of their Cosmic Tools purchased, access information on the accessories that are compatible with their tools, view promotions, access warranty information, and log support requests. In order to develop the custom functionality, 6 custom objects are required. It is proposed that the case object be used for support requests and knowledge articles to record information on products and compatible accessories. It is expected that customers will register their tools after purchase, and then only access the community infrequently when they need to check their warranty, find accessories, log a support request, or use a discount offer. Which combination of license types for internal and external users should a data architect recommend to support this use case?↵Choose 1 answer.”
A. Service Cloud and Lighting External Apps member-based licenses
B. Service Cloud and Partner Community member-based licenses
C. Service Cloud and Customer Community login-based licences
D. Service Cloud and Customer Community Plus login-based licenses
C
“Cosmic Lighting implemented Salesforce Sales Cloud recently. Hundreds of thousands of old customer records were successfully migrated to Salesforce from a legacy system. The sales director of the company is now concerned about the new opportunities being created by the sales reps. She is unable to quickly ascertain what the new opportunities are about, as the reps are creating opportunities using unknown acronyms such as ‘TBC’ and ‘BCQ’. The old opportunity records that were migrated appear to be named much more sensibly, as the opportunity name always included the account’s name, opportunity type, close month and year, and nothing else. What solution can be utilized to ensure that the new opportunity names are generated automatically in Salesforce using this naming convention?↵Choose 1 answer.”
A. Create an opportunity validation rule that uses the REGEX function to generate the opportunity name automatically.
B. Change the data type of the opportunity name field to formula, consisting of the desired concatenation of Account and Opportunity fields, so that it is always accurate and consistent.
C. Create a before update trigger on the Opportunity object that generates the opportunity name automatically.
D. Create a process using Process Builder to change the opportunity name to the desired concatenation of Account and Opportunity fields via a formula.
D
“Cosmic Creations uses four different Salesforce orgs and wants to create a centralized view of the customer. The company has invested in Customer 360 Data Manager to build a global profile for each customer. What steps does the architect need to take to ensure that all the required data is properly mapped and transformed?↵Choose 3 answers.”
A. Install the Customer 360 Data Manager app in each org.
B. Identify the objects and fields to include from each org.
C. Add each org as a connected data source.
D. Configure mapping sets to map data from the orgs.
E. Add users’ login information from each org in the Customer 360 Data Manager hub.
B, C, D
“Which of the following statements are true about how Customer 360 Data Manager uses global profiles to provide a single view of customer across the connected orgs?↵Choose 3 answers.”
A. The global party ID should be added to records in each connected org.
B. A global profile is the combined data from the connected orgs that represents the single source of truth about a customer.
C. A global profile of each customer is replicated in each connected org.
D. A global profile is automatically created when an org is connected to the profile hub.
E. The global party ID is a unique identifier for a customer’s global profile.
A, B, E
“Cosmic Innovation has three Salesforce orgs, each of which uses Sales Cloud, Service Cloud or B2C Commerce Cloud. The Chief Technology Officer of the company would like to use Customer 360 Data Manager to create a unified view of customer data from the three orgs and create integrated experiences that allow users to retrieve data on-demand. The system administrator of the company has connected each org to Customer 360 Data Manager. Which of the following should be created to map the data between the connected orgs and the schema utilized by Customer 360 Data Manager?↵Choose 1 answer.”
A. Match Rules
B. Mapping Sets
C. Data Jobs
D. Data Map
B
“Cosmic Computers recently implemented Sales Cloud. The CEO has complained that opportunity reports are not providing her with enough details. She would like to see the opportunities grouped by different types of business deals on these reports. For example, partner co-proposals, federal funded projects, and RFP responses are some groupings that she would like to see in the reports. Each opportunity should have only one business deal type. What configuration should be recommended?↵Choose 1 answer.”
A. Add a new custom multi-select picklist field on the Opportunity object to capture the business deal type.
B. Add a new custom formula field on the Opportunity object to derive the business deal type automatically.
C. Add a new custom picklist field on the Opportunity object to capture the business deal type.
D. Add a new custom text field on the Opportunity object to capture the business deal type.
C
“Cosmic Solutions wants to create a community for its customers to allow them to view product information, create cases, and view any cases they have created. What type of community license should be recommended?↵Choose 1 answer.”
A. Lightning Platform Plus
B. Customer Community Plus
C. Partner Community
D. Customer Community
D
“Cosmic Sporting Goods sells its products to individuals and other companies in the United States. Sales reps of the company regularly create and update contact records in Salesforce. The company’s data steward has created certain data entry guidelines for adding and modifying information on contact records. Which of the following should be considered during the next data assessment to measure the consistency of data across all the contact records?↵Choose 3 answers.”
A. The correctness of address and phone fields
B. Formatting of data in text fields
C. The language used in text fields
D. Last time each record was updated
E. The spelling of title and department
B, C, E
“Cosmic Foods & Goods uses a Salesforce org that has more than 500,000 account records. Sales users of the company have identified various accounts with very similar names, phone numbers, or email addresses. Which of the following solutions can be utilized by a system administrator in order to resolve this issue and prevent the creation of more account records with similar attributes?↵Choose 2 answers.”
A. Use a custom application to manage duplicates.
B. Use a native tool to merge similar account records.
C. Use duplicate and matching rules to prevent the creation of additional duplicate records.
D. Use a data integration rule to identify duplicate records.
B, C
“Cosmic Service Solutions would like to implement a data governance plan to monitor, maintain and improve the quality of data in Salesforce. Which of the following can be used to enforce the plan?↵Choose 3 answers.”
A. Apex triggers to validate the format of fields
B. Weekly dashboard that displays key data quality metrics
C. Validation rules to validate information and enforce data entry by users
D. Matching rules to update Salesforce data based on crowd-sourced data
E. Workflow rules to automatically update key information
B, C, E
“A new sales representative of Cosmic Solutions recently deleted several important account records owned by other users below him in the role hierarchy. Although the records were recovered, the sales director would like to prevent this from happening in the future. Which of the following can be used to ensure that only the owner of an account record or his manager can delete the account?↵Choose 1 answer.”
A. Validation Rule
B. Apex Trigger
C. Matching Rule
D. Visualforce Page
B
“Cosmic Service Solutions has millions of account and contact records in Salesforce. Data quality issues such as missing address and phone numbers are quite common, which is adversely affecting the billing process. The chief data analyst of the company is looking for an effective way to monitor data quality and measure data quality metrics. What should a data architect recommend for this requirement?↵Choose 1 answer.”
A. Download and install a data quality dashboard app from the AppExchange.
B. Create data quality reports and dashboards based on the business requirement.
C. Use Data Integration rules to monitor and measure data quality on an ongoing basis.
D. Use Lightning Data to integrate with a third-party service for data monitoring.
A
“Cosmic Solutions has a field on the Account record called ‘Service Level’ and a field on the Contact record called ‘Position Title’. These two fields are also on the Case record. In order to avoid data inconsistency, there is a need to ensure that these two fields on the Case record are the same as their corresponding fields on the account and contact records. A user should not have to specify the field values again. What should the data architect recommend to the Salesforce administrator to achieve this?↵Choose 1 answer.”
A. Create two lookup fields on the Case object.
B. Create two picklist fields on the Case object that contain predefined values.
C. Create a validation rule to ensure that the two fields are the same.
D. Create two formula fields on the Case object.
D
“Several sales agents of Cosmic Innovation have complained that there are various businesses that are not reachable due to inaccurate phone number and/or email address. The company has almost five million account records in Salesforce. Which of the following about records with inaccurate information would explain this data quality issue faced by users?↵Choose 2 answers.”
A. Users are entering incomplete data while creating or updating records.
B. There are no guidelines that enforce data entry.
C. The records have not been matched against a trusted source.
D. The records are outdated and have not been updated for a while.
C, D
“A business has a requirement to capture phone numbers that follow the US format in a new custom field on a custom object. The phone number should be rejected if it isn’t entered using the standard US format of +1 (999) 999-9999 (with or without the country code). What should be recommended to achieve this requirement?↵Choose 1 answer.”
A. Use the REGEX function in a Validation Rule to enforce that the correct format has been entered.
B. Use the INCLUDE function in an Autolaunched Flow to enforce that the correct format has been entered.
C. Use the REGEX function in an Autolaunched Flow to enforce that the correct format has been entered.
D. Use the INCLUDE function in a Validation Rule to enforce that the correct format has been entered.
A
“The data steward of Cosmic Service Solutions has found a number of cases on which the selected contact is not associated to the account that has been added to the case. The support director would like to ensure that, while adding a contact to a case, a user can only select one of the contacts that are related to the selected account. Which of the following can be used to achieve this?↵Choose 1 answer.”
A. Lookup Filter on the ‘Account’ field
B. Dependent Field
C. Lookup Filter on the ‘Contact’ field
D. Validation Rule
C
