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

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

• Question 131:

  DreamHouse Realty has a legacy system that captures Branch Offices and Transactions. DreamHouse Realty has 15 Branch Offices. Transactions can relate to any Branch Office. DreamHouse Realty has created hundreds of thousands of

  Transactions per year.

  A Data Architect needs to denormalize this data model into a single Transaction object with a Branch Office picklist.

  What are two important considerations for the Data Architect in this scenario? (Choose two.)

  A. Standard list view in-line editing.
  B. Limitations on Org data storage.
  C. Bulk API limitations on picklist fields.
  D. Limitations on master-detail relationships.
  B. Limitations on Org data storage.
  C. Bulk API limitations on picklist fields.

• Question 132:

  Northern Trail Outfitters (NTO) has multiple Salesforce orgs based on geographical regions (AMER, EMEA, APAC). NTO products are mastered in the AMER org and need to be created in the EMEA in APAC orgs after the products are approved.

  Which two features should a data architect recommend to share records between Salesforce orgs? (Choose two.)

  A. Change data capture (CDC)
  B. Salesforce connect.
  C. Federation search
  D. Salesforce 2 Salesforce
  A. Change data capture (CDC)
  B. Salesforce connect.

• Question 133:

  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.
  A. Ask support to create a skinny table for Application with the necessary reporting fields.
  D. Add custom indexes to the Date fields used for filtering the report.

• Question 134:

  Cloud Kicks has the following requirements:

  1.

  They want to automatically archive all inactive Account data that is older than 3 years.

  2.

  The information does not need to remain accessible within the application.

  Which two approaches should the Architect recommend to meet this requirement? (Choose two.)

  A. Export the data by using the Force.com Workbench.
  B. Schedule jobs to export and delete using the Data Loader.
  C. Schedule a weekly export file from the Salesforce UI.
  D. Schedule jobs to export and delete using an ETL tool.
  B. Schedule jobs to export and delete using the Data Loader.
  D. Schedule jobs to export and delete using an ETL tool.

• Question 135:

  Cloud Kicks has a Salesforce instance with 12,000 Account records. Managers at the company have noticed similar, but not identical, Account names and addresses.

  The Chief Technology Officer (CTO) at Cloud Kicks is concerned about proper data quality.

  Which steps should the CTO take to address this issue?

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

• Question 136:

  DreamHouse Realty has a Salesforce org that is used to manage Contacts. What are two things an Architect should consider using to maintain data quality in this situation? (Choose two.)

  A. Use the private sharing model.
  B. Use Salesforce duplicate management.
  C. Use validation rules on new record create and edit.
  D. Use workflow to delete duplicate records.
  B. Use Salesforce duplicate management.
  C. Use validation rules on new record create and edit.

• Question 137:

  Universal Containers wants to automatically archive all inactive Account data that is older than 3 years. The information does not need to remain accessible within the application.

  Which two methods should be recommended to meet this requirement? Choose 2 answers

  A. Use the Force.com Workbench to export the data.
  B. Schedule a weekly export file from the Salesforce UI.
  C. Schedule jobs to export and delete using an ETL tool.
  D. Schedule jobs to export and delete using the Data Loader.
  C. Schedule jobs to export and delete using an ETL tool.
  D. Schedule jobs to export and delete using the Data Loader.

• Question 138:

  Universal Container (UC) stores 10 million rows of inventory data in a cloud database, As part of creating a connected experience in Salesforce, UC would like to this inventory data to Sales Cloud without a import. UC has asked its data architect to determine if Salesforce Connect is needed. Which three consideration should the data architect make when evaluating the need for Salesforce Connect?

  A. You want real-time access to the latest data, from other systems.
  B. You have a large amount of data and would like to copy subsets of it into Salesforce.
  C. You need to expose data via a virtual private connection.
  D. You have a large amount of data that you don't want to copy into your Salesforce org.
  E. You need to small amounts of external data at any one time.
  A. You want real-time access to the latest data, from other systems.
  D. You have a large amount of data that you don't want to copy into your Salesforce org.
  E. You need to small amounts of external data at any one time.

• Question 139:

  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.
  C. Add limit 100 to the query.

• Question 140:

  UC has a roll-up summary field on Account to calculate the count of contacts associated with an account. During the account load, SF is throwing an "Unable to lock a row" error. Which solution should a data architect recommend, to resolve the error?

  A. Leverage data loader platform API to load data.
  B. Perform Batch job in parallel mode and reduce Batch size
  C. Perform Batch job in serial mode and reduce batch size
  D. Defer roll-up summary fields calculation during data migration.
  B. Perform Batch job in parallel mode and reduce Batch size