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

• Question 61:

  NTO has outgrown its current salesforce org and will be migrating to new org shortly. As part of this process NTO will be migrating all of its metadata and data. NTO's data model in the source org has a complex relationship hierarchy with several master detail and lookup relationships across objects, which should be maintained in target org. What 3 things should a data architect do to maintain the relationship hierarchy during migration? Choose 3 answers:

  A. Use data loader to export the data from source org and then import or Upsert into the target org in sequential order.

  B. Create a external id field for each object in the target org and map source record ID's to this field.

  C. Redefine the master detail relationship fields to lookup relationship fields in the target org.

  D. Replace source record ID's with new record ID's from the target org in the import file.

  E. Keep the relationship fields populated with the source record ID's in the import file.

  Correct Answer: ABD

• Question 62:

  UC has a requirement to migrate 100 million order records from a legacy ERP application into the salesforce platform. UC does not have any requirements around reporting on the migrated data. What should a data architect recommend to reduce the performance degradation of the platform?

  A. Create a custom object to store the data.

  B. Use a standard big object defined by salesforce.

  C. Use the standard "Order" object to store the data.

  D. Implement a custom big object to store the data.

  Correct Answer: C

• Question 63:

  Universal Containers is building a Salesforce application to track Contacts and the respective Conferences that they have attended with the following requirements:

  1.

  Contacts will be stored in the standard Contact object.

  2.

  Conferences will be stored in a custom Conference_ _c object.

  3.

  Each Contact may attend multiple Conferences and each Conference may be related to multiple Contacts.

  How should a data architect model the relationship between the Contact and Conference_ _c objects?

  A. Implement a Contact Conference junction object with master-detail relationships to both Contact and Conference_ _c.

  B. Create a master-detail relationship field on the Conference_ _c object

  C. Create a lookup relationship field on the Contact object.

  D. Create a master-detail relationship field on the Contact object.

  Correct Answer: D

• Question 64:

  Universal Containers needs to load a large volume of leads into Salesforce on a weekly basis. During this process the validation rules are disabled.

  What should a data architect recommend to ensure data quality is maintained in Salesforce?

  A. Activate validation rules once the leads are loaded into salesforce to maintain quality.

  B. Allow validation rules to be activated during the load of leads into salesforce.

  C. Develop custom APEX batch process to improve quality once the load is completed.

  D. Ensure the lead data is preprocessed for quality before loading into salesforce.

  Correct Answer: C

• Question 65:

  Universal Containers (UC) recently migrated 1 billion customer related records from a legacy datastore to Heroku Postgres. A subnet of the data needs to be synchronized with Salesforce so that service agents are able to support customers directly within the service console. The remaining non-synchronized set of data will need to be accessed by Salesforce at any point in time, but UC management is concerned about storage limitations.

  What should a data architect recommend to meet these requirements with minimal effort?

  A. Use Heroku Connect to bidirectionally sync all data between systems

  B. As needed, make callouts into Heroku Postgres and persist the data in Salesforce

  C. Virtualize the remaining set of data with Salesforce Connect and external objects.

  D. Migrate the data to big objects and leverage Async SOQL with custom objects

  Correct Answer: A

  Reference: https://www.heroku.com/connect

• Question 66:

  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

  Correct Answer: ADE

• Question 67:

  The data architect for Universal Containers has written a SOQL query that will return all records from the Task object that do not have a value in the whatID field:

  SELECT ID, Description, Subject FROM Task WHERE WhatId != NULL

  When the data architect uses the query to select values for a process, a time-out error occurs.

  What does the data architect need to change to make this query more performant?

  A. Remove description from the requested field set.

  B. Change query to SOSL

  C. Add limit 100 to the query.

  D. Change the where clause to filter by a deterministic defined value.

  Correct Answer: C

• Question 68:

  Universal Containers developers have created a new Lightning component that uses an Apex controller using a SOQL query to populate a custom list view. Users are complaining that the component often fails to load and returns a time-out error.

  What tool should a data architect use to identify why the query is taking too long?

  A. Use Splunk to query the system logs looking for transaction time and CPU usage.

  B. Enable and use the query plan tool in the developer console.

  C. Use salesforce's query optimizer to analyze the query in the developer console.

  D. Open a ticket with salesforce support to retrieve transaction logs to e analyzed for processing time.

  Correct Answer: C

  Reference: https://trailhead.salesforce.com/content/learn/modules/database_basics_dotnet/ writing_efficient_queries

• Question 69:

  Universal Containers is implementing Sales Cloud for patient management and would like to encrypt sensitive patient records being stored in files.

  Which solution should a data architect recommend to solve this requirement?

  A. Implement shield platform encryption to encrypt files.

  B. Use classic encryption to encrypt files.

  C. Implement 3rd party App Exchange app to encrypt files.

  D. Store files outside of salesforce and access them to real time.

  Correct Answer: A

  Reference: https://www.salesforce.com/content/dam/web/en_us/www/documents/reports/wp-platformencryption-architecture.pdf

• Question 70:

  Northern Trail Outfitters has decided that it is going to build a channel sales portal with the following requirements:

  1.

  External resellers are able to authenticate to the portal with a login.

  2.

  Lead data, Opportunity data, and Order data are available to authenticated users.

  3.

  Authenticated users may need to run reports and dashboards.

  4.

  There is no need for more than 10 custom objects or additional file storage.

  Which Community Cloud license type should a data architect recommend to meet the portal requirements?

  A. Customer community.

  B. Lightning external apps starter.

  C. Customer community plus.

  D. Partner community.

  Correct Answer: D