Salesforce DATA-ARCHITECTURE-AND-MANAGEMENT-DESIGNER Online Practice Questions and Exam Preparation

Salesforce DATA-ARCHITECTURE-AND-MANAGEMENT-DESIGNER Online Questions & Answers

• Question 1:

  Universal Containers (UC) is implementing Salesforce Sales Cloud and Service Cloud. As part of their implementation, they are planning to create a new custom object (Shipments), which will have a lookup relationship to Opportunities. When creating shipment records, Salesforce users need to manually input a customer reference, which is provided by customers, and will be stored in the Customer_Reference__c text custom field. Support agents will likely use this customer reference to search for Shipment records when resolving shipping issues. UC is expecting to have around 5 million shipment records created per year. What is the recommended solution to ensure that support agents using global search and reports can quickly find shipment records?

  A. Implement an archiving process for shipment records created after five years.
  B. Implement an archiving process for shipment records created after three years.
  C. Set Customer-Reference_c as an External ID (non-unique).
  D. Set Customer-Reference_c as an External ID (unique).
  D. Set Customer-Reference_c as an External ID (unique).

• Question 2:

  Northern Trail Outfitters uses Salesforce to manage relationships and track sales opportunities. It has 10 million customers and 100 million opportunities. The CEO has been complaining that a dashboard is taking 10 minutes to run and sometimes fails to load, throwing a time-out error.

  Which three options should help improve the dashboard performance? (Choose three.)

  A. Run the dashboard for the CEO and send it via email.
  B. Denormalize the data by reducing the number of joins.
  C. Remove widgets from the dashboard to reduce the number of graphics loaded
  D. Reduce the amount of data queried by archiving unused opportunity records
  E. Use selective queries to reduce the amount of data being returned
  C. Remove widgets from the dashboard to reduce the number of graphics loaded
  D. Reduce the amount of data queried by archiving unused opportunity records
  E. Use selective queries to reduce the amount of data being returned

• Question 3:

  Cloud Kicks needs to purge detailed transactional records from Salesforce. The data should be aggregated at a summary level and available in Salesforce. What are two automated approaches to fulfill this goal? (Choose two.)

  A. Third-party Integration Tool (ETL)
  B. Schedulable Batch Apex
  C. Third-party Business Intelligence system
  D. Apex Triggers
  A. Third-party Integration Tool (ETL)
  B. Schedulable Batch Apex

• Question 4:

  Universal Containers (UC) has a Salesforce instance with over 10.000 Account records. They have noticed similar, but not identical. Account names and addresses. What should UC do to ensure proper data quality?

  A. Use a service to standardize Account addresses, then use a 3rd -party tool to merge Accounts based on rules.
  B. Run a report, find Accounts whose name starts with the same five characters, then merge those Accounts.
  C. Enable Account de -duplication by creating matching rules in Salesforce, which will mass merge duplicate Accounts.
  D. Make the Account Owner clean their Accounts' addresses, then merge Accounts with the same address.
  C. Enable Account de -duplication by creating matching rules in Salesforce, which will mass merge duplicate Accounts.

• Question 5:

  What should a data architect do to provide additional guidance for users when they enter information in a Standard field?

  A. Provide custom help text under field properties.
  B. Create a custom page with help text for user guidance.
  C. Add custom help text in default value for the field.
  D. Add a label field with help text adjacent to the custom field.
  D. Add a label field with help text adjacent to the custom field.

• Question 6:

  A customer is operating in a highly regulated industry and is planning to implement Salesforce. The customer information maintained in Salesforce, includes the following:

  1.

  Personally identifiable information (PII)

  2.

  IP restrictions on profiles organized by geographic location

  3.

  Financial records that need to be private and accessible only by the assigned sales associate

  4.

  Users should not be allowed to export information from Salesforce

  Enterprise Security has mandated access to be restricted to users within a specific geography and detail monitoring of user activity.

  Which three Salesforce Shield capabilities should a data architect recommend? (Choose three.)

  A. Event monitoring to monitor all user activities
  B. Restrict access to SF from users outside specific geography
  C. Prevent Sales users access to customer PII information
  D. Transaction security policies to prevent export of SF Data.
  E. Encrypt Sensitive Customer information maintained in SF.
  A. Event monitoring to monitor all user activities
  B. Restrict access to SF from users outside specific geography
  E. Encrypt Sensitive Customer information maintained in SF.

• Question 7:

  Universal Containers is migrating 100,000 accounts from an enterprise resource planning (ERP) to Salesforce and is concerned about ownership skew and performances. Which three recommendations should a data architect provide to prevent ownership skew? (Choose three.)

  A. Assign view all permissions on profile to give access to account
  B. Assign a default user as owner of accounts and assign top most role in hierarchy
  C. Assign a default user as owner of accounts, and assign role in hierarchy
  D. Keep users out of public groups that can be used as the source for sharing rules
  E. Assign a default user as owner of accounts and do not assign any role to default user
  A. Assign view all permissions on profile to give access to account
  D. Keep users out of public groups that can be used as the source for sharing rules
  E. Assign a default user as owner of accounts and do not assign any role to default user

• Question 8:

  Northern Trail Outfitter has implemented Salesforce for its associates nationwide, Senior management is concerned that the executive dashboard are not reliable for their real-time decision- making. On analysis , the team the following issues

  with data entered in Salesforce.

  Information in certain records is incomplete.

  Incorrect entry in certain fields causes records to be excluded in report fitters.

  Duplicate entries cause incorrect counts.

  Which three steps should a data architect recommend to address the issues?

  A. Periodically export data to cleanse data and import them back into Salesforce for executive reports.
  B. Build a sales data warehouse with purpose-build data marts for dashboards and senior management reporting.
  C. Explore third-party data providers to enrich and augment information entered in salesforce.
  D. Leverage Salesforce features, such as validate rules, to avoid incomplete and incorrect records.
  E. design and implement data-quality dashboard to monitor and act on records that are incomplete or incorrect
  B. Build a sales data warehouse with purpose-build data marts for dashboards and senior management reporting.
  C. Explore third-party data providers to enrich and augment information entered in salesforce.
  D. Leverage Salesforce features, such as validate rules, to avoid incomplete and incorrect records.

• Question 9:

  Universal Containers (UC) is facing data quality issues where Sales Reps are creating duplicate customer accounts, contacts, and leads. UC wants to fix this issue immediately by prompting users about a record that possibly exists in Salesforce. UC wants a report regarding duplicate records. What would be the recommended approach to help UC start immediately?

  A. Create an after insert and update trigger on the account, contact and lead, and send an error if a duplicate is found using a custom matching criteria.
  B. Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to report and alert for both creates and edits.
  C. Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to block for both creates and edits.
  D. Create a before insert and update trigger on account, contact, and lead, and send an error if a duplicate is found using a custom matching criteria.
  B. Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to report and alert for both creates and edits.

• Question 10:

  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.)

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