Universal Containers (UC) is a major supplier of office supplies. Some products are produced by UC and some by other manufacturers. Recently, a number of customers have complained that product descriptions on the invoices do not match the descriptions in the online catalog and on some of the order confirmations (e.g., "ballpoint pen" in the catalog and "pen" on the invoice, and item color labels are inconsistent: "what vs. "White" or "blk" vs. "Black"). All product data is consolidated in the company data warehouse and pushed to Salesforce to generate quotes and invoices. The online catalog and webshop is a Salesforce Customer Community solution. What is a correct technique UC should use to solve the data inconsistency?
A. Change integration to let product master systems update product data directly in Salesforce via the Salesforce API.
B. Add custom fields to the Product standard object in Salesforce to store data from the different source systems.
C. Define a data taxonomy for product data and apply the taxonomy to the product data in the data warehouse.
D. Build Apex Triggers in Salesforce that ensure products have the correct names and labels after data is loaded into salesforce.
Universal Containers has received complaints that customers are being called by multiple Sales Reps where the second Sales Rep that calls is unaware of the previous call by their coworker. What is a data quality problem that could cause this?
A. Missing phone number on the Contact record.
B. Customer phone number has changed on the Contact record.
C. Duplicate Contact records exist in the system.
D. Duplicate Activity records on a Contact.
Universal Containers (UC) wants to capture information on how data entities are stored within the different applications and systems used within the company. For that purpose, the architecture team decided to create a data dictionary covering the main business domains within UC. Which two common techniques are used building a data dictionary to store information on how business entities are defined?
A. Use Salesforce Object Query Language.
B. Use a data definition language.
C. Use an entity relationship diagram.
D. Use the Salesforce Metadata API.
Universal Containers is exporting 40 million Account records from Salesforce using Informatica Cloud. The ETL tool fails and the query log indicates a full table scan time-out failure. What is the recommended solution?
A. Modify the export job header to specify Export-in-Parallel.
B. Modify the export job header to specify Sforce-Enable-PKChunking.
C. Modify the export query that includes standard index fields(s).
D. Modify the export query with LIMIT clause with Batch size 10,000.
Universal Containers has a public website with several forms that create Lead records in Salesforce using the REST API. When designing these forms, which two techniques will help maintain a high level of data quality?
A. Do client-side validation of phone number and email field formats.
B. Prefer picklist form fields over free text fields, where possible.
C. Ensure the website visitor is browsing using an HTTPS connection.
D. Use cookies to track when visitors submit multiple forms.
Universal Containers (UC) has 1,000 accounts and 50,000 opportunities. UC has an enterprise security requirement to export all sales data outside of Salesforce on a weekly basis. The security requirement also calls for exporting key operational data that includes events such as file downloads, logins, logouts, etc. Which two recommended approaches would address the above requirement?
A. Use Field Audit History to capture operational data and extract it to on-premise systems.
B. Use Weekly Export to extract transactional data to on-premise systems.
C. Use a custom built extract job to extract operational data to on-premise systems.
D. Use Event Monitoring to extract event data to on-premise systems.
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.
UC is having issues using Informatica Cloud Louder to export +10MOrder records. Each Order record has 10 Order Line Items. What two steps can you take to help correct this? Choose two answers.
A. Export in multiple batches
B. Export Bulk API in parallel mode
C. Use PK Chunking
D. Limit Batch to 10K records
Universal Containers (UC) wants to store product data in Salesforce, but the standard Product object does not support the more complex hierarchical structure which is currently being used in the product master system. How can UC modify the standard Product object model to support a hierarchical data structure in order to synchronize product data from the source system to Salesforce?
A. Create a custom lookup filed on the standard Product to reference the child record in the hierarchy.
B. Create a custom lookup field on the standard Product to reference the parent record in the hierarchy.
C. Create a custom master-detail field on the standard Product to reference the child record in the hierarchy.
D. Create an Apex trigger to synchronize the Product Family standard picklist field on the Product object.
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.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Salesforce exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your DATA-ARCHITECTURE-AND-MANAGEMENT-DESIGNER exam preparations and Salesforce certification application, do not hesitate to visit our Vcedump.com to find your solutions here.