The Secret Of Salesforce Data-Architecture-And-Management-Designer Free Practice Test

NEW QUESTION 1
Universal Containers (UC) management has identified a total of ten text fields on the Contact object as important to capture any changes made to these fields, such as who made the change, when they made the change, what is the old value, and what is the new value. UC needs to be able to report on these field data changes within Salesforce for the past 3 months. What are two approaches that will meet this requirement? Choose 2 answers

• A. Create a workflow to evaluate the rule when a record is created and use field update actions to store previous values for these ten fields in ten new fields.
• B. Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.
• C. Turn on field Contact object history tracking for these ten fields, then create reports on contact history.
• D. Create a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send email to the admin.

Answer: BC

NEW QUESTION 2
A health care provider wishes to use salesforce to track patient care. The following actions are in Salesforce
* 1. Payment Providers: Orgas who pay for the care 2 patients.
* 2. Doctors: They provide care plan for patients and need to support multiple patients, they are provided access to patient information.
* 3. Patients: They are individuals who need care.
A data architect needs to map the actor to Sf objects. What should be the optimal selection by the data architect?

• A. Patients as Contacts, Payment providers as Accounts, & Doctors as Accounts
• B. Patients as Person Accounts, Payment providers as Accounts, & Doctors as Contacts
• C. Patients as Person Accounts, Payment providers as Accounts, & Doctors as Person Account
• D. Patients as Accounts, Payment providers as Accounts, & Doctors as Person Accounts

Answer: C

NEW QUESTION 3
NTO need to extract 50 million records from a custom object everyday from its Salesforce org. NTO is facing query timeout issues while extracting these records.
What should a data architect recommend in order to get around the time out issue?

• A. Use a custom auto number and formula field and use that to chunk records while extracting data.
• B. The REST API to extract data as it automatically chunks records by 200.
• C. Use ETL tool for extraction of records.
• D. Ask SF support to increase the query timeout value.

Answer: C

NEW QUESTION 4
Ursa Major Solar has defined a new Data Quality Plan for their Salesforce data.
Which two approaches should an Architect recommend to enforce the plan throughout the organization? (Choose two.)

• A. Ensure all data is stored in an external system and set up an integration to Salesforce for view-only access.
• B. Schedule reports that will automatically catch duplicates and merge or delete the records every week.
• C. Enforce critical business processes by using Workflow, Validation Rules, and Apex code.
• D. Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.

Answer: CD

NEW QUESTION 5
The data architect for UC 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 usages 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 SOS
• C. ??
• D. Add limit 100 to the query.
• E. Change the where clause to filter by a deterministic defined value.

Answer: D

NEW QUESTION 6
UC is migrating data from legacy system to SF. UC would like to preserve the following information on records being migrated:
Date time stamps for created date and last modified date.
Ownership of records belonging to inactive users being migrated to Salesforce.
Which 2 solutions should a data architect recommends to preserve the date timestamps and ownership on records? Choose 2 answers.

• A. Log a case with SF to update these fields
• B. Enable update records with Inactive Owners Permission
• C. Enable Set Audit fields upon Record Creation Permission
• D. Enable modify all and view all permission.

Answer: BC

NEW QUESTION 7
A shipping and logistics company has created a large number of reports within Sales Cloud since Salesforce was introduced. Some of these reports analyze large amounts of data regarding the whereabouts of the company's containers, and they are starting to time out when users are trying to run the reports. What is a recommended approach to avoid these time-out issues?

• A. Improve reporting performance by creating a custom Visualforce report that is using a cache of the records in the report.
• B. Improve reporting performance by replacing the existing reports in Sales Cloud with new reports based on Analytics Cloud.
• C. Improve reporting performance by creating an Apex trigger for the Report object that will pre-fetch data before the report is run.
• D. Improve reporting performance by creating a dashboard that is scheduled to run the reports only once per day.

Answer: B

NEW QUESTION 8
Universal Containers (UC) uses the following Salesforce products: Sales Cloud for customer management.
Marketing Cloud for marketing.
Einstein Analytics for business reporting.
UC occasionally gets a list of prospects from third-party source as comma-separated values (CSV) files for marketing purposes. Historically, UC would load contact Lead object in Salesforce and sync to Marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud, UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud, UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing process.
What should a data architect recommend to UC in order to immediately avoid storage issues in the future?

• A. Load the CSV files in Einstein Analytics and sync with Marketing Cloud prior to sending marketing communications ;
• B. Load the CSV files in an external database and sync with Marketing Cloud prior to sending marketing communications.
• C. Load the contacts directly to Marketing Cloud and have a reconciliation process to track prospects that are converted to customers.
• D. Continue to use the existing process to use Lead object to sync with Marketing Cloud and delete Lead records from Sales after the sync is complete.

Answer: A

NEW QUESTION 9
Which two aspects of data does an Enterprise data governance program aim to improve?

• A. Data integrity
• B. Data distribution
• C. Data usability
• D. Data modeling

Answer: AC

NEW QUESTION 10
Universal Containers (UC) requires 2 years of customer related cases to be available on SF for operational reporting. Any cases older than 2 years and upto 7 years need to be available on demand to the Service agents. UC creates 5 million cases per yr.
Which 2 data archiving strategies should a data architect recommend? Choose 2 options:

• A. Use custom objects for cases older than 2 years and use nightly batch to move them.
• B. Sync cases older than 2 years to an external database, and provide access to Service agents to the database
• C. Use Big objects for cases older than 2 years, and use nightly batch to move them.
• D. Use Heroku and external objects to display cases older than 2 years and bulk API to hard delete from Salesforce.

Answer: CD

NEW QUESTION 11
Universal Containers would like to have a Service-Level Agreement (SLA) of 1 day for any data loss due to unintentional or malicious updates of records in Salesforce. What approach should be suggested to address this requirement?

• A. Build a daily extract job and extract data to on-premise systems for long-term backup and archival purposes.
• B. Schedule a Weekly Extract Service for key objects and extract data in XL sheets to on-premise systems.
• C. Store all data in shadow custom objects on any updates and deletes, and extract them as needed .
• D. Evaluate a third-party AppExchange app, such as OwnBackup or Spanning, etc., for backup and archival purposes.

Answer: D

NEW QUESTION 12
Universal Containers (UC) has users complaining about reports timing out or simply taking too long to run What two actions should the data architect recommend to improve the reporting experience? Choose 2 answers

• A. Index key fields used in report criteria.
• B. Enable Divisions for large data objects.
• C. Create one skinny table per report.
• D. Share each report with fewer users.

Answer: AC

NEW QUESTION 13
Universal Containers (UC) is launching an RFP to acquire a new accounting product available on AppExchange. UC is expecting to issue 5 million invoices per year, with each invoice containing an average of 10 line items. What should UC's Data Architect recommend to ensure scalability?

• A. Ensure invoice line items simply reference existing Opportunity line items.
• B. Ensure the account product vendor includes Wave Analytics in their offering.
• C. Ensure the account product vendor provides a sound data archiving strategy.
• D. Ensure the accounting product runs 100% natively on the Salesforce platform.

Answer: C

NEW QUESTION 14
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.

Answer: D

NEW QUESTION 15
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

Answer: BCD

NEW QUESTION 16
Universal Containers has a custom object with millions of rows of data.
When executing SOQL queries, which three options prevent a query from being selective? (Choose three.)

• A. Using leading % wildcards.
• B. Using trailing % wildcards.
• C. Performing large loads and deletions.
• D. Using NOT and != operators.
• E. Using a custom index on a deterministic formula field.

Answer: ADE

NEW QUESTION 17
NTO has multiple systems across its enterprise landscape including salesforce, with disparate version the customer records.
In salesforce, the customer is represented by the contact object. NTO utilizes an MDM solution with these attributes:
* 1. The MDM solution keeps track of customer master with a master key.
* 2. The master key is a map to the record ID’s from each external system that customer data is stored within.
* 3. The MDM solution provides de-duplication features, so it acts as the single source of truth.
How should a data architect implement the storage of master key within salesforce?

• A. Store the master key in Heroku postgres and use Heroku connect for synchronization.
• B. Create a custom object to store the master key with a lookup field to contact.
• C. Create an external object to store the master key with a lookup field to contact.
• D. Store the master key on the contact object as an external ID (Field for referential imports)

Answer: D

NEW QUESTION 18
UC recently migrated 1 Billion customer related records from a legacy data store to Heroku Postgres. A subset of the data need 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. Virtualize the remaining set of data with salesforce connect and external objects.
• B. Use Heroku connect to bi-directional, sync all data between systems.
• C. As needed, make call outs into Heroku postgres and persist the data in salesforce.
• D. Migrate the data to big objects and leverage async SOQL with custom objects.

Answer: A

NEW QUESTION 19
UC has migrated its Back-office data into an on-premise database with REST API access. UC recently implemented Sales cloud for its sales organization. But users are complaining about a lack of order data inside SF.
UC is concerned about SF storage limits but would still like Sales cloud to have access to the data. Which design patterns should a data architect select to satisfy the requirement?

• A. Migrate and persist the data in SF to take advantage of native functionality.
• B. Use SF Connect to virtualize the data in SF and avoid storage limits.
• C. Develop a bidirectional integration between the on-premise system and Salesforce.
• D. Build a UI for the on-premise system and iframe it in Salesforce

Answer: B

NEW QUESTION 20
......