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

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

• Question 151:

  DreamHouse Realty has 15 million records in the Order_c custom object. When running a bulk query, the query times out. What should be considered to address this issue?

  A. Tooling API
  B. PK Chunking
  C. Metadata API
  D. Streaming API
  B. PK Chunking

• Question 152:

  Universal Containers (UC) provides shipping services to its customers.

  They use Opportunities to track customer shipments. At any given time, shipping status can be one of the 10 values.

  UC has 200,000 Opportunity records. When creating a new field to track shipping status on opportunity, what should the architect do to improve data quality and avoid data skew?

  A. Create a picklist field, values sorted alphabetically.
  B. Create a Master -Detail to custom object ShippingStatus c.
  C. Create a Lookup to custom object ShippingStatus c.
  D. Create a text field and make it an external ID.
  A. Create a picklist field, values sorted alphabetically.

• Question 153:

  UC has a variety of systems across its technology landscape, including SF, legacy enterprise resource planning (ERP) applications and homegrown CRM tools. UC has decided that they would like to consolidate all customer, opportunity and

  order data into Salesforce as part of its master data management (MDM) strategy.

  What are the 3 key steps that a data architect should take when merging data from multiple systems into Salesforce? Choose 3 answers:

  A. Create new fields to store additional values from all the systems.
  B. Install a 3rd party AppExchange tool to handle the merger
  C. Analyze each system's data model and perform gap analysis
  D. Utilize an ETL tool to merge, transform and de-duplicate data.
  E. Work with Stakeholders to define record and field survivorship rules
  C. Analyze each system's data model and perform gap analysis
  D. Utilize an ETL tool to merge, transform and de-duplicate data.
  E. Work with Stakeholders to define record and field survivorship rules

• Question 154:

  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.
  D. Partner community.

• Question 155:

  Universal Containers has deployed Salesforce for case management The company is having difficulty understanding what percentage of cases are resolved from the initial call to their support organization. What first step is recommended to implement a reporting solution to measure the support reps case closure rates?

  A. Enable field history tracking on the Case object.
  B. Create a report on Case analytic snapshots.
  C. Install AppExchange packages for available reports.
  D. Create Contact and Opportunity Reports and Dashboards.
  A. Enable field history tracking on the Case object.

• Question 156:

  Get Cloudy Consulting uses an invoicing system that has specific requirements. One requirement is that attachments associated with the Invoice_c custom object be classified by Types (i.e., ""Purchase Order"", ""Receipt"", etc.) so that reporting can be performed on invoices showing the number of attachments grouped by Type.

  What should an Architect do to categorize the attachments to fulfill these requirements?

  A. Add additional options to the standard ContentType picklist field for the Attachment object.
  B. Add a ContentType picklist field to the Attachment layout and create additional picklist options.
  C. Create a custom picklist field for the Type on the standard Attachment object with the values.
  D. Create a custom object related to the Invoice object with a picklist field for the Type.
  D. Create a custom object related to the Invoice object with a picklist field for the Type.

• Question 157:

  DreamHouse Realty recently implemented a Sales Cloud. Managers have noticed that sales reps are entering an insufficient amount of data to run insightful reports and dashboards. The managers would like to monitor and measure data quality metrics.

  Which solution addresses this requirement?

  A. Use custom objects and fields to calculate data quality.
  B. Utilize third-party AppExchange tools to measure and monitor data quality.
  C. Run and generate reports to view the quality of sample data.
  D. Export the data to an enterprise data warehouse and use BI tools for data quality.
  B. Utilize third-party AppExchange tools to measure and monitor data quality.

• Question 158:

  A Customer is migrating 10 million order and 30 million order lines into Salesforce using Bulk API. The Engineer is experiencing time-out errors or long delays querying parents order IDs in Salesforce before importing related order line items. What is the recommended solution?

  A. Query only indexed ID field values on the imported order to import related order lines.
  B. Leverage an External ID from source system orders to import related order lines.
  C. Leverage Batch Apex to update order ID on related order lines after import.
  D. Leverage a sequence of numbers on the imported orders to import related order lines.
  B. Leverage an External ID from source system orders to import related order lines.

• Question 159:

  Northern Trail Outfitters (NTO) has been using Salesforce for Sales and Service for 10 years. For the past two years, the marketing group has noticed a rise from 0% to 35% in returned mail when sending mail using the contact information

  stored in Salesforce.

  Which solution should the data architect use to reduce the amount of returned mail?

  A. Use a 3rd party data source to update contact information in salesforce.
  B. Email all customer and asked them to verify their information and to call NTO if their address is incorrect.
  C. Delete contacts when the mail is returned to save postal cost to NTO.
  D. Have the sales team to call all existing customers and ask to verify the contact details.
  B. Email all customer and asked them to verify their information and to call NTO if their address is incorrect.

• Question 160:

  Universal Container is Implementing salesforce and needs to migrate data from two legacy systems. UC would like to clean and duplicate data before migrate to Salesforce. Which solution should a data architect recommend a clean migration?

  A. Define external IDs for an object, migrate second database to first database, and load into Salesforce.
  B. Define duplicate rules in Salesforce, and load data into Salesforce from both databases.
  C. Set up staging data base, and define external IDs to merge, clean duplicate data, and load into Salesforce.
  D. Define external IDs for an object, Insert data from one database, and use upsert for a second database
  D. Define external IDs for an object, Insert data from one database, and use upsert for a second database