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

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

• Question 71:

  Northern Trail Outfitters (NTO) has the following systems:

  Customer master-source of truth for customer information Service cloud-customer support

  Marketing cloud-marketing support

  Enterprise data warehouse--business reporting

  The customer data is duplicated across all these system and are not kept in sync.

  Customers are also complaining that they get repeated marketing emails and have to call into update their information.

  NTO is planning to implement master data management (MDM) solution across the enterprise.

  Which three data will an MDM tool solve?

  Choose 3 answers

  A. Data completeness
  B. Data loss and recovery
  C. Data duplication
  D. Data accuracy and quality
  E. Data standardization
  C. Data duplication
  D. Data accuracy and quality
  E. Data standardization

• Question 72:

  NTO would like to retrieve their SF orgs meta data programmatically for backup within a various external. Which API is the best fit for accomplishing this task?

  A. Metadata API
  B. Tooling API
  C. Bulk API in serial mode
  D. SOAP API
  A. Metadata API

• Question 73:

  A company has 12 million records, and a nightly integration queries these records.

  Which two areas should a Data Architect investigate during troubleshooting if queries are timing out? (Choose two.)

  A. Make sure the query doesn't contain NULL in any filter criteria.
  B. Create a formula field instead of having multiple filter criteria.
  C. Create custom indexes on the fields used in the filter criteria.
  D. Modify the integration users' profile to have View All Data.
  A. Make sure the query doesn't contain NULL in any filter criteria.
  C. Create custom indexes on the fields used in the filter criteria.

• Question 74:

  Universal Containers (UC) has a requirement to create an Account plan object that is related to the Account object. Each Account plan needs to have an Account object, but the accessibility requirement of the Account plan is different from the Account object. What should an Architect recommend?

  A. Create a custom account plan object as detail with Account as mater in a master-detail relationship.
  B. Create a custom account plan object as detail with Account as master with additional sharing rules to allow access.
  C. Create an account plan object with a lookup relations to Account without any validation rules to enforce the Account association.
  D. Create an account plan object with a lookup relationship to Account with validation rules to enforce the Account association.
  D. Create an account plan object with a lookup relationship to Account with validation rules to enforce the Account association.

• Question 75:

  Get Cloudy Consulting monitors 15,000 servers, and these servers automatically record their status every 10 minutes. Because of company policy, these status reports must be maintained for 5 years. Managers at Get Cloudy Consulting

  need access to up to one week's worth of these status reports with all of their details.

  An Architect is recommending what data should be integrated into Salesforce and for how long it should be stored in Salesforce.

  Which two limits should the Architect be aware of? (Choose two.)

  A. Data storage limits
  B. Workflow rule limits
  C. API Request limits
  D. Webservice callout limits
  A. Data storage limits
  C. API Request limits

• Question 76:

  Northern Trail Outfitters (NTO) has a complex Salesforce org which has been developed over past five years. Internal users are complaining about multiple data issues, including incomplete and duplicate data in the org. NTO has decided to engage a data architect to analyze and define data quality standards.

  Which three key factors should a data architect consider while defining data quality standards? (Choose three.)

  A. Finalize an extract transform load (ETL) tool for data migration
  B. Define data duplication standards and rules
  C. Measure data timeliness and consistency
  D. Define key fields in staging database for data cleansing
  E. Measure
  B. Define data duplication standards and rules
  D. Define key fields in staging database for data cleansing
  E. Measure

• Question 77:

  During the implementation of Salesforce, a customer has the following requirements for Sales Orders:

  1.

  Sales Order information needs to be shown to users in Salesforce.

  2.

  Sales Orders are maintained in the on-premises enterprise resource planning (ERP).

  3.

  Sales Order information has more than 150 million records.

  4.

  Sales Orders will not be updated in Salesforce.

  What should a data architect recommend for maintaining Sales Orders in salesforce?

  A. Us custom objects to maintain Sales Orders in Salesforce.
  B. Use custom big objects to maintain Sales Orders in Salesforce.
  C. Use external objects to maintain Sales Order in Salesforce.
  D. Use Standard order object to maintain Sale Orders in Salesforce
  C. Use external objects to maintain Sales Order in Salesforce.

• Question 78:

  Universal Containers (UC) is in the process of selling half of its company. As part of this split, UC's main Salesforce org will be divided into two org:org A and org B, UC has delivered these requirements to its data architect

  1.

  The data model for Org B will drastically change with different objects, fields, and picklist values.

  2.

  Three million records will need to be migrated from org A to org B for compliance reasons.

  3.

  The migrate will need occur within the next two month, prior to be split. Which migrate strategy should a data architect use to successfully migrate the date?

  A. use as ETL tool to orchestrate the migration.
  B. Use Data Loader for export and Data Import Wizard for import
  C. Write a script to use the Bulk API
  D. Use the Salesforces CLI to query, export, and import
  C. Write a script to use the Bulk API

• Question 79:

  A company is introducing a new data quality process and needs an Architect to recommend an appropriate approach. The new process will monitor the data that users are manually entering into the system through the Salesforce UI. Which recommendation is correct?

  A. Create data-quality dashboards by using an app from the AppExchange.
  B. Enable users to import their data using the Salesforce Import tools.
  C. Use a 3rd-party solution from the AppExchange for data uploads.
  D. Validate the format of phone numbers and postal codes by using Apex.
  A. Create data-quality dashboards by using an app from the AppExchange.

• Question 80:

  Universal Containers is looking to use Salesforce to manage their sales organization. They will be migrating legacy account data from two aging systems into Salesforce. Which two design considerations should an architect take to minimize data duplication? Choose 2 answers

  A. Use a workflow to check and prevent duplicates.
  B. Clean data before importing to Salesforce.
  C. Use Salesforce matching and duplicate rules.
  D. Import the data concurrently.
  B. Clean data before importing to Salesforce.
  C. Use Salesforce matching and duplicate rules.